forum.coppermine-gallery.net
Support => cpg1.4.x Support => Older/other versions => cpg1.4 upload => Topic started by: fixatedrock on February 20, 2007, 10:42:08 am
-
I just moved my gallery from one server to another and I'm having problems. This one is that I am trying to create an album in a certain category and everytime I try it comes up with a database error message. I can create an album elsewhere but in this category it always comes up with an error. Can anyone tell me how to solve this problem?
-
error
Critical error
There was an error while processing a database query
-
Enable debug mode and post the mysql error message (not the entire debug output) that you get when you replicate the error. Please search the board before posting.
-
While executing query "INSERT INTO cpg148_albums (category, title, uploads, pos) VALUES ('4', 'AT&T blue room', 'NO', '1')" on 0
mySQL error: Duplicate entry '0' for key 1
------------------------------------------------------------------------------------------------------------
While executing query "INSERT INTO cpg148_pictures (pid, 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 ('', '30', 'userpics/10001/', '6~2.jpg', '95096', '108740', '600', '715', '1172042202', '1', 'Jen','', '', '', 'YES', '', '', '', '', '71.160.15.27', '71.160.15.27', '0')" on 0
mySQL error: Duplicate entry '0' for key 1
-
Your auto increments are missing. You probably failed to preserve them when you migrated the database tables. Re-add them to the tables using the sql/schema.sql as a reference.