vBulletin 3.0.x failed importing threads

[lim (x³-7x²) = ∞]

Unknown column 'hiddencount'

Converting phpBB3 3.0.1 to vBulletin 3.0.9 and vBulletin 3.0.17 results in this error for "Import thread" module:



ImpEx Database errormysql error: Invalid SQL:
INSERT INTO thread
(
forumid, title, importforumid,
importthreadid, firstpostid, lastpost,
pollid, open, replycount,
postusername, postuserid, lastposter,
dateline, views, iconid,
notes, visible, sticky,
votenum, votetotal, attach, similar,
hiddencount, deletedcount
)
VALUES
(
'5',
'Welcome to phpBB3',
'2',
'1',
'',
'',
'0',
'1',
'0',
'admin',
'2',
'0',
'0',
'0',
'0',
'Imported thread',
'1',
'',
'0',
'0',
'',
'',
'',
''
)


mysql error: Unknown column 'hiddencount' in 'field list'

mysql error number: 1054

Date: Wednesday 23rd 2008f July 2008 11:27:45 AM
Database: vbulletin3
MySQL error:


(I need 3.0.*, I didnt tried it with newer vBulletin versions.)

[Jerry]

This is not a bug, you are using the wrong target system when selecting at the first stage of the import.

[lim (x³-7x²) = ∞]

I was using "3.0.x" target system, other modules worked :


ImpEx will now Alter the tables in the vB database to include import id numbers. This is needed during the import process for maintaining refrences between the tables during an import. If you have large tables (i.e. lots of posts) this can take some time. They will also be left after the import if you need to link back to the origional vB userid.

moderator - importmoderatorid Completed
usergroup - importusergroupid Completed
ranks - importrankid Completed
poll - importpollid Completed
forum - importforumid Completed
forum - importcategoryid Completed
user - importuserid Completed
style - importstyleid Completed
thread - importthreadid Completed
post - importthreadid Completed
thread - importforumid Completed
smilie - importsmilieid Completed
pmtext - importpmid Completed
avatar - importavatarid Completed
customavatar - importcustomavatarid Completed
customprofilepic - importcustomprofilepicid Completed
post - importpostid Completed
attachment - importattachmentid Completed
pm - importpmid Completed
usernote - importusernoteid Completed
phrase - importphraseid Completed
subscription - importsubscriptionid Completed
subscriptionlog - importsubscriptionlogid Completed




Importing 6 Usergroups

From : 0 :: To : 6

15.79% Usergroup -> GUESTS
15.79% Usergroup -> REGISTERED
15.79% Usergroup -> REGISTERED_COPPA
15.79% Usergroup -> GLOBAL_MODERATORS
15.79% Usergroup -> ADMINISTRATORS
15.79% Usergroup -> BOTS



Would you like to associated imported users with existing users if the email address matches ?
Yes No

Would you like to import the avatars, this can take some time if they are remotely linked
Yes No
What is the full path to your avatars directory ? (make sure the web server has access to read them).



Import user


Importing 2 Categorys
40.74% Forum -> Your first category
40.74% Forum -> box