SMF Support > YaBB/YaBB SE

Help With YaBB 2.2 Conversion

(1/4) > >>

HighAce:
Well i downgraded my latest YaBB forum software from 2.4 to 2.2 so i could convert it over to SMF however it ran into a few problems.

When doing the conversion it brought up quite a few errors however before i could note them all down it flashed up with the following message:

Recalculating forum statistics... Successful.

Notice: Undefined variable: to_prefix in /home/user/public_html/forumsmf/convert.php on line 1821
Unsuccessful!
This query:

    REPLACE INTO settings (variable, value)
    VALUES ('conversion_time', 1259492139),
    ('conversion_from', 'yabb22_to_smf.php');

Caused the error:

    No database selected

Now it still seems to have brought across everything ok as in number of posts and members, however i noticed that some of the boards are displayed a bit weird, like the usual layout seems to be First Column = the board Name & Description, Second Column =  the number of Posts & Topics and the Last Column = when the last post was made and who by.

Well some of the boards are displaying like this: Boards Name & Description, Last post & By Who and then the last one shows Number of Posts & Topics, however some are even showing as Board Name & Description, Last Post & By Who and the last Column is completely greyed out with no writing in it at all??

I did a 'Find & Repair Any Errors" and it came up with heaps!!! , they started at Topic #244 and went up to the last one which was 2223 and the error was:

Topic #243 has the wrong number of replies, 0.

It then showed up the following error as well:

The subject of topic #2 is currently not stored in the subject cache.

That went all the way up to Topic #2223 as well.

And one last problem is with the Private Messages, they are all there but the Subject and who they are From are the wrong way round, as in it says for example From: "1258905524" Subject: Chris.

Not to fussed if i cannot get the PM's sorted but the board display / structure is really annoying!

Any idea's or suggestions on how i can fix??

 :)

N. N.:
I'm sorry, I don't have Perl so I don't have YaBB installed either. In case you wish, I can try looking at your particular database and correct the converter accordingly, might be quicker, I'm afraid. Please let me in case you agree, I will PM you an account to use.

Alternatively:
About the layout problem, can you please make a screenshot or link to your forum, to show what happens? I'm sorry, I don't fully understand it.

About the errors "has the wrong number of replies": normally a 'find and repair' should be able to fix that, in case the rest of the information is there. It could be solved manually as well, or with a query, but again, if the rest of the information is correctly transfered over.
Eventually, please try (in phpmyadmin, on the converted database, not tested):

--- Code: ---UPDATE smf_topics AS t SET numReplies =
  (SELECT count(ID_MSG) FROM smf_messages AS m WHERE m.ID_TOPIC = t.ID_TOPIC)

--- End code ---

About the errors "the subject is currently not stored in the subject cache", these are really not important, and the 'find and repair' should be able to fix them anyway.

About the PMs: if you are certain that always the subject and the name of the user from which the message comes are messed up, then please try this: (yabb22_to_smf.php)

--- Code: (find) --- $row = array(
'fromName' => substr(htmlspecialchars($userData[$i][0]), 0, 255),
'subject' => substr($userData[$i][1], 0, 255),
'msgtime' => !empty($userData[$i][2]) ? (int) $userData[$i][2] : '0',
'body' => substr(!empty($userData[$i][3]) || empty($userData[$i][7]) ? $userData[$i][3] : $userData[$i][7], 0, 65534),
'ID_MEMBER_FROM' => 0,
'deletedBySender' => $is_outbox ? 0 : 1,
'temp' => htmlspecialchars(substr($entry, 0, -4)),
);

--- End code ---


--- Code: (replace) --- $row = array(
'fromName' => substr($userData[$i][1], 0, 255),
'subject' => substr(htmlspecialchars($userData[$i][0]), 0, 255),
'msgtime' => !empty($userData[$i][2]) ? (int) $userData[$i][2] : '0',
'body' => substr(!empty($userData[$i][3]) || empty($userData[$i][7]) ? $userData[$i][3] : $userData[$i][7], 0, 65534),
'ID_MEMBER_FROM' => 0,
'deletedBySender' => $is_outbox ? 0 : 1,
'temp' => htmlspecialchars(substr($entry, 0, -4)),
);

--- End code ---

HighAce:
Thanks for your reply and offer to help. :)

Firstly here is a link to a screen shot of what i mean about the boards display being messed up:



Some display ok with the first column showing the boards name & description, the second column showing number of topics & replies and the last column showing who made the last post and when, however as in the shot above some are round the wrong way and some have the last column completely greyed out.

If you want to look at my database then yes feel free to PM me what exactly you need.

Thanks again for your help, it's appreciated a lot.

HighAce:
I just tried your suggestion for the PM's and it now displays correctly who it's from but the subject has taken on the unique 10 digit number of each YaBB message, like this for example - From: Chris    Subject: 1251229740 , it also shows every message as being sent on December the 31st 1969 at 6:00PM!

Also i did the Find & Repair option and it has now cleaned up all errors and there are no more errors being found, however the board display is still not right, as i mentioned before i'm not to worried if the PM's cannot be sorted out but i would really love to get the boards / categories sorted out so they are all looking the same. :)

N. N.:
Please try eventually the attached file, if you want:
- PMs should be corrected
- full boards description imported, thus no more wierd layout issues

Navigation

[0] Message Index

[#] Next page