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: [Solved]: Critical errror when deleting file : /include/functions.inc.php - Line: 250  (Read 3561 times)

0 Members and 1 Guest are viewing this topic.

Botilda

  • Coppermine newbie
  • Offline Offline
  • Posts: 11

Yesterday I updated from 1.4.17 to 1.4.20, and now I am no longer able to delete files, nor delete users.
I have tried to update again today, but that didn't help.

I get this error when deleting picture:

There was an error while processing a database query.

Quote
While executing query "DELETE FROM  WHERE picture_id='22163'" 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='22163'' at line 1

File: /home/julia/public_html/gallery/include/functions.inc.php - Line: 250 

I get this error when trying to delete user:

There was an error while processing a database query.

Quote
While executing query "DELETE FROM  WHERE user_id='836,835,834,833,832,831,830,829,828,827,826,825,824,823,822,821,820,819,818,817,816,815,814,813'" 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 user_id='836,835,834,833,832,831,830,829,828,827,826,825,824,823,822,821,8' at line 1

File: /home/julia/public_html/gallery/include/functions.inc.php - Line: 250 

Gallery: http://julia.fan-sites.org/gallery

I made a regular user account:
User: Test
Password: Test
Debug information is turned on, and the user can upload into test album.

Any help is very much appreciated :)
« Last Edit: February 13, 2009, 09:04:22 pm by Nibbler »
Logged

Botilda

  • Coppermine newbie
  • Offline Offline
  • Posts: 11

Could anyone please have a look?
I am still able to upload pictures, but not delete any of them.
Logged

Ludo

  • Contributor
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 706
    • E+GiElle

Did you run update.php after upgrading?
Logged

Botilda

  • Coppermine newbie
  • Offline Offline
  • Posts: 11

Yes. I even tried updating twice, re-installing everything over again and running updape.php again.
Logged

Ludo

  • Contributor
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 706
    • E+GiElle

the user can upload into test album.

"You don't have permission to perform this operation."
Also, do you have Modpack by Stramm installed?
Logged

Fabricio Ferrero

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 1996
  • From San Juan, Argentina, to the World!
    • http://fabricioferrero.com/

Also, do you have Modpack by Stramm installed?

No, he hasn't. ;)
Logged
Read Docs and Search the Forum before posting. - Soporte en espaņol
--*--
Fabricio Ferrero's Website

Catching up! :)

Botilda

  • Coppermine newbie
  • Offline Offline
  • Posts: 11

"You don't have permission to perform this operation."
Also, do you have Modpack by Stramm installed?

Sorry, I had disabled uploads for users. You can try it now.
I haven't installed Modpack, but this gallery has not always been mine. It has worked fine for me for a year though, till I upgraded it.
Logged

Ludo

  • Contributor
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 706
    • E+GiElle

Quote
While executing query "DELETE FROM  WHERE picture_id='22165'" on 0
"picture_id" seems not a valid field name, it should be "pid" as of my delete.php file
Your delete.php might be outdated: please attach it.
Logged

Botilda

  • Coppermine newbie
  • Offline Offline
  • Posts: 11

You were completely right! the delete.php was outdated.

Looks like I had updated everything except for a bunch of files in the root folder. I think FileZilla tricked me..
Uploaded all of them one by one and everything works fine now.

Thank you very much for your help  :)
Logged

Fabricio Ferrero

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 1996
  • From San Juan, Argentina, to the World!
    • http://fabricioferrero.com/

You're welcome, thanks for coming back and solve the topic. ;)
Logged
Read Docs and Search the Forum before posting. - Soporte en espaņol
--*--
Fabricio Ferrero's Website

Catching up! :)
Pages: [1]   Go Up
 

Page created in 0.027 seconds with 20 queries.