No errors converting phpbb2 to SMF 1.1.1 but first char is missing from all sigs

[guspasho]

As the title says, I tried to convert my phpbb 2.0.21 board to SMF 1.1.1 and I didn't get any errors, but when I look at the converted board, everyone's signature are now missing the first character. I used the phpBB2 converter from this page.

http://www.simplemachines.org/download/?converters

Any advice? Any other information needed?

[guspasho]

It appears this still works for me.

http://smf.person-lab.net/phpbb2_to_smf_2006_09_21-utf8.zip

http://www.simplemachines.org/community/index.php?topic=107868.msg738192#msg738192

Perhaps you might want to consider updating your converter? I don't know.

[Calymari]

Hi, I had this same problem when I did this same conversion earlier this week (phpbb 2.0.21 -> SMF 1.1.1), using the script from the website.  I fixed it by making one minor change to the phpbb2_to_smf.sql file, line 122.

The original reads:

Code Select Expand

$row['signature'] = substr($row['signature'], 1, 65534);

I changed it to:

Code Select Expand

$row['signature'] = substr($row['signature'], 0, 65534);

Seems to be a bug in the conversion script, unless earlier versions of phpbb put an extra character in front there, or something...

[margarett]

Yes, this is a known problem, and that change in the code is also documented here

[Calymari]

Oh, sorry, I searched the site and the forums and didn't find anything specifically about this (besides this thread).

[JayBachatero]

I also updated the script. phpBB 2.0.19+