Piwigo Bugtracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0001763Piwigodatabasepublic2010.07.05 20:472010.07.05 23:19
Reportermadman 
Assigned Tonikrou 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformPostgresqlOSCentOS 5.4OS VersionPostgresql 8.4.2
Product Version2.1.2 
Target VersionFixed in Version2.1.3 
Summary0001763: [PostgreSQL] double quote used in queries
DescriptionPostgreSQL handles strings with double qoutes as tables/columns, use single quotes instead.

See the documentation for more detail: http://www.postgresql.org/docs/8.4/interactive/sql-syntax-lexical.html [^]

This error is in the query on line 262 of include/section_init.inc.php

Other possible errors:
admin/include/functions.php:297: WHERE data LIKE "pwg_uid|i:'.(int)$user_id.';%"
admin/include/functions_permalinks.php:50: WHERE op.permalink="'.$permalink.'"
include/functions_search.inc.php:396: $clauses[] = $field.' LIKE "'.$before.addslashes($tokens[$i]).$after.'"';
include/functions_search.inc.php:437: $where_clauses='MATCH(i.name, i.comment) AGAINST( "'.$q.'" IN BOOLEAN MODE)';
include/functions_search.inc.php:455: MATCH(i.name, i.comment) AGAINST( "'.$q.'" IN BOOLEAN MODE) AS weight
include/functions_category.inc.php:409: $in .= '"'.$permalink.'"';
install/db/65-database.php:166: $query = 'SHOW TABLES LIKE "'.$prefixeTable.'%"';
install/db/65-database.php:268: UPDATE '.USER_INFOS_TABLE.' SET language="'.$lang_data['new_lang'].'"
install/db/65-database.php:269: WHERE language="'.$old_lang.'"';
install/db/65-database.php:279: pwg_query('SET NAMES "'.DB_CHARSET.'"');
install/db/34-database.php:37:DELETE FROM '.PREFIX_TABLE.'config WHERE param="active_plugins"';
install/db/34-database.php:43: `state` enum("inactive","active") NOT NULL default "inactive",
plugins/LocalFilesEditor/update_config.php:40:SET value = "' . $_POST['editarea'] . '"
plugins/LocalFilesEditor/update_config.php:41:WHERE param="LocalFilesEditor"
Additional InformationWarning: pg_query() [function.pg-query]: Query failed: ERROR: column "1,%" does not exist LINE 5: uppercats LIKE "1,%" ^ in /var/www/sites/fotos.aarjan.nl/piwigo/piwigo_svn/include/dblayer/functions_pgsql.inc.php on line 122
SELECT id FROM piwigo_categories WHERE uppercats LIKE "1,%"
ERROR: column "1,%" does not exist LINE 5: uppercats LIKE "1,%" ^
TagsNo tags attached.
browserMozilla
Database engine and versionPostgresql 8.4.2
PHP version5.3.2
Web serverApache 2.2.3
Attached Files

- Relationships

-  Notes
(0004030)
svn (reporter)
2010.07.05 23:18

[Subversion] r6664 by nikrou on trunk

-----[Subversion commit log]----------------------------------------------------
Bug 1763 fixed : [PostgreSQL] double quote used in queries
(0004031)
svn (reporter)
2010.07.05 23:18

[Subversion] r6665 by nikrou on branch 2.1

-----[Subversion commit log]----------------------------------------------------
Bug 1763 fixed : [PostgreSQL] double quote used in queries
Merge from trunk

- Issue History
Date Modified Username Field Change
2010.07.05 20:47 madman New Issue
2010.07.05 20:47 madman browser => Mozilla
2010.07.05 20:47 madman Database engine and version => Postgresql 8.4.2
2010.07.05 20:47 madman PHP version => 5.3.2
2010.07.05 20:47 madman Web server => Apache 2.2.3
2010.07.05 22:55 nikrou Status new => assigned
2010.07.05 22:55 nikrou Assigned To => nikrou
2010.07.05 23:18 svn Checkin
2010.07.05 23:18 svn Note Added: 0004030
2010.07.05 23:18 svn Checkin
2010.07.05 23:18 svn Note Added: 0004031
2010.07.05 23:19 nikrou Status assigned => closed
2010.07.05 23:19 nikrou Resolution open => fixed
2010.07.05 23:19 nikrou Fixed in Version => 2.1.3


Copyright © 2000 - 2015 MantisBT Team
Contact
Powered by Mantis Bugtracker