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