Duplicate entry??? What's wrong Duplicate entry??? What's wrong
 

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]

Main Menu

Duplicate entry??? What's wrong

Started by utah, March 29, 2006, 06:55:43 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

utah

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

Nibbler

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.

utah

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