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
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.