Simple Machines Community Forum

SMF Support => Converting to SMF => YaBB/YaBB SE => Topic started by: Larian on June 26, 2020, 04:36:49 PM

Title: Convert from Yabb 2.6
Post by: Larian on June 26, 2020, 04:36:49 PM
Hello,

I'm using a new server and now my Yabb 2.6 doesn't work. So i found Simple Machine an tried to convert. But i only find converters from yabb 1 to yabb 2.2. With the yab 2.2 converter i get the error "Unable to find the settings for YaBB 2.2."
If i rename my Paths.pm to Paths.pl it seems to work, but i see only:

"Successful.
Converting membergroups... Successful.
Converting members..."

- and nothing more

The error-log says:
[Fri Jun 26 22:28:47.252180 2020] [proxy_fcgi:error] [pid 17277:tid 139640652621568] AH01071: Got error 'PHP message: PHP Warning:  file(/var/www/vhosts/domain/httpdocs/forum26/Variables/Settings.pl): failed to open stream: No such file or directory in /var/www/vhosts/domain/httpdocs/forum/yabb22_to_smf.php on line 87\nPHP message: PHP Warning:  Invalid argument supplied for foreach() in /var/www/vhosts/domain/httpdocs/forum/yabb22_to_smf.php on line 88\n', referer: domain/forum/convert.php?step=1

[Fri Jun 26 22:28:47.252339 2020] [proxy_fcgi:error] [pid 17277:tid 139640652621568] AH01071: Got error 'PHP message: PHP Warning:  file(/var/www/vhosts/domain/httpdocs/forum26/Variables/membergroups.txt): failed to open stream: No such file or directory in /var/www/vhosts/domain/httpdocs/forum/yabb22_to_smf.php on line 139\nPHP message: PHP Warning:  Invalid argument supplied for foreach() in /var/www/vhosts/domain/httpdocs/forum/yabb22_to_smf.php on line 140\n', referer: domain/forum/convert.php?step=1

[Fri Jun 26 22:28:47.253214 2020] [proxy_fcgi:error] [pid 17277:tid 139640652621568] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught Error: Call to undefined function mysql_fetch_assoc() in /var/www/vhosts/domain/httpdocs/forum/yabb22_to_smf.php:202\nStack trace:\n#0 /var/www/vhosts/domain/httpdocs/forum/convert.php(1361): convertStep3()\n#1 /var/www/vhosts/domain/httpdocs/forum/convert.php(988): run_php_converter()\n#2 /var/www/vhosts/domain/httpdocs/forum/convert.php(51): doStep1()\n#3 {main}\n  thrown in /var/www/vhosts/domain/httpdocs/forum/yabb22_to_smf.php on line 202\n', referer: domain/forum/convert.php?step=1

I'm using php 7.1 and SMF 2.0.17

I would say the converter doesn't work with php 7 and with yabb 2.6

Has anyone an working converter for yabb 2.6?

Thank You
MArcus
Title: Re: Convert from Yabb 2.6
Post by: vbgamer45 on June 26, 2020, 10:15:29 PM
Do those files exist var/www/vhosts/domain/httpdocs/forum26/Variables/Settings.pl
/var/www/vhosts/domain/httpdocs/forum26/Variables/membergroups.txt

Or are they named something else in the directory

yabb22_to_smf.php  for sure does not work PHP 7 probably will need to downgrade to PHP 5.5
Title: Re: Convert from Yabb 2.6
Post by: Larian on June 29, 2020, 04:08:36 AM
The problem with settings.pl i found, it's renamed to Settings.pm too (like the Paths.pl/.pm)
But the membergroups.txt soesn't exist at yabb 2.6 it's integrated in Settings.pm now.

My new server doesn't support php 5.x anymore but i will try to convert yabb to smf at my old server now :)
Title: Re: Convert from Yabb 2.6
Post by: Larian on July 06, 2020, 03:41:13 PM
Ok, found the solution and converted my old yabb 2.6.11:

1. installed smf 1.1.14 with php 5.5 (on my old server)
2. renamed Paths.pm to Paths.pl and Settings.pm to Settings.pl
3. used the converter from this post: https://www.simplemachines.org/community/index.php?topic=240334.msg4002547#msg4002547
4. converter worked, except for membergroups (other problems: some membernames with special German letters were empty, some board-categories were missing (alle boards were in General board))
5. removed problems (added categories and moved boards, added missing displaynames)
6. added membergroups
7. update to smf 2.0.17
8. changed php to 7.1
9. ready
Title: Re: Convert from Yabb 2.6
Post by: justinbowser on October 06, 2020, 12:03:35 PM
Maybe this should be a new thread, if so mods please detach.

My YaBB 2.6 forum is on it's last legs and I have installed SMF 2.0.17.  It seems all of the instructions I find convert to an earlier version of SMF.  My questions is can I run these conversion scripts with SMF 2.x?

Please be gentle! :o

Justin B.
Title: Re: Convert from Yabb 2.6
Post by: vbgamer45 on October 06, 2020, 12:46:22 PM
I don't believe so I found the instructions above
Title: Re: Convert from Yabb 2.6
Post by: justinbowser on October 06, 2020, 01:15:27 PM
So, I need to "downgrade" the SMF installation in order for the converters to work?  My host's control panel only has one version of SMF as a choice is there a link on how to download and install an earlier version?
Title: Re: Convert from Yabb 2.6
Post by: vbgamer45 on October 06, 2020, 01:22:22 PM
Yes, you can grab from https://download.simplemachines.org/index.php?archive
Title: Re: Convert from Yabb 2.6
Post by: justinbowser on October 06, 2020, 11:35:29 PM
Thanks.

I did a fresh install of 1.1.14 into it's own directory and ran the yabb24_to_smf.php script.  It seemed to run OK the first time except it finished in a second or two.  No errors were reported and of course nothing was converted.  I tried it again and things seems to be going OK.  It is in the converting attachment phase and the only thing that changes is the "substep" counter which is incrementing slowly by 100.  It is currently on 1800 and as long as this number keeps changing I am taking it as a good sign.



Title: Re: Convert from Yabb 2.6
Post by: justinbowser on October 07, 2020, 12:06:31 AM
After running for a couple of hours the conversion finished, claimed it was successful, but the "new" forum has no posts.  It looks like the members were converted, dub-boards appear to be there, my messages/PMs are there, and I have a huge attachment directory under SMF but no posts.

I also have 11 pages of the following error in the forum error log:

https://bmwr65.org/smf/V1.1.14/index.php

8192: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead
File: /home/bmwrorg/public_html/smf/V1.1.14/Sources/Load.php(198) : runtime-created function
Line: 3

Do I need to run the conversion again or is there something elsi I need to check?

Thanks...
Title: Re: Convert from Yabb 2.6
Post by: vbgamer45 on October 07, 2020, 12:19:15 AM
How many rows are in the smf_topics and  smf_messages database tables. If it has content i would try to upgrade to SMF 2.0
Title: Re: Convert from Yabb 2.6
Post by: justinbowser on October 07, 2020, 12:26:18 AM
More weirdness - If I go into my profile and click on "Show Posts" it appears my posts are there and I can see threads.  Some attachments are in the posts but most are not.

It is bed time for this old fart...

I am assuming that the tables you want me to check are in the mysql database?  Not sure how to look at that as YaBB didn't use such things.
Title: Re: Convert from Yabb 2.6
Post by: vbgamer45 on October 07, 2020, 12:29:55 AM
Yeah with a tool such as phpmyadmin etc. Or you can try to do 2.0 upgrade and see what happens.
Title: Re: Convert from Yabb 2.6
Post by: justinbowser on October 07, 2020, 01:36:34 AM
smf_topics = 10417
smf_messages = 105117
Title: Re: Convert from Yabb 2.6
Post by: vbgamer45 on October 07, 2020, 08:22:56 AM
Looks good try the SMF 2.0 upgrade
Title: Re: Convert from Yabb 2.6
Post by: justinbowser on October 07, 2020, 11:10:14 AM
Upgrade appears to be hung on backing up database.  I uploaded the upgrade package, extracted it, set php version back to 7.4, and atarted upgrade.  It is at 4% and has been so for over 15 minutes and the elapsed time only increments when I refresh the page.  Attached is a screen-shot...
Title: Re: Convert from Yabb 2.6
Post by: vbgamer45 on October 07, 2020, 11:22:10 AM
You can skip that part the backup portion. Or you can just export the tables manually first.
Title: Re: Convert from Yabb 2.6
Post by: justinbowser on October 07, 2020, 01:12:45 PM
It hung on the first step.  Apparently my database is hosed so I'm going to wipe everything out and start from scratch...
Title: Re: Convert from Yabb 2.6
Post by: justinbowser on October 07, 2020, 11:01:15 PM
I wiped out the SMF installations and the database and started over installing 1X first, then the YaBB conversion.  My first attempt was installing 2X, downgrade to 1X, conversion, then attempt to go back to 2X. 

Things are definitely running differently now as I am almost 6 hours into the data conversion with no end in sight - we have a crap-load of attachments, pictures mostly!  I checked my server stats and I have maxed out my 1 GB memory allotment since conversion started and now my 2.4 MB/S I/O usage is also maxed out.  Hopefully this will finish by morning as I'd hate to get a nasty-gram from my host...
Title: Re: Convert from Yabb 2.6
Post by: justinbowser on October 08, 2020, 02:57:05 PM
I'm getting a bit concerned.  The conversion has been running almost 22 hours and my    bmwrorg_smf_attachments table is up to over 122,000 lines.  I did an ls | wc -l on the YaBB attachments directory and it counts only 8388 files!  I do ls | wc -l on the smf/attachments directory and get over 122000 files!

Something is not right...
Title: Re: Convert from Yabb 2.6
Post by: justinbowser on October 08, 2020, 03:27:34 PM
I stopped the conversion process and opened up the forum.  Categories exist but show no posts but I can go to threads from my profile.  I opened up some random threads and some posts have attachments that are duplicated dozens of times!  I have also found posts that only contain 1 attachment which was correct for that particular post.  I'm very confused.