Simple Machines Community Forum

SMF Support => Converting to SMF => Topic started by: JayBachatero on January 28, 2007, 11:52:38 PM

Title: [SMF Converter] XOOPS & newBB 2
Post by: JayBachatero on January 28, 2007, 11:52:38 PM
Software: XOOPS & newBB 2
Version: 2.0

This is the official support topic for XOOPS & newBB 2 converter.  Use this topic to ask for support for this converter.

Changelog
! Updated for 1.1 (xoops_to_smf.sql)
+ Added attachments conversion support (xoops_to_smf.sql)

convert.php
Use this convert.php (http://www.simplemachines.org/community/index.php?topic=140741.0) with the .sql file attached in this topic.
Title: Re: [SMF Converter] XOOPS & newBB 2
Post by: igorvuk on February 10, 2007, 12:35:07 PM
Im using Xoops 2.0.13 and i try convert but i got:
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Incomplete.

Converting posts (this may take some time)... Unsuccessful!
This query:
INSERT INTO `smf`.smf_messages
(ID_MSG, ID_TOPIC, posterTime, ID_MEMBER, subject, posterEmail, posterName, posterIP, smileysEnabled, ID_BOARD, body, modifiedName, icon)
VALUES ('9246', '656', '1051729898', '426', 'fgvh', 'email@adresa', 'Denis', '195.29.178.201', '1', '7', 'Ja idem odma\' sutra... aj nek mi neko plati kartu, ja ga častim pićem... :-D ', '', 'xx'),
...
...

Caused the error:
Duplicate entry '9246' for key 1

And every time is diff entry number..
Title: Re: [SMF Converter] XOOPS & newBB 2
Post by: igorvuk on February 10, 2007, 12:47:18 PM
Is this error maybe related to load on server?
Title: Re: [SMF Converter] XOOPS & newBB 2
Post by: JayBachatero on February 10, 2007, 12:57:58 PM
Did you try reconverting?
Title: Re: [SMF Converter] XOOPS & newBB 2
Post by: igorvuk on February 10, 2007, 07:51:53 PM
It's was server load problem, i try again, but i didn't touch "button" and everything works fine
Title: Re: [SMF Converter] XOOPS & newBB 2
Post by: igorvuk on February 10, 2007, 07:56:19 PM
And only thing what is maybe issue for me is coding. In Xoops language setting is UTF-8 but after converting i got this:
In SMF: "ruÅ¡i granice meÄ'u žanrovima"
In Xoops: "ruši granice među žanrovima"
Suppose to be like xoops..

I try convert from admin menu, but didn't work..

And there is no avatars :(
Title: Re: [SMF Converter] XOOPS & newBB 2
Post by: JayBachatero on February 11, 2007, 01:03:48 AM
I've been trying to add UTF-8 support to the converters but my UTF-8 knowledge is very limited.  I'm going to try to get a dev to give me a hand with this.
Title: Re: [SMF Converter] XOOPS & newBB 2
Post by: lucky_phd on April 15, 2007, 06:19:34 AM
Greatings,
I have two questions. First I use xoops 2.2.3 and CBB 2.3. I don't know is the cbb same as newBB, and may I use the convertor.
Second is about UTF-8. IS that issue solved, because I really need that.

Title: Re: [SMF Converter] XOOPS & newBB 2
Post by: SleePy on July 28, 2007, 12:52:17 PM
Is this issue solved or do you still require assistance?

At the moment the script hasn't been updated yet to provide UTF-8 support.
CBB sounds like a different forum software, is it? This converter is made for newBB.
Title: Re: [SMF Converter] XOOPS & newBB 2
Post by: javierjp on August 18, 2007, 04:26:49 PM
CBB its based in newbb2 its almost the same thing, is very easy to find what´s different, only some tables and fields are different, some time ago i made that, i will take a look in  my hard disk, maybe the modified files still there.

Grettings.
Title: Re: [SMF Converter] XOOPS & newBB 2
Post by: JayBachatero on September 29, 2007, 01:11:40 AM
Javier did you get to convert?
Title: Re: [SMF Converter] XOOPS & newBB 2
Post by: metallica48423 on October 10, 2007, 02:48:27 AM
javier, any updates?
Title: Re: [SMF Converter] XOOPS & newBB 2
Post by: mikedown on December 17, 2007, 03:14:39 AM
hey guys i ran into a problem

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 `xoops`.xoops_bb_forums
LIMIT 0, 500;
Caused the error:

Unknown column 'forum_access' in 'field list'
Title: Re: [SMF Converter] XOOPS & newBB 2
Post by: JayBachatero on December 20, 2007, 11:20:27 PM
What version off xoops are you using?
Title: Re: [SMF Converter] XOOPS & newBB 2
Post by: mikedown on December 21, 2007, 04:39:51 AM
im using 2.0.17.1
im losing a couple of  field lists
and a couple of tables

how do i work a way around this?
Title: Re: [SMF Converter] XOOPS & newBB 2
Post by: mikedown on December 21, 2007, 06:20:10 AM
got it to work i was using the old sql file
Title: Re: [SMF Converter] XOOPS & newBB 2
Post by: macmend on December 27, 2007, 04:29:24 PM
I too wish to convert from CBB, CBB was the development from newbb by xoopsforge after newbb was ceased in development some years ago.

http://xoopsforge.com/

I have looked at this guy:

http://www.amevita.eu/modules/wfdownloads/singlefile.php?cid=3&lid=3

who claims to have some sort of convertor but find the download he offers corrupted, does anyne know more about this.

can I use the convertor offered here on CBB 3?




Title: Re: [SMF Converter] XOOPS & newBB 2
Post by: JayBachatero on January 10, 2008, 01:10:17 AM
You can give this converter a try.  Maybe it works if its a fork from newBB.
Title: Re: [SMF Converter] XOOPS & newBB 2
Post by: cnaw on March 17, 2008, 12:51:59 AM
Quote from: lucky_phd on April 15, 2007, 06:19:34 AM
Greatings,
I have two questions. First I use xoops 2.2.3 and CBB 2.3. I don't know is the cbb same as newBB, and may I use the convertor.



Did you ever get the converter to work? I have the same Xoops setup as you, and I'm having troubles.

-cw
Title: Re: [SMF Converter] XOOPS & newBB 2
Post by: SleePy on April 12, 2008, 11:35:56 PM
cnaw,

Where you able to solve this?

There is basic UTF-8 support if you convert your SMF forum to UTF-8 before converting your xoops forum
Title: Re: [SMF Converter] XOOPS & newBB 2
Post by: macmend on August 11, 2008, 03:54:27 AM
I wonder how it would work to convert it back, my problem is that I wanted smf in my xoops site, but the smf bridge module is terrible and now I am stuck with smf and only tinyportal. whereas I want a xoops wrap.  So I need to convert smf back to cbb/newbb
Title: Re: [SMF Converter] XOOPS & newBB 2
Post by: metallica48423 on August 11, 2008, 04:13:14 AM
youll need to contact the folks that make cbb/newbb regarding that.
Title: Re: [SMF Converter] XOOPS & newBB 2
Post by: bluesman84 on November 26, 2008, 02:51:10 PM
Hi all,
I can't convert a XOOPS + newbb 2 database in SMF one. I got many errors. Because I need to only convert users, how to do it? The problem is how to convert the MD5 password from xoops in MD5 for SMF cause they don't use the same MD5 algorithm.
Thanks bye
Title: Re: [SMF Converter] XOOPS & newBB 2
Post by: SleePy on November 29, 2008, 10:56:59 AM
What errors do you get?

One of the nice hidden features of SMF is its ability to attempt to figure out old or other software password hashing methods and then convert it to its own.
If the XOOPS & newBB2 are just using md5(password), then SMF will be able to convert that without you needing to edit anything. If it can't, we just need to figure out how the password conversion is done and then edit the LogInOut.php to have that new method.
Title: Re: [SMF Converter] XOOPS & newBB 2
Post by: cyke0 on December 05, 2008, 12:34:50 PM
Not sure if this is the right forum place to post but i'm working on converting xoops newbb to smf and i cannot find the settings.php for /modules/newbb file.. to convert
Title: Re: [SMF Converter] XOOPS & newBB 2
Post by: ThorstenE on December 05, 2008, 01:01:12 PM
which version of newBB is it? the pathes in convert.php must be absolute pathes,
example: /home/www/user/public_html/xoops
Title: Re: [SMF Converter] XOOPS & newBB 2
Post by: Beriadan on February 01, 2009, 02:54:00 PM
Hi, I'm using xoops_to_smf converter, everything completes without error, but after the convert is done, the boards table is still empty. The categories and topics are there though.

Note : I had to do some mods to the sql file in the members section because my version of newbb uses a "user_profile" table for data such as icq and url.
Title: Re: [SMF Converter] XOOPS & newBB 2
Post by: ThorstenE on February 01, 2009, 03:06:38 PM
any errors during the conversion? maybe this converter helps (newBB3/CBB):
http://www.simplemachines.org/community/index.php?topic=255433.0
Title: Re: [SMF Converter] XOOPS & newBB 2
Post by: Beriadan on February 01, 2009, 04:18:26 PM
Odd, I was sure I was running newBB, but it seems to be working now, Thanks