Mysql Error 1062

StuartDH · April 20th, 2005, 06:10 AM

I've imported my gallery from Coppermine and because of a few problems setting it up, I had to delete the pictures in the file folder and re-import a couple of times.

Now when I try to upload photos to the gallery I get the following error

Invalid SQL: INSERT INTO vb3_adv_gallery_customfields_entries (imgid ) VALUES (1490 )
mysql error: Duplicate entry '1490' for key 1

mysql error number: 1062

Date: Tuesday 19th of April 2005 12:35:44 PM
Script: http://www.wildaboutbritain.co.uk/gallery/upload.php
Referer: http://www.wildaboutbritain.co.uk/g.../upload.php?&c=
Username: StuartDH

I've got a support ticket running, but whilst I wait for a reply from Brian, I was wondering if anyone else has had the same problem and managed to sort it out.

Any tips would be much appreciated.

StuartDH · April 20th, 2005, 09:14 PM

I still can't get this to work properly. Despite the error, the pictures still manage to upload and publish in the gallery once moderated.

bulbasnore · June 13th, 2005, 10:39 PM

I'm having the same problem. Did you get it solved?

June 14th, 2005, 11:13 AM

It's not that easy to explain how to fix the problem. If you'd like to submit a support ticket though I'll be glad to have a look at things and make sure the problem gets sorted.

dcpaq2 · May 27th, 2006, 10:48 AM

Anyone know the fix to this, im dealing with the same thing.

Thanks

Doug