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

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

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