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
QuoteCritical 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.