Bug Gold upgrade database error.

[Neo_Angelo]

I get the following when upgrading from beta to GOLD just a heads up (not sure if its me or the product thats going wrong):

Database error in vBulletin 4.1.11:

Invalid SQL:
UPDATE vBdbtech_avatars_part SET layerid = '1' WHERE folder = '';

MySQL Error   : Unknown column 'folder' in 'where clause'
Error Number  : 1054
Request Date  : Monday, April 2nd 2012 @ 10:52:12 AM
Error Date    : Monday, April 2nd 2012 @ 10:52:14 AM
Script        : http://www.pantherproducts.co.uk/forums/*****/plugin.php?do=productimport
Referrer      : http://www.pantherproducts.co.uk/forums/*****/plugin.php?do=productadd
IP Address    : *.***.***.**
Username      : *******
Classname     : vB_Database
MySQL Version : 5.1.56

 

[Fillip H.]

That code doesn't exist in the upgrade file from 1.0.1 to 1.0.2.

What is the version number listed in your Product Manager?

 

[Neo_Angelo]

mine says vBavatars version 1.0.0 (although i'm sure i've updated before *shrugs*)

 

[Fillip H.]

Manually set it to 1.0.1 then

 

[Neo_Angelo]

i think i broke it again i get a new DB error after changing version manually to 1.0.1:

Database error in vBulletin 4.1.11:

Invalid SQL:

		INSERT INTO `vb_dbtech_avatars_part` 
			(`title`, `active`, `categoryid`, `displayorder`, `filename`, `permissions`, `price`, `layerid`)
		VALUES
			('Female Base 2', '1', 1, 11, 'avatar_base_female_B.png', NULL, 10, 1),
			('Female Base 3', '1', 1, 12, 'avatar_base_female_C.png', NULL, 10, 1),
			('Female Base 4', '1', 1, 13, 'avatar_base_female_D.png', NULL, 10, 1),
			('Male Base 2', '1', 1, 21, 'avatar_base_male_B.png', NULL, 10, 1),
			('Male Base 3', '1', 1, 22, 'avatar_base_male_C.png', NULL, 10, 1),
			('Male Base 4', '1', 1, 23, 'avatar_base_male_D.png', NULL, 10, 1);

MySQL Error   : Table 'panther_vBulletin.vb_dbtech_avatars_part' doesn't exist
Error Number  : 1146
Request Date  : Monday, April 2nd 2012 @ 11:01:09 AM
Error Date    : Monday, April 2nd 2012 @ 11:01:10 AM
Script        : http://www.pantherproducts.co.uk/forums/***/plugin.php?do=productimport
Referrer      : http://www.pantherproducts.co.uk/forums/***/plugin.php?do=productadd
IP Address    : *.***.***.**
Username      : *****
Classname     : vB_Database
MySQL Version : 5.1.56

 

[Fillip H.]

Fixed, re-download and re-upload then try it again.

 

[Neo_Angelo]

I can confirm it is working correctly now nice job on the fix whatever you did has done the trick