• Welcome to Simple Machines Community Forum. Please login or sign up.
December 06, 2021, 10:58:21 AM

News:

Wondering if this will always be free?  See why free is better.


[SMF Converter] IPB 1.3.x

Started by JayBachatero, January 28, 2007, 02:56:33 PM

Previous topic - Next topic

ThorstenE

have you tried to restart the conversion from the beginning?
Sometimes clicking "continue" will cause errors and cause a double submission of the form. try to restart. convert.php should continue it's work without clicking the "continue" button.

GerMalaz

Trying to convert a fairly big (few hundred thousand posts) and active (would like to minimize off time) forum.

Topic conversion is very slow, taking hours now, and ongoing.

Any advice on speeding it up? (Dual Xeon 2.8, single IDE disk).

SleePy

You can change the block size of the sections it is converting.
Such as if it was converting topics at the moment.
You could open the .sql
Find:
---* {$to_prefix}topics

and Replace that with:
---* {$to_prefix}topics 200
Note that 200 added after it is the only change.

The 200 will change the block size of how many topics it is converting at once. So you can play with this and use bigger or smaller numbers, depending on what your server will allow.

Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

GerMalaz

Thanks, will recheck.

It did it (500 at a time), took several hours (like 15+, unclear).

Another issue:


Converting posts (this may take some time)...
Successful.
Converting polls...
Successful.
Converting poll options...
Unsuccessful!
This query:

    INSERT INTO `smf`.smf115_poll_choices
    (ID_POLL, ID_CHOICE, label, votes)
    VALUES (1, SUBSTRING('1', 1, 255), '8 boards', 1, 255), '15'),
    .......... more data .............

Caused the error:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''15'),
    (1, SUBSTRING('2', 1, 255), '12 boards', 1, 255), '35'),
    ' at line 3

 
where (1, 1, '8 boards', 15) looks more appropiate.

Maybe I'm using an outdated .sql?

ThorstenE

the invision_to_smf.sql from the first post of this topic should be up to date?!?! maybe it is not, try the version from this post:
http://www.simplemachines.org/community/index.php?topic=146211.msg1522935#msg1522935

GerMalaz

My fault, was using an old one, taken from smf_1-1-5_invision_converter.tar.gz.

Maybe it can be updated?

GerMalaz

Also solved the slow topics conversion issue:

Replaced
SELECT
       t.tid AS ID_TOPIC, t.pinned AS isSticky, t.forum_id AS ID_BOARD,
       t.starter_id AS ID_MEMBER_STARTED, t.last_poster_id AS ID_MEMBER_UPDATED
,
       pl.pid AS ID_POLL, t.posts AS numReplies, t.views AS numViews,
       MIN(p.pid) AS ID_FIRST_MSG, MAX(p.pid) AS ID_LAST_MSG,
       t.state = 'closed' AS locked
FROM ({$from_prefix}topics AS t, {$from_prefix}posts AS p)
       LEFT JOIN {$from_prefix}polls AS pl ON (pl.tid = t.tid)
WHERE p.topic_id = t.tid
GROUP BY t.tid
HAVING ID_FIRST_MSG != 0
       AND ID_LAST_MSG != 0;

with

SELECT
       ID_TOPIC, isSticky, ID_BOARD, ID_MEMBER_STARTED, ID_MEMBER_UPDATED,
       pl.pid AS ID_POLL, numReplies, numViews, ID_FIRST_MSG, ID_LAST_MSG,
       locked
FROM ( SELECT
               t.tid AS ID_TOPIC, t.pinned AS isSticky,
               t.forum_id AS ID_BOARD, t.starter_id AS ID_MEMBER_STARTED,
               t.last_poster_id AS ID_MEMBER_UPDATED, t.posts AS numReplies,
               t.views AS numViews, MIN(p.pid) AS ID_FIRST_MSG,
               MAX(p.pid) AS ID_LAST_MSG, t.state = 'closed' AS locked
       FROM ({$from_prefix}topics AS t, {$from_prefix}posts AS p)
       WHERE p.topic_id = t.tid
       GROUP BY t.tid
       HAVING ID_FIRST_MSG != 0 AND ID_LAST_MSG != 0) res
LEFT JOIN {$from_prefix}polls AS pl ON (pl.tid = res.ID_TOPIC);

Idea from hxxp:www.mysqlperformanceblog.com/2007/04/06/using-delayed-join-to-optimize-count-and-limit-queries [nonactive].
Makes a LOT of sense in this case, to delay the JOIN till after we get the trimmed list, rather than do a BIG JOIN, then try to filter that.
VERY fast now. 26107 rows in less than 2 mins.
Partitioned in 10000 to avoid the max packet limit.

GerMalaz

Success (at first glance, checking further).

Thanks all.

dantheman1

I need help. Is their anyway I can change my SMF to IPB v1.3? Is their any file or attachment? can you please give me intstructions?  :-[

ThorstenE

Our converters support converting from IPB to SMF, not from SMF to IPB. If you are looking for a converter  to IPB you should ask for support in the IPB Homepage...

worstl

Hy I would like to convert my IPB 1.3.1 to smf 1.1.8
but after executing the conversion process an error occurred in the members table.
Everything works fine till the 7500 entry. Why did that happened? I've used the attached .sql file and the convert.php from the download section.

ThorstenE

was it an error like "duplicate entry" or similar? can you post the exact error message please?

worstl

Yes it was a "duplicate entry" error. But it seems that I have been able to solve this problem by limiting the blocksize for new entry's.

worstl

Damn it just seemed to be a proper solution. From 59,918 Post are just 30200 converted and from 10,616 Topics just 10,110. But no error message or something. *help*

worstl

Now I tried to convert a 2nd time and these error messages occured after a couple of seconds:

Converting...

Notice: Undefined index: convert_script in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 810

Warning: Invalid argument supplied for foreach() in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 813

Notice: Undefined index: convert_script in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 825

Notice: Undefined index: convert_script in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 721
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1211

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1221

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1229

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1239

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1252

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1265

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1311

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1313

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1319

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1325

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1336

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1337

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1345

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1347

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1353

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1354

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1360

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1361

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1385

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1387

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1393

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1405

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1430

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1432

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1476

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1491

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1520

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1522

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1535

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1557

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1562

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1623

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1625

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1661

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1680

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1703

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1704

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2411

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2411

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239

Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240
Successful.
Conversion Complete
Congratulations, the conversion has completed successfully. If you have or had any problems with this converter, or need help using SMF, please feel free to look to us for support.
Now that everything is converted over, your SMF installation should have all the posts, boards, and members from the installation.

We hope you had a smooth transition!

ThorstenE

the new error was a broken session, this is often host related. Try to restart the conversion.
for the "duplicate entry": do you know the step? (topics, PMs, Messages?)


worstl

the duplicate entry error isn't the problem (I limited the blocksize to 20) but he occured in topics, members, and poll log. The new problem is that from 59,918 Post are just 30200 converted and from 10,616 Topics just 10,110. But no error message or something.

Thanks in advance for your help. 

ThorstenE

any chance to test an offline conversion with XAMPP or similar products (www.apachefriends.org)? I think this is an host related issue or your IPB database is corrupted?

worstl

I can't really imagine that the IPB is corrupted. But I will try the XAMPP thing.

SleePy

Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

Advertisement: