Print Page - Critical erro - processing database query

Title: Critical erro - processing database query
Post by: LACA Rio on July 13, 2006, 08:58:20 PM

Hi,

My old gallery (1.3.5) was hacked so I've just updated to the latest version of coppermine (1.4.8 stable) but now, I've got problems with my database.
The last one was when I tried to upload new pictures I received this meesage:

"Critical erro - processing database query"

Any Sugestion?

Regards,

www.cagarras.com.br/galeria/
Luiz Araujo

Title: Re: Critical erro - processing database query
Post by: Nibbler on July 13, 2006, 09:14:16 PM

Enable debug mode in config and post the mysql error message (NOT the debug output) that you get when you replicate the error....

Title: Re: Critical erro - processing database query
Post by: LACA Rio on July 13, 2006, 09:23:36 PM

Thanks for reply.

Here's the code:

While executing query "INSERT INTO cpg135_pictures (aid, filepath, filename, filesize, total_filesize, pwidth, pheight, ctime, owner_id, owner_name, title, caption, keywords, approved, user1, user2, user3, user4, pic_raw_ip, pic_hdr_ip, position) VALUES ('3', 'userpics/10001/', '71~1.jpg', '57658', '60927', '400', '300', '1152818535', '1', 'laca','', '', '', 'YES', '', '', '', '', '201.51.163.202', '201.51.163.202', '0')" on 0

mySQL error: Unknown column 'position' in 'field list'

Title: Re: Critical erro - processing database query
Post by: Nibbler on July 13, 2006, 09:25:31 PM

http://forum.coppermine-gallery.net/index.php?action=search2&search=Unknown%20column%20position

Title: Re: Critical erro - processing database query
Post by: LACA Rio on July 13, 2006, 09:35:00 PM

I already run the update.php but the problem persists.
Everything is ok in versiocheck.php except:
anycontent.php
albums/index.php - -
albums/edit/index.html - -
albums/edit/no_FTP-uploads_into_this_folder! - -

albums/edit/index.html - -

albums/userpics/index.php - -
albums/userpics/no_FTP-uploads_into_this_folder!

The upgrade doc says: Except for the "albums" directory, upload all of the new files and directories making sure not to overwrite the include/config.inc.php file, your anycontent.php file or the albums directory.

[]s

Title: Re: Critical erro - processing database query
Post by: LACA Rio on July 13, 2006, 11:58:20 PM

Well,

I upload this files:
albums/index.php
albums/edit/index.html
albums/edit/no_FTP-uploads_into_this_folder!
albums/edit/index.html
albums/userpics/index.php
albums/userpics/no_FTP-uploads_into_this_folder!

And now its working.
I hope I made the right thing.
regards,

Luiz

coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 upgrading => Topic started by: LACA Rio on July 13, 2006, 08:58:20 PM