forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: Tracey12 on October 27, 2007, 02:36:42 pm

Title: mysql error
Post by: Tracey12 on October 27, 2007, 02:36:42 pm
hi. i was trying to delete a file when i got this error: can you help please.

While executing query "DELETE FROM  WHERE picture_id='5503'" on 0

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 'WHERE picture_id='5503'' at line 1



File: /home/neyopix/public_html/include/functions.inc.php - Line: 249
Title: Re: mysql error
Post by: Sami on October 27, 2007, 02:43:39 pm
Did you change any core code ?
Title: Re: mysql error
Post by: Tracey12 on October 27, 2007, 07:07:45 pm
No. Not at all.
Title: Re: mysql error
Post by: Hein Traag on October 27, 2007, 07:23:45 pm
reupload a fresh functions.inc.php see if that works..
Title: Re: mysql error
Post by: Tracey12 on October 27, 2007, 10:05:27 pm
Still same message:

While executing query "DELETE FROM  WHERE picture_id='5506'" on 0

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 'WHERE picture_id='5506'' at line 1
Title: Re: mysql error
Post by: Sami on October 28, 2007, 05:17:42 am
Do you have any plugin/mod installed?
If you were deleting from displayimage.php then re-upload delete.php
Title: Re: mysql error
Post by: Joachim Müller on October 28, 2007, 10:39:34 am
Post a link to your gallery for a start.
Title: Re: mysql error
Post by: Tracey12 on October 28, 2007, 03:45:12 pm
Quote from: Sami on October 28, 2007, 05:17:42 am
Do you have any plugin/mod installed?
If you were deleting from displayimage.php then re-upload delete.php

I have the WhoIsOnline Mod installed, and I may have Stramn's modpack also, but I'm not sure.
Thank you! That has fixed the issue. :)

Quote from: GauGau on October 28, 2007, 10:39:34 am
Post a link to your gallery for a start.

http://neyopictures.net