1.1 Converters

[StanJ]

25 pages here...

OK  I have an ubbThreads that I would like to convert over to a better forums (SMF) and i have the mysql command... BUT

How does one convert?  Would it be best to do a demo with a dummy or extra domain name?

I am on a mac, the site hosted in unix or some sort,  are there instructions some place?  I may have missed them

Thanks

Stan

[sektor]

Tried to convert from Simpleboard 1.1 to SMF 1.1rc2, didn't work.

Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Incomplete.

and then...

Converting posts (this may take some time)... Successful.
Converting topic notifications... Successful.
Converting moderators... Successful.
Clearing unused tables... Successful.
Converting smileys... Successful.
Converting attachments... Successful.
Converting avatars... Successful.
Recalculating forum statistics... Unsuccessful!
This query:

    UPDATE `bourdela`.smf_boards
    SET ID_LAST_MSG = 16916, lastUpdated = 1138651692
    WHERE ID_BOARD = 1
    LIMIT 1;

Caused the error:

    Unknown column 'lastUpdated' in 'field list'

Any ideas?

al

[Omniverse]

This is what I get when attempting to convert a YaBB 2.1 to SMF

Code Select Expand


Converting...
Converting membergroups... Successful.
Converting members...
Notice: Undefined index: webtitle in /home/.kawasaki/omniverse/forums.gaminghole.org/yabb2_to_smf.php on line 264

Notice: Undefined index: weburl in /home/.kawasaki/omniverse/forums.gaminghole.org/yabb2_to_smf.php on line 265

Notice: Undefined index: signature in /home/.kawasaki/omniverse/forums.gaminghole.org/yabb2_to_smf.php on line 266

Notice: Undefined index: position in /home/.kawasaki/omniverse/forums.gaminghole.org/yabb2_to_smf.php on line 268

Notice: Undefined index: icq in /home/.kawasaki/omniverse/forums.gaminghole.org/yabb2_to_smf.php on line 269

Notice: Undefined index: aim in /home/.kawasaki/omniverse/forums.gaminghole.org/yabb2_to_smf.php on line 270

Notice: Undefined index: yim in /home/.kawasaki/omniverse/forums.gaminghole.org/yabb2_to_smf.php on line 271

Notice: Undefined index: msn in /home/.kawasaki/omniverse/forums.gaminghole.org/yabb2_to_smf.php on line 272

Notice: Undefined index: gender in /home/.kawasaki/omniverse/forums.gaminghole.org/yabb2_to_smf.php on line 273

Notice: Undefined index: gender in /home/.kawasaki/omniverse/forums.gaminghole.org/yabb2_to_smf.php on line 273

Notice: Undefined index: location in /home/.kawasaki/omniverse/forums.gaminghole.org/yabb2_to_smf.php on line 277

Notice: Undefined index: bday in /home/.kawasaki/omniverse/forums.gaminghole.org/yabb2_to_smf.php on line 278

Notice: Undefined index: hidemail in /home/.kawasaki/omniverse/forums.gaminghole.org/yabb2_to_smf.php on line 279

Notice: Undefined index: bday in /home/.kawasaki/omniverse/forums.gaminghole.org/yabb2_to_smf.php on line 287



Converting...
Unsuccessful!
This query:
ALTER TABLE `gamingholedata`.smfgh_personal_messages
CHANGE COLUMN ID_PM ID_PM int(10) unsigned NOT NULL default 0,
DROP PRIMARY KEY,
ADD temp_toName tinytext;
Caused the error:

Can't DROP 'PRIMARY'; check that column/key exists


[Bruno36]

I seek a converter for last Fire-Software-Board has SMF

Thank you for your assistance

[patchster]

ok  first i tried it with rc2 then i got an error bringing over my posts from my XOOPS 2.0.9.2 based site using NewBB 2.0 version 2.02  with your 1.1 converter
its brought over the members/users names data but none of the catagories/topics/posts or anything at all
i have this error

Code Select Expand

...Converting boards... Unsuccessful!
This query:
SELECT
forum_id AS ID_BOARD, cat_id AS ID_CAT, forum_name AS name,
forum_desc 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 `gamehacking`.xoops_bb_forums
LIMIT 0, 500;
Caused the error:

Unknown column 'forum_access' in 'field list'

so i read someones reply that its not ready to convert RC2 and to try  smf RC1 .so i found the RC1 version of smf and installed it as a test , however after doing so , i got the exact same failure
and error code

can anyone tell me whats up with it and why it wont migrate all the data i need? not sure it the original poster of this topic still looks at this post as its quite a few months old and massive
many thanks

[Omniverse]

Just another note about YaBB2 conversion. It seems to work mostly fine for members, but completely craps out when it gets the the boards/posts. (see my post above)

Any word on when some of these converters might be updated?

And, if I need to wait till a later date to convert boards, I can live with that, question is, once i can convert them, how hard will it be to merge the newly converted boards/posts into what is already up?

New error:

Converting...
Converting boards and categories... Unsuccessful!
This query:
ALTER TABLE `gamingholedata`.ghsmf_categories
ADD tempID tinytext;
Caused the error:

Duplicate column name 'tempID'

[Trekkie101]

Quick tip to all people making support requests in this thread, you are more likely to get answers if you post in your own topics, create them with your problems and youll probably get a faster responce, this topic is becoming a bit of a mess.

[data967]

mostly OK just this error:

Recalculating forum statistics... Unsuccessful!
This query:

    UPDATE `database`.smf_boards
    SET ID_LAST_MSG = 1, lastUpdated = 972086460
    WHERE ID_BOARD = 1
    LIMIT 1;

Caused the error:

    Unknown column 'lastUpdated' in 'field list'

[flawa]

Can't DROP 'PRIMARY'; check that column/key exists

This one was quite easy to fix - rename all "$_GET" - commands to "$_REQUEST"

[Omniverse]

Can't DROP 'PRIMARY'; check that column/key exists

This one was quite easy to fix - rename all "$_GET" - commands to "$_REQUEST"

All of them? In the entire convert.php?

**EDIT***
Tryed it and got this:

This query:

    INSERT INTO `gamingholedata`.ddosmf_log_mark_read
    (logTime, ID_MEMBER, ID_BOARD)
    VALUES ('1135711856', '1', '17'),
    ('1135711856', '1', '13'),
    ('1135711856', '1', '9'),
    ('1135711856', '1', '26'),
    ('1135711856', '1', '10'),
    ('1135711856', '1', '44'),
    ('1135711856', '1', '32'),
    ('1135711856', '1', '25'),
    ('1135711856', '1', '11'),
    ('1135711856', '1', '14'),
    ('1135711856', '1', '36'),
    ('1135711856', '1', '45'),
    ('1135711856', '1', '18'),
    ('1135711856', '1', '42'),
    ('1135711856', '1', '3'),
    ('1135711856', '1', '12'),
    ('1135711856', '1', '33'),
    ('1135711856', '1', '23'),
    ('1135711856', '1', '31'),
    ('1135711856', '1', '39'),
    ('1135711856', '1', '40'),
    ('1135711856', '1', '1'),
    ('1135711856', '1', '43'),
    ('1135711856', '1', '65'),
    ('1135711856', '1', '24'),
    ('1135711856', '1', '48'),
    ('1135711856', '1', '29'),
    ('1135711856', '1', '46'),
    ('1135711856', '1', '7'),
    ('1135711856', '1', '15'),
    ('1135711856', '1', '27'),
    ('1135711856', '1', '8'),
    ('1135711856', '1', '5'),
    ('1135711856', '1', '41'),
    ('1135711856', '1', '2'),
    ('1135711856', '1', '37'),
    ('1135711856', '1', '6'),
    ('1135711856', '1', '4'),
    ('1135711856', '1', '30'),
    ('1135711856', '1', '66');

Caused the error:

    Unknown column 'logTime' in 'field list'

[Shoeb Omar]

Just replied in the other thread, but what you might want to do is install smf fresh, make the request change as instructed above (wish I'd have thought of that!), and then run the conversion on a new fresh install.

EDIT: Also make sure you convert to 1.1 RC 1 THEN upgrade.

[shortbuser]

phpBB2 2.0.18 --> SMF 1.1 rc2

Using convert.php and phpbb2_to_smf.sql gives this error:

Code Select Expand

Recalculating forum statistics... Unsuccessful!
This query:
UPDATE `pitbull_shortbus`.smf_boards
SET ID_LAST_MSG = 1925, lastUpdated = 1140013925
WHERE ID_BOARD = 1
LIMIT 1;
Caused the error:

Unknown column 'lastUpdated' in 'field list'


[Hania]

Hello,

When I trying convert phpBB by Przemo on SMF 1.1 RC2 script come back many errors:

Warning: require_once() [function.require-once]: SAFE MODE Restriction in effect. The script whose uid is 21179 is not allowed to access /srv/www/htdocs/web489/html/kobiety/forum/extension.inc owned by uid 21117 in /srv/www/htdocs/web489/html/pilkakobieca/forum/phpbb2_to_smf.php on line 100

Warning: require_once(/srv/www/htdocs/web489/html/kobiety/forum/extension.inc) [function.require-once]: failed to open stream: Success in /srv/www/htdocs/web489/html/pilkakobieca/forum/phpbb2_to_smf.php on line 100

Fatal error: require_once() [function.require]: Failed opening required '/srv/www/htdocs/web489/html/kobiety/forum/extension.inc' (include_path='.:/php/includes:/usr/share/php') in /srv/www/htdocs/web489/html/pilkakobieca/forum/phpbb2_to_smf.php on line 100

I searched solve on this board but I can't find anything. If you can help me I will be very delighted.

P.S I used phpbb2_to_smf.php

[Luigi]

I'm converting from phpbb2 to smf 1.1 rc2 using the beta converter and sql file, it gave some warnings about avatars, and then it continued until it started recalculating the statistics.
Well, it has been updating the page every 3 seconds for half an hour, and it's still recalculating!
My forum is not SO big, is this normal?
Can I stop this process or it will corrupt my smf?

Edit
I decided to stop it, and the forum works fine, so there isn't any problem apparently.

[SpaceJam]

convert.php + phpbb2_to_smf.sql works fine.
Except this:
Recalculating forum statistics... Unsuccessful!
This query:

    UPDATE `smf`.smf_boards
    SET ID_LAST_MSG = 13004, lastUpdated = 1140119786
    WHERE ID_BOARD = 2
    LIMIT 1;
...but no big deal
I convert phpBB 2.0.19 with 100 members, 1000 Topics, 13000 Posts in about 3 minutes -

THX all supporter 

[Oldiesmann]

Just go to Admin -> Maintenance and click on "Recount All Totals And Statistics" to make sure everything is correct.

[Pedja]

I just run convert on my PHPBB and it killed all mesages on PHPBB forum. I thought instructions were clear that script does nothing with phpbb database and it won't do any damage to it.

Well, great... I am just ruined...

[Harzem]

It has no code to alter any data on phpBB installation. Try to be sure that data are there (or not there) using phpmyadmin.

[BlueSkyWeb]

Hi,

I have already run into problems - am converting from phpnuke 7.9 - is this going to be a problem?

Thanks,
Felisa

[BlueSkyWeb]

I am not even getting that far - I get teh following error msg - I try and upload teh sql file through phpmyadmin.  Is this even what I am meant to do?


SQL query:

/******************************************************************************/ ---~ name : "PHP-Nuke 7.7"/******************************************************************************/ ---~ version : "SMF 1.1 RC1+" ---~ settings : "/config.php", "/includes/constants.php" ---~ defines : IN_PHPBB ---~ from_prefix : "`$dbname`.{$prefix}_" ---~ table_test : "{$from_prefix}users"/******************************************************************************//* Developers Note: *//* phpNuke is EXACTLY the same as phpBB but with constants for table names. *//* The converter doesn't support constants, so this is hard coded. *//******************************************************************************//******************************************************************************/ - -- Converting ranks...
/******************************************************************************/ DELETE FROM {$to_prefix}membergroups WHERE groupName LIKE 'phpBB %'
MySQL said: 

#1064 - 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 '---~ name: "PHP-Nuke 7.7"
/****************************************************' at line 2