error im trying to upgrade from vb3.8.0 to vb4.0.7 and this is what error say i need

[dznmods]

Step 4) Import latest style

Importing vbulletin-style.xml

Database error
The DZN Mods Forums database has encountered a problem.
Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the http://www.dznmods.net home page, then try to open another page.
Click the Back button to try another link.
The http://www.dznmods.net forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.
danny
Sep 30th '10 02:35am
Database error in vBulletin 3.8.0:

Invalid SQL:

REPLACE INTO stylevardfn
(stylevarid, styleid, stylevargroup, product, datatype, validation, failsafe)
VALUES
('albumedit_blockrow_border', -1, 'Album', 'vbulletin', 'border', '', ''),('albumedit_maineditor_background', -1, 'Album', 'vbulletin', 'background', '', ''),('albumedit_maineditor_border', -1, 'Album', 'vbulletin', 'border', '', ''),('albumedit_maineditor_width', -1, 'Album', 'vbulletin', 'size', '', ''),('albumedit_thumbnailedit_width', -1, 'Album', 'vbulletin', 'size', '', ''),('albumlist_blockbody_background', -1, 'Album', 'vbulletin', 'background', '', ''),('albumlist_entry_background', -1, 'Album', 'vbulletin', 'background', '', ''),('albumlist_entry_border', -1, 'Album', 'vbulletin', 'border', '', ''),('albumlist_entry_width', -1, 'Album', 'vbulletin', 'size', '', ''),('albumlist_image_shadow_color', -1, 'Album', 'vbulletin', 'color', '', ''),('albumtop_background', -1, 'Album', 'vbulletin', 'background', '', ''),('albumtop_border', -1, 'Album', 'vbulletin', 'border', '', ''),('albumtop_font_size', -1, 'Album', 'vbulletin', 'size', '', ''),('albumtop_list_a_color', -1, 'Album', 'vbulletin', 'color', '', ''),('albumtop_list_a_hover_color', -1, 'Album', 'vbulletin', 'color', '', ''),('albumtop_margin', -1, 'Album', 'vbulletin', 'size', '', ''),('album_content_width', -1, 'Album', 'vbulletin', 'size', '', ''),('picturelink_img_shadow_color', -1, 'Album', 'vbulletin', 'color', '', ''),('picturelink_margin', -1, 'Album', 'vbulletin', 'size', '', '');

MySQL Error : Table 'forumdznmods.stylevardfn' doesn't exist
Error Number : 1146
Request Date : Wednesday, September 29th 2010 @ 11:21:29 PM
Error Date : Wednesday, September 29th 2010 @ 11:21:29 PM
Script : http://www.dznmods.net/install/final...p=4&startat=60
Referrer : http://www.dznmods.net/install/final...p=4&startat=50
IP Address : 75.108.189.42
Username :
Classname : vB_Database
MySQL Version : 5.0.91-log

[Lynne]

Did you have any previous errors during the upgrade? That table should have been created. You can get the information for creating it in the install/mysql-schema.php file.

[Videx]

Personally, I just very carefully uninstalled all my old mods (including uploaded files) and styles before updating. Nothing but trouble.