prefix_vb4_cmsanswered_title_rich upgrade db error

[kaan_18_samsun]

hi
3.8.2 to 4.0.1 suite upgrade error

step 6 cms install/upgrade





Invalid SQL:
ALTER TABLE cms_article ADD previewvideo TEXT NULL DEFAULT NULL;
MySQL Error : Duplicate column name 'previewvideo'




delete previewvideo tablo but below the warning

Database error in vBulletin 4.0.1:
Invalid SQL:
insert into cms_widgettype(class, packageid)
values('CategoryNavBU', );
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 2
Error Number : 1064


please help me upgrade forum

[Trevor Hannant]

If you got a duplicate column error then one of two things has happened here:

1. You've previously tried to upgrade this database and haven't reverted to your 3.8.2 one properly or
2. You've re-run the same step during the upgrade

Can you do the following and see what happens here (make sure you have a backup BEFORE doing this!):

- drop all vB database tables
- restore your 3.8.2 backup to a new database
- check that the 'cms_' tables don't already exist in the restored database (if they do, drop them)
- update config.php to point to the newly restored database
- re-run upgrade.php

What happens this time?