I made this modification to my gallery: http://forum.coppermine-gallery.net/index.php?topic=23695.0 (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.)
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.
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?
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.
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 :)
Please, I really need help with this! :(