Skip to main content
Topic: [MyBB 1.8] Importer (Read 16972 times) previous topic - next topic - Topic derived from Converting MyBB to Elk
0 Members and 1 Guest are viewing this topic.

Re: [MyBB 1.8] Importer

Reply #30
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?
Thorsten "TE" Eurich
------------------------


Re: [MyBB 1.8] Importer

Reply #32
Here's another attempt to fix the avatars issue.. Hope that one works...
Thorsten "TE" Eurich
------------------------

Re: [MyBB 1.8] Importer

Reply #33
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

Re: [MyBB 1.8] Importer

Reply #34
next version  :D
Thorsten "TE" Eurich
------------------------

Re: [MyBB 1.8] Importer

Reply #35
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


Re: [MyBB 1.8] Importer

Reply #36
Have you tried rebuilding some caches?

Re: [MyBB 1.8] Importer

Reply #37
No @Allan i didn't. I will try and update the details here.

Re: [MyBB 1.8] Importer

Reply #38
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. 

Re: [MyBB 1.8] Importer

Reply #39
it would be helpful if you post a sample not working  avatar record from the database.
Quote
select * from elkarte_attachments where id_msg=0 and id_member=XXX;
Replace id_member with a member having a avatar problem.

Re: [MyBB 1.8] Importer

Reply #40
it would be helpful if you post a sample not working  avatar record from the database.
Quote
select * 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?

Re: [MyBB 1.8] Importer

Reply #41
Who ever has a problem ;)

Re: [MyBB 1.8] Importer

Reply #42
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'

Re: [MyBB 1.8] Importer

Reply #43
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';

Re: [MyBB 1.8] Importer

Reply #44
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