Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Album Database Error  (Read 2105 times)

0 Members and 1 Guest are viewing this topic.

fixatedrock

  • Coppermine newbie
  • Offline Offline
  • Posts: 5
Album Database Error
« 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?
Logged

fixatedrock

  • Coppermine newbie
  • Offline Offline
  • Posts: 5
Re: Album Database Error
« Reply #1 on: February 20, 2007, 10:45:39 am »

error

Quote
Critical error
There was an error while processing a database query
Logged

Nibbler

  • Guest
Re: Album Database Error
« Reply #2 on: February 20, 2007, 12:22:55 pm »

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

fixatedrock

  • Coppermine newbie
  • Offline Offline
  • Posts: 5
Re: Album Database Error
« Reply #3 on: February 21, 2007, 08:17:16 am »

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
Logged

Nibbler

  • Guest
Re: Album Database Error
« Reply #4 on: February 21, 2007, 01:43:17 pm »

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.
Logged
Pages: [1]   Go Up
 

Page created in 0.021 seconds with 19 queries.