Converting from YaBB 2.2

Started by unpossible, January 03, 2008, 11:15:44 PM

Previous topic - Next topic

dontshoot

#160
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

#161
Yea I was told pms where not converting. :P

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 :D
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

dontshoot

#162
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.  :P

SleePy

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
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

dontshoot

sure, no problem. ill pm it to you.

SleePy

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.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

AzJose

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

Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

AzJose

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

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

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

edit the yabb22_to_smf.php and find
) CHARACTER SET utf8 COLLATE utf8_general_ci");
replace it with
)");
then save the file and restart the conversion.

AzJose

#172
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

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?
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

AzJose

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

Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

AzJose

Get this now.  :o

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

Query was empty

SleePy

Alright then, This one should hopefully work. If not then something else has gone amiss.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

AzJose

Where is the beer/cheers smiley??  ;D 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

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:

QuoteConverting 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 [nofollow] 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. :D

Advertisement: