Just wanted to post a note of thanks LoB!!

worked like a charm :) can't wait for an update on the post conversion.

*mr burns voice* exxxcellent....

my old server is now back online so i have access to the IB posts/threads so ill be writing the convertor tonight when i get back from work, should only take a few hours hopefully

Thank you for this. I will be testing both scripts to see if they can merge both the posts and members.

Doesn't work on version 2.19.

After following all the instructions correctly and using 3 different populated vbulletin databases as well as 2 different IB forums, I get the following:

Processing 153 members ..1136: Column count doesn't match value count at row 1

and then these 153 times:

1136: Column count doesn't match value count at row 1
USERFIELD database
.1136: Column count doesn't match value count at row 1

that means that in your userfield table, you have more columns than has been accounted for (have you added any hacks that changes/adds to the userfield table?) to fix, just go into the script and where it writes to the DB, add the extra column information for your database

Here is the structure, no idea on what to do.

#
# Table structure for table 'userfield'
#

CREATE TABLE `userfield` (
`userid` int(10) unsigned NOT NULL default '0',
`field1` char(250) NOT NULL default '',
`field2` char(250) NOT NULL default '',
`field3` char(250) NOT NULL default '',
`field4` char(250) NOT NULL default '',
`importuserid` int(10) unsigned NOT NULL default '0',
`isnew` int(1) unsigned NOT NULL default '0',
`field5` char(250) NOT NULL default '',
`field6` char(250) NOT NULL default '',
PRIMARY KEY (`userid`)
) TYPE=MyISAM;

I tried your converter (IB 2.19b to VB 2.0.3) and found it very useful.
Just a couple of questions or 'bug notification', if any...
:p


First, I realize that you don't import all the fields (i.e. IP address or some other handwrited in the php). Is there a particular reason ?

Second, I noticed that the files in the working directory aren't correctly chosen (*.cgi), but all the files (Apache Un*x server) are listed, even '.' and '..'

O-T: is there any way to reset an auto_increment field in mySql (with phpMyAdmin) for example for a lot of members deleted ?

Thank you very much and excuse my requests.
Bye

I know that this topic is a bit old now but have you completed the posts convertor?
If not, how far have you got?

i also realy need the post converter
right now i use yabb and i already have a member/post converter from YaBB to Ikonboard but i realy need to be able to convert from IB to VB since my board has got 80+ members and over 4000 posts and i do not want to lose em.

http://www.metallica-mechanix.com/metalboard/logo.gif

Which version of Ikonboard you have?

I can convert all your posts and members to a vbulletin database. E-mail me for information, as this involves much more than just a scipt. The method works 100%.

webmaster_listings@yahoo.com

Or you can wait for Jelsoft to release the conversion script they are working on.