forum.coppermine-gallery.net
Support => cpg1.5.x Support => cpg1.5 plugins => Topic started by: N2GetherNow on July 21, 2013, 08:16:21 am
-
Hello there,
i've installed this plug-in but seem to not work. When i hit "zip" button it returns this error:
Critical error
There was an error while processing a database query
Also this is from the database log:
Юли 20, 2013 at 09:21 PM - While executing query 'SELECT filepath, filename FROM cpg_fairs_pictures AS pictures , (SELECT keyword FROM cpg_fairs_albums WHERE aid = '5' ) AS keyword, cpg_fairs_albums AS r WHERE (1) AND r.aid = pictures.aid AND (pictures.aid = '5' OR ( keyword.keyword <> '' AND CONCAT(';', keywords, ';') LIKE CONCAT('%;', keyword.keyword, ';%')))' in plugins\albumdownload\zip.php on line 28 the following error was encountered:
You have an error in your SQL syntax near '(SELECT keyword FROM cpg_fairs_albums WHERE aid = '5' ) AS keyword, cpg_fairs_al' at line 1
I'm running cpg 1.5.24 revision 8570 on Win7, Apache 1.3.7 (PHP v.4.3.2, MySQL v.3.23.49).
Favorites zip download works perfect. Any ideas?
P.S. THIS is the gallery and English language exist, so this is not the problem (i've checked it for sure and don't work while english is active) (http://soadfan.eu/Trips/)
-
It would probably be beneficial for you (especially in the long run) to update/upgrade your versions of MySQL and PHP.
-
It would probably be beneficial for you (especially in the long run) to update/upgrade your versions of MySQL and PHP.
It would probably, but i don't think i can configure them properly (i had tried already in the past). This is complete package like xampp.
-
Your MySQL version is too old, as it doesn't support sub-queries. However, that could probably be fixed if you move the sub-query to a separate query.
If you don't know how to do that, please reply to this post.
-
It is quite easy to upgrade XAMPP, please visit their website for full details. It is because of things like this that we try not to recommend self hosting.