MyBB Community Forums

Full Version: SQL Problem
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
My friend having this problem. We can not see the threads.



mySQL error: 1016
Can't open file: 'mybb_sessions.MYI' (errno: 145)
Query: DELETE FROM mybb_sessions WHERE uid='1'


Performing necessary upgrade queries..
mySQL error: 1091
Can't DROP 'messageindex'; check that column/key exists
Query: ALTER TABLE mybb_threads DROP messageindex;

Help..!
Presuming you are using cPanel, go to MySQL and click Check. See if everything is Ok. If not, Go Back and click Repair.
It is more than likely a broken table.
No. It is Plesk. Well I think the problem is the Lang. Coding because when we backup we cannot get the Turkish characters right. Now I am using mysqlfront but the characters are not proper.

I think the server should find a solution
lapsetur Wrote:No. It is Plesk. Well I think the problem is the Lang. Coding because when we backup we cannot get the Turkish characters right. Now I am using mysqlfront but the characters are not proper.

I think the server should find a solution

Oh ok. I am not familiar with Plesk. Sorry about that.
You should contact your host provider, who will fix it for you.

Regards,
Dan.
Quote:mySQL error: 1016
Can't open file: 'mybb_sessions.MYI' (errno: 145)

http://www.redrook.com/faqs/mysql-error-...no-145.php

Which version are you trying to upgrade from, and which version are you trying to upgrade to.
Well we changed the lang. codes and installed new one and abnegated from our old DB.
Still having problems?
Well this site belongs to my friend as I told. Now I am waiting for him to have backup. I'll look in to *.sql file if the cahracters are right.

We'll see