Simple Board to SMF

[Zook]

SMF Version: SMF 1.0.7
I've seen this question in an older thread but no replies, so here we go again:
Converting from Simple Board 1.1.0 to SMF 1.0.7
the conversion seems to work ok the only problem is that "Recalculating" does not go all the way. When I recalculate from the admin area in SMF however all is ok.
Whats the problem then?

All posts look like this:
L[img width=]ndo[img width=][img width=][img width=]BK[img width=]had[img width=][img width=]und[img width=]r[img width=][img width=][img width=]tt[img width=]n[img width=]av[img width=]jul[img width=][img width=][img width=]tt[img width=]

Any ideas?

[mivaho]

Hi,

I've got a similar problem but at conversion time. When I start the conversion all is OK up until the point that the messages are being converted then I see all kind of messages on the screen that look like this:

---
('503', '503', '1122233294', 'blah blah', '64', 'blah_blah', '[email protected]', 'xxx.xxx.xxx.xxx', '31', 'D[img width=]t[img width=]ond[img width=]rw[img width=]rp[img width=][img width=]aat[img width=]ov[img width=]r[img width=]Cont[img width=]nt[img width=]art[img width=]k[img width=]l:[img width=][url/www.do[img width=][img width=][img width=][img width=]rx.nl/[img width=]nd[img width=]x.php/cont[img width=]nt/v[img width=][img width=]w/[img width=][img width=][img width=]/[img width=]/]V[img width=]rr[img width=]cht[img width=][img width=][img width=]lf[img width=][img width=][img width=]t[img width=]n[img width=][img width=]n[img width=]aan[img width=]h[img width=]t[img width=]aard-[img width=]a[img width=]n[img width=]t[img width=][img width=]ch[img width=]v[img width=]ld[/url]
---

No messages get to SMF so it effects all message bodies.

I've tracked it down in the simpleboard_to_smf.sql at line 97 and 98 a replace is done I think for attachments and images. I think somehow it effects a lot of letters in the body text. Maybe it has to do with language or something, only in those message no special signs are used, it's in dutch.

And in most of the messages no URLs are mentioned or images embedded.

Conversion stops with the message "

Caused the error:

    MySQL server has gone away"

Just can't code so don't know where to look further.

Trying to convert SimpleBoard 1.0.3 to SMF 1.1RC2 using the latest convert.php and the only simpleboard_to_smf.sql I could find in the big convert topic.

Any help is welcome.

Thnx in advance,
Michel

[Zook]

Hmm...
Maybe we are on to something here, my forum is in Swedish so this could be language related?
Of course I found some minor bugs in the simpleboard_to_smf.sql file, but no big issues. I don't get an SQL server melt down  and everything seem to work just fine except that the text in all posts is totally messed up...
Hope some of the SMF gurus can take a look at this *blink*

[mivaho]

Hi Zook,

Yeah, could be language (UTF-8?) related or something. That's why I replied to your topic. The same problem you are having is mentioned in the big 1.1 converter topic by chanh and a lonely message from DukeN here: http://www.simplemachines.org/community/index.php?topic=81457.0. Both got no answer.

My problem is not exactly the same but it seems I get the message at conversion time and you don't but it puts the kind of output that I get as real messages in your board 

These lines are doing the bad I think:

Code Select Expand

$row['body'] = preg_replace('~[file name=.+?]http.+?[/file]~i', '', $row['body']);
$row['body'] = preg_replace('~[img size=(\d+)]~i', '[img width=$1]', $row['body']);

Hope someone can help us

Michel

[Zook]

Hi Michel,

at least we are having a nice conversation here
Tried to fiddle a little with the code and when I commented out this row:
$row['body'] = preg_replace('~[img size=(\d+)]~i', '[img width=$1]', $row['body']);
all posts are correctly formatted(!)
Now the only thing remaining is to get all links in the posts to work...

Lennart