Converting from xoops 2.2.4 and cbb 3.04 forum problems

[Svaha]

Hi I want to convert my forum to smf.
Xoops 2.2.4 has a different way for handling users and an extended profile.
CBB forum is build on the old newbb forum but things have changed.
I used the xoops converter that I found on this forum.

Xoops 2.2.4 has : uname, loginname and name. The 'uname'  is displayed, the loginname is name for the password.
I left this unchanged in the converter sql, because I want this name in the smf forum to be the membername.

I had to change the converter because some things have moved to the 'user_profile'.

Like this :

/******************************************************************************/
--- Converting members...
/******************************************************************************/

TRUNCATE {$to_prefix}members;

---* {$to_prefix}members
SELECT
   uid AS ID_MEMBER, uname AS memberName, pass AS passwd,
        email AS emailAddress,
   IF(rank = 7, 1, 0) AS ID_GROUP
FROM {$from_prefix}users;
---*

---* {$to_prefix}members
SELECT
   user_regdate AS dateRegistered,
   posts,
    url AS websiteTitle, url AS websiteUrl,
   user_icq AS ICQ, user_aim AS AIM,
   user_yim AS YIM, user_msnm AS MSN, user_sig AS signature,
   user_viewemail = 0 AS hideEmail, timezone_offset AS timeOffset
FROM {$from_prefix}user_profile;
---*

I don't know if this is correct written because I have no idea of this sql things, lol.

This passed the test, but there were notices of 'no index'  for uname and name.

Then 'forum access'  was not found, I did not find it either, so I deleted this, because I can change the forum access later (after conversion)

'nosmilies' was not found, I made this 'dosmilies'

Moderators are in cbb in another record : ' bb_moderates', I changed this.

Now the converter went all the way untill I came to forum statistics.
There was an error,

Converting moderators... Successful.
Recalculating forum statistics... Unsuccessful!
This query:
UPDATE `smfspirit`.smf_boards
SET ID_LAST_MSG = 2861, lastUpdated = 1149901444
WHERE ID_BOARD = 1
LIMIT 1;
Caused the error:

Unknown column 'lastUpdated' in 'field list'

And now I'm stuck,

So if someone could help me, thank you.

[psi0]

Hello, i have a problem like you.

i convert xoops to phpbb and then to smf.

the xoops converter don´t work with cbb.

[Svaha]

Ok, I managed to convert my cbb forum to smf, just ignored the error about statistics.
I logged in and let statistics do a fresh run.

I only have one problem left now and that is that none of my members is linked to the posts.
In the boards the name is correct, but when I look up my members they are not connected/linked to a post.

My number of members increased / doubled.

Anyone who can help here?

[Svaha]

Ok, I managed to convert the forum, here is what I did.

I used downgrade.php to downgrade xoops 2.2.4 to 2.0.x
I made one change in this file, I added :

           //Set uname as name
            $sql = "UPDATE ".$xoopsDB->prefix("users")." SET name=uname";
            if (!$xoopsDB->query($sql)) {
                $log[] = "Could not set name to uname value, check MySQL log for details";
   }

Just before :

            //Set loginname as uname
            $sql = "UPDATE ".$xoopsDB->prefix("users")." SET uname=loginname";
            if (!$xoopsDB->query($sql)) {
                $log[] = "Could not set uname to loginname value, check MySQL log for details";
            }

This way the display names of the users are filled in the 'name' field of xoops, and after conversion this becomes the displayname of smf.


I did not follow the instructions for downgrade.php, just hit the buttons and downgraded the database (that's all I needed for the conversion)

For the conversion I used the convert.php and xoops_to_smf.sql that can be found on smf forum.
I had to make some changes in the sql file because cbb is different from newbb.

nosmiley changed to dosmiley
bb_forum_mods to bb_moderates and also here user_id to mod_id.

I had to comment out the line where the converter is looking for forum_access, I don't know how this is accomplished in cbb.

When you run the converter don't touch any buttons when it's converting the posts because then the conversion will not complete errorfree.

Now you can login to your converted forum and all you have to do now is setting the permissions of the boards.

That's all
hth

[chancefox]

can someone please upload or update the converter in download section for xoops 2.2.4 and cbb 3.04?
i need my xoops site convert to smf and my knowledge in php and mysql is very damn low 

[ekose]

Code Select Expand

Converting members... Successful.
Converting categories... Unsuccessful!
This query:
TRUNCATE `my_bd_name`.smf_categories
LIMIT 0, 500;
Caused the error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 500' at line 2

What does it mean?