ElkArte Community

General => OpenImporter => Topic started by: TE on January 12, 2016, 07:11:24 am

Title: [MyBB 1.8] Importer
Post by: TE on January 12, 2016, 07:11:24 am
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..
Title: Re: [MyBB 1.8] Importer
Post by: Allan on January 12, 2016, 08:49:50 am
Great job @TE 
Title: Re: [MyBB 1.8] Importer
Post by: meetdilip on January 13, 2016, 05:40:34 am
Awesome work @TE
Title: Re: [MyBB 1.8] Importer
Post by: IndianTalkZone on January 14, 2016, 02:38:52 am
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
Title: Re: [MyBB 1.8] Importer
Post by: IndianTalkZone on January 14, 2016, 03:07:18 am
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)
Title: Re: [MyBB 1.8] Importer
Post by: meetdilip on January 14, 2016, 05:36:22 am
@IndianTalkZone ,thanks for reporting the bugs. I hope @TE will be able to come up with a fix.
Title: Re: [MyBB 1.8] Importer
Post by: TE on January 14, 2016, 09:25:19 am
please try again with the attached mybb18_importer.xml, should at leat fix the issues regarding polls..
Title: Re: [MyBB 1.8] Importer
Post by: IndianTalkZone on January 15, 2016, 01:44:29 am
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
Title: Re: [MyBB 1.8] Importer
Post by: TE on January 15, 2016, 02:18:02 am
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?
Title: Re: [MyBB 1.8] Importer
Post by: IndianTalkZone on January 15, 2016, 03:05:09 am
Quote from: TE – 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.
Title: Re: [MyBB 1.8] Importer
Post by: TE on January 15, 2016, 03:16:23 am
Quote from: IndianTalkZone – . 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..
Title: Re: [MyBB 1.8] Importer
Post by: IndianTalkZone on January 15, 2016, 03:31:23 am
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?
Title: Re: [MyBB 1.8] Importer
Post by: TE on January 15, 2016, 03:56:05 am
can you check the path G:\wamp\www/attachments/4_f81a866f99d98822837317eab6b92129cbea37e9.elk with windows explorer?
Does this folder folder  G:\wamp\www/attachments/ exist?
Title: Re: [MyBB 1.8] Importer
Post by: IndianTalkZone on January 15, 2016, 04:04:53 am
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.
Title: Re: [MyBB 1.8] Importer
Post by: TE on January 15, 2016, 04:16:13 am
Attached a new version, can you test this one please?
Title: Re: [MyBB 1.8] Importer
Post by: IndianTalkZone on January 15, 2016, 04:23:26 am
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.
Title: Re: [MyBB 1.8] Importer
Post by: IndianTalkZone on January 15, 2016, 04:29:29 am
If you want to share screen using Skype or Team Viewer do let me know.
Title: Re: [MyBB 1.8] Importer
Post by: TE on January 15, 2016, 05:20:49 am
ok, found some more bugs.. try the attached version..
Title: Re: [MyBB 1.8] Importer
Post by: IndianTalkZone on January 15, 2016, 05:24:21 am
Hmm still it shoots an error

QuoteMessage: filesize(): stat failed for G:\wamp\www\attachments/4_824b4187b609de7aa2f94f34cf66bc9122f68cf2.elk
Trace: filesize(): stat failed for G:\wamp\www\attachments/4_824b4187b609de7aa2f94f34cf66bc9122f68cf2.elk
Line: 17
File: G:\wamp\www\import\import.php(846) : eval()'d code

But when i untick "Import Avatar" it successfully imported everything without any problem (before using the latest importer.xml file)
Title: Re: [MyBB 1.8] Importer
Post by: IndianTalkZone on January 15, 2016, 05:28:03 am
Here is a screen shots,


Title: Re: [MyBB 1.8] Importer
Post by: TE on January 15, 2016, 07:03:33 am
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  :)
Title: Re: [MyBB 1.8] Importer
Post by: IndianTalkZone on January 15, 2016, 08:01:36 am
It is 1.8.6 from the beginning :D and i will check the importer and update here.
Title: Re: [MyBB 1.8] Importer
Post by: IndianTalkZone on January 15, 2016, 08:07:14 am
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
Title: Re: [MyBB 1.8] Importer
Post by: Jorin on January 15, 2016, 08:12:25 am
What a thrill! My poor heart!  :o  ;)
Title: Re: [MyBB 1.8] Importer
Post by: TE on January 15, 2016, 08:49:11 am
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..
Title: Re: [MyBB 1.8] Importer
Post by: IndianTalkZone on January 15, 2016, 08:55:48 am
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
Title: Re: [MyBB 1.8] Importer
Post by: TE on January 15, 2016, 09:00:54 am
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..
Title: Re: [MyBB 1.8] Importer
Post by: IndianTalkZone on January 15, 2016, 09:14:05 am
Hmm i tried, it didn't work well :(
Title: Re: [MyBB 1.8] Importer
Post by: IndianTalkZone on January 15, 2016, 09:40:45 am
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
Title: Re: [MyBB 1.8] Importer
Post by: IndianTalkZone on January 15, 2016, 09:47:31 am
Screenshot of the imported forum :) (Localhost)
Title: Re: [MyBB 1.8] Importer
Post by: TE on January 18, 2016, 03:18:47 am
Quote from: IndianTalkZone – 3) Everything is imported perfectly (me facing avatar issue due to corrupt DB)
Avatars are broken at all or just those with the default avatar?
Title: Re: [MyBB 1.8] Importer
Post by: IndianTalkZone on January 20, 2016, 03:34:42 am
Quote from: TE –
Quote from: IndianTalkZone – 3) Everything is imported perfectly (me facing avatar issue due to corrupt DB)
Avatars are broken at all or just those with the default avatar?

All are broken TE, not the default one alone
Title: Re: [MyBB 1.8] Importer
Post by: TE on January 20, 2016, 07:03:44 am
Here's another attempt to fix the avatars issue.. Hope that one works...
Title: Re: [MyBB 1.8] Importer
Post by: IndianTalkZone on January 22, 2016, 12:36:13 am
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
Title: Re: [MyBB 1.8] Importer
Post by: TE on January 22, 2016, 02:42:53 am
next version  :D
Title: Re: [MyBB 1.8] Importer
Post by: IndianTalkZone on January 23, 2016, 02:06:51 am
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


Title: Re: [MyBB 1.8] Importer
Post by: Allan on January 23, 2016, 10:35:52 am
Have you tried rebuilding some caches?
Title: Re: [MyBB 1.8] Importer
Post by: IndianTalkZone on January 23, 2016, 10:47:56 am
No @Allan i didn't. I will try and update the details here.
Title: Re: [MyBB 1.8] Importer
Post by: Allan on January 23, 2016, 06:06:22 pm
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. 
Title: Re: [MyBB 1.8] Importer
Post by: Nifty on January 24, 2016, 03:29:25 am
it would be helpful if you post a sample not working  avatar record from the database.
Quoteselect * from elkarte_attachments where id_msg=0 and id_member=XXX;
Replace id_member with a member having a avatar problem.
Title: Re: [MyBB 1.8] Importer
Post by: IndianTalkZone on January 24, 2016, 03:46:22 am
Quote from: Nifty – it would be helpful if you post a sample not working  avatar record from the database.
Quoteselect * from elkarte_attachments where id_msg=0 and id_member=XXX;
Replace id_member with a member having a avatar problem.

Are you suggesting it to me?
Title: Re: [MyBB 1.8] Importer
Post by: Nifty on January 24, 2016, 04:18:50 am
Who ever has a problem ;)
Title: Re: [MyBB 1.8] Importer
Post by: IndianTalkZone on January 24, 2016, 10:04:56 am
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'
Title: Re: [MyBB 1.8] Importer
Post by: Nifty on January 24, 2016, 10:16:55 am
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:
Quote$config['database']['type'] = 'mysqli';
$config['database']['database'] = 'mybb';
$config['database']['table_prefix'] = 'mybb_';

$config['database']['hostname'] = 'localhost';
$config['database']['username'] = 'mybbUser';
$config['database']['password'] = 'MybbPassword';
Title: Re: [MyBB 1.8] Importer
Post by: IndianTalkZone on January 24, 2016, 10:27:09 am
Quote from: Nifty – 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:
Quote$config['database']['type'] = 'mysqli';
$config['database']['database'] = 'mybb';
$config['database']['table_prefix'] = 'mybb_';

$config['database']['hostname'] = 'localhost';
$config['database']['username'] = 'mybbUser';
$config['database']['password'] = 'MybbPassword';

Everything is right there. But still the error comes
Title: Re: [MyBB 1.8] Importer
Post by: Nifty on January 24, 2016, 10:57:47 am
And how is your setup ? You need to provide more information to get qualified help.
Title: Re: [MyBB 1.8] Importer
Post by: IndianTalkZone on January 24, 2016, 11:01:50 am
Shall i provide u teamviewer or skype id so that u can look into it
Title: Re: [MyBB 1.8] Importer
Post by: Nifty on January 24, 2016, 11:06:28 am
Sorry, i don't make onside support.
Title: Re: [MyBB 1.8] Importer
Post by: Nifty on January 24, 2016, 11:15:41 am
Ok i didnt ask for the password ;)
install of elkarte & mybb is on the same server ? Mybb is working & elkarte is working ?
Title: Re: [MyBB 1.8] Importer
Post by: IndianTalkZone on January 24, 2016, 11:16:15 am
Yes, they are in the same server. MyBB is working fine and elkarte is not.
Title: Re: [MyBB 1.8] Importer
Post by: Nifty on January 24, 2016, 11:23:30 am
What in Elkarte is not working ? It needs to be setup correctly before you start importing.
Title: Re: [MyBB 1.8] Importer
Post by: IndianTalkZone on January 24, 2016, 11:24:46 am
Elkarte import shoots the error i mentioned. By some means i am not able to grant permission to my username in SQL
Title: Re: [MyBB 1.8] Importer
Post by: Nifty on January 24, 2016, 11:26:19 am
Can you provide a screenshoot of the settings you provide to the Import ?
Title: Re: [MyBB 1.8] Importer
Post by: IndianTalkZone on January 24, 2016, 11:28:04 am
Here you go,
Title: Re: [MyBB 1.8] Importer
Post by: Nifty on January 24, 2016, 11:38:55 am
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.
Title: Re: [MyBB 1.8] Importer
Post by: IndianTalkZone on January 24, 2016, 11:43:49 am
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';
Title: Re: [MyBB 1.8] Importer
Post by: Nifty on January 24, 2016, 11:48:50 am
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.
Title: Re: [MyBB 1.8] Importer
Post by: IndianTalkZone on January 24, 2016, 01:54:01 pm
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.
Title: Re: [MyBB 1.8] Importer
Post by: emanuele on March 02, 2016, 03:15:51 am
Not sure if it better to have it attached to the  first message or not, though: a script for redirecting mybb pretty urls to Elk's current scheme (http://www.elkarte.net/community/index.php?topic=3335.msg23721#msg23721).
Title: Re: [MyBB 1.8] Importer
Post by: Spuds on March 02, 2016, 06:59:54 am
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.
Title: Re: [MyBB 1.8] Importer
Post by: lordmortimer on September 03, 2017, 10:52:21 am
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...
screen1.png

...but after converting 1000 topics this happens:
screen2.png
Title: Re: [MyBB 1.8] Importer
Post by: radu81 on September 03, 2017, 12:19:22 pm
hello and welcome to Elkarte!
Did you used the file attached in this topic or the official importer? 
Title: Re: [MyBB 1.8] Importer
Post by: lordmortimer on September 03, 2017, 12:36:04 pm
The attached file. And used the .xml on page 3.
Title: Re: [MyBB 1.8] Importer
Post by: radu81 on September 03, 2017, 02:28:10 pm
any errors logs?
Title: Re: [MyBB 1.8] Importer
Post by: emanuele on September 03, 2017, 03:20:43 pm
Welcome. :) (E ciao :P)

hmm...
Are you familiar with the developer tools of chrome (or maybe another browser)?
Title: Re: [MyBB 1.8] Importer
Post by: lordmortimer on September 03, 2017, 04:41:38 pm
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)
Title: Re: [MyBB 1.8] Importer
Post by: emanuele on September 03, 2017, 05:01:36 pm
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...
Title: Re: [MyBB 1.8] Importer
Post by: lordmortimer on September 04, 2017, 06:14:19 am
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?
Title: Re: [MyBB 1.8] Importer
Post by: emanuele on September 04, 2017, 07:12:45 am
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
Title: Re: [MyBB 1.8] Importer
Post by: Jorin on September 04, 2017, 08:24:40 am
Quote from: emanuele – I was breaking working on the "next" version...

lol
Title: Re: [MyBB 1.8] Importer
Post by: Spuds on September 04, 2017, 10:30:35 am
I would try the version from the official importer site (http://openimporter.github.io/openimporter/) I did make some fixes to that version which I also tried to pull in all of the various stand alone files, such as the one in this thread.   No guarantees if it will make any difference but worth a test.
Title: Re: [MyBB 1.8] Importer
Post by: lordmortimer on September 04, 2017, 11:29:10 am
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.
Title: Re: [MyBB 1.8] Importer
Post by: Spuds on September 06, 2017, 07:43:47 am
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.
Title: Re: [MyBB 1.8] Importer
Post by: Tegenarian on May 21, 2018, 05:21:13 am
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:

QuoteSorry, 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 'd02a81ad'@'localhost' for table 'mybb_users'

Is there a solution (MyBB = 1.8.15; ElkArte = 1.1.3)
Title: Re: [MyBB 1.8] Importer
Post by: Jason on May 22, 2018, 12:33:07 pm
@Tegenarian

Hope this helps - https://www.elkarte.net/community/index.php?topic=5170.0
Title: Re: [MyBB 1.8] Importer
Post by: Tegenarian on May 22, 2018, 02:03:09 pm
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.