SQL Error - functions.inc on line: 563

jgorman · Newbie Offline Joined: May 28, 2005 Posts: 3

My server emailed this to me today...

Code::

On /index.php?name=coppermine&file=displayimage&meta=random
&album=18&pid=206&slideshow=5000
While executing query "SELECT pid, filepath, filename, p.title, keywords, url_prefix, filesize, pwidth, pheight, ctime, p.aid, p.aid FROM cms_cpg_pictures AS p INNER JOIN cms_cpg_albums AS a ON (p.aid = a.aid AND visibility IN (0,2,2,10006) AND a.aid = 18) WHERE approved='YES' GROUP BY p.pid ORDER BY RAND() LIMIT -1"

the following error occured: 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 '-1' at line 1

In: /var/www/gormans/html/includes/coppermine/functions.inc on line: 563

Phoenix · Posted: Wed Jun 22, 2005 3:14 am Post subject: Re: SQL Error in Coppermine

hmm, I think I saw a similar one reported recently by Pitcher.
I'll move this to Coppermine before it gets buried here.

Edit: I knew I had seen it somewhere.
You can monitor progress here,
dragonflycms.org/Proje...d=515.html

hardlocke

i get this error by email:

Quote::

On /index.php?name=coppermine&file=thumbnails&op=modload&album=7&page=&sort=ra
While executing query "SELECT pid, filepath, filename, p.title, keywords, url_prefix, filesize, pwidth, pheight, ctime, p.aid, p.title, caption, hits, description from cms_cpg_pictures as p INNER JOIN cms_cpg_albums AS a ON (a.aid = 7 AND visibility IN (0,3)) WHERE p.aid='7' AND approved='YES' ORDER BY pic_rating ASC ,24"

the following error occured: Unknown column '24' in 'order clause'

In: C:\Inetpub\wwwroot\includes\coppermine\functions.inc on line: 377

Guest information:
User id: 1
Username: Anonymous
Admin: No
IP: 66.249.66.204
Host: crawl-66-249-66-204.googlebot.com

what can i do? is the database corrupt?

staybright · Supporter Offline Joined: Apr 20, 2004 Posts: 91

I started having the same issue, only mine ends with:

Quote::

the following error occured: Unknown column '20' in 'order clause'

Guest information:
User id: 1
Username: Anonymous
Admin: No
IP: 66.249.65.5
Host: crawl-66-249-65-5.googlebot.com

I have run a number of searches and have not found anything as yet. It started within a day of upgrading to 9.0.4

Tried switching to the latest CVS as of 18 Jun and it still shows up.

Does not seem to occur when I browse the gallery as a normal user but seem to only show up with the googlebot visit.

Haven't had a chance to but in a bug request yet

Mel · Posted: Sun Jun 26, 2005 2:25 pm Post subject: Re: SQL Error on coppermine

I am also getting this error:
On /coppermine/displayimage/meta=random/album=5/pid=108/slideshow=5000.html
While executing query "SELECT pid, filepath, filename, p.title, keywords, url_prefix, filesize, pwidth, pheight, ctime, p.aid, p.aid FROM cms_cpg_pictures AS p INNER JOIN cms_cpg_albums AS a ON (p.aid = a.aid AND visibility IN (0,3) AND a.aid = 5) WHERE approved='YES' GROUP BY p.pid ORDER BY RAND() LIMIT -1"

the following error occured: 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 '-1' at line 1

In: /home/xtremeje/public_html/includes/coppermine/functions.inc on line: 563

Guest information:
User id: 1
Username: Unregistered Guest
Admin: No
IP: 66.249.65.132
Host: crawl-66-249-65-132.googlebot.com

The problem is, its filling up my email inbox with HUNDREDS OF EMAILS ...
can SOMEONE PLEASE tell me how to stop it....

Thank you....

Phoenix · Posted: Sun Jun 26, 2005 7:02 pm Post subject: Re: SQL Error on coppermine

We seem to have 2 coppermine issues - the first one I don't beieve has been reported as a bug, but the one Mel has is a bug report.

=> Coppermine forum

Śyama_Dāsa · Posted: Wed Jul 06, 2005 1:14 am Post subject: Re: SQL Error on coppermine

Slideshow error fix /cvs/html/modules/coppermine/displayimage.php new revision: 9.3

American · Supporter Offline Joined: Aug 18, 2004 Posts: 135

I received this via email from one of my 9.050 sites:

Code::

On /coppermine/displayimage/meta=random/album=6/pid=255/slideshow=5000.html
While executing query "SELECT pid, filepath, filename, p.title, keywords, url_prefix, filesize, pwidth, pheight, ctime, p.aid, p.aid FROM nuke_cpg_pictures AS p INNER JOIN nuke_cpg_albums AS a ON (p.aid = a.aid AND visibility IN (0,2,2,16080) AND a.aid = 6) WHERE approved='YES' GROUP BY p.pid ORDER BY RAND() LIMIT -1"

the following error occured: 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 '-1' at line 1

In: /home/buellman/domains/mydomain.com/public_html/includes/coppermine/functions.inc on line: 563

I've noticed since upgrading from 8.2 that the system does not automatically create a Coppermine album for the user but they can create one on their own if they wish. I wonder if there is any connection?

Any insight into this?

Thanks,

Phoenix · Posted: Wed Aug 10, 2005 12:39 am Post subject: Re: Coppermine SQL Error

I believe your fix is here - released after 9.0.5
dragonflycms.org/Forum...A+563.html

American · Supporter Offline Joined: Aug 18, 2004 Posts: 135

Thanks, I'll take a look at that post.

As a side note, I created a normal users, setup an album, uploaded a photo, all with no problems. I was able to suspend the user and delete the album with no issues. Everything seems to work ok but I'll have to look over the link you sent.

American · Supporter Offline Joined: Aug 18, 2004 Posts: 135

If I am reading the post you referred correctly it seems to be a slideshow or googlebot issue. My slideshows work fine without sending any SQL error emails.

Plus, I neglected to post the full email:

Quote::

Guest information:
User id: 6080
Username: tomtheiceman (valid user that signed up months before the upgrade... fyi)
Admin: No
IP: 64.223.83.224
Host: pool-64-223-83-224.burl.east.verizon.net

It was not a googlebot issue.

Am I reading this correctly?

Phoenix · Posted: Wed Aug 10, 2005 1:18 am Post subject: Re: Coppermine SQL Error

hmm, it was slideshow having the error you showed above, and that was what akamu referred to, so I guess so - not a strong gallery user myself, so I'm limited to searching for what's been posted Smile

American · Supporter Offline Joined: Aug 18, 2004 Posts: 135

I'll keep an eye out for more sql error emails and chase the issue if it happens again. Thanks for your help.

wishbone · Posted: Fri Aug 12, 2005 7:04 am Post subject: Re: SQL Error on coppermine

Melinda wrote:

I am also getting this error:
On /coppermine/displayimage/meta=random/album=5/pid=108/slideshow=5000.html
While executing query "SELECT pid, filepath, filename, p.title, keywords, url_prefix, filesize, pwidth, pheight, ctime, p.aid, p.aid FROM cms_cpg_pictures AS p INNER JOIN cms_cpg_albums AS a ON (p.aid = a.aid AND visibility IN (0,3) AND a.aid = 5) WHERE approved='YES' GROUP BY p.pid ORDER BY RAND() LIMIT -1"

the following error occured: 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 '-1' at line 1

In: /home/xtremeje/public_html/includes/coppermine/functions.inc on line: 563

Guest information:
User id: 1
Username: Unregistered Guest
Admin: No
IP: 66.249.65.132
Host: crawl-66-249-65-132.googlebot.com

The problem is, its filling up my email inbox with HUNDREDS OF EMAILS ...
can SOMEONE PLEASE tell me how to stop it....

Thank you....

I'm having this same issue and the above CVS file didn't seem to help. Is there another fix for this issue?

thanks!

namshik · Newbie Offline Joined: Jul 28, 2004 Posts: 26

CPG errors after upgrading cpnuke from 5.01 -> 9.05

On /coppermine/displayimage/meta=random/album=5/pid=101/slideshow=5000.html
While executing query "SELECT pid, filepath, filename, p.title, keywords, url_prefix, filesize, pwidth, pheight, ctime, p.aid, p.aid FROM cms_cpg_pictures AS p INNER JOIN cms_cpg_albums AS a ON (p.aid = a.aid AND visibility IN (0,3) AND a.aid = 5) WHERE approved='YES' GROUP BY p.pid ORDER BY RAND() LIMIT -1"

the following error occured: 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 '-1' at line 1

In: /home/.wakanda/namshik/namshik.com/includes/coppermine/functions.inc on line: 563

Guest information:
User id: 1
Username: Anonymous
Admin: No
IP: 66.249.65.137
Host: crawl-66-249-65-137.googlebot.com