Print

[LACA Rio]

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

[Nibbler]

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

[LACA Rio]

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'

[Nibbler]

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

[LACA Rio]

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

[LACA Rio]

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