Re: [MyBB 1.8] Importer Reply #30 – January 18, 2016, 03:18:47 am Quote from: IndianTalkZone – January 15, 2016, 09:40:45 am3) Everything is imported perfectly (me facing avatar issue due to corrupt DB)Avatars are broken at all or just those with the default avatar?
Re: [MyBB 1.8] Importer Reply #31 – January 20, 2016, 03:34:42 am Quote from: TE – January 18, 2016, 03:18:47 amQuote from: IndianTalkZone – January 15, 2016, 09:40:45 am3) 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
Re: [MyBB 1.8] Importer Reply #32 – January 20, 2016, 07:03:44 am Here's another attempt to fix the avatars issue.. Hope that one works...
Re: [MyBB 1.8] Importer Reply #33 – 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 6Hope others check and give you the output
Re: [MyBB 1.8] Importer Reply #35 – 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
Re: [MyBB 1.8] Importer Reply #36 – January 23, 2016, 10:35:52 am Have you tried rebuilding some caches?
Re: [MyBB 1.8] Importer Reply #37 – January 23, 2016, 10:47:56 am No @Allan i didn't. I will try and update the details here.
Re: [MyBB 1.8] Importer Reply #38 – 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.
Re: [MyBB 1.8] Importer Reply #39 – 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.
Re: [MyBB 1.8] Importer Reply #40 – January 24, 2016, 03:46:22 am Quote from: Nifty – January 24, 2016, 03:29:25 amit 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?
Re: [MyBB 1.8] Importer Reply #42 – 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'
Re: [MyBB 1.8] Importer Reply #43 – 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.phpshould 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 – January 24, 2016, 10:27:09 am Quote from: Nifty – January 24, 2016, 10:16:55 amYeah. 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.phpshould 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