Advertisement:

Author Topic: Converting big forum from Yabb to SMF  (Read 51022 times)

Offline JMB

  • Semi-Newbie
  • *
  • Posts: 50
  • Gender: Male
Re: Converting big forum from Yabb to SMF
« Reply #40 on: August 06, 2008, 10:48:14 AM »
One another bug. Serious bug.
In "Converting membergroups" step function convertStep1().
I notice that NoPost Groups has not been converted.

How it now:
Code: [Select]
elseif (preg_match('~\$NoPost\[(\d+)\] = [\'|"]([^|]*)\|(\d*)\|([^|]*)\|([^|]*)~', $group, $match) != 0)
How it should be:
Code: [Select]
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:

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

Although the minPosts count is wrong on all of them...
« Last Edit: August 06, 2008, 10:50:35 AM by JMB »

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,292
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: Converting big forum from Yabb to SMF
« Reply #41 on: August 06, 2008, 01:01:32 PM »
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

Offline JMB

  • Semi-Newbie
  • *
  • Posts: 50
  • Gender: Male
Re: Converting big forum from Yabb to SMF
« Reply #42 on: August 06, 2008, 01:50:09 PM »
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:
Code: [Select]
$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.

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,292
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: Converting big forum from Yabb to SMF
« Reply #43 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
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline JMB

  • Semi-Newbie
  • *
  • Posts: 50
  • Gender: Male
Re: Converting big forum from Yabb to SMF
« Reply #44 on: August 06, 2008, 06:38:53 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

Offline mtagoon

  • Newbie
  • *
  • Posts: 6
Re: Converting big forum from Yabb to SMF
« Reply #45 on: December 28, 2018, 02:40:40 PM »
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!


Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,232
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Converting big forum from Yabb to SMF
« Reply #46 on: December 28, 2018, 02:45:31 PM »
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

Offline mtagoon

  • Newbie
  • *
  • Posts: 6
Re: Converting big forum from Yabb to SMF
« Reply #47 on: December 28, 2018, 03:00:16 PM »
No, I can not attach the convert.php file in this thread. Only this link -> https://www.simplemachines.org/community/index.php?action=dlattach;topic=140741.0;attach=128919

Thx.

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,232
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Converting big forum from Yabb to SMF
« Reply #48 on: December 28, 2018, 03:04:51 PM »
Try this file
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

Offline mtagoon

  • Newbie
  • *
  • Posts: 6
Re: Converting big forum from Yabb to SMF
« Reply #49 on: December 28, 2018, 03:19:15 PM »
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.

Offline mtagoon

  • Newbie
  • *
  • Posts: 6
Re: Converting big forum from Yabb to SMF
« Reply #50 on: January 10, 2019, 11:56:08 PM »
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

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,232
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Converting big forum from Yabb to SMF
« Reply #51 on: January 11, 2019, 09:12:58 AM »
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

Offline mtagoon

  • Newbie
  • *
  • Posts: 6
Re: Converting big forum from Yabb to SMF
« Reply #52 on: January 17, 2019, 01:55:24 AM »
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

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,232
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Converting big forum from Yabb to SMF
« Reply #53 on: January 17, 2019, 08:59:40 AM »
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