Advertisement:

Author Topic: [SMF Converter] XOOPS & CBB 3  (Read 12118 times)

ThorstenE

  • Guest
[SMF Converter] XOOPS & CBB 3
« on: August 13, 2008, 01:37:19 PM »
Software: XOOPS & CBB 3.0.x
Version: 2.0

This is the official support topic for XOOPS & CBB 3 converter.  Use this topic to ask for support for this converter.

Note: This was tested on XOOPS 2.0.16 and CBB 3.0.8, but should in theory work on other versions of CBB if the database changes have not been to great.

Changelog


convert.php
Use this convert.php with the .sql file attached in this topic.
« Last Edit: July 18, 2009, 03:02:38 PM by TE »

Offline macmend

  • Semi-Newbie
  • *
  • Posts: 21
Re: [SMF Converter] XOOPS & CBB 3
« Reply #1 on: November 15, 2009, 03:34:55 PM »
Hi

I used the latest CBB to smf 2.0 and am getting an error after install the sql file and the convertorin the smf directory and the running mydomain.com/convertor.php and then putting the filepaths in and clicking continue I get his error....

My smf forum is up and running, but runs in utf

XOOPS path check: Script is not inside XOOPS_ROOT_PATH and cannot run.

This refers I think to this line in mainfile.php

if ( strcasecmp( substr($xoopsScriptPath, 0, strlen(XOOPS_ROOT_PATH)), str_replace( DIRECTORY_SEPARATOR, '/', XOOPS_ROOT_PATH)) ) {
          exit("XOOPS path check: Script is not inside XOOPS_ROOT_PATH and cannot run.");

please can you help,

« Last Edit: November 15, 2009, 04:06:53 PM by macmend »

Offline macmend

  • Semi-Newbie
  • *
  • Posts: 21
Re: [SMF Converter] XOOPS & CBB 3
« Reply #2 on: November 15, 2009, 04:27:37 PM »
Ok quick reply to my own post...so I removed the offending line from mainfile.php and now I get this error

Notice: Undefined index: member_name in /home/xxxxx/public_html/xxxx/convert.php on line 1265

Notice: Undefined index: real_name in /home/xxxxx/public_html/xxxx/convert.php on line 1266,

This goes on through about 50 lines

Then:
Unknown column '_' in 'field list'

Then after this the admin login and password no longer works
« Last Edit: November 15, 2009, 04:55:38 PM by macmend »

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,314
  • Blue Wolf
Re: [SMF Converter] XOOPS & CBB 3
« Reply #3 on: November 20, 2009, 05:45:30 PM »
Sorry for the delay, I will look into this, but unfortunately I might not be able to so immediately. If you could make sure that the script is finding your XOOPS, it might help, instead of removing that line that errors out.
Alternatively, perhaps you can also consider to try converting to SMF 1.1.10, just to see if it works fine, and then if you want, you can upgrade to SMF 2.0 with the large upgrade package to SMF 2.0 RC2, from this site's downloads.
To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github

Offline macmend

  • Semi-Newbie
  • *
  • Posts: 21
Re: [SMF Converter] XOOPS & CBB 3
« Reply #4 on: November 20, 2009, 06:08:38 PM »
I went for 1.1.10 and it all seemed to work fine, I think i will stick with that til 2 is more stable, thanks

Offline Logicbloke

  • Semi-Newbie
  • *
  • Posts: 21
Re: [SMF Converter] XOOPS & CBB 3
« Reply #5 on: February 14, 2010, 07:08:08 PM »
I'm totally lost, is newbb and CBB the same thing ? I got a newbb folder in my XOOPS installation I don't know what version, for the converter I see it says CBB 3.0.X do I have to first convert from newbb to CBB and then migrate to SMF or what ? also members conversion goes okay, but stops at the forums conversion, saying that a field is missing in the database.

Anyone has any idea ? Thanks a lot =)

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,314
  • Blue Wolf
Re: [SMF Converter] XOOPS & CBB 3
« Reply #6 on: February 14, 2010, 08:02:25 PM »
The converter should work for both XOOPS and CBB 3.

I'd advice for the time being to do like macmend, as I will not have time to look into the issue with the RC2 converter immediately: you can install SMF 1.1.11, from this site's Downloads, and take the converter to SMF1.1.x, too, from Downloads > Converters. It should be more stable. After you convert your XOOPS to SMF 1.1.11, you can always upgrade to SMF 2.0 RC2 using the large upgrade package to SMF 2.0 RC2 and the instructions for upgrading SMF here:
Upgrading SMF
Please make sure you make a full database backup before trying to upgrade.
To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github

Offline Logicbloke

  • Semi-Newbie
  • *
  • Posts: 21
Re: [SMF Converter] XOOPS & CBB 3
« Reply #7 on: February 15, 2010, 03:33:52 PM »
Hello Norv and thank you for your answer,

Actually I am on SMF 1.1.11, and I have XOOPS 2 as well, converting members ends with no errors, but everything after that ( I tried by modifiying the step variable) fails for "Unknown field"

Converting members... Successful
Converting topics... Unsuccessful!
This query:

    SELECT
    t.topic_id AS ID_TOPIC, t.topic_sticky AS isSticky, t.forum_id AS ID_BOARD,
    t.topic_last_post_id AS ID_LAST_MSG, t.topic_poster AS ID_MEMBER_STARTED,
    t.topic_replies AS numReplies, t.topic_views AS numViews,
    t.poll_id AS ID_POLL,
    t.topic_status AS locked, MIN(p.post_id) AS ID_FIRST_MSG
    FROM `shipspotting`.xoops_bb_topics AS t
    INNER JOIN `shipspotting`.xoops_bb_posts AS p ON (p.topic_id = t.topic_id)
    GROUP BY t.topic_id
    HAVING ID_FIRST_MSG != 0
    AND ID_LAST_MSG != 0
    LIMIT 0, 500;

Caused the error:

    Unknown column 't.poll_id' in 'field list'

Any idea ? Thanks in advance

ThorstenE

  • Guest
Re: [SMF Converter] XOOPS & CBB 3
« Reply #8 on: February 23, 2010, 12:20:11 PM »
Sorry, for the late reply.. I believe your XOOPS doesn't support polls?

you have to edit the xoops_to_smf.sql and find:
Code: [Select]
t.poll_id AS ID_POLL,remove this code.

Offline option

  • Newbie
  • *
  • Posts: 7
Re: [SMF Converter] XOOPS & CBB 3
« Reply #9 on: April 03, 2010, 01:21:37 PM »
TE,
please adapt the script to the module d3forum
mysql of d3forum (hxxp:www.fileden.com/files/2010/1/18/2729673//mysql-d3forum.sql [nonactive])
module d3forum (hxxp:xoops.peak.ne.jp/md/mydownloads/singlefile.php?lid=103&cid=1 [nonactive])
thx
« Last Edit: April 03, 2010, 01:32:00 PM by option »

Offline terryfor

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] XOOPS & CBB 3
« Reply #10 on: October 16, 2010, 01:33:00 PM »
Hi I did the conversion but none of the attachment came over. Could you please advise me on what to do now. Thanks