Newbb 3.x to SMF 1.1.5 ?

[CrazyJoe_]

I've tried the converter that's available in the downloads section, but it goves me this error :

Unable to find the settings for XOOPS & newBB 2. Please double check the path and try again.

I know I have it pointed to the correct directory for the newbb install ( ... /modules/newbb/ )

is there a different converter for this ... since it is actually CBB 3.0 ? ( continuation of the newbb forums )

Thanks in advance !

[N3RVE]

NewBB is not on the Converter Request Page.
You can Request for it to be created.

-[n3rve]

[ThorstenE]

[n3rve], a converter for newBB 2 and XOOPS exists
http://www.simplemachines.org/download/?converters

CrazyJoe_,
the path should be the path to XOOPS (without /modules/newbb/ )

[CrazyJoe_]

[n3rve], a converter for newBB 2 and XOOPS exists
http://www.simplemachines.org/download/?converters

CrazyJoe_,
the path should be the path to XOOPS (without /modules/newbb/ )

This is the error I get with that ...

The error MySQL gave was: SELECT command denied to user 'database_username'@'xxx.xxx.xxx.xxx' for table 'xoops_users'

Each install ( Xoops and SMF ) is a different database with different user names and passwords ...
is thaere an easy way to do this, or should I just change the user names and passwords to the same thing ?

[ThorstenE]

From the docs

For best results, you should install SMF on the same database as the forum you're converting from. If this is not possible, you will need to make sure that the MySQL user account being used for SMF has access to the other forum's database.

maybe it helps:

or should I just change the user names and passwords to the same thing ?

[SleePy]

Common conversion errors.

[CrazyJoe_]

Thanks Sleepy and ThorstenE !

A lot of help right there.
Since I wasn't very far into the install as far as modifications go, I went ahead and did a re-install using the same database.
This is the result :

Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Unsuccessful!
This query:
SELECT
forum_id AS ID_BOARD, cat_id AS ID_CAT,
SUBSTRING(forum_name, 1, 255) AS name,
SUBSTRING(forum_desc, 1, 65534) AS description, forum_topics AS numTopics,
IF(forum_access = 1, '0,2', IF(forum_access = 3, '', '0,-1,2')) AS memberGroups,
forum_posts AS numPosts
FROM `database_name`.xoops_bb_forums
LIMIT 0, 500;
Caused the error:
Unknown column 'forum_access' in 'field list'

Closer than before ... that's for certain.
Is this a coding issue then ?

Thanks again !

[ThorstenE]

open xoops_to_smf.sql and replace:

Code Select Expand

IF(forum_access = 1, '0,2', IF(forum_access = 3, '', '0,-1,2')) AS memberGroups,
with

Code Select Expand

'0,-1,2' AS memberGroups,
after edit don't forget to upload the new version and convert it again.

your xoops-version does not have a column "forum_access" in table xoops_bb_forum. Doesn't matter, but after conversion check the board-permissions!

[CrazyJoe_]

Wootage ! ... Thanks !
Got a little further that time ...

Got this ...

Converting...
Converting posts (this may take some time)... Unsuccessful!
This query:

    SELECT
    hxxp:p.post [nonactive]_id AS ID_MSG, p.topic_id AS ID_TOPIC, hxxp:p.post [nonactive]_time AS posterTime,
    p.uid AS ID_MEMBER, SUBSTRING(p.subject, 1, 255) AS subject,
    SUBSTRING(u.email, 1, 255) AS posterEmail,
    SUBSTRING(IFNULL(u.name, 'Guest'), 1, 255) AS posterName,
    SUBSTRING(p.poster_ip, 1, 255) AS posterIP,
    IF(p.nosmiley, 0, 1) AS smileysEnabled, hxxp:p.forum [nonactive]_id AS ID_BOARD,
    SUBSTRING(REPLACE(pt.post_text, '<br>', '<br />'), 1, 65534) AS body,
    '' AS modifiedName, 'xx' AS icon
    FROM (`forum_name`.xoops_bb_posts AS p, `forum_name`.xoops_bb_posts_text AS pt)
    LEFT JOIN `forum_name`.xoops_users AS u ON (u.uid = p.uid)
    WHERE hxxp:pt.post [nonactive]_id = hxxp:p.post [nonactive]_id
    LIMIT 0, 200;

Caused the error:

    Unknown column 'p.nosmiley' in 'field list'

Always a bit close ... got the Boards and Topics to transfer ... but not the posts ... yet. 

Once I get this to work fully, I'll be sure to post a fully updated conversion file for you all to post for CBB 3.08 conversions !

[SleePy]

Find:

Code Select Expand


IF(p.nosmiley, 0, 1) AS smileysEnabled, p.forum_id AS ID_BOARD,



Replace:

Code Select Expand


IF(IFNULL(p.nosmiley, 1), 0, 1) AS smileysEnabled, p.forum_id AS ID_BOARD,



I just hope I don't forget that myself so I can make the change in the files (at school at the moment).

[CrazyJoe_]

Well crud ... still didn't work ...

Got this:

Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Unsuccessful!
This query:

    SELECT
    hxxp:p.post [nonactive]_id AS ID_MSG, p.topic_id AS ID_TOPIC, hxxp:p.post [nonactive]_time AS posterTime,
    p.uid AS ID_MEMBER, SUBSTRING(p.subject, 1, 255) AS subject,
    SUBSTRING(u.email, 1, 255) AS posterEmail,
    SUBSTRING(IFNULL(u.name, 'Guest'), 1, 255) AS posterName,
    SUBSTRING(p.poster_ip, 1, 255) AS posterIP,
    IF(IFNULL(p.nosmiley, 1), 0, 1) AS smileysEnabled, hxxp:p.forum [nonactive]_id AS ID_BOARD,
    SUBSTRING(REPLACE(pt.post_text, '<br>', '<br />'), 1, 65534) AS body,
    '' AS modifiedName, 'xx' AS icon
    FROM (`sm_forums`.xoops_bb_posts AS p, `sm_forums`.xoops_bb_posts_text AS pt)
    LEFT JOIN `sm_forums`.xoops_users AS u ON (u.uid = p.uid)
    WHERE hxxp:pt.post [nonactive]_id = hxxp:p.post [nonactive]_id
    LIMIT 0, 200;

Caused the error:

    Unknown column 'p.nosmiley' in 'field list'

I made certain that the changes were made to the file on the server ... still no change ...
This is the file section you referred to :

/******************************************************************************/
--- Converting posts (this may take some time)...
/******************************************************************************/

TRUNCATE {$to_prefix}messages;
TRUNCATE {$to_prefix}attachments;

---* {$to_prefix}messages 200
SELECT
   hxxp:p.post [nonactive]_id AS ID_MSG, p.topic_id AS ID_TOPIC, hxxp:p.post [nonactive]_time AS posterTime,
   p.uid AS ID_MEMBER, SUBSTRING(p.subject, 1, 255) AS subject,
   SUBSTRING(u.email, 1, 255) AS posterEmail,
   SUBSTRING(IFNULL(u.name, 'Guest'), 1, 255) AS posterName,
   SUBSTRING(p.poster_ip, 1, 255) AS posterIP,
   IF(IFNULL(p.nosmiley, 1), 0, 1) AS smileysEnabled, hxxp:p.forum [nonactive]_id AS ID_BOARD,
   SUBSTRING(REPLACE(pt.post_text, '<br>', '<br />'), 1, 65534) AS body,
   '' AS modifiedName, 'xx' AS icon
FROM ({$from_prefix}bb_posts AS p, {$from_prefix}bb_posts_text AS pt)
   LEFT JOIN {$from_prefix}users AS u ON (u.uid = p.uid)
WHERE hxxp:pt.post [nonactive]_id = hxxp:p.post [nonactive]_id;
---*

Still plugging away at it tho' ... Thanks again to everyone for all the help !

[SleePy]

ok..
Well I guess I force it..

Find:

Code Select Expand

    IF(IFNULL(p.nosmiley, 1), 0, 1) AS smileysEnabled, p.forum_id AS ID_BOARD,

Replace:

Code Select Expand

    1 AS smileysEnabled, p.forum_id AS ID_BOARD,

[CrazyJoe_]

Whoo Hoooo ... getting A LOT closer ... just missing moderators now ... but it appears to have all the previous members, their login information, and the old posts are there ... I can always put the members in their groups and assign moderators to the forums by hand.

This is what I've gotten so far :

Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Clearing unused tables... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting moderators... Unsuccessful!
This query:

    SELECT user_id AS ID_MEMBER, forum_id AS ID_BOARD
    FROM `forum_name`.xoops_bb_forum_mods
    LIMIT 0, 500;

Caused the error:

    Table 'forum_name.xoops_bb_forum_mods' doesn't exist

Unless there's something else to be converted that I'm forgetting ... and there very well may be ... this will work for me.
I'm willing to try it again to get a fully functional configuration for anybody else that is doing this conversion.

If this is it, here's the updated xoops_to_smf.sql file. --> hxxp:"http://www.stealth-and-mutilation.com/downloads/xoops_to_smf.zip" [nonactive]

[ThorstenE]

ok, you can remove this block from the xoops_to_smf.sql. The conversion should be done, because it is the last block in the script (it converts the moderators)..

Code Select Expand


/******************************************************************************/
--- Converting moderators...
/******************************************************************************/

TRUNCATE {$to_prefix}moderators;

---* {$to_prefix}moderators
SELECT user_id AS ID_MEMBER, forum_id AS ID_BOARD
FROM {$from_prefix}bb_forum_mods;
---*

btw, it would be much better to update this script to the new CBB-version, there are some new features in CBB 3.0.8 (attachments, polls...) i will look at this next days, so if you don't want to loose attachments, polls etc you should wait for a new version.. (i planned to make a wowBB script, but the user didn't responce, so i have some time for the CBB-Converter)

Edit: i attached a working version for CBB 3.0.8 and XOOPS 2.0.18

at this time it does not convert: moderators, permissions, attachments, polls, notifications, avatars