Advanced search  

News:

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

Pages: [1]   Go Down

Author Topic: mysql error  (Read 3858 times)

0 Members and 1 Guest are viewing this topic.

Tracey12

  • Coppermine newbie
  • Offline Offline
  • Posts: 15
mysql error
« 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
« Last Edit: October 29, 2007, 04:44:16 am by Sami »
Logged

Sami

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 3686
  • BMossavari
    • My Project
Re: mysql error
« Reply #1 on: October 27, 2007, 02:43:39 pm »

Did you change any core code ?
Logged
‍I don't answer to PM with support question
Please post your issue to related board

Tracey12

  • Coppermine newbie
  • Offline Offline
  • Posts: 15
Re: mysql error
« Reply #2 on: October 27, 2007, 07:07:45 pm »

No. Not at all.
Logged

Hein Traag

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: nl
  • Offline Offline
  • Gender: Male
  • Posts: 2166
  • A, B, Cpg
    • Personal website - Spintires.nl
Re: mysql error
« Reply #3 on: October 27, 2007, 07:23:45 pm »

reupload a fresh functions.inc.php see if that works..
Logged

Tracey12

  • Coppermine newbie
  • Offline Offline
  • Posts: 15
Re: mysql error
« Reply #4 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
Logged

Sami

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 3686
  • BMossavari
    • My Project
Re: mysql error
« Reply #5 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
Logged
‍I don't answer to PM with support question
Please post your issue to related board

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: mysql error
« Reply #6 on: October 28, 2007, 10:39:34 am »

Post a link to your gallery for a start.
Logged

Tracey12

  • Coppermine newbie
  • Offline Offline
  • Posts: 15
Re: mysql error
« Reply #7 on: October 28, 2007, 03:45:12 pm »

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. :)

Post a link to your gallery for a start.

http://neyopictures.net
Logged
Pages: [1]   Go Up
 

Page created in 0.126 seconds with 21 queries.