Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: mysql error  (Read 4322 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.027 seconds with 20 queries.