vBulletin 3.0.x failed importing threads Issue Tools
issueid=26033 Wed 23rd Jul '08 10:39am
Senior Member
vBulletin 3.0.x failed importing threads
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:

Code:
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.)
Issue Details
Project ImpEx
Category SQL error
Status Not a Bug
Priority 8
Affected Version Unknown
Fixed Version (none)
Users able to reproduce bug 0
Users unable to reproduce bug 0
Assigned Users (none)
Tags (none)

Thu 24th Jul '08 12:59pm
ImpEx Developer
 
This is not a bug, you are using the wrong target system when selecting at the first stage of the import.
Reply
Thu 24th Jul '08 7:01pm
Senior Member
 
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
Reply
Reply