Invalid SQL: INSERT INTO adv_gallery_customfields_entries

[PageUp]

I get this error after I upload an image:

----------------

Database error in vBulletin 3.0.7:

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

mysql error number: 1062

Date: Wednesday 30th of March 2005 03:33:37 AM
Script: http://www.domain.com/gallery/upload.php
Referer: http://www.domain.com/gallery/upload.php?&c=
Username: User
IP Address:

----------------

Image gets uploaded despite this error. However, image count and link to the image within the categories are updated only after I use the "Update Category Counters" tool in the CP.

This error appeared after I've moved the site to a new dedicated server. Before transferring d/b and files, I've removed all images. Could this be due to the fact that I'm now running newer versions of PHP and MySQL? vBa Gallery still works fine on the old server.

PHP old: 4.3.9-11.rh90.art
PHP new: 4.3.10-3.rhel3.art

MySQL old: 4.0.21-2.rh90.art
MySQL new: 4.0.24-2.rhel3.art

(I use Plesk)


vBulletin and 2 other applications also seem to work fine on the new server. I've upgraded RC3 to RC4 but the error is still the same.

Did you manually empty your adv_gallery_images table or anything like that? The error indicates that you already have values for the custom fields associated with that imageid and there shouldn't be any way that could occur otherwise.

[PageUp]

No, I'm pretty sure I didn't do that. I used the empty category tool in the admin CP.

The thing is that Gallery works without any issues on my old VPS. As far as I know, database and files are same in both places (well, they were before I've upgraded to RC4 on the new server - but like I said, the error appeared before the upgrade).

Would you recommend that I upgrade to RC4 on the old server as well and then try to copy tables from that d/b to the new one again? Which tables do I need to copy?

If you'd like to just submit a support ticket I'll have a look and get those extra ones cleared out for you.