MyBB Community Forums
Error code SQL 1064 - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: Merge System Support (https://community.mybb.com/forum-180.html)
+--- Thread: Error code SQL 1064 (/thread-225966.html)



Error code SQL 1064 - prouddaughter - 2020-01-07

Hi: I originally posted in the installation section of the forum.  Anyway, experienced another error code in the Module Selection USERS, so started over after making some corrections. However, I when I re-ran BB Merge, I now see:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1064 - 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 ' 1000' at line 3
Query:
SELECT * FROM ibf_core_members m LIMIT , 1000


I am migrating from IPBOARD 3.4.6 to MyBB 1.8.22

Thanks  Huh


RE: Error code SQL 1064 - noyle - 2020-01-07

Have you selected the correct convert module? Since you're trying to convert from IPB 3.4.6, you should choose "Invision Power Board 3" over "Invision Power Board 4".


RE: Error code SQL 1064 - prouddaughter - 2020-01-07

I do have the correct version. Actually I am dyslexic today, I should have said, 4.3.6, but I double-checked. LOL


RE: Error code SQL 1064 - noyle - 2020-01-08

I'm not very sure what your current problem came from, but maybe it's caused by some records that have been left in table datacache or trackers.

I have to suggest you to install a new MyBB forum, and then try to use the Merge System to convert your IPB forums. Remember to choose the correct convert module.


RE: Error code SQL 1064 - [ExiTuS] - 2020-01-08

Quote:SQL Error:
1064 - 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 ' 1000' at line 3
Query:
SELECT * FROM ibf_core_members m LIMIT , 1000

The SQL error occurs because of missing limit value!

SELECT ... LIMIT [STARTING_ROW] , 1000

Check and repair the code or go the way with MyBB Merge System already mentioned.

[ExiTuS]