IPB 2.3.6 to VB 3.7.4 Patch Level 1 (Updateing parent ids, please wait)

[muks]

I decided to buy a license and tried converting my IPB 2.3.6 board. It's just a test import but when it comes to the part of importing the posts, it stops at From : 1796605 :: To : 1801869 and at the end there's

Invalid, skipping. Failed on : threadid . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Updateing parent ids, please wait

and I'm running top and loads are now low and it seems Impex is not running anymore but why does it say to please wait?

I run Impex on standalone with 1024MB memory limit, I did this to the target database before I ran the import posts

ALTER TABLE `post` DROP INDEX `title`;

and

ALTER TABLE `post` ADD INDEX `idx_importpostthread` ( `importpostid` , `importthreadid` )

ALTER TABLE `thread` ADD INDEX `idx_importthread` ( `importthreadid` )

also:

define('shortoutput', true);
define('dupe_checking', true);

and 13,000 posts per page

Help? :confused:

[Jerry]

Set the parent id update to false in IMpExConfig and try it again.

[muks]

define('skipparentids', false);

its already set to false by default

[muks]

ok set it to true

define('skipparentids', true);

and import is finally done

now the problem is with cleaner.php


$do_posts = true;
$do_sigs = false;
$do_thread_titles = false;
$do_pm_text = false;
$do_pm_text_title = false;I get

Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/***/domains/****/public_html/vb/impex/db_mysql.php on line 281

There seems to have been a problem with the database.


ImpEx Database errormysql error: Invalid SQL: SELECT postid, pagetext, title FROM post

mysql error: MySQL client ran out of memory

mysql error number: 2008

Date: Monday 15th 2008f December 2008 05:30:37 PM
Database: ***_vb
MySQL error: MySQL client ran out of memory

[Jerry]

On larger boards it is much better to use direct SQL, what is it that you're trying to clean out ?

[muks]

I'm trying to clean out posts

the quotes, there are a lot of


<div class='quotetop'>QUOTE (*** @ Dec 10 2008, 07:42 PM) <{POST_SNAPBACK}> (http://index.php/?act=findpost&pid=1798650)</div>in the signature, there are


<div align='center'>*image here*</div>and


<span style="color:#F5DEB3">*text here*</span>

[muks]

And do I have to delete the imported default member group from IPB so that they all go to the registered users?

[muks]

I also have a lot of bbcodes from IPB with the following format


[flash=1,1]http://url-of-flv-file.flvit displays flash in posts and when it was imported to VB it became


<OBJECT CLASSID='clsid27CDB6E-AE6D-11cf-96B8-444553540000' WIDTH='1' HEIGHT='1'><PARAM NAME='MOVIE' VALUE='http://url-of-flv-file.flv'><PARAM NAME='PLAY' VALUE='TRUE'><PARAM NAME='LOOP' VALUE='TRUE'><PARAM NAME='QUALITY' VALUE='HIGH'><PARAM NAME='allowscriptaccess' VALUE='never'><EMBED AllowScriptAccess='never' SRC='http://url-of-flv-file.flv' WIDTH='1' HEIGHT='1' PLAY='TRUE' LOOP='TRUE' QUALITY='HIGH'></EMBED></OBJECT>

[Jerry]

And do I have to delete the imported default member group from IPB so that they all go to the registered users?

Yes, that will move the users into the registered group, as per :

http://www.vbulletin.com/docs/html/impex_cleanup

I'm checking out the parsing atm.