forum.coppermine-gallery.net
Support => cpg1.5.x Support => cpg1.5 upgrading => Topic started by: cally6008 on October 28, 2014, 04:38:35 pm
-
I upgraded/updated previously and got this error but did nothing about it.
I have just gone from 1.5.30 to 1.5.34 and thought I should get this fixed
Link - http://www.tracingequines.co.uk/gallery/index.php
This only seems to happen when a person clicks on the main category name.
Critical error
There was an error while processing a database query
File: /... /gallery/include/functions.inc.php - Line: 272
Debug mode shows this information -
Tracing Equines
While executing query 'SELECT a.aid, a.title, a.description, a.thumb, a.keyword, category, visibility, filepath, filename, url_prefix, pwidth, pheight, a.owner FROM cpg15x_albums AS a LEFT JOIN cpg15x_pictures AS p ON a.thumb=p.pid WHERE a.category = 5 ORDER BY LIMIT 0,8' in index.php on line 738
mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0,8' at line 1
Horsewatch
While executing query 'SELECT a.aid, a.title, a.description, a.thumb, a.keyword, category, visibility, filepath, filename, url_prefix, pwidth, pheight, a.owner FROM cpg15x_albums AS a LEFT JOIN cpg15x_pictures AS p ON a.thumb=p.pid WHERE a.category = 4 ORDER BY LIMIT 0,3' in index.php on line 738
mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0,3' at line 1
Stolen Horse Register
While executing query 'SELECT a.aid, a.title, a.description, a.thumb, a.keyword, category, visibility, filepath, filename, url_prefix, pwidth, pheight, a.owner FROM cpg15x_albums AS a LEFT JOIN cpg15x_pictures AS p ON a.thumb=p.pid WHERE a.category = 2 ORDER BY LIMIT 0,24' in index.php on line 738
mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0,24' at line 1
Other Photos
While executing query 'SELECT a.aid, a.title, a.description, a.thumb, a.keyword, category, visibility, filepath, filename, url_prefix, pwidth, pheight, a.owner FROM cpg15x_albums AS a LEFT JOIN cpg15x_pictures AS p ON a.thumb=p.pid WHERE a.category = 7 ORDER BY LIMIT 0,4' in index.php on line 738
mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0,4' at line 1
Full Albums
While executing query 'SELECT a.aid, a.title, a.description, a.thumb, a.keyword, category, visibility, filepath, filename, url_prefix, pwidth, pheight, a.owner FROM cpg15x_albums AS a LEFT JOIN cpg15x_pictures AS p ON a.thumb=p.pid WHERE a.category = 9 ORDER BY LIMIT 0,3' in index.php on line 738
mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0,3' at line 1
-
Solved ,, apologies ,, ran the update database again and it now works as it should
-
hello, we have just upgraded to the newer version and this is what we got
There was an error while processing a database query.
the site: www.mindanews.com/pictures
i checked the user/password/dbname, they are all correct.
sorry, im a newbie here. thanks
-
hello, we have just upgraded to the newer version and this is what we got
There was an error while processing a database query.
the site: www.mindanews.com/pictures
i checked the user/password/dbname, they are all correct.
sorry, im a newbie here. thanks
Even if you have the same problem, you have to start a new thread.
I can see you solved it. You have to say how for other users to learn how to solve it if they have the same problem. Users will find your thread in search and will want to know how you solved it. This way they won't have to wait for someone to help them.
User cally6008 post it his solution.
Are forum rules.