Author Topic: Converting from YaBB 2.2 (Read 152742 times)

dontshoot · « **Reply #160 on:** September 17, 2008, 09:03:57 PM »

Worked great! It hung a little at the end when it was cleaning installation. But otherwise works fine. Only thing that didn't transfer over were the pm's. but i don't mind. (They needed to be cleaned up anyway.) and Post count based groups Required posts reset to 0 but that was a 5 minute fix

Once it finished i ran "Find and repair any errors." "Recount all forum totals and statistics." in Forum Maintenance. and everything important transfer d over.
(members, post, member groups, boards and posts)

Just wanted to say thank you. Yabb was great for a long time. But its was defiantly time to upgrade. it came down to smf or phpbb. You pretty much know who won that. =)

SleePy · « **Reply #161 on:** September 17, 2008, 10:33:00 PM »

Yea I was told pms where not converting.

Required posts for what? To be in the post count group?

Edit, I think I fixed the pms not converting if you want to try it again. Although it sounds like you are happy with them not converting

dontshoot · « **Reply #162 on:** September 19, 2008, 03:42:48 AM »

yeah i dont mind the pm's being wiped. i glad it was. maybe you should keep that as a optional download for people that what the pm's wiped.

What i was talking about the form rank. Like 0 post = Newbie. 50 post = whatever then 100 posts and so on. They all were rest to 0 posts. but it took me only a few minutes to fix it.

thanks again.

now i gotta find out why SimplePortal blocks are all weird sizes in ie but fine in firefox.

SleePy · « **Reply #163 on:** September 20, 2008, 11:24:51 PM »

Do you have a sample membergroups.txt file I can look at? This files is in the vars directory. You can send it how ever

I did update the yabb 2.2 beta topic btw.
http://www.simplemachines.org/community/index.php?topic=249777

So anyone wanting to try the yabb 2.2 converter is welcome

dontshoot · « **Reply #164 on:** September 21, 2008, 06:04:33 PM »

sure, no problem. ill pm it to you.

SleePy · « **Reply #165 on:** September 22, 2008, 12:16:59 AM »

Ok thanks. I believe it is now fixed in my sources

Seems like it wasn't using the right match string to get the post group info.

AzJose · « **Reply #166 on:** September 22, 2008, 08:38:22 PM »

When I run the yabb22_to_smf.php I get nothing back, just a blank screen.

I have both the convert.php and yabb22_to_smf.php in the /smf folder

Any thoughts? Thanks.

SleePy · « **Reply #167 on:** September 22, 2008, 09:48:26 PM »

Updated Converters List & Support Topics

Have you tried using the convert.php from that file.

AzJose · « **Reply #168 on:** September 22, 2008, 11:04:01 PM »

Ok, I got the one on the very bottom, I was using the one in the zip.

Gonna search out some more, but now I get this..

Converting...
Unsuccessful!
This query:
CREATE TABLE `db_atr_joomla`.smf_convert (
real_id TINYTEXT NOT NULL ,
temp TINYTEXT NOT NULL ,
type TINYTEXT NOT NULL
) CHARACTER SET utf8 COLLATE utf8_general_ci;
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 'COLLATE utf8_general_ci' at line 5

ThorstenE · « **Reply #169 on:** September 23, 2008, 01:18:46 AM »

which MySQL version are you using? this error appears when trying to convert with UTF-8 as character set and using MySQL 4.0 or earlier versions (they don't support UTF-8)..

try converting your forum without UTF-8

AzJose · « **Reply #170 on:** September 23, 2008, 01:36:54 AM »

Yes, the SQL is 4.0.21

When the convert loads, I fill in the paths and sql password. I leave the default character set to ISO-8859-1. And I still get the same error. Is there something in the php files I need to tweak?

ThorstenE · « **Reply #171 on:** September 23, 2008, 01:50:21 AM »

edit the yabb22_to_smf.php and find

Code: [Select]

) CHARACTER SET utf8 COLLATE utf8_general_ci");replace it with

Code: [Select]

)");then save the file and restart the conversion.

AzJose · « **Reply #172 on:** September 23, 2008, 02:19:45 AM »

I must be going blind, I cannot find that bit of code at all.

Ok, I am blind, there was another version of the yabb2_to_smf.php I found in the forums. Fixed that.

Now I get another issue. Guess I am just a problem child.

BTW I am using yabb 2.2.2 so dunno if that is gonna make an issue as well.

Successful.
Converting membergroups... Unsuccessful!
This query:
REPLACE INTO `db_atr_joomla`.smf_membergroups
(id_group, group_name, online_color, min_posts, stars)
VALUES (2, SUBSTRING('Global Moderator', 1, 80), SUBSTRING('olive', 1, 20), '-1', SUBSTRING('#stargmod.gif', 1, 255)),
(3, SUBSTRING('Moderator', 1, 80), SUBSTRING('green', 1, 20), '-1', SUBSTRING('#starmod.gif', 1, 255)),
(1, SUBSTRING('Admin', 1, 80), SUBSTRING('blue', 1, 20), '-1', SUBSTRING('#staradmin.gif', 1, 255));
Caused the error:

Unknown column 'group_name' in 'field list'

SleePy · « **Reply #173 on:** September 23, 2008, 02:39:33 PM »

Which file did you find?
Which file where using? I am guessing the beta version of the yabb 2.2 converter that is released on this board?

AzJose · « **Reply #174 on:** September 24, 2008, 10:06:44 AM »

Yes. Using the ones that you guys have lead me towards. Could the 2.2.2 version of yabb I have be causing issues?

SleePy · « **Reply #175 on:** September 24, 2008, 02:32:56 PM »

Does this one work then?

AzJose · « **Reply #176 on:** September 24, 2008, 03:00:44 PM »

Get this now.

Converting...
Unsuccessful!
This query:
;
Caused the error:

Query was empty

SleePy · « **Reply #177 on:** September 24, 2008, 03:31:42 PM »

Alright then, This one should hopefully work. If not then something else has gone amiss.

AzJose · « **Reply #178 on:** September 24, 2008, 03:40:46 PM »

Where is the beer/cheers smiley??

You guys rock!

Converting...
Recalculating forum statistics... Successful.
Conversion Complete
Congratulations, the conversion has completed successfully. If you have or had any problems with this converter, or need help using SMF, please feel free to look to us for support.

pikarl · « **Reply #179 on:** February 26, 2009, 12:37:12 PM »

Hi,

its been a longer time after the last posts in this tread. Now I read all of them and did not find my problem. Here it comes:

trying to convert YaBB 2.2.1 to SMF 1.1.0
is converting like hell for messages
then he´s putting out some error messages for unsuccessful boards and categories (and he´s not converting them)
finally he is accumulating 1.2 GB+ in the attachments folder. in my yabb-attachments-folders are just 11 MB (!)

Those are my error messages:

Quote

Converting personal messages... Successful.
Converting boards and categories...
Notice: Undefined index: iaf in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: raumfahrer.net in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: adminforum in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: 11 in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: 1 in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: 10 in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: 6 in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: fragenastro in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: technikastro in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: news in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: baustelle in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: intern in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: papierkorb in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: rn_redaktion in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: 4 in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: 5 in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: 8 in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: fragenraumfahrt in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: visionen in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: 7 in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652
Successful.
Converting mark read data... Unsuccessful!
This query:

INSERT INTO `raumcon`.log_boards
(logTime, ID_MEMBER, ID_BOARD)
VALUES ('1235498694', '60', '17'),
('1235331378', '60', '18'),
('1235491873', '60', '5'),
('1234375478', '60', '8'),
('1235484928', '60', '20'),
('1235496619', '60', '16'),
('1231120332', '60', '11'),
('1235041315', '60', '6'),
('1235149001', '60', '9'),
('1234375652', '60', '4'),
('1235462077', '60', '12'),
('1235438229', '60', '7'),
('1234802755', '60', '13'),
('1235353186', '60', '19'),
('1235124657', '60', '14'),
('1235414426', '60', '15');

Caused the error:

Unknown column 'logTime' in 'field list'

I also had a look at the newly filled smf attachment folder. Those 1.2 GB (19000+ files!) look like included pictures which are just embedded from external servers. They should stay there.

I appreciate any comments.

News:

Author Topic: Converting from YaBB 2.2 (Read 152742 times)

ThorstenE

ThorstenE