mysql error when upgrading to RC4

[weirdpixels]

Hi,
When using the install script to upgrade the gallery I get an error.

Basically After the upgrade has added the new templates etc and I click on the done button, I then get a message This part of the upgrade will move all of you EXIF info for images into a new table.

Once the Click here to continue is clicked
I get the following error:

Database error in vBulletin 3.0.7:

Invalid SQL: INSERT INTO adv_gallery_exif (imageid, exifinfo) VALUES ('7', 'b:0;')
mysql error: Duplicate entry '7' for key 1

mysql error number: 1062

Date: Wednesday 30th of March 2005 12:52:54 PM
Script: http://www.weirdpixels.com/forum/adm...f&pagenumber=1
Referer: http://www.weirdpixels.com/forum/adm...?do=updateexif
Username: weirdpixels
IP Address:

Any idea of whats going wrong here?

The actually gallery still seems to be working and it says RC4 at the bottom so it looks like the upgrade worked.

[Delphivi]

well could be you clicked that button twice by accident and then MySQL will complain cause you try to add a value that's already there my advice is check to see everything is still working if not come back and somebody will help you if it's still working as it should then there is nothing to worry about

[weirdpixels]

thanks, nothing seems to be wrong so thats probably the case

[ConqSoft]

Were you upgrading from a version earlier than RC3?

[weirdpixels]

nope, was an upgrade to RC4 from RC3

Looks like there was still a small mistake in the upgrade script and you shouldn't have been redirected to that page unless you were upgrading from RC2 or earlier. Going to the extra step as you did won't hurt anything though and I've just updated the files on here to be sure others won't have the same problem.

[weirdpixels]

alright, thanks for the update
And good work again Brian