coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Upload => Topic started by: utah on March 29, 2006, 06:55:43 PM

Title: Duplicate entry??? What's wrong
Post by: utah 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
Title: Re: Duplicate entry??? What's wrong
Post by: Nibbler 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.
Title: Re: Duplicate entry??? What's wrong
Post by: utah 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