forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: Botilda on February 07, 2009, 07:12:52 pm

Title: [Solved]: Critical errror when deleting file : /include/functions.inc.php - Line: 250
Post by: Botilda on February 07, 2009, 07:12:52 pm

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

Title: Re: Critical errror when deleting file : /include/functions.inc.php - Line: 250
Post by: Botilda on February 12, 2009, 10:38:22 pm

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

Title: Re: Critical errror when deleting file : /include/functions.inc.php - Line: 250
Post by: Ludo on February 12, 2009, 11:51:40 pm

Did you run update.php after upgrading?

Title: Re: Critical errror when deleting file : /include/functions.inc.php - Line: 250
Post by: Botilda on February 13, 2009, 12:19:19 pm

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

Title: Re: Critical errror when deleting file : /include/functions.inc.php - Line: 250
Post by: Ludo on February 13, 2009, 02:57:30 pm

Quote from: Botilda on February 07, 2009, 07:12:52 pm

the user can upload into test album.

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

Title: Re: Critical errror when deleting file : /include/functions.inc.php - Line: 250
Post by: Fabricio Ferrero on February 13, 2009, 03:24:29 pm

Quote from: Ludo on February 13, 2009, 02:57:30 pm

Also, do you have Modpack by Stramm installed?

No, he hasn't. ;)

Title: Re: Critical errror when deleting file : /include/functions.inc.php - Line: 250
Post by: Botilda on February 13, 2009, 04:06:43 pm

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.

Title: Re: Critical errror when deleting file : /include/functions.inc.php - Line: 250
Post by: Ludo on February 13, 2009, 05:00:49 pm

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.

Title: Re: Critical errror when deleting file : /include/functions.inc.php - Line: 250
Post by: Botilda on February 13, 2009, 09:01:17 pm

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

Title: Re: [Solved]: Critical errror when deleting file : /include/functions.inc.php - Line: 250
Post by: Fabricio Ferrero on February 13, 2009, 09:41:32 pm

You're welcome, thanks for coming back and solve the topic. ;)