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

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

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