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.
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!
Try the attached file.
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
Quote from: 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!
I have the same issue when trying to convert from MyBB 1.4 to SMF
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.
Do they both work or just the second one?
the mybb14_to_smf.sql from the first post of this topic should work fine.
Hi...
Can you please tell me step by step on how to convert it? I'm not used to these stuff...
Looking to convert to SMF? (http://www.simplemachines.org/community/index.php?topic=273509.0)
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?
I personally prefer the SMF folder but they should work from any folder..
if i convert from myBB to SMF the original data on mybb remain the same or deleted?
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 ..
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.
Quote from: 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.
was your forum originally converted from myBB 1.4 ? SMF is able to read the old passwords. Any errors during login?
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.
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 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".
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:
'passwordSalt' => 'passwordSalt password_salt varchar(5) NOT NULL default \'\'',
replace it with:
'passwordSalt' => 'passwordSalt password_salt varchar(8) NOT NULL default \'\'',
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
Quote from: TE 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 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".
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:
'passwordSalt' => 'passwordSalt password_salt varchar(5) NOT NULL default \'\'',
replace it with:
'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.
@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.
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.
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 ;)
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. :)
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.
Quote from: 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
i'm also having this same problem how to solvi it????
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.
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????
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.
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'
Quote from: 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.
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.
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
I tried this but i get;
See Attactched ::(
DJBoddington, this looks like a broken session.. please restart the conversion from the beginning.. are the errors the same?
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?
Quote from: DJBoddington on January 10, 2009, 03:34:54 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
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 :/
Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)
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'
:/
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.
QuoteProblem: 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.]
Mm thanks i understand now ;)
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
Welcome to SMF :)
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).
Will this converter work with 1.1.8?
Or better still 2.0
Quote from: Antechinus on February 05, 2009, 06:18:47 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.
Quote from: IndigoStar on February 05, 2009, 06:45:30 AM
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.
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?
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.
brilliant thank you, worked a treat :)
" Duplicate entry '127' for key 'PRIMARY'
Dosya: C:\wamp\www\smf\recount_categories.php
Satır: 288 "
jazz37, check SleePy's reply at http://www.simplemachines.org/community/index.php?topic=290289.msg1917947#msg1917947
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 ??
januszwaras, this looks like an aborted session. please restart the convert from the beginning.
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
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 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.
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.
Quote from: TE on February 26, 2009, 01:44:45 AM
Have you tried the conversion? maybe you can complete it without problems.
Yes, don't work.
Quote from: TE on February 26, 2009, 01:44:45 AM
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
Quote from: TE 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?
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.
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.
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
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)
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
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?
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
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();
yeh will try
thanks big bro
bah the webserver is great
if you want to send you the link to check you're self i will
Best Regards
a link to phpinfo(); would help a bit.
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
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 ;)
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
look bro
Problem Solved
works great this before converting
anything to say ?
bro are you here ?
i amwaiting you reponse
any news bro?
replied via PM
Quote from: TE on March 16, 2009, 12:36:17 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
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
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
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
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)
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'"
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)
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....
attached to: http://www.simplemachines.org/community/index.php?topic=140741.0 (at the end - scroll down)
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:
(http://wratka.pl/bzdety/screenshot1240911421.jpg)
On web server:
(http://wratka.pl/bzdety/screenshot1240922893.jpg)
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 :/
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.
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
sure, you can use convert.php via command line. parameters on windows:
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
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:
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)
The linux one, your session expired during the conversion. You will need to restart it.
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
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
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 ?
the 1st always working
Quote from: TE on May 03, 2009, 01:32:55 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.
how many i need
i use 8MB
do i Tell Them to make it 16MB Or What ?
http://download.simplemachines.org/requirements.php
I personally prefer at least 32M memory_limit and a max_execution_time set to 30s (30 seconds)
ok thanks
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.
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.
<?php
header("HTTP/1.1 301 Moved Permanently");
header("Location: http://www.yourdomain.com/smf");
header("Connection: close");
exit();
?>
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!
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');
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)
Hello,
This came out:
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
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
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
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?
I use this version: SMF 2.0 RC1.2
And I get this error, with the version above:
Quote from: Franky77 on August 01, 2009, 07:57:32 AM
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
uuups, seems to be a bug on our downloads page.. please try the attached version from mybb14x_to_smf.sql
now this error code appears:
Converting members...Wrong value type sent to the database. Date expected. (birthdate)
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):
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
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.
Quote from: TE on August 02, 2009, 08:40:58 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:
(http://img5.imagebanana.com/img/mdnj4jz5/Unbenannt.PNG)
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
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)
I'm sorry to have opened a topic for the following problem, but i really havent seen this topic.
My problem is:
Quote from: BMercer on August 04, 2009, 06:47:35 AM
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:
QuoteConverting 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?
It doesn't work when converting members using MyBB 1.4 to SMF 2.0 RC1.2.
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'
http://www.simplemachines.org/community/index.php?topic=256073.msg2189855#msg2189855
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:
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.
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.
When converting MyBB 1.4 to SMF 1.1.10
I get this error?
Fatal error: Call to undefined function loaddatabase() in /home/theaviat/public_html/smf/convert.php on line 410
Ross Burke,
please try the attached files..
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
gaora,
in mybb14x_to_smf.sql find
---* {$to_prefix}topics
add after
---{
$ignore = true;
---}
then restart the conversion.
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
ask mr. google and it's a bug hehehe...
thx m8
i am having some problem while converting mybb to smf plz help , > http://www.simplemachines.org/community/index.php?topic=338339.0
Hey, I get the following error:
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
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.
QuoteConverting...
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):
Topic #2 contains no (actual) messages. (Have this one for ALL posts)
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.
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)
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.
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 :)
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.
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.
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.
Converting from mybb 1.4 to SMF 2.0 RC2 and i receive this error :
Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics...Wrong value type sent to the database. Integer expected. (id_member_updated)
Please try using the attached file instead.
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
Good to hear, and thanks for sharing! :)
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. :'(
Please check out:
http://www.simplemachines.org/community/index.php?topic=256073.msg2189889#msg2189889
Quote from: Norv on December 26, 2009, 01:43:23 AM
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...
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.
Thanks Norv. Everything went successful. I decided not to use RC2 because TinyPortal has not released a version that is compatible :).
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?
Anyone, please?
Try to make another type to this column in phpMyAdmin.
I'm sorry, not quite sure what that means.
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
jetli68, please check out our docs: Converting to SMF (http://docs.simplemachines.org/index.php?board=4.0;sort=subject)
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?
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
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?
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?).
Quote from: 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?).
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?
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. :)
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 ...
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.
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 1115And 500 looking similar to this line:('500', 'pa11', 'pa11', '[email protected]', 'ecb7279arf235fg372fd7e40df1f89', 'dVrwOdqTt', '1', '', '116923458128', '0', '116623454956', '', '', '', '', '', '', '', '1', '', '', '', '', '372', '0001-01-01', '', ''),And at the bottom it says:Unknown column 'memberName' in 'field list'
Ahhhh ******... I've tried a lot of .sql files in this thread, not one works. >:(
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
slavko17, edit the mybb14_to_smf.sql and find:
LEFT JOIN {$from_prefix}users AS ul ON (BINARY ul.username = t.lastposter)
replace it with
LEFT JOIN {$from_prefix}users AS ul ON (ul.username = t.lastposter)
then re-start the converion, hopefully it helps.
Woooow! It works now! :D Thanks alot :D
Now i am trying to go from mybb 1.4 to smf 1.1 and get this :
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'
Nm....this edit worked :
---* {$to_prefix}log_polls
---{
$ignore = true;
---}
Sorry if I'm dense...still trying to learn databases and such...is this convertor for SMF 2 or 1?
Thanks!
Quote from: alvarorojas4 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'
:/
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
Quote from: indytycoon on October 01, 2010, 02:55:59 PM
Quote from: alvarorojas4 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'
:/
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.
please check Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)