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: Duplicate entry??? What's wrong  (Read 4809 times)

0 Members and 1 Guest are viewing this topic.

utah

  • Coppermine newbie
  • Offline Offline
  • Posts: 9
Duplicate entry??? What's wrong
« on: March 29, 2006, 06:55:43 pm »
Hey there,

After my succesful upload of my back-up, this error appeared while uploading pictures...

mySQL error: Duplicate entry '0' for key 1

My Web: www.77photography.nl/coppermine

username: test
password: test

Greets,

Jasper
Logged

Nibbler

  • Guest
Re: Duplicate entry??? What's wrong
« Reply #1 on: March 29, 2006, 07:11:43 pm »
You didn't include the auto_increment settings in your backup. You will need to re-add these back in manually, so check thr sql/schema.sql file and search the board for details.
Logged

utah

  • Coppermine newbie
  • Offline Offline
  • Posts: 9
Re: Duplicate entry??? What's wrong
« Reply #2 on: March 30, 2006, 11:13:46 pm »
Hey Nibbler,

I've found some info:
You need to reset the autoincrement. run the query:


Code:
ALTER TABLE cpg130d_pictures AUTO_INCREMENT=0

How do I run a query?? Is that a strange question?

Best regards,

Jasper
Logged
Pages: [1]   Go Up
« previous next »
 

Page created in 0.014 seconds with 16 queries.