[SMF Converter] Yabb - 2.1

[JayBachatero]

! When converting non posts based groups the preg_match was incorrect. (yabb21_to_smf.php)
! Make sure to use the correct offset to get the correct minPosts for post count based groups. (yabb21_to_smf.php)

Do you have ab example for the board names issue?  Like before and after example.

Let me know how this goes.  Any outstanding issues?

[naitram]

just started another conversion with a clean install, i'll post the board names later

[naitram]

just started another conversion with a clean install, i'll post the board names later

example

was
VRXSE Screamin' Eagle® Destroyer™

after conversion
VRXSE Screamin' Eagle

[JayBachatero]

Post the forum.master file so that I can test it locally.

[naitram]

here ya go

[JayBachatero]

Ok can you please also post the forum.control file?

[naitram]

here ya go

[naitram]

stuck in a loop at

convert.php?step=1&substep=0&cstep=11&start=0

forced it forward by manually going to

convert.php?step=1&substep=1&cstep=11&start=0


ok now stuck at

convert.php?step=1&substep=12&cstep=12&start=0
Converting...
Converting posts (part 3)...     250 out of 164448 have been assigned to the correct member.     500 out of 164448 have been assigned to the correct member. Incomplete.

[JayBachatero]

Ok give this a try.

! When converting board names make sure to sanitize it. (yabb21_to_smf.php)
! Show the convert posts status just once. (yabb21_to_smf.php)

[naitram]

not at home right now, but i'll get this tested tomorrow

[naitram]

starting another conversion, board names look good

[JayBachatero]

Ok good.  Let me know how everything else goes.

[naitram]

still stuck on step 12

convert.php?step=1&substep=12&cstep=12&start=0

Converting...
Converting posts (part 3)...      out of 164448 have been assigned to the correct member. Incomplete.

[JayBachatero]

Seems like I have a typo somewhere.  Just let the converter run.  It will finish.

[naitram]

it's always substep 12 in the URL

i checked in mysql

mysql> show processlist;
+-----+------+-----------+------+---------+------+-------+------------------+
| Id  | User | Host      | db   | Command | Time | State | Info             |
+-----+------+-----------+------+---------+------+-------+------------------+
| 506 | smf  | localhost | smf  | Sleep   |  151 |       | NULL             |
| 514 | smf  | localhost | smf  | Sleep   |   57 |       | NULL             |
| 515 | smf  | localhost | smf  | Sleep   |   43 |       | NULL             |
| 516 | smf  | localhost | NULL | Sleep   |   97 |       | NULL             |
| 517 | smf  | localhost | smf  | Sleep   |   17 |       | NULL             |
| 518 | smf  | localhost | smf  | Sleep   |  191 |       | NULL             |
| 519 | smf  | localhost | NULL | Sleep   |   30 |       | NULL             |
| 520 | smf  | localhost | smf  | Sleep   |   84 |       | NULL             |
| 521 | smf  | localhost | smf  | Sleep   |  735 |       | NULL             |
| 522 | smf  | localhost | smf  | Sleep   |  111 |       | NULL             |
| 523 | smf  | localhost | smf  | Sleep   |  138 |       | NULL             |
| 524 | smf  | localhost | smf  | Sleep   |   70 |       | NULL             |
| 525 | smf  | localhost | NULL | Sleep   |    3 |       | NULL             |
| 546 | root | localhost | NULL | Query   |    0 | NULL  | show processlist |
+-----+------+-----------+------+---------+------+-------+------------------+
14 rows in set (0.00 sec)

running this over and over, i don't see any activity in the DB

[JayBachatero]

Well there is a 5 seconds sleep period between each page load.

[naitram]

i sat in mysql using issuing that command over and over as fast as possible for a good 10 seconds just to be sure

[naitram]

ok, started from a clean install again,

found the error in the echo statemens in Step12

Code Select Expand

    ', $actualPosts, ' out of ', $_SESSION['totalPosts'], '
have been assigned to the correct member.';

changed to

Code Select Expand


    ', $_SESSION['actualPosts'], ' out of ', $_SESSION['totalPosts'], '
have been assigned to the correct member.';

[naitram]

may last run worked

[naitram]

followup issues found


ID_MEMBER not linked in smf_polls table

all boards default to posts not counting towards post total