A question regarding importing database data and upgrading to 4.0

[shorecogs]

In order to get read for vb 4, I installed a fresh copy of vb 3.8 in a secondary folder on my webserver. I figured instead of messing with the current forum when it's released, I'd install a second copy on my webserver and then do the upgrade on that so my current forums will remain online during the upgrade. Unfortunately my 3.8 database has some customized fields not present in the stock version, so when I try importing the data from the old forum to the new one, I get errors, ie:

SQL query:
-- -- Database: `flot_flotpanel` -- -- -- Dumping data for table `user` -- INSERT INTO `user` (`userid`, `usergroupid`, `membergroupids`, `displaygroupid`, `username`, `password`, `passworddate`, `email`, `styleid`, `parentemail`, `homepage`, `icq`, `aim`, `yahoo`, `msn`, `gf_playstation`, `gf_wii`, `gf_xbox`, `skype`, `showvbcode`, `showbirthday`, `usertitle`, `customtitle`, `joindate`, `daysprune`, `lastvisit`, `lastactivity`, `lastpost`, `lastpostid`, `posts`, `reputation`, `reputationlevelid`, `timezoneoffset`, `pmpopup`, `avatarid`, `avatarrevision`, `profilepicrevision`, `sigpicrevision`, `options`, `birthday`, `birthday_search`, `maxposts`, `startofweek`, `ipaddress`, `referrerid`, `languageid`, `emailstamp`, `threadedmode`, `autosubscribe`, `pmtotal`, `pmunread`, `salt`, `ipoints`, `infractions`, `warnings`, `infractiongroupids`, `infractiongroupid`, `adminoptions`, `ncode_imageresizer_mode`, `ncode_imageresizer_maxwidth`, `ncode_imageresizer_maxheight`, `emailDate`, `ignor[...]
MySQL said:
#1054 - Unknown column 'gf_playstation' in 'field list'

My question is this: Is there a way to take the data from a modded vb like that and strip out the custom stuff so it can be imported to the new forum or is there a way to set it so MySQL doesn't import the fields it doesn't recognize?

Another question I have is this: When vb 4 comes out, will it be possible to do an upgrade from 3.8 to 4.0 if your board is modded or will I need a fresh install of 4.0 with data imported?

[cellarius]

Don't know what you put into your post, but opening this thread I get prompted for http auth for cpanel.wolfserver.com. You want to remove whatever it is.

First question: You realize that by importing your old forum into an new database you will lose all ids (as in threadid, userid etc.) as those will be counted afresh? You sure will have gaps there (deleted posts, threads, users...). The links to the content defined by those ids will break.

Think about doing it this way: Use an empty forum for testing and skinning, then, to migrate, use a copy of your current database and strip out everything not custom.
See this thread: http://www.vbulletin.com/forum/showt...back-to-basics

[shorecogs]

Thank you for the reply. That post has nice information that I might use later on. What about my question about 4.0 (maybe I should ask this in another forum)? Will I be able to upgrade from 3.8 to 4.0 even with my modded board?

[cellarius]

My whole answer is about upgrading to vB4, as is the thread I linked you to. And please remove whatever spawns that password request for your server, that's annoying!