MyBB Community Forums

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1104 - The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
Query:
SELECT mybb_threads.tag , mybb_threads.fid , mybb_stcp.tag_name , mybb_stcp.tag_amount FROM mybb_stcp LEFT JOIN mybb_threads ON mybb_threads.tag LIKE CONCAT('%',',',mybb_stcp.tag_name,'%') AND mybb_threads.fid != '' WHERE mybb_threads.fid = 344 ORDER BY RAND() LIMIT 30;


entry error:
MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 'remember' in 'field list'
Query:
SELECT uid,username,password,salt,loginkey,remember,coppauser,usergroup FROM mybb_users WHERE username='Mc MuSti Mc' LIMIT 1

Are you possibly using outdated plugins? That seems to be the common cause of the error regarding remember. The other error could be from a poorly set up MySQL server... with a LIMIT 30 clause in the SQL, you shouldn't be joining too many rows.

1st error: caused by a plugin.

2nd error: http://community.mybb.com/thread-75028.html

Individual thank you Problems Solved.