Upgrading from Vanilla 2.0 - 2.3 [RESOLVED]
I have a client who has an old website that uses Vanilla version 18.104.22.168. The website was inaccessible for an extended period of time due to several errors. The client sought help from several people, but the site was never recovered. I was finally able to work through the errors and get the site working, but this meant the site wasn't being upgraded for a long time. Now we want to upgrade to Vanilla 2.3.1 and republish the site (right now, I'm just running it on my local web server). However, the DDL statements we have from the old site, which are many thousands of lines long and contain years-worth of forum content, cannot be run easily in the new database for 2.3.1 since the database structure has changed. For instance, the field "CommentActivityID" no longer exists in the table GDN_Activity. Rather, there is a new table called GDN_ActivityComment that appears to handle that information now. I've tried the typical upgrade method of using utility/upgrade, but to no avail. Does anyone have any tips on how to deal with the database version differences?