MyBB Community Forums

Full Version: Why Always "internal SQL error" when logging in
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Help me, yesterday I merge from SMF to MyBB, then when logging out and want to log in again, either as a normal user or as an admin, can not and there's always the inscription:

MyBB SQL Error

Experienced MyBB has an internal SQL error and can not continue.

SQL Error:
1146 - Table 'earthgam_mybb.mybb_user' does not exist
Query:
SELECT COUNT (*) as users FROM mybb_user WHERE LOWER (username) =''LIMIT 1

Can anyone help me?
My forum is http://earthgamerz.com
Make sure your database prefix is correct. To fix this, open ./inc/config.php and check the entry for $config['database']['table_prefix']. If you do not know what needs to be here, contact your host provider.
Have you installed a plugin meant for MyBB 1.2.x on a MyBB 1.6 install??
(2011-05-01, 06:45 AM)Yaldaram Wrote: [ -> ]Make sure your database prefix is correct. To fix this, open ./inc/config.php and check the entry for $config['database']['table_prefix']. If you do not know what needs to be here, contact your host provider.

what should I do with table_prefix? Sad
Set it to what the prefix of all your tables actually is.
thanks all for reply Big Grin
I installed a plugin for MyBB 1.2
be careful while installing plugins.
it will break your forum
(2011-05-05, 03:57 PM)FBI Wrote: [ -> ]be careful while installing plugins.
it will break your forum

Not will, can, and only can. Only use plugins from trusted sources, and for the correct versions.