[SMF Converter] Yabb - 2.1

[fbiss]

thanks

just really ready to move from yabb  .

[fbiss]

I know your still working on this , but i got a quick question.

the current yabb forum I am working with is setup on a Win Server, It shouldn't matter if I copy the files over to a Apache server and convert it there should it?

[JayBachatero]

No it shouldn't matter.  Also I just finished writing the poll stuff to convert them.  Now I am working on the keys so that you wont have to convert on a fresh forum.  I should have it up by tonight.

[fbiss]

Awesome!!


thanks again for your work on this. 

[JayBachatero]

Whos has a YaBB board that they want to convert?  I need a board to test the new features that I added to the converter.  If you want to offer your board please send me a PM with the FTP info and the database password.

[fbiss]

Information sent via PM

[Sir_Trout]

Hey all,

I have been working on converting from Yabb 2.1 to SMF on and off for a week now and it's not working for me.  I have a few questions after reading through this thread.

Are there any other instructions then what shows up when you start the converter?

Do I need to delete all of the Polls?

I saw a post about deleting all of the tables, what tables are they talking about?

I'm using IE 7 could that be a problem?


Here is the first error that I get....

YaBB 2 to SMF Converter
Converting...
Converting membergroups... Successful.
Converting members...
Notice: Undefined index: icq in /homepages/31/d134884673/htdocs/ffwis/smf/yabb2_to_smf.php on line 301

Notice: Undefined index: aim in /homepages/31/d134884673/htdocs/ffwis/smf/yabb2_to_smf.php on line 302

Notice: Undefined index: yim in /homepages/31/d134884673/htdocs/ffwis/smf/yabb2_to_smf.php on line 303

Notice: Undefined index: msn in /homepages/31/d134884673/htdocs/ffwis/smf/yabb2_to_smf.php on line 304

*Snip*
This goes on for about 3500 lines...
*Snip*

Notice: Undefined index: staff in /homepages/31/d134884673/htdocs/ffwis/smf/yabb2_to_smf.php on line 656
Unsuccessful!
This query:
INSERT INTO `db189962049`.smf_boards
(name, description, countPosts, boardOrder, memberGroups, tempID, tempCatID, membergroups)
VALUES ('', 'For news and information regarding the Fox Valley chapter of Trout Unlimited.', '1', '1', '', 'FoxValleyTU', 'general', '-1,0'),
('', 'Share information on what's hatching and how the tributary runs are doing.', '1', '2', '', 'Hatch', 'general', '-1,0'),
('', 'Discuss Wisconsin fly patterns and how best to tie them.', '1', '3', '', 'Tying', 'general', '-1,0'),
('', 'This is the board for General Discussions on Fly Fishing.<br />', '1', '4', '', 'general', 'general', '-1,0'),
('', 'Test the forum out here. Posts made in this board will not add to your post count. Post will be deleted from this section after testing is done.', '', '5', '', 'test', 'general', '-1,0'),
('', '', '', '6', '', '2', 'staff', '-1,0'),
('', 'If You Can\'t Stand The Heat, Stay Out Of The Fire!<br /><br />Complaints To Staff Will Be Ignored You Have Been Warned', '1', '7', '', 'Flame', 'staff', '-1,0'),
('', 'Share info and notes on moderating task.', '1', '8', '', 'Moderator', 'staff', '-1,0'),
('', 'Topics you place in this board will display as a \"Global Announcement\" on the top of all other boards. Use this for things such as forum rules, top news articles, or important statements.', '1', '9', '', 'announcements', 'staff', '-1,0');
Caused the error:

Column 'memberGroups' specified twice

So I hit try again and I get this....

Converting...
Converting boards and categories... Unsuccessful!
This query:
ALTER TABLE `db189962049`.smf_categories
ADD tempID tinytext;
Caused the error:
Duplicate column name 'tempID'

Is this just the Index error that other are seeing?

I'm in no big rush to get it convered over but sooner the better.

Thanks for reading the post.

-ST

[JayBachatero]

I've been real busy the past few days and I've worked on this slowly.  I'll try to see if I get a working converter by monday.  Can't promise anything since i work today and I'm going to a party from work tom.

[Sir_Trout]

Thanks for the reply, I'll glady wait untill you have time.

Enjoy the party!

-ST

[fbiss]

Any Update on the Converter?

[JayBachatero]

No update sorry.  I've been too busy with work.  Barely had time to work on it.  After new years I should be able to finish it.  Sorry for the log wait.  I did manage to fix the bug that you were having when the convertor was just hanging.  Just need to finish the poll conversion.

[fbiss]

Thanks Jay,

Thats understandable , I know what its like to be busy at work, especially this time of year.

and No worries, Im just happy someone is even making this converter.


thanks again. Enjoy the rest of the holiday season. 

[Ertado]

I have a problem. I converted from YaBB 2.1 and I thought everything was fine until I noticed that when people posted, their post count wasn't increasing. How do I fix this?

[madkeen]

Thanks for a great converter. I just converted a board with the following stats
22444 Posts in 2528 Topics by 49 Members

Only problem I had was the polls. I just deleted the *.poll and *.polled files from the Yabb Messages directory and then did a fresh install of SMF and then did the conversion and it went fine.

The problem I have now is that I want to convert a board with the following stats
Our users have made 461213 Posts within 50111 Topics.
We have 16603 registered members.

There is a lot of polls in this one that I do not want to delete. Will be great if you do get some time to do the poll bit. But as they say, All good things take time 

Thanks for all the hard work you have done

[JayBachatero]

Yea I worked on it a bit the other day but haven't had time to work on it again.  I do have 3 days off from work this week so I can work on it and fix it finally.

[JayBachatero]

The converter has been updated.  The two biggest changes are: Polls are now converted and you don't need a fresh install of SMF to convert to.  Before if you got a duplicate column/key error you had to reinstall SMF.  Now you don't have to do that.

Changelog
! In some cases YaBB users ' or " in membergrouos.txt causing the regular expression to fail and membergroups not to be converted. (yabb21_to_smf.php)
+ Added check to prevent duplicate columns/keys errors. (convert.php, yabb21_to_smf.php)
! It's location not locaiton (yabb21_smf.php)
+ Added allow_guestAccess to the list of settings to convert. (yabb21_to_smf.php)
! Sometimes YaBB leaves members files behind causing deleted members to be converted. (yabb21_to_smf.php)
! Mark PM's as read. (yabb21_to_smf.php)
! When converting posts in part 3 "while (true)" was giving internal server errors in some hosts and looping for ever. (yabb21_to_smf.php)
+ Polls are now converted. (yabb21_to_smf.php)

[madkeen]

Thanks for your hard work. Much appreciated.

[madkeen]

Just tried to convert my main board and got the following
It listed about 100 Members, I cut the list down and also blanked out their E-mail address
Any clues as to what I should do. I tried a second time and it appeared to list different users.

**** = information I have blanked out

Code Select Expand


Converting...
Converting members...
Notice: Undefined offset: 0 in /home/****/public_html/forums/yabb21_to_smf.php on line 2005

Warning: array_keys() [function.array-keys]: The first argument should be an array in /home/****/public_html/forums/yabb21_to_smf.php on line 2005

Warning: implode() [function.implode]: Bad arguments. in /home/****/public_html/forums/yabb21_to_smf.php on line 2005
Unsuccessful!
This query:

    INSERT INTO `****_forums`.smf_members
    ()
     ('RichardS', '1589061267c6524965bdc0895ae9f2d2', 'RichardS', '****@ssc.net.au', '', '', '', '0', '0', '', '', '', '', '', '****.com.au', 'blank.gif', '1165176649', '', '', '1', '', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
    ('ifan', '7ad8c6ae6fad49f2ab9f3a5be0e7c432', 'ifan', '****@yahoo.com.au', '', '', '', '0', '0', '', '', '', '', '1', '****.com.au', 'homer.gif', '1152023499', '', '', '1', '1152019743', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
    ('nitro_man', '5b38b6a590f60c2984b979e27bc95c6e', 'nitro_man', '****@hotmail.com', '', '', '', '0', '0', '', '', '', '', '1', 'Born to Fish - Forced to Work', 'blank.gif', '1102519288', '', '1989-03-04', '1', '', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
    ('thespark', '1b7cfe4906531892381d8ae090eaad8d', 'thespark', '****@bigpond.net.au', '', '', '', '0', '0', '', '', '', '', '', '****.com.au', 'blank.gif', '1163169833', '', '', '1', '1164090541', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
    ('duebs', 'd86c195a46545a0881b9cce677b3ffbe', 'duebs', '****@sunmetals.com.au', '', '', '', '0', '0', '', '', '', '', '', 'Ausfish.com.au', 'blank.gif', '1138076641', '', '', '1', '1138642040', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
    ('bartman', '6768cd7620fcc4167671496f743097cd', 'bartman', '****@hotmail.cm', '', '', '', '0', '0', '', '', '', '', '', '****.com.au', 'blank.gif', '1154457618', '', '', '0', '', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
    ('catchum', '1e80686bf909b80af2b9d0194a9be327', 'catchum', '****@hotmail.com', '', '', '', '15', '0', '', '', '', '', '', '****.com.au', 'blank.gif', '1161730076', 'caboolture', '', '0', '1168330582', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
    ('salty', 'f1165d717f35820468caf0dc2bc00aea', 'salty', '****@interworx.com.au', '', '', '', '0', '0', '', '', '', '', '', 'Born to fish - Forced to work', 'blank.gif', '1010876228', '', '', '1', '', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
    ('plano', '67db70a1524fad9ed75af956d0e3a201', 'plano', '****@hotmail.com', '', '', '', '0', '0', '', '', '', '', '', '****.com.au', 'blank.gif', '1131881778', 'redland bay', '1970-12-03', '1', '1131862057', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
    ('Hamowa', 'ec8f8f6b2ba2a444472d4b6d07a87d09', 'Hamowa', '****@iinet.net.au', '', '', '', '0', '0', '', '', '', '', '1', '****.com.au', 'ze0_avatar.gif', '1138275008', '', '', '0', '1141254986', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '');

Caused the error:

    Column count doesn't match value count at row 1



[JayBachatero]

What version of YaBB are you using?

[madkeen]

Running 2.1

Stats

Our users have made 463089 Posts within 50320 Topics.
We have 16672 registered members.



Mods installed

Members Only Search
Ban / Mod Functions YaBB2
Quick Reply Box
YaMMS 4
Gender Lock
Event Calendar
Search for IP Address
Online Games
SpelChek
Users Today
NewsIndex
Sub-Board for YaBB 2.1
Print Who Is Online
Dice 4
YaBB Media Center
Admin HTML in Posts
RateIT Mod
Alert Moderator
Users Avatars Upload