forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 upgrading => Topic started by: cally6008 on October 28, 2014, 04:38:35 pm

Title: Database query problem
Post 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

Quote
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

Quote
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

Quote
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

Quote
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

Quote
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
Title: Re: Database query problem
Post by: cally6008 on October 28, 2014, 05:04:30 pm
Solved ,, apologies ,, ran the update database again and it now works as it should
Title: Re: Database query problem
Post by: kuletdesigns on December 02, 2014, 01:54:38 pm
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
Title: Re: Database query problem
Post by: allvip on December 04, 2014, 09:04:44 pm
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.