Mysql error on upload

[camoman]

I upgraded my gallery a couple weeks ago from to the latest version and now I noticed that when I try to upload multiple images I get a MYSQL error

Database error in vBulletin 3.0.7:

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

mysql error number: 1062

Date: Wednesday 22nd of March 2006 11:21:58 AM
Script: http://www.trackshare.com/gallery/upload.php
Referer: http://www.trackshare.com/gallery/upload.php
Username: camoman
IP Address: 205.200.79.250Database error in vBulletin 3.0.7:

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

mysql error number: 1062

Date: Wednesday 22nd of March 2006 11:21:58 AM
Script: http://www.trackshare.com/gallery/upload.php
Referer: http://www.trackshare.com/gallery/upload.php
Username: xxxxx
IP Address: xxx.xxx.xxx.xxx

Why is this happening?!?!

[camoman]

Anyone have any ideas on this one?? I have been doing some reseach and it almost looks like its trying to index the pictures where others already are?!? how do I fix this?

[camoman]

So how long does a paying user have to wait for support ?? I ended up fixing the probelm by back reving the upgrade.. What now do I try it againg?!?! sure would help if I knew what could have caused this.

[camoman]

Well looks like the problem is back.. can anyone help me with this?!?!?!

[Zachariah]

Take a look @ your adv_gallery_images table via. phpMyAdmin.

Browse the table and find out what the last imageid is on the last record added.

Hit: Operations Tab
At the bottem of the page is AUTO_INCREMENT under table options section.

Add 1 to your last / largest imageid and save.

EX: If your last record has imageid 2000 then place 2001 in the AUTO_INCREMENT field.

Save