[Solved]: Critical errror when deleting file : /include/functions.inc.php - Line: 250 [Solved]: Critical errror when deleting file : /include/functions.inc.php - Line: 250
 

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]

Main Menu

[Solved]: Critical errror when deleting file : /include/functions.inc.php - Line: 250

Started by Botilda, February 07, 2009, 07:12:52 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Botilda

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.

QuoteWhile 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.

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

Botilda

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

Ludo


Botilda

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

Ludo

Quote from: Botilda on February 07, 2009, 07:12:52 PMthe user can upload into test album.

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

Fabricio Ferrero

Read Docs and Search the Forum before posting. - Soporte en español
--*--
Fabricio Ferrero's Website

Catching up! :)

Botilda

Quote from: Ludo on February 13, 2009, 02:57:30 PM
"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.

Ludo

QuoteWhile 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.

Botilda

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

Fabricio Ferrero

Read Docs and Search the Forum before posting. - Soporte en español
--*--
Fabricio Ferrero's Website

Catching up! :)