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

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

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