MyBB Community Forums

Full Version: ***Are you getting "mySQL Error 1146" or no mybb_threads table is created? Look here!
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hmmm...this is the umpteenth time i've installed MyBB, and I have got this error quite a few times, but normally, when I keep on clicking back, then click next, it works. Not this time. I get this problem when clicking on next after signing up for the admin account:

mySQL error: 1146
Table 'mybb.mybb_threads' doesn't exist
Query: SELECT * FROM mybb_threads

So I checked my phpMyAdmin and I can't find mybb_threads in my MyBB database. Maybe a typo with the SQL Query? If anyone knows, can you please tell me what to change it to?
Are the error is caused because your verision of mySQL doesn't like these two lines for when creating the table mybb_threads.

either open up install/resources/db_tables.php and find and remove these lines:

,
  KEY subject (subject),
  FULLTEXT KEY subject_2 (subject)

or replace db_tables.php with the attached file below:
I also had the problem and found another way to fix it.

http://www.mybboard.com/community/showth...p?tid=2948

(couple of posts down is my solution)
I've stuck this thread since it's a common problem, and I've split the rest of the chatter into here