Print

[fixatedrock]

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?

[fixatedrock]

error

Critical error
There was an error while processing a database query

[Nibbler]

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.

[fixatedrock]

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

[Nibbler]

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.