Advanced search  

News:

cpg1.5.46 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter recently discovered vulnerabilities. It is important that all users who run version cpg1.5.44 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Database query problem  (Read 2612 times)

0 Members and 1 Guest are viewing this topic.

cally6008

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
Database query problem
« 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
Logged

cally6008

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
Re: Database query problem
« Reply #1 on: October 28, 2014, 05:04:30 pm »

Solved ,, apologies ,, ran the update database again and it now works as it should
Logged

kuletdesigns

  • Coppermine newbie
  • Offline Offline
  • Posts: 1
Re: Database query problem
« Reply #2 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
Logged

allvip

  • Global Moderator
  • Coppermine addict
  • *****
  • Country: 00
  • Offline Offline
  • Posts: 1290
Re: Database query problem
« Reply #3 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.
Logged
Pages: [1]   Go Up
 

Page created in 0.038 seconds with 21 queries.