From b2d7edfc173228035f9dfadb73caa01e88b2b7e4 Mon Sep 17 00:00:00 2001 From: nikrou Date: Mon, 5 Jul 2010 21:18:45 +0000 Subject: Bug 1763 fixed : [PostgreSQL] double quote used in queries Merge from trunk git-svn-id: http://piwigo.org/svn/branches/2.1@6665 68402e56-0260-453c-a942-63ccdbb3a9ee --- admin/include/functions.php | 2 +- admin/include/functions_permalinks.php | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) (limited to 'admin') diff --git a/admin/include/functions.php b/admin/include/functions.php index 1d7fda97c..8b3861253 100644 --- a/admin/include/functions.php +++ b/admin/include/functions.php @@ -294,7 +294,7 @@ DELETE FROM '.$table.' // destruction of the user $query = ' DELETE FROM '.SESSIONS_TABLE.' - WHERE data LIKE "pwg_uid|i:'.(int)$user_id.';%" + WHERE data LIKE \'pwg_uid|i:'.(int)$user_id.';%\' ;'; pwg_query($query); diff --git a/admin/include/functions_permalinks.php b/admin/include/functions_permalinks.php index a61ed32a0..4073970fd 100644 --- a/admin/include/functions_permalinks.php +++ b/admin/include/functions_permalinks.php @@ -47,7 +47,7 @@ function get_cat_id_from_old_permalink($permalink) SELECT c.id FROM '.OLD_PERMALINKS_TABLE.' op INNER JOIN '.CATEGORIES_TABLE.' c ON op.cat_id=c.id - WHERE op.permalink="'.$permalink.'" + WHERE op.permalink=\''.$permalink.'\' LIMIT 1'; $result = pwg_query($query); $cat_id = null; -- cgit v1.2.3