Error uploading after increasing Custom Fields Error uploading after increasing Custom Fields
 

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

Error uploading after increasing Custom Fields

Started by Rai, December 19, 2007, 10:40:01 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Rai

I made this modification to my gallery: http://forum.coppermine-gallery.net/index.php?topic=23695.0

I successfully created new fields but when I get to the end of the upload process and hit continue I get this:
There was an error while processing a database query.

This is my debug report:
QuoteWhile executing query "INSERT INTO cpg14x_pictures (pid, aid, filepath, filename, filesize, total_filesize, pwidth, pheight, ctime, owner_id, owner_name, title, caption, keywords, approved, user1, user2, user3, user4, user5, user6, user7, user8,  pic_raw_ip, pic_hdr_ip, position) VALUES ('', '4', 'userpics/10001/', 'MVC-013F~0.jpg', '237981', '269494', '640', '480', '1198099728', '1', 'admin','', '', '', 'YES', '4', '5', '6', '7', '8', '', '', '',  '38.105.83.34', '38.105.83.34', '0')" on 0

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




I had made the database change via uploading a text file with the singe line:
QuoteINSERT INTO `cpg14x_config` ( `name` , `value` ) VALUES ('user_field_num', '4');

(I did backup my database before I modified it because I have next to no experience doing it.)

Joachim Müller

You appear not to have made the needed database modifications. Use a third-party tool like phpMyAdmin to verfiy or apply the needed changes. Undo the mod if that's beyond your skills.

Rai

Quote from: GauGau on December 20, 2007, 08:04:37 AM
You appear not to have made the needed database modifications.

When I try to add in the new line again (via Run SQL query/queries on database) I get an error saying "#1062 - Duplicate entry 'user_field_num' for key 1"

I've attached two screenshots.

What am I doing wrong?

Nibbler


Rai

Quote from: Nibbler on December 20, 2007, 04:58:37 PM
Review the posts in the mod's thread as your problem is discussed there. See particularly http://forum.coppermine-gallery.net/index.php?topic=23695.msg142556#msg142556.

Oops, I figured I'd missed something but got lost. I made the change and now I'm getting this error:
QuoteWhile executing query "INSERT INTO cpg14x_pictures (pid, aid, filepath, filename, filesize, total_filesize, pwidth, pheight, ctime, owner_id, owner_name, title, caption, keywords, approved, user1, user2, user3, user4, user5,  pic_raw_ip, pic_hdr_ip, position) VALUES ('', '4', 'userpics/10001/', 'MVC-013F~2.jpg', '237981', '269494', '640', '480', '1198168396', '1', 'admin','', '', '', 'YES', 'LOC', 'EVENT', 'NAMES', 'DATE', 'PERM',  '38.105.83.34', '38.105.83.34', '0')" on 0

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

I've attached the debug info (it was to long to include)

I've also attached the admin file with the changes (did I put it in wrong?)

Thanks  :)

Rai