MyBB Community Forums

Full Version: How do i fix this?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
my site is http://leet.ro i have not change anything this morning my site work fine after 3h the site give this error:
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    126 - Incorrect key file for table './mybb/mybb_sessions.MYI'; try to repair it
Query:
    DELETE FROM mybb_sessions WHERE ip='188.25.207.0'

Please contact the MyBB Group for support.


i did not change anything not even go to acp
Empty the mybb_sessions table (this will log all users out).
Although, it seems like a host issue.
wath host issue the others site work the only problem is with mybb wath issue
You just need to reapir the table like the error message says.

Run this query in phpMyAdmin:

REPAIR TABLE `mybb_sessions`;

It's not a MyBB issue, it's an issue with a file for the database.
Ok now i uploaded the site on other webhost that i have i uploaded the db i have change in inc/config.php username,password,db and still taking the old username
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    1045 - Access denied for user 'leet'@'localhost' (using password: YES)
Query:
    [READ] Unable to connect to MySQL server 

config.php
$config['database']['type'] = 'mysqli';
$config['database']['database'] = 'leet_mybb';
$config['database']['table_prefix'] = 'mybb_';

$config['database']['hostname'] = 'localhost';
$config['database']['username'] = 'leet_mybb';
$config['database']['password'] = 'notshown';
(2011-02-14, 09:10 AM)cezars Wrote: [ -> ]Ok now i uploaded the site on other webhost that i have i uploaded the db i have change in inc/config.php username,password,db and still taking the old username
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    1045 - Access denied for user 'leet'@'localhost' (using password: YES)
Query:
    [READ] Unable to connect to MySQL server 

config.php
$config['database']['type'] = 'mysqli';
$config['database']['database'] = 'leet_mybb';
$config['database']['table_prefix'] = 'mybb_';

$config['database']['hostname'] = 'localhost';
$config['database']['username'] = 'leet_mybb';
$config['database']['password'] = 'notshown';

Delete the inc/config.php file and re-upload the edited one with the correct username and details.

At times some ftp programs will not overwrite existing files, deleting and re-uploading will make sure thats not the case here.
done the same thing and thx for such fast answer
If its still picking up the old database name on the new host then somehow you still have the old config.php file there. Is it possible to have the URL and the ftp details so we can have a better look?
yes i will send them in private to you

i have pm the detail host,user,password

url is http://test.leet.ro

i found the problem the home of site is in other directory i have change it there and now it`s work thx for help