News:

SMF 2.1.1 has been released! Take it for a spin! Read more.

Main Menu

Converting big forum from Yabb to SMF

Started by evgenydeep, May 20, 2008, 06:53:08 AM

Previous topic - Next topic

JMB

#40
Quote from: evgenydeep on August 05, 2008, 03:44:04 AM
One another bug. Serious bug.
In "Converting membergroups" step function convertStep1().
I notice that NoPost Groups has not been converted.

How it now:
elseif (preg_match('~\$NoPost\[(\d+)\] = [\'|"]([^|]*)\|(\d*)\|([^|]*)\|([^|]*)~', $group, $match) != 0)

How it should be:
elseif (preg_match('~\$NoPost\[(\d+)\} = [\'|"]([^|]*)\|(\d*)\|([^|]*)\|([^|]*)~', $group, $match) != 0)

I hadn't noticed the non post groups not being imported!

I tried this change but it didn't work for me. I got it working with this:


elseif (preg_match('~\$NoPost\{\'(\d+)\'\} = [\'|"]([^|]*)\|(\d*)\|([^|]*)\|([^|]*)~', $group, $match) != 0)


Although the minPosts count is wrong on all of them...

SleePy

Do you have a sample of a post group?

Just wanted to know where the number was coming from.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

JMB

It's only the post dependant groups that have the wrong value for minPosts. Mods/Admins and NoPost groups are ok.

Here is a line from my membergroups.txt file:

$Post{'50'} = 'Junior|2|stargold.gif|#9acd32|0|0|0|0|0|0|Blue';


This group imports with a minPosts value of 2. Looks like the 2 comes from between the name and the graphic. That value is the number of stars for the group.

SleePy

Was the minPosts supposed to be 50?
The other numbers there are 0 so I don't think thats it :P

And this is really Yabb 2.1? I can't believe something like that went missing for a while. I guess not many Yabb users customize their post groups :P
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

JMB

Quote from: SleePy on August 06, 2008, 06:26:44 PM
Was the minPosts supposed to be 50?
The other numbers there are 0 so I don't think thats it :P

And this is really Yabb 2.1? I can't believe something like that went missing for a while. I guess not many Yabb users customize their post groups :P

Yep, minPosts is 50 for that one. I have no idea what all the 0's are about!

And yes, it's YaBB 2.1!

Maybe people just went in to SMF after they converted and changed them back by hand.  :o

mtagoon

Hello all,

I want to convert my YaBB 2.5.2 Forum to SMF with this thread instructions [ http://www.simplemachines.org/community/index.php?topic=457735.0 ] and plan to go from YaBB 2.5.2 > YaBB 2.4 > SMF 1.1.14 > SMF 2.0 > SMF 2.0.15 in my computer. I've downloaded the convert.php from here [ http://www.simplemachines.org/community/index.php?topic=140741.0 ] and yabb22_to_smf.php from here [http://www.simplemachines.org/community/index.php?topic=249777.0 ].

I am using Windows 10 Pro, XAMPP for Windows 5.6.39, YaBB 2.4 (downgraded from YaBB 2.5.2), a fresh copy of SMF 1.1.14. Put my YaBB 2.4 site into Maintenence Mode. Run all the YaBB Maintenence Controls. I uploaded/copied the yabb22_to_smf.php and convert.php to my SMF 1.1.14 installation and ran it...  I received an error though as displayed in the results below:

- - - - - -
Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:\xampp\htdocs\forum\convert.php on line 380
Unsuccessful!
This query:

    SELECT @@SQL_BIG_SELECTS, @@SQL_MAX_JOIN_SIZE;

Caused the error:

    Unknown system variable 'SQL_MAX_JOIN_SIZE'

Try again
- - - - - - -

Exist:
My YaBB 2.4 Forum with
- 25,443 members
- 11,176 total topics
- 137,611 total posts


Thanks for any advice!


vbgamer45

Can you attach the convert.php file you are using
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro


vbgamer45

Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

mtagoon

Thank you vbgamer45

After run your new convert.php. I received an error :


Fatal error: Call to undefined function loadDatabase() in C:\xampp\htdocs\forum\convert.php on line 418


Thx.

mtagoon

Hi,

I tried using the converter again from here [ http://www.simplemachines.org/community/index.php?topic=344465.0 ] which user mrtoner paid someone and made a change to convert.php and yabb24_to_smf.php to get it to work. I've attached the converter here for your use. (convert.php and yabb24_to_smf.php are included.)

convert.php :
   - Replace '@@SQL_MAX_JOIN_SIZE' to '@@MAX_JOIN_SIZE' ( line 428 and 437 )
   - Replace '@set_time_limit(300);' to '@set_time_limit(600);' ( line 1979 )

yabb24_to_smf.php
   - Replace 'YaBB 2.2' to 'YaBB 2.4' ( line 26 )

Exist: Windows 10 Pro, XAMPP for Windows 5.6.39
My YaBB 2.4 Forum with
   - 25,443 members
   - 11,176 total topics
   - 137,611 total posts
   - 34,150 pictures (YaBB's Attachments directory)
   - no polls

I've also tried to convert YaBB 2.4 to SMF 1.1.14 :
   1. without picture in YaBB's Attachments directory [Put my YaBB 2.4 site into Maintenence Mode. Run all the YaBB Maintenence Controls.] Database Table prefix : smf_db_00
     The converter took about 5 minutes and the conversion has completed successfully.

   2. with all of 34,150 pictures in YaBB's Attachments directory [Put my YaBB 2.4 site into Maintenence Mode. Run all the YaBB Maintenence Controls.]
     The converter took about 12 hours with no error or successful and the screen didn't show Continue(0) button in the bottom right. It showed " Converting... Converting attachments (if the mod is installed)... " . It seemed that the converter's converted about 10,900 pictures in SMF's attachments directory and my computer did nothing after 12 hours. LoL

   3. with pictures 0 - 10,000 in YaBB's Attachments directory [Put my YaBB 2.4 site into Maintenence Mode. Run all the YaBB Maintenence Controls.] Database Table prefix : smf_db_01
    The converter took about 1.5 hours and the conversion has completed successfully. Attachments all showed up almost fine.

   4. with pictures 10,001 - 20,000 in YaBB's Attachments directory [Put my YaBB 2.4 site into Maintenence Mode. Run all the YaBB Maintenence Controls.] Database Table prefix : smf_db_02
    The converter took about 1.5 hours and the conversion has completed successfully. Attachments all showed up almost fine.

   5. with pictures 20,001 - 30,000 in YaBB's Attachments directory [Put my YaBB 2.4 site into Maintenence Mode. Run all the YaBB Maintenence Controls.] Database Table prefix : smf_db_03
    The converter took about 1.5 hours and the conversion has completed successfully. Attachments all showed up almost fine.

   6. with pictures 30,001 - 34,150 in YaBB's Attachments directory [Put my YaBB 2.4 site into Maintenence Mode. Run all the YaBB Maintenence Controls.] Database Table prefix : smf_db_04
    The converter took about 40 minutes and the conversion has completed successfully. Attachments all showed up almost fine.

I tried converting my YaBB 2.4 to the SMF 1.1.14 and it succeeded in 1, 3, 4, 5 and 6. How to add only the posts with new attachments from database table prefix smf_db_04, smf_db_03 and smf_db_02 to database table prefix smf_db_01?  If I can do.. this migration will be successful with all attachments.

Any ideas?
mtagoon

vbgamer45

I like how creative you were in getting the job done.

After the files are converted I would move them all back to the attachments directory in your main folder for SMF that ran completely.

Then take the entries from smf_attachments table in each database prefix and add them to your main SMF database install. Insert/Replace the smf_attachments table with those entries. They should be unique with the attachment id.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

mtagoon

Eureka!!!

Thank you vbgamer45; modified, updated and inserted all smf_attachments tables as per your suggestions, and successfully migrating from YaBB 2.4 with all attachments to SMF 1.1.14 forum. Rebuilt/moved/modified boards, categories, membergroups, attachments that duplicated copies or didn't import properly and ran the SMF 1.1.14 maintenence tasks before successfully large upgrade the local copy of SMF 1.1.14 to SMF 2.0.15 forum in 10 minutes! Thank you very much indeed - I spent a lot of time looking for a solution and was getting nowhere  ...and also thanks for the other relative posts, of course.

mtagoon

vbgamer45

Excellent news glad you have it working!
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Advertisement: