Simple Machines Community Forum

SMF Support => Converting to SMF => MyBB => Topic started by: ThorstenE on August 17, 2008, 02:58:49 AM

Title: [SMF Converter] MyBB 1.4
Post by: ThorstenE on August 17, 2008, 02:58:49 AM
Software: MyBB
Version: 1.4

This is the official support topic for MyBB 1.4 converter.  Use this topic to ask for support for this converter.

Note: This was tested on MyBB 1.4, but should in theory work on newer versions of MyBB if the database changes have not been to great.

Changelog


convert.php
Use this convert.php (http://www.simplemachines.org/community/index.php?topic=140741.0) with the .sql file attached in this topic.
Title: Re: [SMF Converter] MyBB 1.4
Post by: osgeld on September 22, 2008, 08:39:35 PM
whenever i try and convert i get this error message

Quote
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Unsuccessful!
This query:

    SELECT
    t.tid AS ID_TOPIC, t.fid AS ID_BOARD, t.sticky AS isSticky,
    t.poll AS ID_POLL, t.views AS numViews, t.uid AS ID_MEMBER_STARTED,
    ul.uid AS ID_MEMBER_UPDATED, t.replies AS numReplies, t.closed AS locked,
    MIN(p.pid) AS ID_FIRST_MSG, MAX(p.pid) AS ID_LAST_MSG
    FROM (`irshello_irshell`.mybb_threads AS t, `irshello_irshell`.mybb_posts AS p)
    LEFT JOIN `irshello_irshell`.mybb_users AS ul ON (BINARY ul.username = t.lastposter)
    WHERE p.tid = t.tid
    GROUP BY t.tid
    HAVING ID_FIRST_MSG != 0
    AND ID_LAST_MSG != 0
    LIMIT 0, 500;

Caused the error:

    Server shutdown in progress

and i had the same issue when going from mybb 1.2 to smf earlier on (different site), which was resolved

urgency is expressed since mybb decided to die and the site is down

thanks!
Title: Re: [SMF Converter] MyBB 1.4
Post by: SleePy on September 22, 2008, 09:31:39 PM
Try the attached file.
Title: Re: [SMF Converter] MyBB 1.4
Post by: osgeld on September 22, 2008, 09:34:15 PM
Quote
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of MyBulletinBoard 1.0. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: SELECT command denied to user 'irshello_irsrobo'@'localhost' for table 'users'

this is what i get with that file (hi btw) ... this is a 1.14 site
Title: Re: [SMF Converter] MyBB 1.4
Post by: dezzy94 on September 23, 2008, 08:39:16 AM
whenever i try and convert i get this error message

Quote
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Unsuccessful!
This query:

    SELECT
    t.tid AS ID_TOPIC, t.fid AS ID_BOARD, t.sticky AS isSticky,
    t.poll AS ID_POLL, t.views AS numViews, t.uid AS ID_MEMBER_STARTED,
    ul.uid AS ID_MEMBER_UPDATED, t.replies AS numReplies, t.closed AS locked,
    MIN(p.pid) AS ID_FIRST_MSG, MAX(p.pid) AS ID_LAST_MSG
    FROM (`irshello_irshell`.mybb_threads AS t, `irshello_irshell`.mybb_posts AS p)
    LEFT JOIN `irshello_irshell`.mybb_users AS ul ON (BINARY ul.username = t.lastposter)
    WHERE p.tid = t.tid
    GROUP BY t.tid
    HAVING ID_FIRST_MSG != 0
    AND ID_LAST_MSG != 0
    LIMIT 0, 500;

Caused the error:

    Server shutdown in progress

and i had the same issue when going from mybb 1.2 to smf earlier on (different site), which was resolved

urgency is expressed since mybb decided to die and the site is down

thanks!

I have the same issue when trying to convert from MyBB 1.4 to SMF
Title: Re: [SMF Converter] MyBB 1.4
Post by: SleePy on September 23, 2008, 02:40:49 PM
osgeld,
Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)
 
dezzy94,

Try the file I attached above in my previous post. It doesn't have the BINARY in the query that sometimes causes this.
Title: Re: [SMF Converter] MyBB 1.4
Post by: Drift on November 07, 2008, 11:12:59 PM
Do they both work or just the second one?
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on November 08, 2008, 01:58:38 AM
the mybb14_to_smf.sql from the first post of this topic should work fine.
Title: Re: [SMF Converter] MyBB 1.4
Post by: Eldron on November 19, 2008, 02:29:59 PM
Hi...

Can you please tell me step by step on how to convert it? I'm not used to these stuff...
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on November 19, 2008, 02:52:53 PM
Looking to convert to SMF? (http://www.simplemachines.org/community/index.php?topic=273509.0)
Title: Re: [SMF Converter] MyBB 1.4
Post by: Eldron on November 20, 2008, 02:48:58 AM
Yes I tried that page....

I only don't know in which folder to upload the SQL files and Convert.php file to, either SMF folder or MyBB. If in MyBB, in which folder? in the MyBB root? if SMF, which?
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on November 20, 2008, 02:52:37 AM
I personally prefer the SMF folder but they should work from any folder..
Title: Re: [SMF Converter] MyBB 1.4
Post by: tempo on December 06, 2008, 10:23:47 AM
if i convert from myBB to SMF the original data on mybb remain the same or deleted?
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on December 06, 2008, 02:26:55 PM
the mybb content will be copied to your SMF. MyBB will not be modified or deleted. You only need to install SMF to a different directory ..
Title: Re: [SMF Converter] MyBB 1.4
Post by: foxxx428 on December 28, 2008, 08:23:43 PM
A little problem here. I upgraded to 1.1.7 and everything was great except everyone who used IE got an error on every page load. I upgraded to 2.0 and it was gone, but nobody could log in.
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on December 29, 2008, 04:03:20 AM
A little problem here. I upgraded to 1.1.7 and everything was great except everyone who used IE got an error on every page load. I upgraded to 2.0 and it was gone, but nobody could log in.
was your forum originally converted from myBB 1.4 ? SMF is able to read the old passwords. Any errors during login?
Title: Re: [SMF Converter] MyBB 1.4
Post by: foxxx428 on December 29, 2008, 05:45:18 PM
It's an odd one. I converted from MyBB 1.4.4 to SMF 1.1.7 and passwords worked. When I upgraded to the 2.0 beta it was telling people that their username or password was wrong. I've deleted it now and will try again, but I was just hoping someone had some insight for me. Okay I've just tried it again and it's saying Password incorrect to all accounts but my admin account.
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on December 30, 2008, 02:41:17 AM
I need to verify this first but I think I know why the passwords are not working ..

MyBB uses a 8 Character Salt for the passwords encryption. Our converter changes the passwordSalt field in table smf_members to
Code: [Select]
varchar(8) NOT NULL
the Upgrade-Script from SMF 2.0 changes this table field to password_salt. the field is reduced from 8 to 5 characters and so the salt is "destroyed".

Code: [Select]
passwordSalt password_salt varchar(5) NOT NULL
I have no time to verify this at the moment, maybe you can test this?!?
before you upgrade to 2.0 edit the upgrade_2-0_mysql.sql
and find:
Code: [Select]
'passwordSalt' => 'passwordSalt password_salt varchar(5) NOT NULL default \'\'',
replace it with:
Code: [Select]
'passwordSalt' => 'passwordSalt password_salt varchar(8) NOT NULL default \'\'',
Title: Re: [SMF Converter] MyBB 1.4
Post by: dakuipje on December 30, 2008, 09:06:17 AM
Hi,

Im having some heavy problems with the converter as well. The first time it looked to go well but after the members which said unfinished a message came telling me that the converter had stopped to prevent an overloading of my server but when I would click continue it would start where it stopped. I clicked continue however this did not help, the converter did not continue at all yet ended up in an endless loading of the page untill it simple continued for ages. I check the database in phpMyAdmin yet it had the exact same values, the converter was stuck.

After cleaning the database, installing a fresh SMF I tried the converter again. This time however it didnt even do the members ! I cleaned all cookies and stuff.

In fact the endless loading caused my server to automatically go offline for a while. Now this has nothing to do with the server itself as its a pretty heavy one.

The forum im trying to convert has more then 40.000 members and around 90.000 posts. The database is about 200MB. I know this is quite heavy for a script but it should be able to handle it shouldnt it ?

Wilco
Title: Re: [SMF Converter] MyBB 1.4
Post by: foxxx428 on December 30, 2008, 12:43:29 PM
I need to verify this first but I think I know why the passwords are not working ..

MyBB uses a 8 Character Salt for the passwords encryption. Our converter changes the passwordSalt field in table smf_members to
Code: [Select]
varchar(8) NOT NULL
the Upgrade-Script from SMF 2.0 changes this table field to password_salt. the field is reduced from 8 to 5 characters and so the salt is "destroyed".

Code: [Select]
passwordSalt password_salt varchar(5) NOT NULL
I have no time to verify this at the moment, maybe you can test this?!?
before you upgrade to 2.0 edit the upgrade_2-0_mysql.sql
and find:
Code: [Select]
'passwordSalt' => 'passwordSalt password_salt varchar(5) NOT NULL default \'\'',
replace it with:
Code: [Select]
'passwordSalt' => 'passwordSalt password_salt varchar(8) NOT NULL default \'\'',


Hey you're great. I'm not used to getting support for anything. It does work. Will that affect any future updates? I haven't decided on 1.1 or 2.0 for sure yet, but 2.0 seems the way to go from the testing I've done on it so far. Thank you for the fix and thank you for supporting your script! I'm impressed.
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on December 30, 2008, 02:11:56 PM
@dakuipje:
please try the mybb_to_smf.sql attached to this message:
http://www.simplemachines.org/community/index.php?topic=256073.msg1719516#msg1719516
the converter stops before overloading but should automatically continue after 5 Seconds. Try it without click "continue".

@foxxx428:
ugrading SMF "can" be a problem because all table fields were changed to SMF standard values during the upgrade. During the first logon from a user the password is changed to the SMF encryption (4 character salted SHA1). So a later upgrade without the above changes may destroy passwords, but only passwords from members who never logged in SMF before.
Title: Re: [SMF Converter] MyBB 1.4
Post by: foxxx428 on December 30, 2008, 02:24:48 PM
Okay I think I just learned something here, but I need to clarify. I think what you're saying is that if I upgraded to 1.1.7 now and waited to upgrade to 2.0 until it's final and used the normal upgrade path, everyone who had already logged in won't have a problem after the upgrade, but those who didn't will need a password reset, correct? That makes sense since I'd already upgraded to 2.0 before I gave anyone access to the test board. I'm just weighing my options thinking that anyone who doesn't log in by then probably won't be returning.
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on December 30, 2008, 02:32:44 PM
yes, that's exactly what I tried to say :)

Excuse my sometimes "horrible" english  :P (my native language is german).. I learned english in school but it's more than 17 years ago ;)
Title: Re: [SMF Converter] MyBB 1.4
Post by: foxxx428 on December 30, 2008, 02:40:12 PM
Simply amazing support! I think all my problems are resolved except redoing all the subforums and fixing bbcodes, etc. Thank you so much. I just need to consult the rest of my team to decide which way to proceed. By the way, your english is just fine.  :)
Title: Re: [SMF Converter] MyBB 1.4
Post by: SleePy on January 06, 2009, 07:10:03 PM
foxxx428,

Running upgrade again may revert the field again to the lower value. The best thing I can say is hopefully by the next time you do a upgrade (and run Upgrade.php), that your users have logged in already so their passwords are updated to match SMF's encryption.
You could let your users know about the conversion and see if that gets those lurkers to come back to relogin.
Title: Re: [SMF Converter] MyBB 1.4
Post by: karthikguru on January 09, 2009, 03:22:39 AM
Quote
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of MyBulletinBoard 1.0. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: SELECT command denied to user 'irshello_irsrobo'@'localhost' for table 'users'

this is what i get with that file (hi btw) ... this is a 1.14 site



i'm also having this same problem how to solvi it????
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on January 09, 2009, 03:33:04 AM
Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)
the MySQL user from SMF needs access to your myBB database. a possible solution: install SMF and MyBB in the same database.
Title: Re: [SMF Converter] MyBB 1.4
Post by: karthikguru on January 09, 2009, 04:59:47 AM
Converting categories... Unsuccessful!
This query:

    INSERT INTO `database`.smf_categories
    (ID_CAT, name, catOrder)
    VALUES ('1', 'MBA ZONE', '3'),
    ('6', 'Downloadz 360', '6'),
    ('14', 'Projectz 360', '2'),
    ('23', 'E bookz 360', '4'),
    ('31', 'Campus 360', '5'),
    ('82', 'Anna university Questions', '8'),
    ('290', 'General Discussion', '1'),
    ('309', 'Lounge', '7');

Caused the error:

    Duplicate entry '1' for key 1




hi i'm getting this error wat should i do??? i tried the  "    
[Beta] Correct high ID_CAT values "  php file but it din work wat to do????
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on January 09, 2009, 05:31:27 AM
any errors while using the "Correct high ID_CAT values"?

you should run the first step from that file, then start the conversion and after the converter has finished run the second step from "correct high ID_CAT values"

if this doesn't solve your issue you can also use phpMyAdmin ( What is phpMyAdmin? (http://www.simplemachines.org/community/index.php?topic=21919.0) ) and change the smf tables from tinyint to int.

Code: [Select]
ALTER TABLE `smf_categories` CHANGE `ID_CAT` `ID_CAT` INT( 4 ) UNSIGNED NOT NULL AUTO_INCREMENT 
  ALTER TABLE `smf_boards` CHANGE `ID_CAT` `ID_CAT` INT( 4 ) UNSIGNED NOT NULL DEFAULT '0'
Title: Re: [SMF Converter] MyBB 1.4
Post by: foxxx428 on January 09, 2009, 04:00:51 PM
foxxx428,

Running upgrade again may revert the field again to the lower value. The best thing I can say is hopefully by the next time you do a upgrade (and run Upgrade.php), that your users have logged in already so their passwords are updated to match SMF's encryption.
You could let your users know about the conversion and see if that gets those lurkers to come back to relogin.

I really hate sending out mass emails, but I thought your advice is probably best. We ended up using 1.1.7, but it's lacking many features and are growing anxious to the 2.0 upgrade. The problem is we depend on the mkportal for our front page and as far as I know, none of the other portals are set up to run as the front page. The other problem I have is this, I simply cannot find a mass email option in the admin control panel! Am I blind or is it just not an option? You're converter itself did the trick for us and it took me about 12 hours to re-do what was lost in case anyone has a medium sized board and are planning on doing this by themselves like I did. I just up and decided to do it on New Years Eve while everyone else was getting blasted and oddly enough, I couldn't find a single soul to help me! Anyway, I thank you from the bottom of my heart for making this as painless as possible. I wanted to rep or karma you, but I guess it's disabled on this board.
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on January 10, 2009, 02:06:01 AM
for the Newsletters: Admin - News & Newsletters - Newsletters
Choose your groups, then click next and fill the forms ...

You can also use TinyPortal & SimplePortal for the "frontpage".. the only thing you must do: move the entire SMF folder to the top and run repair_settings.php (What is repair_settings.php? (http://docs.simplemachines.org/index.php?topic=663) )
http://www.tinyportal.net
http://www.simpleportal.net
Title: Re: [SMF Converter] MyBB 1.4
Post by: DJBoddington on January 10, 2009, 11:07:14 AM
I tried this but i get;
See Attactched ::(
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on January 10, 2009, 01:42:55 PM
DJBoddington, this looks like a broken session.. please restart the conversion from the beginning.. are the errors the same?
Title: Re: [SMF Converter] MyBB 1.4
Post by: DJBoddington on January 10, 2009, 03:34:54 PM
ah okay :)
Worked and i stuck it in a differnet database (to the one with MyBB in)
Edit; Hmm..a member struggled to log in, they reset password - still failed to login, i changed it - it works....is there anything to do so i dont have to edit all members?
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on January 11, 2009, 11:14:50 PM
is there anything to do so i dont have to edit all members?
the MyBB Forum uses a different encrytion but SMF is able to read the old passwords.. have you done an upgrade to 2.0.B4 after the conversion? then read this please:
http://www.simplemachines.org/community/index.php?topic=256073.msg1858020#msg1858020
Title: Re: [SMF Converter] MyBB 1.4
Post by: Álvaro R on January 16, 2009, 08:35:21 PM
I have a problem...
Appear:

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of MyBulletinBoard 1.4. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: SELECT command denied to user 'alvaroro_smf'@'localhost' for table 'mybb_users'

I dont know what i can make :/
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on January 17, 2009, 01:46:50 AM
Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)
Title: Re: [SMF Converter] MyBB 1.4
Post by: Álvaro R on January 17, 2009, 07:47:27 AM
in this page no is the answer...
the problem is...
The error MySQL gave was: SELECT command denied to user 'alvaroro_smf'@'localhost' for table 'mybb_users'

:/
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on January 17, 2009, 09:37:36 AM
both forums should be installed into the same database.. you can use different databases, but: the MySQL User for both databases must be the same.

Quote
Problem: SELECT command denied to user
Info: The cause of this error is that SMF and Software X are in separate databases and the SMF database user does not have access to Software X's database.
Fix: If your host has cPanel you can add the SMF database user to Software X's database.  If your host does not have cPanel you can contact them with regards on how to accomplish this. As well as a last resort, what you can do is reinstall SMF in the same database as Software X.]
Title: Re: [SMF Converter] MyBB 1.4
Post by: Álvaro R on January 17, 2009, 01:23:32 PM
Mm thanks i understand now ;)
Title: Re: [SMF Converter] MyBB 1.4
Post by: Álvaro R on January 17, 2009, 01:28:31 PM
Now appear another error:

Access denied for user 'root'@'localhost' (using password: NO) :(

NO problem, was the configuration of SMF :)
Now i have SMF !! thanks a LOT
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on January 18, 2009, 03:44:13 AM
Welcome to SMF :)
Title: Re: [SMF Converter] MyBB 1.4
Post by: eclipsenow on January 31, 2009, 03:55:40 AM
I'm interested in why some people leave MyBB for SMF? I've started a thread on it here (http://www.simplemachines.org/community/index.php?topic=289534.0).
Title: Re: [SMF Converter] MyBB 1.4
Post by: Antechinus on February 05, 2009, 06:18:47 AM
Will this converter work with 1.1.8?
Title: Re: [SMF Converter] MyBB 1.4
Post by: IndigoStar on February 05, 2009, 06:45:30 AM
Or better still 2.0
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on February 05, 2009, 10:22:05 AM
Will this converter work with 1.1.8?
sure, there is nothing changed in the database layout between 1.1.7 and 1.1.8.

Or better still 2.0
our 2.0 converters are still in developement. but you can convert your myBB to SMF 1.1.8, then upgrade your forum.
Title: Re: [SMF Converter] MyBB 1.4
Post by: StuR on February 05, 2009, 02:34:15 PM
i have the same problem as alvarorojas4's original problem.

i have tried to create a blank mysql database using the same username but it wont allow me to have duplicates. 

what can i do now?
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on February 05, 2009, 02:36:52 PM
you can install SMF in the MyBB database. SMF tables have a different table prefix (all tables start with smf_ by default) and will not affect the MyBB tables.
Title: Re: [SMF Converter] MyBB 1.4
Post by: StuR on February 05, 2009, 02:42:47 PM
brilliant thank you, worked a treat :)
Title: Re: [SMF Converter] MyBB 1.4
Post by: jazz37 on February 08, 2009, 02:29:17 PM
"  Duplicate entry '127' for key 'PRIMARY'
Dosya: C:\wamp\www\smf\recount_categories.php
Satır: 288   "
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on February 09, 2009, 01:33:24 AM
jazz37, check SleePy's reply at http://www.simplemachines.org/community/index.php?topic=290289.msg1917947#msg1917947
Title: Re: [SMF Converter] MyBB 1.4
Post by: januszwaras on February 09, 2009, 04:41:33 PM
i got this error

Notice: Undefined index: convert_script in /ultraspeedteam/convert.php on line 810

Warning: Invalid argument supplied for foreach() in /ultraspeedteam/convert.php on line 813

Notice: Undefined index: convert_script in /ultraspeedteam/convert.php on line 825

Notice: Undefined index: convert_script in /ultraspeedteam/convert.php on line 721
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2239

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1211

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1221

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2239

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1229

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1239

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2239

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1252

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1265

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2239

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1311

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1313

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2239

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1319

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1325

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2239

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1336

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1337

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2239

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2240

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1345

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1347

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2239

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1353

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1354

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2239

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1360

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1361

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2239

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2240

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2239

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1385

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1387

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2239

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1393

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1405

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2239

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2240

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2239

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1430

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1432

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2239

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2240

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1476

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1491

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2239

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2240

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1520

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1522

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1535

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2239

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1557

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1562

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2239

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1623

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1625

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2239

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1661

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1680

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2239

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2240

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2239

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2240

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2239

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2240

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1703

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 1704

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2239

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 2411

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2239

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2240

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2239

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /ultraspeedteam/convert.php on line 2411

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2239

Notice: Undefined variable: result in /ultraspeedteam/convert.php on line 2240
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.
Please check this box to delete the converter right now for security reasons. (doesn't work on all servers.)

Now that everything is converted over, your SMF installation should have all the posts, boards, and members from the installation.

We hope you had a smooth transition!




BUT NOTHING HAPPENS

WHAT I SHOULD DO ??
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on February 10, 2009, 01:49:34 AM
januszwaras, this looks like an aborted session. please restart the convert from the beginning.
Title: Re: [SMF Converter] MyBB 1.4
Post by: Hime on February 24, 2009, 12:15:15 PM
With the first post's attachment, the members are getting converted(checked through phpmyadmin) & then it just goes on & nothing happens!

8500+ members get converted & then other things just don't change & the converter page keeps loading! Is it normal?

I tried to use the other sql file, it gives a error about the first line of the convert.php!

May I have a little attention please.

MyBB version: 1.4
PHP version: 5.2.8
MySQL: 5.0.67
SMF: 1.1.8
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on February 25, 2009, 01:56:29 AM
on large boards the converter should stop for some seconds during the steps (to avoid a server overload) and then automatically restart (a java-script based auto refresh). Is java-script enabled in your browser settings?
Title: Re: [SMF Converter] MyBB 1.4
Post by: Løque on February 25, 2009, 06:41:04 PM
I have this error: Warning: set_time_limit() has been disabled for security reasons in /www/110mb.com/a/s/h/useraccount/htdocs/smf/convert.php on line 29

Help me.
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on February 26, 2009, 01:44:45 AM
Løque,
our converters use the set_time_limit()  to increase the script execution time. Your host doesn't allow to change this.

Have you tried the conversion? maybe you can complete it without problems.

Another solution: export your MyBB and import it on a local system (XAMPP for example). then convert it to SMF and export the new SMF back to your host.
Title: Re: [SMF Converter] MyBB 1.4
Post by: Løque on February 26, 2009, 08:30:14 AM
Have you tried the conversion? maybe you can complete it without problems.
Yes, don't work.

Another solution: export your MyBB and import it on a local system (XAMPP for example). then convert it to SMF and export the new SMF back to your host.
The right solution, you are a genius :D
Title: Re: [SMF Converter] MyBB 1.4
Post by: Hime on February 27, 2009, 06:49:27 AM
on large boards the converter should stop for some seconds during the steps (to avoid a server overload) and then automatically restart (a java-script based auto refresh). Is java-script enabled in your browser settings?

I am using the latest version of firefox for this. To simplify my problem, the page "convert.php" with the first page .sql file never going to anywhere & keeps always loading only itself! The database when checked through phpmyadmin was getting loaded with the members & the forums, but not anything further! I tried to leave it for few hours but not a single topic or anything else got inside the database.

I used the same database & different database for testin, both resulted in same.

Your help will be very much appreciated.
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on February 27, 2009, 10:55:30 AM
the script simply stops without any errors?

firefox with enabled java-script works great for me, have you checked this with a different browser (Internet Explorer, Opera, Safari)?

Maybe you can PM me a link to both forums, convert.php and your MySQL password. I would like to check it myself.
Title: Re: [SMF Converter] MyBB 1.4
Post by: SAFAD on March 15, 2009, 08:23:39 AM
an error apeared
when i finished converting withe page apear
d* i tried evrything
P.S : when i convert in localhost evrything great but in my website that f* white page apear i treid evrything : convert in localhost then upload the database - change all files - tried with smf 2 evry d* thing

Best Regards
SAFAD
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on March 15, 2009, 02:27:14 PM
sounds like a server specific issue.. you should convert on localhost, then upload the converted forum to your host.
How do I move my SMF board to a different host? (http://docs.simplemachines.org/index.php?topic=489)
Title: Re: [SMF Converter] MyBB 1.4
Post by: SAFAD on March 15, 2009, 03:50:11 PM
thanks bro but i did that & never work
i gotta go crazy cuz the forum somtimes apear & other times white page
P.S : dont think that am new bie cuz am developer & HLH (search in uncle googl xD)
Best Regards
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on March 15, 2009, 04:18:49 PM
have you tried using a fresh install from SMF on your server? (without converted data). is this the same issue with white pages from time to time?
Title: Re: [SMF Converter] MyBB 1.4
Post by: SAFAD on March 15, 2009, 04:21:55 PM
yes i tried it more than 4 times & nothing goes well
as i said the forum works great in localhost but in my site white page
Best Regards
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on March 15, 2009, 04:35:53 PM
you should contact your host about this issues.. a white page is an aborted php script or a missing php extension. you may chek the system requirements (http://download.simplemachines.org/requirements.php) and compare it with a phpinfo();
Title: Re: [SMF Converter] MyBB 1.4
Post by: SAFAD on March 15, 2009, 04:37:17 PM
yeh will try
thanks big bro
Title: Re: [SMF Converter] MyBB 1.4
Post by: SAFAD on March 15, 2009, 04:46:05 PM
bah the webserver is great
if you want to send you the link to check you're self i will
Best Regards
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on March 15, 2009, 04:59:20 PM
a link to phpinfo(); would help a bit.
Title: Re: [SMF Converter] MyBB 1.4
Post by: SAFAD on March 15, 2009, 05:48:38 PM
please bro i want to have luck like you
before this i said that the support arent here (mean my server host)
and i posted the url
you have gived me the correction then the support apeared
holy s* you're amazing but..........................
..............................
..............................
..........................
..............................
............................
..........................
...................
they said that they will try cuz it will minimize security
Best Regards
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on March 16, 2009, 02:48:23 AM
mhh, setting the session.save_path isn't a security risk (it's a "must have" for any php application using sessions) ..

php needs it for creating temporary session files. it's often set to /tmp but it can also be set to /home/username/phptmp or semething similar in your home directory.

also: increasing the memory_limit and script max_execution_time is not a security risk.

Change your host and you'll be happy with SMF ;)
Title: Re: [SMF Converter] MyBB 1.4
Post by: SAFAD on March 16, 2009, 02:56:47 AM
this isnt the prob
cuz when i install SMF it works great but after convert the white page
i will install SMF now to make you sure
Best Regards
Title: Re: [SMF Converter] MyBB 1.4
Post by: SAFAD on March 16, 2009, 03:22:57 AM
look bro
Problem Solved
works great this before converting
anything to say ?
Title: Re: [SMF Converter] MyBB 1.4
Post by: SAFAD on March 16, 2009, 04:18:59 AM
bro are you here ?
 i amwaiting you reponse
Title: Re: [SMF Converter] MyBB 1.4
Post by: SAFAD on March 17, 2009, 06:16:25 AM
any news bro?
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on March 17, 2009, 07:20:26 AM
replied via PM
ok, checked it and got a white page .. I'll bet it is an issue with the session.save_path..

Do you have access to the webserver's error log?
I still get a white page
Title: Re: [SMF Converter] MyBB 1.4
Post by: r9 on April 05, 2009, 06:34:59 PM
I'm trying to download the convert.php, but everytime I click on it on the first page of this thread, it takes me to another thread, and then it just goes in circles.

I have MyBB 1.4, and I want to convert to the SMF 1.1.8 software.

Thanks
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on April 06, 2009, 05:47:49 AM
convert.php is attached to this topic (scroll down)
http://www.simplemachines.org/community/index.php?topic=140741.0
or direct link:
http://www.simplemachines.org/community/index.php?action=dlattach;topic=140741.0;attach=79452
Title: Re: [SMF Converter] MyBB 1.4
Post by: donatas on April 06, 2009, 08:21:44 AM
Converting members... Unsuccessful!
This query:

    ALTER TABLE `databasename(edit by me) `.smf_members
    CHANGE COLUMN passwordSalt passwordSalt varchar(8) NOT NULL default '';

Caused the error:

    Unknown column 'passwordSalt' in 'smf_members'



I dont understand this error
I need help
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on April 06, 2009, 01:22:03 PM
maybe the wrong SMF version? our converters are actually SMF 1.1.x only (not 2.0).
But you can convert to 1.1.8 and after successful conversion upgrade to 2.0
Upgrade SMF (http://docs.simplemachines.org/index.php?board=3.0;sort=subject)
Title: Re: [SMF Converter] MyBB 1.4
Post by: SAFAD on April 10, 2009, 04:09:10 AM
HI
i think doesnt work with SMF2
"Converting members... Unsuccessful!
This query:
ALTER TABLE `Mybb`.smf_members
CHANGE COLUMN passwordSalt passwordSalt varchar(8) NOT NULL default '';
Caused the error:
Unknown column 'passwordSalt' in 'smf_members'"
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on April 10, 2009, 04:35:54 AM
SAFAD, that's right.. our converters are SMF 1.1.x only at the moment, but you can convert to SMF 1.1.8 and after a successful conversion upgrade to SMF 2.0 RC1
Upgrade SMF (http://docs.simplemachines.org/index.php?board=3.0;sort=subject)
Title: Re: [SMF Converter] MyBB 1.4
Post by: ps3ia on April 14, 2009, 05:40:03 PM
Where is the convert.php file? THe one in the post just links to another thread and in that thread it links to this thread....
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on April 15, 2009, 01:43:19 AM
attached to: http://www.simplemachines.org/community/index.php?topic=140741.0 (at the end - scroll down)
Title: Re: [SMF Converter] MyBB 1.4
Post by: maRoff on April 28, 2009, 10:11:48 AM
I think, I have small problem with this conversion...
I'm using Mybb 1.4.4 Forum I think isn't very big: ~50k posts, ~5k members

I tried to convert it:

On localhost:
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fwratka.pl%2Fbzdety%2Fscreenshot1240911421.jpg&hash=8c37dc35efcc25f4b3fbef7b35cbc4eb)

On web server:
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fwratka.pl%2Fbzdety%2Fscreenshot1240922893.jpg&hash=0235b03cc9a926334b5963e761273d85)

And problem is at windows localhost it's stopped at Converting topics and page not refresh ;/ like on the screen
but on the linux webserver it's something new "Not quiete done yet!" and when I click continue the conversion take a long time, and I think it's stopped :/
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on April 28, 2009, 12:34:16 PM
is Java-Script enabled on your browser? (Firefox, IE) .. convert.php restarts automatically after 3 seconds then. the script stops during a large conversion to avoid a server overload.
Title: Re: [SMF Converter] MyBB 1.4
Post by: maRoff on April 28, 2009, 12:51:01 PM
I tried in IE and Mozilla
On localhost - at converting topic - java not working, I'm waited min. 20 minutes, and page not refresh anymore, when converting 3 first (members, categories, boards) - my computer is lagging, and after that I know that conversion it work.

Maybe you know a version to convert via command line? like this:
http://www.simplemachines.org/community/index.php?topic=207760.msg1322067;topicseen#msg1322067
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on April 28, 2009, 12:59:45 PM
sure, you can use convert.php via command line. parameters on windows:

Code: [Select]
c:\path\to\php.exe  c:\path\to\convert.php  --path_to=c:\path\to\smf --path_from=c:\path\from\mybb --convert_script=mybb14_to_smf.sql --db_pass=smf-database-pass --debug
Title: Re: [SMF Converter] MyBB 1.4
Post by: maRoff on April 28, 2009, 03:08:44 PM
Code: [Select]
C:\Program Files\WebServ\php>php.exe  D:\HTTP\smf\convert.php  --path_to=D:\HTTP
\smf --path_from=D:\HTTP\kopia --convert_script=mybb14_to_smf.sql --db_pass=password --debug
This converter was unable to find SMF in the path you specified.<br /><br />Plea
se double check the path, and that it is already installed there.
C:\Program Files\WebServ\php>

wtf?
For 100% I have path to my SMF correct and mybb too.
Maybe when I can try this command on linux? but problem is to find localization of PHP on my server ;/

Edit: tried on linux via www:
Code: [Select]
Notice: Undefined index: convert_script in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 810

Warning: Invalid argument supplied for foreach() in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 813

Notice: Undefined index: convert_script in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 825

Notice: Undefined index: convert_script in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 721
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2239

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1211

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1221

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2239

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1229

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1239

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2239

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1252

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1265

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2239

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1311

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1313

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2239

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1319

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1325

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2239

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1336

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1337

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2239

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2240

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1345

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1347

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2239

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1353

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1354

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2239

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1360

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1361

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2239

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2240

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2239

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1385

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1387

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2239

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1393

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1405

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2239

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2240

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2239

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1430

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1432

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2239

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2240

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1476

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1491

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2239

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2240

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1520

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1522

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1535

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2239

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1557

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1562

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2239

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1623

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1625

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2239

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1661

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1680

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2239

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2240

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2239

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2240

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2239

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2240

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1703

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 1704

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2239

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2411

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2239

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2240

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2239

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2411

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2239

Notice: Undefined variable: result in /home/gamemaniak/httpdoc/gamemaniak.pl/smf/convert.php on line 2240
Successful.
Conversion Complete

but now thread, no posts :/

Edit2:
I converted first Mybb>vbb (15 minutes)>smf (5 minutes)
Title: Re: [SMF Converter] MyBB 1.4
Post by: SleePy on April 29, 2009, 05:41:11 PM
The linux one, your session expired during the conversion. You will need to restart it.
Title: Re: [SMF Converter] MyBB 1.4
Post by: SAFAD on May 03, 2009, 01:19:11 PM
Hi, Am Back Again To Disturb You People ;)
So You Said That My Host Is Poor
But I Think You Are Wrong !
Why ?
Look
This Is The Link That I Have Installed SMF In Without Converting
Problem Solved
And Now For The Link That I Have SMF In And I Have Converted It From MyBB
Removed Cuz The Problem Solved
The First One Works Correctly But The Second Is A White Page
Any Ideas ?

Best Regards
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on May 03, 2009, 01:32:55 PM
I got a white page with the FIRST link .../smf/index.php and can see the second forum (see attached screenshot).
I believe this is a max_execution_time issue in php.ini
Title: Re: [SMF Converter] MyBB 1.4
Post by: SAFAD on May 03, 2009, 01:36:37 PM
thats not possible !
it was not working
ooo
now try to enter any forum
white page again !
sometimes work and other not
what should i do ?
Title: Re: [SMF Converter] MyBB 1.4
Post by: SAFAD on May 03, 2009, 01:39:24 PM
the 1st always working
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on May 03, 2009, 01:49:14 PM
I believe this is a max_execution_time issue in php.ini
the forum is sometimes available and sometimes the script is aborted. this is definitely a host related issue, sorry but we cannot help you with this. Again: contact your host, the server is overloaded.
Title: Re: [SMF Converter] MyBB 1.4
Post by: SAFAD on May 03, 2009, 01:52:21 PM
how many i need
i use 8MB
do i Tell Them to make it 16MB Or What ?
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on May 03, 2009, 01:56:33 PM
http://download.simplemachines.org/requirements.php
I personally prefer at least 32M memory_limit and a max_execution_time set to 30s (30 seconds)
Title: Re: [SMF Converter] MyBB 1.4
Post by: SAFAD on May 03, 2009, 02:11:41 PM
ok thanks
Title: Re: [SMF Converter] MyBB 1.4
Post by: Hime on May 22, 2009, 03:07:38 PM
Great news....the latest sql file you gave me, worked like a charm!! Its getting converted even faster than my local pc!!!

1 more question....*too much bothering you*

Can I possibly redirect all my /forum urls to /smf or, such? I mean through .htaccess how to do that?

Thank you in advance.
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on May 22, 2009, 05:46:27 PM
you can move your new SMF to the /forums folder: rename the /smf folder to /forum and use repair_settings.php from our downloads page.
alternatively you can use a .htaccess (example here (http://www.simplemachines.org/community/index.php?topic=307900.0)) or even a single php file with a redirect in it.
Code: (index.php) [Select]
<?php
   header
("HTTP/1.1 301 Moved Permanently");
   
header("Location: http://www.yourdomain.com/smf");
   
header("Connection: close");
   exit();
?>

Title: Re: [SMF Converter] MyBB 1.4
Post by: glas on July 30, 2009, 11:13:57 AM
PHP Error Message

Notice: Undefined index: convert_script in /home/a3009661/public_html/v2/convert.php on line 822

Free Web Hosting

PHP Error Message

Warning: Invalid argument supplied for foreach() in /home/a3009661/public_html/v2/convert.php on line 825

Free Web Hosting

PHP Error Message

Notice: Undefined index: convert_script in /home/a3009661/public_html/v2/convert.php on line 837

Free Web Hosting
Successful.
Recalculating forum statistics...
PHP Error Message

Notice: Undefined variable: result in /home/a3009661/public_html/v2/convert.php on line 2257

Free Web Hosting

PHP Error Message

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1223

Free Web Hosting

PHP Error Message

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1233

Free Web Hosting

PHP Error Message

Notice: Undefined variable: result in /home/a3009661/public_html/v2/convert.php on line 2257

Free Web Hosting

PHP Error Message

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1241

Free Web Hosting

PHP Error Message

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1251

Free Web Hosting

PHP Error Message

Notice: Undefined variable: result in /home/a3009661/public_html/v2/convert.php on line 2257

Free Web Hosting

PHP Error Message

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1264

Free Web Hosting

PHP Error Message

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1277

Free Web Hosting

PHP Error Message

Notice: Undefined variable: result in /home/a3009661/public_html/v2/convert.php on line 2257

Free Web Hosting

PHP Error Message

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1323

Free Web Hosting

PHP Error Message

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1325

Free Web Hosting

PHP Error Message

Notice: Undefined variable: result in /home/a3009661/public_html/v2/convert.php on line 2257

Free Web Hosting

PHP Error Message

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1331

Free Web Hosting

PHP Error Message

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1337

Free Web Hosting

PHP Error Message

Notice: Undefined variable: result in /home/a3009661/public_html/v2/convert.php on line 2257

Free Web Hosting

PHP Error Message

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1348

Free Web Hosting

PHP Error Message

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1349

Free Web Hosting

PHP Error Message

Notice: Undefined variable: result in /home/a3009661/public_html/v2/convert.php on line 2257

Free Web Hosting

PHP Error Message

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1357

Free Web Hosting

PHP Error Message

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1359

Free Web Hosting

PHP Error Message

Notice: Undefined variable: result in /home/a3009661/public_html/v2/convert.php on line 2257

Free Web Hosting

PHP Error Message

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1365

Free Web Hosting

PHP Error Message

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1366

Free Web Hosting

PHP Error Message

Notice: Undefined variable: result in /home/a3009661/public_html/v2/convert.php on line 2257

Free Web Hosting

PHP Error Message

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1372

Free Web Hosting

PHP Error Message

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1373

Free Web Hosting

PHP Error Message

Notice: Undefined variable: result in /home/a3009661/public_html/v2/convert.php on line 2257

Free Web Hosting

PHP Error Message

Notice: Undefined variable: result in /home/a3009661/public_html/v2/convert.php on line 2257

Free Web Hosting

PHP Error Message

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1397

Free Web Hosting

PHP Error Message

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1399

Free Web Hosting

PHP Error Message

Notice: Undefined variable: result in /home/a3009661/public_html/v2/convert.php on line 2257

Free Web Hosting

PHP Error Message

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1405

Free Web Hosting

PHP Error Message

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1417

Free Web Hosting

PHP Error Message

Notice: Undefined variable: result in /home/a3009661/public_html/v2/convert.php on line 2257

Free Web Hosting

PHP Error Message

Notice: Undefined variable: result in /home/a3009661/public_html/v2/convert.php on line 2257

Free Web Hosting

PHP Error Message

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1442

Free Web Hosting

PHP Error Message

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1444

Free Web Hosting

PHP Error Message

Notice: Undefined variable: result in /home/a3009661/public_html/v2/convert.php on line 2257

Free Web Hosting

PHP Error Message

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1488

Free Web Hosting

PHP Error Message

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1503

Free Web Hosting

PHP Error Message

Notice: Undefined variable: result in /home/a3009661/public_html/v2/convert.php on line 2257

Free Web Hosting

PHP Error Message

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1532

Free Web Hosting

PHP Error Message

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1534

Free Web Hosting

PHP Error Message

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1547

Free Web Hosting

PHP Error Message

Notice: Undefined variable: result in /home/a3009661/public_html/v2/convert.php on line 2257

Free Web Hosting

PHP Error Message

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1569

Free Web Hosting

PHP Error Message

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1574

Free Web Hosting

PHP Error Message

Notice: Undefined variable: result in /home/a3009661/public_html/v2/convert.php on line 2257

Free Web Hosting

PHP Error Message

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1635

Free Web Hosting

PHP Error Message

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1637

Free Web Hosting

PHP Error Message

Notice: Undefined variable: result in /home/a3009661/public_html/v2/convert.php on line 2257

Free Web Hosting

PHP Error Message

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1673

Free Web Hosting

PHP Error Message

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1692

Free Web Hosting

PHP Error Message

Notice: Undefined variable: result in /home/a3009661/public_html/v2/convert.php on line 2257

Free Web Hosting

PHP Error Message

Notice: Undefined variable: result in /home/a3009661/public_html/v2/convert.php on line 2257

Free Web Hosting

PHP Error Message

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1715

Free Web Hosting

PHP Error Message

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 1716

Free Web Hosting

PHP Error Message

Notice: Undefined variable: result in /home/a3009661/public_html/v2/convert.php on line 2257

Free Web Hosting

PHP Error Message

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 2429

Free Web Hosting

PHP Error Message

Notice: Undefined variable: result in /home/a3009661/public_html/v2/convert.php on line 2257

Free Web Hosting

PHP Error Message

Notice: Undefined variable: result in /home/a3009661/public_html/v2/convert.php on line 2257

Free Web Hosting

PHP Error Message

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/a3009661/public_html/v2/convert.php on line 2429

Free Web Hosting

PHP Error Message

Notice: Undefined variable: result in /home/a3009661/public_html/v2/convert.php on line 2257

Free Web Hosting
Successful.

PHP Error Message

Notice: Undefined variable: to_prefix in /home/a3009661/public_html/v2/convert.php on line 1821

Free Web Hosting

PHP Error Message

Notice: Undefined index: convert_script in /home/a3009661/public_html/v2/convert.php on line 1823

Free Web Hosting

PHP Error Message

Notice: Undefined variable: result in /home/a3009661/public_html/v2/convert.php on line 2257

Free Web Hosting
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.
Now that everything is converted over, your SMF installation should have all the posts, boards, and members from the installation.

We hope you had a smooth transition!
Title: Re: [SMF Converter] MyBB 1.4
Post by: glas on July 30, 2009, 11:24:32 AM
NO NO NO everythign is ok
exept this

This query:

    REPLACE INTO settings (variable, value)
    VALUES ('conversion_time', 1248967328),
    ('conversion_from', 'mybb14x_to_smf.sql');
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on July 30, 2009, 02:59:47 PM
Don't care about, everything is fine (this is a minor bug in convert.php, we add a note to the database after the conversion has finished and this is buggy)
Title: Re: [SMF Converter] MyBB 1.4
Post by: Franky77 on August 01, 2009, 07:57:32 AM
Hello,

This came out:

Code: [Select]
Converting members... Unsuccessful!
This query:
ALTER TABLE `7board_net`.smf_members
CHANGE COLUMN passwordSalt passwordSalt varchar(8) NOT NULL default '';
Caused the error:

Unknown column 'passwordSalt' in 'smf_members'

What can I do?
I need some help please  :'(

Regards
Franky
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on August 01, 2009, 08:26:21 AM
I belive you used the wrong converter version (SMF 1.1.x instead of SMF 2.0 RC) .. please check our downloads page for the right version:
http://www.simplemachines.org/download/?converters
Title: Re: [SMF Converter] MyBB 1.4
Post by: Franky77 on August 01, 2009, 09:21:12 AM
   
Hello TE,

Thank you for your quick reply!

My forum is a MyBB 1.4 and I downloaded this converter: http://download.simplemachines.org/index.php?thanks;filename=smf_2-0-rc1-2_mybb14x_converter.zip

I think this is the right one

or not?

My MyBB is installed in: " / "
And SMF is installed in: " /smf/ "

I hope this is correct.

In the converter form I selct: "UTF8" because my Database ist a: utf8_general_ci

what am I doing wrong?

I am in despair  :'(

Regards
Franky
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on August 02, 2009, 05:23:34 AM
the linked file is for SMF 2.0 RC1, the converter is the right one if your destination Forum is SMF 2.0.
Do you still get errors with that file?
Title: Re: [SMF Converter] MyBB 1.4
Post by: Franky77 on August 02, 2009, 07:46:10 AM
I use this version: SMF 2.0 RC1.2

And I get this error, with the version above:


Code: [Select]
Converting members... Unsuccessful!
This query:
ALTER TABLE `7board_net`.smf_members
CHANGE COLUMN passwordSalt passwordSalt varchar(8) NOT NULL default '';
Caused the error:

Unknown column 'passwordSalt' in 'smf_members'


I tried a few versions but with ervery version it's the same error.

Can I convert the tabels in the DataServer by hand? Copy & Past ..... ?

Or is there everything spezial?

I only need the Members an the Topics of my Forum,  the Settings  and so on ..... are not so important.




Sorry my english is not verry good ;-) I came from Germany.  ;D

Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on August 02, 2009, 07:59:51 AM
uuups, seems to be a bug on our downloads page.. please try the attached version from mybb14x_to_smf.sql
Title: Re: [SMF Converter] MyBB 1.4
Post by: Franky77 on August 02, 2009, 08:15:00 AM
now this error code appears:

Code: [Select]
Converting members...Wrong value type sent to the database. Date expected. (birthdate)
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on August 02, 2009, 08:40:58 AM
mhh, another bug.. sorry, but our 2.0 RC converters are still beta.

Can you live without converting the old birthdates from MyBB?
you could replace (in mybb14x_to_smf.sql):
Code: [Select]
timeonline AS total_time_logged_in,
CASE
WHEN birthday = '' THEN '0001-01-01'
ELSE CONCAT_WS('-', RIGHT(birthday, 4), SUBSTRING(birthday, LOCATE('-', birthday) + 1, LOCATE('-', birthday, LOCATE('-', birthday) + 1) - LOCATE('-', birthday) - 1), LEFT(birthday, LOCATE('-', birthday) - 1))
END AS birthdate

with this
Code: [Select]
timeonline AS total_time_logged_in
another possible solution: install SMF 1.1.10,use the 1.1.10 converters, then upgrade your SMF version to 2.0 RC.
Title: Re: [SMF Converter] MyBB 1.4
Post by: Franky77 on August 02, 2009, 10:28:35 AM
another possible solution: install SMF 1.1.10,use the 1.1.10 converters, then upgrade your SMF version to 2.0 RC.

Thanks! This works for me! But now I have another problem the converted and imported Treads are not complete.

Look here:

(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fimg5.imagebanana.com%2Fimg%2Fmdnj4jz5%2FUnbenannt.PNG&hash=0a6c0f7cf62c86888555463f1aa1b15b)

after every: " Ü Ä Ö ü ä ö .. " the post is not complete. In the Picture above, the letter "ü" would be the next one. But no "ü" is there. On the SQL Server the tabels are written in: latin1_swedish_ci but I need it in utf8_general_ci i think this is also the problem for the "ä ö ü". Why did the converter don't convert the orginal tabels?

I need some help please?!
I am verry glad that the Converter works, but in this way, the converter don't work for me :-(

sincerely,
Franky
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on August 02, 2009, 01:00:12 PM
install SMF without the UTF-8 support (checkbox install.php). you can switch over to UTF-8 later:
UTF-8 Readme (http://docs.simplemachines.org/index.php?topic=865)
Title: Re: [SMF Converter] MyBB 1.4
Post by: BMercer on August 04, 2009, 07:15:26 AM
I'm sorry to have opened a topic for the following problem, but i really havent seen this topic.
My problem is:

Hi, i'm quitely upset and i really need of an help.
I just followed an italian tutorial to convert my board (mybb 1.4) to SMF, and i downloaded SMF, installet it in the root and than downloaded the convert.php and the mybb14_to_smf.sql files, and i uploaded them into the SMF folder.
Then (as the tutorial explain) i runned covert.php, i set the path and the password and i runned it.
All goes right, but at the end something goes wrong and an error occurred:
Quote
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...
Warning: copy(/home/shadowsc/public_html/forum/uploads/post_3_1209123253.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_3_1209132089.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_3_1209132600.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_3_1209248780.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_12_1209482287.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_12_1209482366.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_3_1209767975.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_12_1210244413.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_12_1210260798.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_12_1210260813.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_12_1210437380.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_4_1210503861.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_3_1211401985.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_3_1211402003.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_3_1212227942.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_3_1212847683.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_3_1213278279.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_7_1213367157.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_11_1214549006.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_11_1214549045.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_11_1214855643.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_11_1214933282.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_11_1214954069.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_30_1216879074.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_3_1216069151.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_3_1216315844.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_7_1215806927.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_42_1216402953.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_11_1216486422.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_11_1216639388.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_11_1217015297.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_11_1217015345.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_11_1217093399.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_11_1217093444.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_11_1217093483.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_11_1217093560.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_11_1217096822.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_7_1217161983.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_11_1217164679.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_7_1217235416.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_7_1217235703.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_11_1217413326.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_11_1217414553.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_7_1217460993.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_7_1217507767.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_11_1217618294.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_11_1217619085.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_11_1217619094.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_11_1217619107.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_11_1217619119.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_11_1217619131.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_11_1217619179.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_7_1217623709.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_7_1217623756.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_7_1217782361.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_11_1217786382.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_11_1217786395.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_11_1217786410.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_11_1217786544.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_11_1217786551.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_11_1217786603.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_11_1217848127.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_11_1217848561.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_7_1217871634.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20

Warning: copy(/home/shadowsc/public_html/forum/uploads/post_11_1217932505.attach) [function.copy]: failed to open stream: No such file or directory in /home/shadowsc/public_html/convert.php(1109) : eval()'d code on line 20
Successful.
Recalculating forum statistics... Successful.

Notice: Undefined variable: to_prefix in /home/shadowsc/public_html/convert.php on line 1821
Unsuccessful!
This query:
REPLACE INTO settings (variable, value)
VALUES ('conversion_time', 1249382428),
('conversion_from', 'mybb14x_to_smf.sql');
Caused the error:
No database selected

What do i have to do right now?
Title: Re: [SMF Converter] MyBB 1.4
Post by: shaythong8 on August 06, 2009, 06:07:54 PM
It doesn't work when converting members using MyBB 1.4 to SMF 2.0 RC1.2.

Code: [Select]
Converting members... Unsuccessful!
This query:

    ALTER TABLE `mainuser_smf`.smf_members
    CHANGE COLUMN _ _ varchar(8) NOT NULL default '';

Caused the error:

    Unknown column '_' in 'smf_members'
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on August 07, 2009, 01:51:16 AM
http://www.simplemachines.org/community/index.php?topic=256073.msg2189855#msg2189855
Title: Re: [SMF Converter] MyBB 1.4
Post by: shaythong8 on August 07, 2009, 02:21:42 PM
I have gotten it to work already by installing SMF 1.1.10, convert the info over, and then install SMF 2.0 RC1.2. It was a success. Passwords work normally too. The thing is I discovered that pm_email_notify column for members were set to 0 and not 1 by default when converted. If so run for users who don't know the option can be set under private messaging settings:

Code: [Select]
UPDATE smf_members SET pm_email_notify =1 WHERE pm_email_notify =0
Also forums don't seem to have "count posts" enabled by default. Make sure you disable count posts for admin only forums if you want.

Code: [Select]
UPDATE smf_boards SET count_posts =0 WHERE count_posts =1
Post counts will be wrong. The 'Recount Posts Maintenance' mod doesn't work right (even installed manually, it sets the wrong count). I've fixed the counts manually since I don't have a lot of members. I wish a working recount posts maintenance gets into SMF 2.0 and that it checks if the forum has count posts enabled or not.
Title: Re: [SMF Converter] MyBB 1.4
Post by: Ross Burke on August 10, 2009, 07:03:13 PM
When converting MyBB 1.4 to SMF 1.1.10

I get this error? 
Code: [Select]

Fatal error: Call to undefined function loaddatabase() in /home/theaviat/public_html/smf/convert.php on line 410
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on August 11, 2009, 03:38:17 AM
Ross Burke,
please try the attached files..
Title: Re: [SMF Converter] MyBB 1.4
Post by: gaora on August 25, 2009, 05:56:35 AM
i'm sorry but can someone help me...

i'm upgrading mybb 1.4 to smf 1.1.10 and i got this error :

INSERT INTO `fiona`.fiona_topics
(ID_TOPIC, ID_BOARD, isSticky, ID_POLL, numViews, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, numReplies, locked, ID_FIRST_MSG, ID_LAST_MSG)
VALUES ('2058', '31', '0', '0', '14', '55', '55', '0', '', '4425', '4425'),
('2059', '31', '0', '0', '12', '52', '52', '0', '', '4429', '4429'),
('2060', '43', '0', '0', '11', '56', '56', '0', '', '4430', '4430'),
('2061', '37', '0', '0', '3', '75', '75', '0', '', '4431', '4431'),

after a long query i got this error

Duplicate entry '2058' for key 1

thx
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on August 25, 2009, 06:08:08 AM
gaora,
in mybb14x_to_smf.sql find
Code: [Select]
---* {$to_prefix}topicsadd after
Code: [Select]
---{
$ignore = true;
---}
then restart the conversion.
Title: Re: [SMF Converter] MyBB 1.4
Post by: gaora on August 25, 2009, 06:53:37 AM
sorry i dont use your previous script, i'm using [Beta] Correct high ID_CAT values tools and it worked but i got this error now :

Recalculating forum statistics... Successful.
Unsuccessful!
This query:
REPLACE INTO {$to_prefix}settings (variable, value)
VALUES ("conversion_time", 1251197525),
("conversion_from", "mybb14x_to_smf.sql");
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 '{$to_prefix}settings (variable, value)
VALUES ("conversion_time", 1251197525)' at line 1
Title: Re: [SMF Converter] MyBB 1.4
Post by: gaora on August 25, 2009, 07:16:54 AM
ask mr. google and it's a bug hehehe...

thx m8
Title: Re: [SMF Converter] MyBB 1.4
Post by: auto:blank on September 24, 2009, 09:51:12 PM
i am having some problem while converting mybb to smf plz help , > http://www.simplemachines.org/community/index.php?topic=338339.0
Title: Re: [SMF Converter] MyBB 1.4
Post by: phatuis on November 01, 2009, 01:38:57 AM
Hey, I get the following error:
Code: [Select]
Notice: Undefined variable: to_prefix in /home/phatuis/public_html/smf/convert.php on line 1821
Unsuccessful!
This query:
REPLACE INTO settings (variable, value)
VALUES ('conversion_time', 1257057388),
('conversion_from', 'mybb14x_to_smf.sql');
Caused the error:
No database selected

SMF: 1.1.10
MyBB: 1.4.9
Title: Re: [SMF Converter] MyBB 1.4
Post by: Norv on November 01, 2009, 04:02:43 PM
Please don't worry about that particular error, it's actually a little bug in the converter to SMF 1.1.x.

All the important steps of the conversion must have completed at this point, so if there were no problems before this, then your conversion succeeded.
Title: Re: [SMF Converter] MyBB 1.4
Post by: keldek on November 08, 2009, 06:32:05 AM
Quote
Converting...
Successful.
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.
Now that everything is converted over, your SMF installation should have all the posts, boards, and members from the installation.

We hope you had a smooth transition!
MyBB v 1.4.9

Yet, none of my actual child boards or posts were converted.

Seems only the members were converted successfully. Any ideas?

Additionally.. when using the 'find and repair any errors' under 'forum maintenance' I get the following type errors (too long to post them all, so posting similar ones):

Code: [Select]
Topic #2 contains no (actual) messages.  (Have this one for ALL posts)
Code: [Select]
Topic #1 has the first message ID 39014, which is incorrect.
Topic #1 has the last message ID 39015, which is incorrect.
Topic #2 has the first message ID 39009, which is incorrect.
Topic #2 has the last message ID 39009, which is incorrect.
Topic #2 has the wrong number of replies, 1.
Topic #3 has the first message ID 39008, which is incorrect.
Topic #3 has the last message ID 39065, which is incorrect.
Topic #3 has the wrong number of replies, 3.

Code: [Select]
Topic #91 is in board #0, which is missing.
Topic #104 is in board #0, which is missing.
Board #9 is in category #0, which is missing.
Board #10 is in category #0, which is missing.
SAME ERROR FOR ALL BOARDS
 

Also, I tried both converters (the one on the downloads page as well as the one in this forum, both with the same result - in case they're different)
Title: Re: [SMF Converter] MyBB 1.4
Post by: Norv on November 08, 2009, 10:32:14 PM
You were converting to SMF 1.1.10 then?
Please eventually, try using these files, just in case, and run the convert.php file as your_smf_address/convert.php?debug=1
A file convert_debug_log should be created in your SMF directory during the conversion, please attach it here if that is the case. Also, if any errors were displayed on the page during conversion please copy paste them here.
Title: Re: [SMF Converter] MyBB 1.4
Post by: keldek on November 09, 2009, 10:26:35 PM
Seems the conversion went through on the 3rd attempt...

I guess the "3rd time's a charm" line really is true.

Just as an aside though, there were no error messages at all during the install, aside from the one marked as a bug to be ignored (only got this error on the successful conversion). The only errors I had were those posted above.

The first conversion attempt took roughly 5 minutes, which seemed kind of fast considering the size of our board. I used 2 separate dbs for this attempt and nothing was actually imported at all. Files used were the ones from the download page.

Second attempt was with a separate db, files used were the ones in the start of this thread. Conversion took significantly longer. Members were imported fine, but no boards or posts were imported properly.

Third attempt I installed smf on the same db as mybb. Used the convert scripts from this thread. Took about 30 minutes all in all. Conversion went through properly this time so far as I can tell at the moment.

As a conclusion, I can only assume there's maybe an issue when using separate dbs. I'll look into this more over the weekend and post back with my findings.

Have a good day :)
Title: Re: [SMF Converter] MyBB 1.4
Post by: Norv on November 10, 2009, 01:21:27 AM
Thank you for letting us know! I will make sure to test using 2 databases, perhaps there's some bug there we weren't aware of.
Title: Re: [SMF Converter] MyBB 1.4
Post by: sigtau on November 19, 2009, 07:08:30 PM
Unsuccessful!
This query:

    REPLACE INTO {$to_prefix}settings (variable, value)
    VALUES ("conversion_time", 1258675558),
    ("conversion_from", "mybb14x_to_smf.sql");

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 '{$to_prefix}settings (variable, value)
    VALUES ("conversion_time", 1258675558)' at line 1

-----------

I'm doing this for a friend, so I'd really like a speedy response.
Title: Re: [SMF Converter] MyBB 1.4
Post by: Norv on November 20, 2009, 04:38:44 PM
Please ignore that error, it's not relevant to the conversion, rather a bug in the converter itself, which should be updated as soon as possible. Your conversion has actually succeeded.
Title: Re: [SMF Converter] MyBB 1.4
Post by: .Vapor on December 17, 2009, 12:52:33 AM
Converting from mybb 1.4 to SMF 2.0 RC2 and i receive this error :
Code: [Select]
Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics...Wrong value type sent to the database. Integer expected. (id_member_updated)
Title: Re: [SMF Converter] MyBB 1.4
Post by: Norv on December 17, 2009, 02:05:09 AM
Please try using the attached file instead.
Title: Re: [SMF Converter] MyBB 1.4
Post by: .Vapor on December 17, 2009, 12:37:43 PM
This was my final sql file that i got it to work. All i did was add TE's suggestion for the birthdate and used your sql file norv......voila. Thank you all for the fix's !

This worked for mybb 1.4.10 ---> smf2 rc2
Title: Re: [SMF Converter] MyBB 1.4
Post by: Norv on December 17, 2009, 12:50:04 PM
Good to hear, and thanks for sharing! :)
Title: Re: [SMF Converter] MyBB 1.4
Post by: Boricua012 on December 25, 2009, 11:56:19 PM
Hi,

I'm trying convert 1.4.10 to SMF RC2.

When i go to converter.php i fill in my info and then the first step it does is Coverting Members. I get a message saying:

Converting members...Wrong value type sent to the database. Date expected. (birthdate)

Then nothing happens.  :'(
Title: Re: [SMF Converter] MyBB 1.4
Post by: Norv on December 26, 2009, 01:43:23 AM
Please check out:
http://www.simplemachines.org/community/index.php?topic=256073.msg2189889#msg2189889
Title: Re: [SMF Converter] MyBB 1.4
Post by: Boricua012 on December 26, 2009, 05:31:43 PM
Please check out:
http://www.simplemachines.org/community/index.php?topic=256073.msg2189889#msg2189889

Thank you :). Now my website is running on SMF 1.0x how do i upgrade to RC2? I read the manual and was sort of confused by it...
Title: Re: [SMF Converter] MyBB 1.4
Post by: Norv on December 26, 2009, 06:42:42 PM
I suppose you mean 1.1.11 ?

To upgrade to SMF 2.0 RC2, the manual instructions are here: Upgrading SMF (http://docs.simplemachines.org/index.php?board=3.0;sort=subject) (not sure what you found).
Mainly, please take first a backup of the database.
Then, grab the large upgrade package from this site's Downloads, and unzip it. Then upload all files to your SMF directory. (like you uploaded the previous installation files, too, I suppose?). Overwriting almost all your previous files.
Then, point your browser to http://your_address/upgrade.php, to run the upgrade itself. It's a little wizard that will guide you through the rest of the process.
Title: Re: [SMF Converter] MyBB 1.4
Post by: Boricua012 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 :).
Title: Re: [SMF Converter] MyBB 1.4
Post by: edjca 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?
Title: Re: [SMF Converter] MyBB 1.4
Post by: edjca on January 02, 2010, 02:44:29 AM
Anyone, please?
Title: Re: [SMF Converter] MyBB 1.4
Post by: alexmaster on January 02, 2010, 07:19:44 AM
Try to make another type to this column in phpMyAdmin.
Title: Re: [SMF Converter] MyBB 1.4
Post by: edjca on January 02, 2010, 04:27:38 PM
I'm sorry, not quite sure what that means.
Title: Re: [SMF Converter] MyBB 1.4
Post by: jetli68 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
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on January 05, 2010, 09:36:39 AM
jetli68, please check out our docs: Converting to SMF (http://docs.simplemachines.org/index.php?board=4.0;sort=subject)
Title: Re: [SMF Converter] MyBB 1.4
Post by: Tiscan 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?
Title: Re: [SMF Converter] MyBB 1.4
Post by: weeman007 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
Title: Re: [SMF Converter] MyBB 1.4
Post by: Seventy_Six 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 www.moviemania-pt.com/convert.php but i am so noob with this, so how can i create a database with my backup? in cpanel?
Title: Re: [SMF Converter] MyBB 1.4
Post by: Norv 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?).
Title: Re: [SMF Converter] MyBB 1.4
Post by: Seventy_Six 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?
Title: Re: [SMF Converter] MyBB 1.4
Post by: Norv 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. :)
Title: Re: [SMF Converter] MyBB 1.4
Post by: EnjatsRed 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 ...
Title: Re: [SMF Converter] MyBB 1.4
Post by: Norv 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.
Title: Re: [SMF Converter] MyBB 1.4
Post by: Pellets 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'
Title: Re: [SMF Converter] MyBB 1.4
Post by: Pellets on June 20, 2010, 11:06:45 AM
Ahhhh ******... I've tried a lot of .sql files in this thread, not one works.  >:(
Title: Re: [SMF Converter] MyBB 1.4
Post by: slavko17 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
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE 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.
Title: Re: [SMF Converter] MyBB 1.4
Post by: slavko17 on June 29, 2010, 02:52:33 PM
Woooow! It works now! :D Thanks alot :D
Title: Re: [SMF Converter] MyBB 1.4
Post by: .Vapor on July 19, 2010, 11:50:55 PM
Now i am trying to go from mybb 1.4 to smf 1.1 and get this :

Code: [Select]
MyBulletinBoard 1.4 to SMF Converter
Converting...
Converting poll votes... Unsuccessful!
This query:

    INSERT INTO `dgaming3_2255`.smf_log_polls
    (ID_POLL, ID_MEMBER, ID_CHOICE)
    VALUES ('0', '101', '1'),
    ('0', '192', '1'),
    ('0', '4', '1'),
    ('0', '148', '1'),
    ('0', '189', '1'),
    ('0', '153', '1'),
    ('0', '14', '1'),
    ('0', '9', '3'),
    ('0', '241', '2'),
    ('0', '192', '1'),
    ('0', '101', '2'),
    ('0', '192', '1'),
    ('0', '242', '1'),
    ('0', '101', '3'),
    ('0', '242', '2'),
    ('0', '192', '3'),
    ('0', '79', '1'),
    ('0', '23', '1'),
    ('0', '241', '1'),
    ('0', '189', '3'),
    ('0', '9', '3'),
    ('0', '14', '1'),
    ('0', '141', '3'),
    ('0', '148', '3'),
    ('0', '45', '1'),
    ('0', '113', '3'),
    ('0', '153', '2'),
    ('0', '91', '2'),
    ('0', '91', '3'),
    ('0', '113', '1'),
    ('0', '192', '1'),
    ('0', '101', '3'),
    ('0', '79', '3'),
    ('0', '242', '3'),
    ('0', '99', '1'),
    ('0', '99', '1'),
    ('0', '248', '1'),
    ('0', '79', '1'),
    ('0', '189', '3'),
    ('0', '189', '1'),
    ('0', '113', '1'),
    ('0', '13', '1'),
    ('0', '91', '2'),
    ('0', '192', '1'),
    ('0', '99', '3'),
    ('0', '99', '2'),
    ('0', '14', '1'),
    ('0', '24', '1'),
    ('0', '241', '2'),
    ('0', '141', '1'),
    ('0', '13', '1'),
    ('0', '9', '1'),
    ('0', '251', '1'),
    ('0', '7', '1'),
    ('0', '79', '2'),
    ('0', '192', '1'),
    ('0', '4', '1'),
    ('0', '148', '1'),
    ('0', '14', '1'),
    ('0', '79', '1'),
    ('0', '189', '1'),
    ('0', '24', '1'),
    ('0', '99', '1'),
    ('0', '79', '2'),
    ('0', '99', '1'),
    ('0', '101', '1'),
    ('0', '192', '1'),
    ('0', '79', '1'),
    ('0', '159', '1'),
    ('0', '101', '2'),
    ('0', '153', '2'),
    ('0', '241', '2'),
    ('0', '148', '1'),
    ('0', '251', '1'),
    ('0', '99', '1'),
    ('0', '13', '2'),
    ('0', '23', '2'),
    ('0', '24', '2'),
    ('0', '14', '1'),
    ('0', '242', '1'),
    ('0', '4', '2'),
    ('0', '98', '2'),
    ('0', '112', '1'),
    ('0', '41', '1'),
    ('0', '29', '1'),
    ('0', '142', '1'),
    ('0', '47', '2'),
    ('0', '23', '4'),
    ('0', '148', '1'),
    ('0', '242', '3'),
    ('0', '41', '6'),
    ('0', '251', '3'),
    ('0', '29', '6'),
    ('0', '101', '6'),
    ('0', '192', '6'),
    ('0', '79', '6'),
    ('0', '241', '1'),
    ('0', '14', '6'),
    ('0', '142', '6'),
    ('0', '159', '6'),
    ('0', '192', '4'),
    ('0', '99', '1'),
    ('0', '241', '3'),
    ('0', '251', '3'),
    ('0', '79', '5'),
    ('0', '242', '4'),
    ('0', '148', '4'),
    ('0', '241', '2'),
    ('0', '99', '2'),
    ('0', '79', '2'),
    ('0', '159', '2'),
    ('0', '192', '2'),
    ('0', '14', '2'),
    ('0', '4', '2'),
    ('0', '101', '4'),
    ('0', '251', '1'),
    ('0', '98', '4'),
    ('0', '47', '2'),
    ('0', '79', '1'),
    ('0', '241', '1'),
    ('0', '159', '1'),
    ('0', '14', '1'),
    ('0', '4', '2'),
    ('0', '192', '1'),
    ('0', '101', '1'),
    ('0', '99', '1'),
    ('0', '24', '1'),
    ('0', '263', '1'),
    ('0', '13', '1'),
    ('0', '79', '2'),
    ('0', '14', '3'),
    ('0', '99', '3'),
    ('0', '242', '1'),
    ('0', '241', '3'),
    ('0', '3', '3'),
    ('0', '153', '1'),
    ('0', '148', '1'),
    ('0', '9', '1'),
    ('0', '159', '3'),
    ('0', '141', '2'),
    ('0', '47', '3'),
    ('0', '99', '1'),
    ('0', '159', '4'),
    ('0', '189', '2'),
    ('0', '192', '2'),
    ('0', '47', '1'),
    ('0', '113', '1'),
    ('0', '79', '2'),
    ('0', '91', '2'),
    ('0', '192', '1'),
    ('0', '148', '1'),
    ('0', '159', '1'),
    ('0', '9', '1'),
    ('0', '47', '1'),
    ('0', '99', '1'),
    ('0', '101', '2'),
    ('0', '99', '1'),
    ('0', '14', '3'),
    ('0', '242', '1'),
    ('0', '141', '2'),
    ('0', '189', '2'),
    ('0', '192', '1'),
    ('0', '9', '1'),
    ('0', '45', '2'),
    ('0', '99', '1'),
    ('0', '24', '1'),
    ('0', '113', '2'),
    ('0', '101', '1'),
    ('0', '192', '128'),
    ('0', '22', '128'),
    ('0', '26', '128'),
    ('0', '14', '2'),
    ('0', '9', '128'),
    ('0', '9', '1'),
    ('0', '11', '128'),
    ('0', '13', '128'),
    ('0', '3', '128'),
    ('0', '11', '128'),
    ('0', '26', '128'),
    ('0', '192', '128'),
    ('0', '3', '128'),
    ('0', '22', '128'),
    ('0', '4', '128'),
    ('0', '192', '128'),
    ('0', '16', '128'),
    ('0', '24', '128'),
    ('0', '281', '128'),
    ('0', '6', '128'),
    ('0', '192', '128'),
    ('0', '27', '128'),
    ('0', '281', '128'),
    ('0', '16', '128'),
    ('0', '14', '128'),
    ('0', '9', '128'),
    ('0', '38', '128'),
    ('0', '6', '128'),
    ('0', '13', '128'),
    ('0', '5', '128'),
    ('0', '192', '128'),
    ('0', '3', '128'),
    ('0', '14', '128'),
    ('0', '282', '128'),
    ('0', '4', '128'),
    ('0', '20', '128'),
    ('0', '7', '128'),
    ('0', '23', '128'),
    ('0', '16', '128'),
    ('0', '47', '128'),
    ('0', '192', '128'),
    ('0', '3', '128'),
    ('0', '13', '128'),
    ('0', '281', '128'),
    ('0', '6', '128'),
    ('0', '5', '128'),
    ('0', '13', '128'),
    ('0', '16', '128'),
    ('0', '46', '128'),
    ('0', '22', '128'),
    ('0', '192', '128'),
    ('0', '47', '128'),
    ('0', '14', '128'),
    ('0', '24', '128'),
    ('0', '9', '128'),
    ('0', '6', '128'),
    ('0', '5', '128'),
    ('0', '4', '128'),
    ('0', '13', '128'),
    ('0', '20', '128'),
    ('0', '24', '2'),
    ('0', '24', '1'),
    ('0', '4', '1'),
    ('0', '192', '2'),
    ('0', '47', '2'),
    ('0', '4', '2'),
    ('0', '87', '2'),
    ('0', '6', '1'),
    ('0', '27', '1'),
    ('0', '192', '1'),
    ('0', '47', '1'),
    ('0', '24', '1'),
    ('0', '45', '1'),
    ('0', '9', '1'),
    ('0', '4', '1'),
    ('0', '23', '1'),
    ('0', '11', '1'),
    ('0', '192', '1'),
    ('0', '4', '1'),
    ('0', '5', '1'),
    ('0', '45', '2'),
    ('0', '14', '1'),
    ('0', '292', '1'),
    ('0', '79', '2'),
    ('0', '9', '1'),
    ('0', '29', '2'),
    ('0', '13', '1'),
    ('0', '49', '1'),
    ('0', '101', '2'),
    ('0', '11', '1'),
    ('0', '45', '1'),
    ('0', '13', '2'),
    ('0', '192', '1'),
    ('0', '14', '1'),
    ('0', '27', '1'),
    ('0', '98', '1'),
    ('0', '34', '1'),
    ('0', '4', '1'),
    ('0', '97', '1'),
    ('1', '192', '1'),
    ('1', '27', '1'),
    ('1', '99', '1'),
    ('1', '306', '1'),
    ('1', '79', '2'),
    ('1', '241', '2'),
    ('1', '101', '1'),
    ('1', '310', '3'),
    ('1', '148', '3'),
    ('1', '244', '1'),
    ('1', '14', '2'),
    ('1', '189', '1'),
    ('1', '275', '3');

Caused the error:

    Duplicate entry '0-101-1' for key 'PRIMARY'
Title: Re: [SMF Converter] MyBB 1.4
Post by: .Vapor on July 20, 2010, 01:10:34 PM
Nm....this edit worked :
Code: [Select]
---* {$to_prefix}log_polls
---{
$ignore = true;
---}
Title: Re: [SMF Converter] MyBB 1.4
Post by: BlueAce3 on July 23, 2010, 07:03:02 PM
Sorry if I'm dense...still trying to learn databases and such...is this convertor for SMF 2 or 1?

Thanks!
Title: Re: [SMF Converter] MyBB 1.4
Post by: indytycoon on October 01, 2010, 02:55:59 PM
in this page no is the answer...
the problem is...
The error MySQL gave was: SELECT command denied to user 'alvaroro_smf'@'localhost' for table 'mybb_users'

:/

I am getting this error and I've been over this thread but, I have one question.  Where do I tell it the prefix?

Got it  never mind
Title: Re: [SMF Converter] MyBB 1.4
Post by: AndrewS on November 07, 2010, 04:54:47 PM
in this page no is the answer...
the problem is...
The error MySQL gave was: SELECT command denied to user 'alvaroro_smf'@'localhost' for table 'mybb_users'

:/

I am getting this error and I've been over this thread but, I have one question.  Where do I tell it the prefix?

Got it  never mind


Could you please tell me how you got past this error, I've just got the same error and not sure how to fix it. ?

I'm trying to convert a MyBB 1.6 database to SMF 2.0 RC4.
Title: Re: [SMF Converter] MyBB 1.4
Post by: ThorstenE on November 08, 2010, 01:16:49 AM
please check Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)