Piwigo Bugtracker

Viewing Issue Advanced Details Jump to Notes ] Issue History ] Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0001763 [Piwigo] database minor always 2010.07.05 20:47 2010.07.05 23:19
Reporter madman View Status public  
Assigned To nikrou
Priority normal Resolution fixed Platform Postgresql
Status closed   OS CentOS 5.4
Projection none   OS Version Postgresql 8.4.2
ETA none Fixed in Version 2.1.3 Product Version 2.1.2
  Target Version Product Build Trunk r6659
Summary 0001763: [PostgreSQL] double quote used in queries
Description PostgreSQL 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"
Steps To Reproduce
Additional Information Warning: 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,%" ^
Tags No tags attached.
browser Mozilla
Database engine and version Postgresql 8.4.2
PHP version 5.3.2
Web server Apache 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


Mantis 1.1.6[^]
Copyright © 2000 - 2008 Mantis Group
Contact
Powered by Mantis Bugtracker