2008-03-28, 10:55 AM
Ok, a few more problems I stumbled upon:
1) Thread and post titles turned out to be HTML-encoded - e.g. an < was displayed as < (same for >, &, and "). Either there's some extraneous HTML escaping happening, or SMF stores thread/post subjects as HTML escaped in the db (*boggle*).
2) Single ticks (') were stored as \x03 in the database. Sounds a bit weird to me. Might be SMF is storing it that way internally? (*reboggle*)
I fixed both by editing the db directly.
Otherwise, no problems so far - the conversion script even survived my ISP disconnecting me for a few hours in the middle of the post import, and resumed happily after that. Nice work, thanks a lot :-)
1) Thread and post titles turned out to be HTML-encoded - e.g. an < was displayed as < (same for >, &, and "). Either there's some extraneous HTML escaping happening, or SMF stores thread/post subjects as HTML escaped in the db (*boggle*).
2) Single ticks (') were stored as \x03 in the database. Sounds a bit weird to me. Might be SMF is storing it that way internally? (*reboggle*)
I fixed both by editing the db directly.
Otherwise, no problems so far - the conversion script even survived my ISP disconnecting me for a few hours in the middle of the post import, and resumed happily after that. Nice work, thanks a lot :-)