Advertisement:

Author Topic: [SMF Converter] MyBB 1.4  (Read 230864 times)

Offline Boricua012

  • Semi-Newbie
  • *
  • Posts: 46
  • Gender: Male
    • PSTRIPLE UNITE
Re: [SMF Converter] MyBB 1.4
« Reply #140 on: December 27, 2009, 12:51:46 AM »
Thanks Norv. Everything went successful. I decided not to use RC2 because TinyPortal has not released a version that is compatible :).

Offline edjca

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] MyBB 1.4
« Reply #141 on: January 01, 2010, 07:55:54 AM »
Alright, SMF is 2.0 RC and MyBB is 1.4.11

I'm getting

Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls...Wrong value type sent to the database. Integer expected. (id_member)

What does this mean?
« Last Edit: January 01, 2010, 08:00:46 AM by edjca »

Offline edjca

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] MyBB 1.4
« Reply #142 on: January 02, 2010, 02:44:29 AM »
Anyone, please?

Offline alexmaster

  • Semi-Newbie
  • *
  • Posts: 33
  • Gender: Male
  • just be happy
    • Фьючерсы, брокерские услуги
Re: [SMF Converter] MyBB 1.4
« Reply #143 on: January 02, 2010, 07:19:44 AM »
Try to make another type to this column in phpMyAdmin.

Offline edjca

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] MyBB 1.4
« Reply #144 on: January 02, 2010, 04:27:38 PM »
I'm sorry, not quite sure what that means.

Offline jetli68

  • Semi-Newbie
  • *
  • Posts: 90
Re: [SMF Converter] MyBB 1.4
« Reply #145 on: January 04, 2010, 08:57:50 AM »
hi i  got mybb 1.4   and i want to  go  to smf

is there any guide to dong this  step by step guides ? and can i  install smf into anothe folder incase the  things got wrong  so i will still have my  mybb folder and database

tia

jet

ThorstenE

  • Guest
Re: [SMF Converter] MyBB 1.4
« Reply #146 on: January 05, 2010, 09:36:39 AM »
jetli68, please check out our docs: Converting to SMF

Offline Tiscan

  • Semi-Newbie
  • *
  • Posts: 38
Re: [SMF Converter] MyBB 1.4
« Reply #147 on: January 06, 2010, 10:24:54 PM »
I just converted a forum from MyBB 1.4.11 to SMF 2.0RC2 and in posts (titles and bodies) we have all sorts of character escaping issues apparently, such as:

\'09

And:

don\'t

Any ideas?

Offline weeman007

  • Semi-Newbie
  • *
  • Posts: 10
Re: [SMF Converter] MyBB 1.4
« Reply #148 on: January 09, 2010, 05:45:11 PM »
Converting from mybb 1.4x to SMF 2.0 RC2  but i have many problems

First of all i had that birthday problem and then something else. I got this solved by using sql that someone posted that had the same problem.

Everything is working now but i got many errors when i scan the forum in the admin panel

A list:

    * Poll #1 is tied to non-existent topic #0.
    * Topic #223 has the wrong number of replies, 9.
    * Topic #439 is in board #8, which is missing.
    * The subject of topic #2 is currently not stored in the subject cache.
   
Around 100 errors so how can i fix that when converting? If i press the fix button it makes a mess of all the topics etc

By the way i went 4 days ago from vbulletin too mybb so i also tried the vbulletin converter. That didnt work very well since i lost many posts with that one

Offline Seventy_Six

  • Newbie
  • *
  • Posts: 7
Re: [SMF Converter] MyBB 1.4
« Reply #149 on: May 03, 2010, 05:45:59 PM »
Need help, so i uploaded the convert.php to my forum root (public_html), and i uploaded mybb14x_to_smf.sql to the same place and i acess the hxxp:www.moviemania-pt.com/convert.php [nonactive] but i am so noob with this, so how can i create a database with my backup? in cpanel?

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: [SMF Converter] MyBB 1.4
« Reply #150 on: May 03, 2010, 06:18:28 PM »
So you don't have MyBB installed, but instead a backup file?

If so, yes... in cpanel, please create a database for mybb (optional). Then, in phpmyadmin, select that database, OR the SMF database, and import the backup file. Please note! If you use the same database, you should make sure your tables have different prefixes... You can see the SMF tables prefixes by looking at the SMF database in phpmyadmin, it's the starting letters of the tables (for example "smf_" if tables are "smf_attachments" etc). For myBb, you may need to open the .sql backup file in a code editor and take a look at the first "CREATE TABLE" line you find: how is the immediately next word - it's the name of the table, and its prefix is MyBB's prefix.

If not, please do tell exactly what you have installed (MyBB is still installed? Where?).
To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github

Offline Seventy_Six

  • Newbie
  • *
  • Posts: 7
Re: [SMF Converter] MyBB 1.4
« Reply #151 on: May 04, 2010, 05:50:13 AM »
So you don't have MyBB installed, but instead a backup file?

If so, yes... in cpanel, please create a database for mybb (optional). Then, in phpmyadmin, select that database, OR the SMF database, and import the backup file. Please note! If you use the same database, you should make sure your tables have different prefixes... You can see the SMF tables prefixes by looking at the SMF database in phpmyadmin, it's the starting letters of the tables (for example "smf_" if tables are "smf_attachments" etc). For myBb, you may need to open the .sql backup file in a code editor and take a look at the first "CREATE TABLE" line you find: how is the immediately next word - it's the name of the table, and its prefix is MyBB's prefix.

If not, please do tell exactly what you have installed (MyBB is still installed? Where?).

I dont have mybb instaled but i have a database backup, so i create a database and i upload the backup...
And i run the convert.php?

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: [SMF Converter] MyBB 1.4
« Reply #152 on: May 04, 2010, 11:21:54 AM »
Please do create a database (or use SMF's database, it might be easier). If you create a different database, please also make sure that: you have now two databases, one for SMF and one for MyBB. The database user for SMF's database should also have all rights to access MyBB's database.
(If you import the backup into SMF's database directly you don't have to worry about users too - but please see the above post to make sure there's no conflict)

Then, please create anywhere in your web space (maybe in SMF's directory if you want - might be easier), a folder "inc". Download the attached file and open it in a code editor, and edit it to contain the name of your MyBB database, and your MyBB prefix.
Add this file in the /inc folder.

Then, run convert.php. When it asks where is MyBB installed, please tell it the folder in which you created /inc (so the parent folder, without "inc"). It will trick it. :)
To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github

Offline EnjatsRed

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] MyBB 1.4
« Reply #153 on: May 10, 2010, 01:09:16 PM »
Code: [Select]
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting censored words... Successful.
Converting moderators... Successful.
Converting topic view logs... Successful.
Converting attachments... Successful.
Recalculating forum statistics... Unsuccessful!
This query:

    SELECT mem.ID_MEMBER, COUNT(pmr.ID_PM) AS realNum, mem.instantMessages
    FROM `playined_ind`.smff_users AS mem
    LEFT JOIN `playined_ind`.smff_pm_recipients AS pmr ON (mem.ID_MEMBER = pmr.ID_MEMBER AND pmr.deleted = 0)
    GROUP BY mem.ID_MEMBER
    HAVING realNum != instantMessages;

Caused the error:

    Table 'playined_ind.smff_users' doesn't exist

And is need the :


    Table 'playined_ind.smff_members'

please fix theprblem ...

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: [SMF Converter] MyBB 1.4
« Reply #154 on: May 10, 2010, 01:35:29 PM »
Can you please tell, what converter did you use? It would be better if you download the one for your SMF version, from this site's Downloads > Converters.
To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github

Offline Pellets

  • Semi-Newbie
  • *
  • Posts: 49
Re: [SMF Converter] MyBB 1.4
« Reply #155 on: June 20, 2010, 10:06:43 AM »
I get tons of errors when trying to convert.

I get ~500 lines of these:
Notice: Undefined index: realName in /usr/www/virtual/www.***.com/smf/convert.php on line 1116

Notice: Undefined index: memberName in /usr/www/virtual/www.***.com/smf/convert.php on line 1115



And 500 looking similar to this line:
('500', 'pa11', 'pa11', 'fiasdfdsns@teasdfco.net', 'ecb7279arf235fg372fd7e40df1f89', 'dVrwOdqTt', '1', '', '116923458128', '0', '116623454956', '', '', '', '', '', '', '', '1', '', '', '', '', '372', '0001-01-01', '', ''),

And at the bottom it says:

Unknown column 'memberName' in 'field list'

Offline Pellets

  • Semi-Newbie
  • *
  • Posts: 49
Re: [SMF Converter] MyBB 1.4
« Reply #156 on: June 20, 2010, 11:06:45 AM »
Ahhhh ******... I've tried a lot of .sql files in this thread, not one works.  >:(

Offline slavko17

  • Newbie
  • *
  • Posts: 2
Re: [SMF Converter] MyBB 1.4
« Reply #157 on: June 27, 2010, 03:42:43 AM »
This converter makes my server very unstable... It hangs at Members... incomplete "the installer has paused to avoid"etc... Then my server stop responding and i'm getting many 503 errors and i have to kill one process of MySQL... On localhost is exactly same situation... I looked at database and it seemed, that all members got alredy converted, then why it freeze?



Sorry for my bad english, regards

ThorstenE

  • Guest
Re: [SMF Converter] MyBB 1.4
« Reply #158 on: June 29, 2010, 03:01:04 AM »
slavko17, edit the mybb14_to_smf.sql and find:
Code: [Select]
LEFT JOIN {$from_prefix}users AS ul ON (BINARY ul.username = t.lastposter)replace it with
Code: [Select]
LEFT JOIN {$from_prefix}users AS ul ON (ul.username = t.lastposter)then re-start the converion, hopefully it helps.

Offline slavko17

  • Newbie
  • *
  • Posts: 2
Re: [SMF Converter] MyBB 1.4
« Reply #159 on: June 29, 2010, 02:52:33 PM »
Woooow! It works now! :D Thanks alot :D