2011-05-21, 11:53 AM
2011-05-29, 03:11 PM
I managed to fix the incorrect replies problem.
I had tried:
UPDATE
that worked but then after I did a recount it screwed up again. I hadn't formatted the
Still haven't fixed the formatting of the imported posts themselves . . . going through 3500 of them manually . . . open edit save, open edit save, open edit save . . . should only take a few days :-)
cheers for the help getting it this far!
I had tried:
UPDATE
mybb_threads SET replies="0" WHERE replies="1"that worked but then after I did a recount it screwed up again. I hadn't formatted the
firstpost values correctly, fixed that and it was all goodStill haven't fixed the formatting of the imported posts themselves . . . going through 3500 of them manually . . . open edit save, open edit save, open edit save . . . should only take a few days :-)
cheers for the help getting it this far!
2011-05-29, 05:04 PM
Yeah, sorry I can't help further... except to give some advice.
You could run a simple script to use ereg_replace() on all the posts and this replace the Office newline character with a proper newline.
You could run a simple script to use ereg_replace() on all the posts and this replace the Office newline character with a proper newline.
2011-05-29, 06:27 PM
Hmmm, that might be a bit beyond me, my php isn't that great (yet!) and with the different newlines . . . but I'll look into it
Thanks again for your help.
Thanks again for your help.