MyBB Community Forums

Full Version: punBB 1.2 > myBB 1.2.14 - MySQL error: 1064
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
i am having this same issue when trying to convert a punbb 1.2 database to mybb 1.2.14. it occurs when configurin/converting the threads and halts with the same 1064 limit 1 error for a user id.

Quote:Inserting thread #1805... MySQL 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 's new online' LIMIT 1' at line 1
Query: SELECT id, username FROM users WHERE username = ' what's new online' LIMIT 1

i am new to sql... so what do i need to query through myphpadmin in order to fix this? if you could give me the steps, that'd be great! what's new online

thank you in advance!