The attached version can hopefully import a MyBB 1.8 forum to ElkArte 1.0 ..
Importing Members... ✔
Importing Categories... ✔
Importing Boards... ✔
Importing Topics... ✔
Importing Messages... ✔
Importing polls... ✔
Importing poll choices... ✔
Importing poll votes... ✔
Importing personal messages... ✔
Importing pm recipients... ✔
Importing topic notifications... ✔
Importing board notifications... ✔
Importing attachments... ✔
Importing avatars... ✔
It's based on a totally outdated version of Openimporter. the newer ones (especially the ones for MyBB seem to be completely broken). Just upload the three files to your ElkArte directory and call import.php from your favourite web browser..
Have problems in importing poll,
Importing Members... ✔
Importing Categories... ✔
Importing Boards... ✔
Importing Topics... ✔
Importing Messages... ✔
Importing polls... ✔
Importing poll choices... Unsuccessful!
This query:
INSERT IGNORE INTO elk.elkarte_poll_choices
(id_poll, id_choice, label, votes)
VALUES (1, 1, "WordPress", 2),
(1, 2, "Blogspot", 0),
(2, 1, "Free", 1),
(2, 2, "Paid", 6),
('2', 'Free||~|~||Paid', '1||~|~||6'),
(4, 1, "Yes", 4),
(4, 2, "Ok with the current one.", 1),
('4', 'Yes||~|~||Ok with the current one.', '4||~|~||1'),
(5, 1, "Android", 2),
(5, 2, "BB", 0),
(5, 3, "Symbian", 1),
(5, 4, "Windows", 1),
(5, 5, "iOS", 2),
(5, 6, "Java", 0),
(5, 7, "Bada", 0),
(5, 8, "Meego", 0),
(5, 9, "Firefox OS", 0),
(5, 10, "Sailfish OS", 0),
('5', 'Android||~|~||BB||~|~||Symbian||~|~||Windows||~|~||iOS||~|~||Java||~|~||Bada||~|~||Meego||~|~||Firefox OS||~|~||Sailfish OS', '2||~|~||0||~|~||1||~|~||1||~|~||2||~|~||0||~|~||0||~|~||0||~|~||0||~|~||0'),
(6, 1, "5", 0),
(6, 2, "4", 0),
(6, 3, "3", 0),
(6, 4, "2", 2),
(6, 5, "1", 0),
('6', '5||~|~||4||~|~||3||~|~||2||~|~||1', '0||~|~||0||~|~||0||~|~||2||~|~||0'),
(7, 1, "Keep it", 1),
(7, 2, "Rip it", 2),
('7', 'Keep it||~|~||Rip it', '1||~|~||2'),
(8, 1, "Indianstalkzone.com", 0),
(8, 2, "IndianChitChat.com", 3),
(8, 3, "Indiantalkzone.com", 3),
(8, 4, "Indiancc.com", 2),
(8, 5, "ChatZoneIndia.com", 1),
('8', 'Indianstalkzone.com||~|~||IndianChitChat.com||~|~||Indiantalkzone.com||~|~||Indiancc.com||~|~||ChatZoneIndia.com', '0||~|~||3||~|~||3||~|~||2||~|~||1'),
(9, 1, "Coffee!", 0),
(9, 2, "Tea!", 2),
(9, 3, "Both!", 4),
(9, 4, "Neither.", 0),
('9', 'Coffee!||~|~||Tea!||~|~||Both!||~|~||Neither.', '0||~|~||2||~|~||4||~|~||0'),
(10, 1, "Chennai Super Kings", 3),
(10, 2, "Delhi Daredevils", 2),
(10, 3, "Kings XI Punjab", 2),
(10, 4, "Kolkata Knight Riders", 4),
(10, 5, "Mumbai Indians", 2),
(10, 6, "Rajasthan Royals", 1),
(10, 7, "Royal Challengers Bangalore", 3),
(10, 8, "Sunrisers Hyderabad", 1),
('10', 'Chennai Super Kings||~|~||Delhi Daredevils||~|~||Kings XI Punjab||~|~||Kolkata Knight Riders||~|~||Mumbai Indians||~|~||Rajasthan Royals||~|~||Royal Challengers Bangalore||~|~||Sunrisers Hyderabad', '3||~|~||2||~|~||2||~|~||4||~|~||2||~|~||1||~|~||3||~|~||1'),
(11, 1, "yay", 1),
(11, 2, "nay", 1),
(11, 3, "IT DOESNT MATTER WHAT I WANT", 0),
('11', 'yay||~|~||nay||~|~||IT DOESNT MATTER WHAT I WANT', '1||~|~||1||~|~||0'),
(12, 1, "Square", 2),
(12, 2, "Round", 3),
('12', 'Square||~|~||Round', '2||~|~||3'),
(13, 1, "Firefox", 2),
(13, 2, "Chrome", 0),
('13', 'Firefox||~|~||Chrome', '2||~|~||0'),
(14, 1, "Internet Explorer / Edge", 0),
(14, 2, "Google Chrome / Chromium / Iron", 1),
(14, 3, "Firefox", 2),
(14, 4, "Opera", 0),
(14, 5, "Safari", 0),
(14, 6, "Other", 0),
('14', 'Internet Explorer / Edge||~|~||Google Chrome / Chromium / Iron||~|~||Firefox||~|~||Opera||~|~||Safari||~|~||Other', '0||~|~||1||~|~||2||~|~||0||~|~||0||~|~||0'),
(15, 1, "Yes", 1),
(15, 2, "No", 3),
('15', 'Yes||~|~||No', '1||~|~||3'),
(16, 1, "MyBB", 2),
(16, 2, "phpBB", 0),
(16, 3, "SMF", 0),
('16', 'MyBB||~|~||phpBB||~|~||SMF', '2||~|~||0||~|~||0'),
(17, 1, "Yes!", 2),
(17, 2, "No", 0),
('17', 'Yes!||~|~||No', '2||~|~||0');
Caused the error:
Column count doesn't match value count at row 5
And the subcategories in a main category, comes out as new main category.
Ex: Mobiles (cat) > Android (sub cat) (in MyBB)
Mobiles (cat)
Android (cat)
@IndianTalkZone ,thanks for reporting the bugs. I hope
@TE will be able to come up with a fix.
please try again with the attached mybb18_importer.xml, should at leat fix the issues regarding polls..
Thanks TE, the poll issue is fixed. Now the attachment..i don't whether it is a problem with wamp..
Message: getimagesize(G:\wamp\www/attachments/1_7a18519243bbaabb294cce2a2dfe74e8d4cbd794.elk): failed to open stream: No such file or directory
Trace: getimagesize(G:\wamp\www/attachments/1_7a18519243bbaabb294cce2a2dfe74e8d4cbd794.elk): failed to open stream: No such file or directory
Line: 33
File: G:\wamp\www\import\import.php(846) : eval()'d code
Probably missing attachment files? Is it a real MyBB forum or just a database backup you're trying to import? Maybe the attachment files aren't part of your backup?
It is a real MyBB backup database, my current forum DB (www.indiantalkzone.com). Downloaded using phpMyAdmin in the control panel and tried.
Ah, then you only downloaded the
database. The attachments and avatars are not part of the database, they are files under the MyBB folder /uploads and you'd need to copy this folder to localhost in order to import attachments & avatars..
I have uploaded the folder to my localhost from /uploads (live) to /uploads (localhost) still some problem.
Message: filesize(): stat failed for G:\wamp\www/attachments/4_f81a866f99d98822837317eab6b92129cbea37e9.elk
Trace: filesize(): stat failed for G:\wamp\www/attachments/4_f81a866f99d98822837317eab6b92129cbea37e9.elk
Line: 14
File: G:\wamp\www\import\import.php(846) : eval()'d code
I deleted attachments in MyBB db and tried again..but it didn't work. I am doing something wrong?
can you check the path G:\wamp\www/attachments/4_f81a866f99d98822837317eab6b92129cbea37e9.elk with windows explorer?
Does this folder folder G:\wamp\www/attachments/ exist?
Here you go
Importing...
Importing Members... ✔
Importing Categories... ✔
Importing Boards... ✔
Importing Topics... ✔
Importing Messages... ✔
Importing polls... ✔
Importing poll choices... ✔
Importing poll votes... ✔
Importing personal messages... ✔
Importing pm recipients... ✔
Importing topic notifications... ✔
Importing board notifications... ✔
Importing attachments... ✔
Importing avatars...
Message: filesize(): stat failed for G:\wamp\www/attachments/4_8b68f0ad289fd94fccf1cef5b74bd21ee62f352f.elk
Trace: filesize(): stat failed for G:\wamp\www/attachments/4_8b68f0ad289fd94fccf1cef5b74bd21ee62f352f.elk
Line: 14
File: G:\wamp\www\import\import.php(846) : eval()'d code
Everytime the attachment name changes.
Attached a new version, can you test this one please?
Importing Members... ✔
Importing Categories... ✔
Importing Boards... ✔
Importing Topics... ✔
Importing Messages... ✔
Importing polls... ✔
Importing poll choices... ✔
Importing poll votes... ✔
Importing personal messages... ✔
Importing pm recipients... ✔
Importing topic notifications... ✔
Importing board notifications... ✔
Importing attachments... ✔
Importing avatars...
Message: filesize(): stat failed for G:\wamp\www/attachments/4_62aaa0203663926989f7f80c814991ce41338153.elk
Trace: filesize(): stat failed for G:\wamp\www/attachments/4_62aaa0203663926989f7f80c814991ce41338153.elk
Line: 15
File: G:\wamp\www\import\import.php(846) : eval()'d code
May be my backup is not right? I tried backup from phpMyAdmin and MyBB admin panel database backup option.
If you want to share screen using Skype or Team Viewer do let me know.
ok, found some more bugs.. try the attached version..
Hmm still it shoots an error
But when i untick "Import Avatar" it successfully imported everything without any problem (before using the latest importer.xml file)
was it a MyBB 1.8.x from the beginning or previously an older version / other forum software?
Added an extended check for the avatar error and hopefully fixed the categories / boards order chaos..
Try the attached version :)
It is 1.8.6 from the beginning :D and i will check the importer and update here.
OMG almost there and this error came,
Importing attachments... ✔
Importing avatars... Unsuccessful!
This query:
INSERT IGNORE INTO elks.elkarte_attachments
(id_attach, size, filename, file_hash, id_member)
VALUES (1, 3964, '/avatar_1.png', '88f8ceafecbff2c8d30357c10ba6ca7549dccec6', 1),
(2, 16604, '/avatar_2.png', 'dd3123d963bcd9c15e988d42921821a06b32314a', 2),
(3, 3663, '/avatar_7.jpg', '442ddf6a6d2411f2923c0aada0683da5318a76db', 7),
(4, , '/default_avatar.jpg', 'c300dd97ab94448fd7065e79129e79db540b1242', 12),
(5, , '/default_avatar.jpg', '4966a69e21934491fd48e017c4e043353212d2b5', 13),
(6, 22646, '/avatar_26.png', '6ce88240751269ff32ae093d9d38aacfb12b276d', 26),
(7, , '/avatar_29.jpg', 'f1ebcd682fa6fe783f032cfc7727d673d2dc512d', 29),
(8, , '/avatar_72.gif', '8bef656edba72c85469fd903d75d2d96e4459ba3', 72),
(9, 2128, '/avatar_76.jpg', '58714cf4e7313a8c1d7371f41830e8f93b3dda3d', 76),
(10, , '/avatar_83.jpg', '7d4c0ed44054fa1b3f6be4a562b62ddde845159c', 83),
(11, 20008, '/avatar_107.png', '86f56187bb00a8f57d60547fb65c5dac12372428', 107),
(12, 3289, '/avatar_110.jpg', '5acca533844f17c8a221e71c44e1e42d3c24bfde', 110),
(13, 2692, '/avatar_117.jpg', '91a1a0f337887e2d4dace074f58bff6add2db0b7', 117),
(14, 2365, '/avatar_120.jpg', 'b7fe78aa093dc70bfddcc342a99581fe2f43c46e', 120),
(15, 2861, '/avatar_123.jpg', '5e2a3b2e2d9b9c59a6ba0ea9d55935446fee720d', 123),
(16, 2380, '/avatar_125.jpg', 'f09e4e8d3638d05767f2948b49fd952bf95b5fa8', 125),
(17, 12962, '/avatar_126.png', 'cc53b937f170108708e180949d64e77225103ed8', 126),
(18, 3884, '/avatar_136.jpg', 'f3aa51c4a247948dcc1d026d588c94a04de14b38', 136),
(19, 3534, '/avatar_137.jpg', '72beeac5cd04e984939044616c75d41e2c463ce0', 137),
(20, 4133, '/avatar_140.png', 'bed7252c94a508605e9ef77673bad8287d890fe8', 140),
(21, 16853, '/avatar_142.jpg', 'f06cd6f379e424b84d22ba4f5b6d31e0bbc5879e', 142),
(22, 1346, '/avatar_144.png', 'ac563aaf3603370bfb5f90c76a6214895509e0b0', 144),
(23, 3091, '/avatar_154.gif', 'f6426dba290e24ae420312a79c8a2a9d6b4f4c23', 154),
(24, 4598, '/avatar_174.jpg', '905b1319f7b4f594ba018ecee139c9196e327964', 174),
(25, 2681, '/avatar_176.jpg', 'd7bca1ad983c9717710c9eb07497ae4076dea5f6', 176),
(26, 3069, '/avatar_177.jpg', '314676461a1d32de739e2ea8c383daf8822c8d13', 177);
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 ' '/default_avatar.jpg', 'c300dd97ab94448fd7065e79129e79db540b1242', 12),
' at line 6
What a thrill! My poor heart! :o ;)
default_avatar.jpg -> looks like rows with this information are incomplete.. is it a standard feature of MyBB 1.8 or a modification? Can't find a related admin setting in MyBB..
I think my MyBB is little corrupted then, i upgraded 1.6 to 1.8 in amateur way that would have caused some issue in default_avatar.jpg
Is there a file named default_avatar.jpg in myBB under /uploads/avatars/ ? If not place a default avatar file with that name under /uploads/avatars/ and try again.. maybe that fixes the issues..
Hmm i tried, it didn't work well :(
Thanks TE, you are awesome....Great job
Log: (TE fixed)
1) Attachment problem solved
2) Categories neatly synchronize
3) Everything is imported perfectly (me facing avatar issue due to corrupt DB)
4) Poll issue fixed
Screenshot of the imported forum :) (Localhost)
Avatars are broken at all or just those with the default avatar?
All are broken TE, not the default one alone
Here's another attempt to fix the avatars issue.. Hope that one works...
Not successful for me
@TE This query:
INSERT IGNORE INTO
elks.elkarte_attachments
(size, filename, file_hash, id_member)
VALUES (3964, 'avatar_1.png', 'e6efd10efecb39b243f31f9b1ae307a12db71d36', 1),
(16604, 'avatar_2.png', '18618a0885daa99c71d2b6e3ed0047209d378db7', 2),
(3663, 'avatar_7.jpg', 'ca0a0d7b702cfca694d653c26e0a0fadbbd0492c', 7),
(, 'default_avatar.jpg', 'c36a56a20af4c0eee13289a5adc4d3862b17afc9', 12),
(, 'default_avatar.jpg', '699bdf019b075d94af81502c7d07d90f64d90272', 13),
(22646, 'avatar_26.png', '3f901bc635f8b0833b93674d89f2590c9339fb51', 26),
(, 'avatar_29.jpg', '29839dfed52b13aeb9ae92f0c8e5024881769c02', 29),
(, 'avatar_72.gif', 'f1aba98ba48a684e794e0450c42bd7c27bb381a9', 72),
(2128, 'avatar_76.jpg', 'f75cb953b1c79347fc3b35b8af0de70ad33db87c', 76),
(, 'avatar_83.jpg', 'cbcdafa82cc27d659c3fe9a28ef7078be41fa70c', 83),
(20008, 'avatar_107.png', '75b44834f8150f8d86a3320e3d51ea3ba405a638', 107),
(3289, 'avatar_110.jpg', '713f181b797a206c897c9210b126ef7b00abb426', 110),
(2692, 'avatar_117.jpg', '13ab26dd79d28491baa3ee2481f85f86405b6ff5', 117),
(2365, 'avatar_120.jpg', 'b5cf88313c18548b23467bad28a4569c991157ce', 120),
(2861, 'avatar_123.jpg', '3911091fe5a232a8994a6c7ebc8fc9ca8dbd8afe', 123),
(2380, 'avatar_125.jpg', 'c6097c066d4129ff406e920f86c8b34cc10242d8', 125),
(12962, 'avatar_126.png', '0f0eb0ff09494661dd43afbace6f06220ad98590', 126),
(3884, 'avatar_136.jpg', 'da35e12de69568d608de025340a10aa610766cdd', 136),
(3534, 'avatar_137.jpg', '4b166a581385f783b97ad9408e820b99b9d42c3f', 137),
(4133, 'avatar_140.png', 'dded51b3c80e2cb7324e1701e3c951d8183ccf72', 140),
(16853, 'avatar_142.jpg', 'b6cb694b0e0a50f4f79e872153ea5551589666d8', 142),
(1346, 'avatar_144.png', '5389a6e413d05fac40f3754a345177a2f2941472', 144),
(3091, 'avatar_154.gif', '19eb795c94d36d0d1523b79e4968eeb3294b8161', 154),
(4598, 'avatar_174.jpg', '09a9eb9d089e86f8be563729ed32c2c3b7cc3fae', 174),
(2681, 'avatar_176.jpg', '9ff7757824992455ab29f95ab271e4f54deb6076', 176),
(3069, 'avatar_177.jpg', '84b09524691d58b2e1ac084e4374bb8024756cf7', 177);
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 ' 'default_avatar.jpg', 'c36a56a20af4c0eee13289a5adc4d3862b17afc9', 12),
' at line 6
Hope others check and give you the output
next version :D
Finally, Hurray......
Importing Members... ✔
Importing Categories... ✔
Importing Boards... ✔
Importing Topics... ✔
Importing Messages... ✔
Importing polls... ✔
Importing poll choices... ✔
Importing poll votes... ✔
Importing personal messages... ✔
Importing pm recipients... ✔
Importing topic notifications... ✔
Importing board notifications... ✔
Importing attachments... ✔
Importing avatars... ✔
Recalculating statistics... ✔
One thing is avatars are not displayed in the forum. May be if i do a full forum download and try. It may show the avatar
Have you tried rebuilding some caches?
No
@Allan i didn't. I will try and update the details here.
Just asking, I have converted a couple forums in my time and avatars always seem to be a problem. But I have noticed the rebuilding worked on some occasions.
it would be helpful if you post a sample not working avatar record from the database.
Replace id_member with a member having a avatar problem.
Are you suggesting it to me?
Who ever has a problem ;)
This is the problem in live (demo folder)
Sorry, the database connection information used in the specified installation of your forum cannot access the installation of %1. 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 'server name' for table 'mybb_users'
Yeah. Seems that that you did not supplied the right user to access the mybb database. You can get that information from your Mybb Installation inc/config.php
should look something like this:
Everything is right there. But still the error comes
And how is your setup ? You need to provide more information to get qualified help.
Shall i provide u teamviewer or skype id so that u can look into it
Sorry, i don't make onside support.
Ok i didnt ask for the password ;)
install of elkarte & mybb is on the same server ? Mybb is working & elkarte is working ?
Yes, they are in the same server. MyBB is working fine and elkarte is not.
What in Elkarte is not working ? It needs to be setup correctly before you start importing.
Elkarte import shoots the error i mentioned. By some means i am not able to grant permission to my username in SQL
Can you provide a screenshoot of the settings you provide to the Import ?
Here you go,
If you have a look on your screenshoot you see that it trys to use a user "indianta_jaz" to connect to the mybb database. But it must be "intz" according to your mybb setup. Do you now where it gets that from ? the Info must be somewhere.
That was the dummy thing which i gave, right one
$db_server = 'localhost';
/**
The port for the database server
@var string
/
$db_port = '';
/*
The database name
@var string
/
$db_name = 'indianta_elk';
/*
Database username
@var string
/
$db_user = 'indianta_jaz';
/*
$config['database']['type'] = 'mysqli';
$config['database']['database'] = 'indianta_gct';
$config['database']['table_prefix'] = 'mybb_';
$config['database']['hostname'] = 'localhost';
$config['database']['username'] = 'indianta_intz';
still, it should use
$config['database']['username'] = 'indianta_intz'
but it uses "indianta_jaz".
It looks to me as if you have a bunch of installations and lost the overview.
Finally done it,
I just have to add DB1 user to DB2 and vice versa
So it is like, DB1->DB1 user & DB2 user .....DB2->DB2 user & DB1user.
Maybe add it to the OI repo and add a Utilities section to the OI home page?
I tried to get everything working on the current OI master branch a few weeks ago so we got back to a centralized "master" location for all the working importer functions.
Help please: the conversion stops in the topics field. I'm converting from MyBB 1.8.12 and before that I was using an Invision 3.4.8
This is the conversion screen. All right it seems...
...but after converting 1000 topics this happens:
hello and welcome to Elkarte!
Did you used the file attached in this topic or the official importer?
The attached file. And used the .xml on page 3.
any errors logs?
Welcome. :) (E ciao :P)
hmm...
Are you familiar with the developer tools of chrome (or maybe another browser)?
Nope. Indeed I can't answer to radu 'cause I'm not sure if I got an error or not. Not from the browser however.
I'm using XAMPP with PHP 7 in local environment btw.
(Emanuele mi ha riconosciuto pare. Siamo tutti e 3 italiani XD)
Okay, then let's try another thing.
My feeling is that something fails in the AJAX response, so either you use one of the developer tools provided by the browsers to inspect the request and discover what is going wrong, or you disable javascript and runs the importer this way, so that the outcome id printed directly in the HTML instead of in the AJAX response.
Disable js in the code is a bit of a pain (it's still somehow a mess), so the easiest option is for you to install the https://noscript.net/ firefox add-on and run the importer.
This should show a more meaningful error... If we are lucky...
We are not. And the importer stops in different times too: sometimes it's after "... start=1500", sometimes it's right after the very beginning. I have to say it really takes a lot of time to go to the actual importing page, but maybe this isn't important.
On a side note: I still have the IPB installation, but I read that the Open Importer for this is still not very operational, isn't it?
In fact it is intended: when javascript is disabled, then you have to confirm each step, and that should be the reason you may get more meaningful error messages.
But... meh.
I don't know, I was
breaking working on the "next" version, and didn't come back to 1.0 for a while, either
@Spuds or
@TE know this version way better than me.
But... could it be you have turned off the error reporting in XAMPP?
Would you mind checking it?
Here it is a guide to turn it *off*, in case just do the opposite and turn it "On":
http://www.complete-concrete-concise.com/web-tools/how-to-turn-off-display_errors-in-xampp
I was able to convert: some mybb tables were corrupted, so a database repair solved everything. I'm sorry but I don't know if using the official importer helped since XAMPP signed the error (mysql) but it was "hidden" among many other little issues and I didn't notice it the first time I checked.
Thats very strange ... I think at this point I would need to get a copy of the db so I could determine where its making the mistake. I know I ran MyBB though the importer but it was a very small DB.
Hello! First of all Thank you all for your effort.
Which Password from which Database I have to write?
If I write my Password of my MyBB-Databse: Openimporter says: "Wrong Password"
If I write my Password of my ElkArte-Database: Openimporter says:
Is there a solution (MyBB = 1.8.15; ElkArte = 1.1.3)
@Tegenarian Hope this helps - https://www.elkarte.net/community/index.php?topic=5170.0
Thank you Jason. I stopped to import my old Forum and start from new. Sometimes ist more ballast. But nevertheless thank you a lot for your help.