HELP.........

[angie201]

I had my store up and running with no problems at all. Its been a few weeks now.

Today I went to check the store and got this error..

1016 - Can't open file: 'whos_online.MYI'. (errno: 145)

delete from whos_online where time_last_click < '1053120001'

[TEP STOP]


Can anyone help, please......

I have done any thing to the files or even uploaded any new stuff to the store. I was checking the who is online last night and it was working find.... .

Please please help.

Stressed out Angie

[michael_s]

Angie,

This is related to mysql 4. All you have to do is repair the table 'whos_online' using phpmyadmin. Then, to prevent this from happening again, change the table type to INNODB, again using phpmyadmin.

The fix takes about 2 minutes, but will keep it from happening again.

[angie201]

Hi,

Thanks for the fast reply! I really appreciate it.

What do I need to do to the table? I'm not very familiar with phpmyadmin...

I will go and have alook into it now... any further help greatly appreciated.

[michael_s]

on the main page of phpmyadmin that lists all the tables, scroll down and find the whos_online table and click the checkbox next to it.

Then at the bottom of that listing of tables, there is a dropdown list box, you want to select 'repair'

This will fix the error.

Then, again from the main table listing, you want to scroll down and find the whos_online table again. This time click the 'browse' link to the right of the table. Then on the next page, select the tab at the top that says 'Options"

Then, on the options page, find the dropdown box for "table type" and select INNO DB and click 'GO'

Thats it...

[angie201]

Hi Msasek,

Thank you so much for your help... its greatly greatly appreciated!

Any ideas why this happened. Could it have been something that I did or just a glitch. I know I was looking at the who is page lastnight and had over 20 people in the shop with a few of them with orders. This morning no orders in my inbox... thats why I went to check the shop and found the error...

Again thank you

Angie

[michael_s]

Angie,

It is actually a problem with MySQL 4. It doesn't have anything to do with anything that you did. It is a strange problem, and doesnt happen to all databases. You were just unlucky. Making the changes should eradicate it

[balacom]

Dear msasek


Thanks for your advice !
It helped me too!

But when I use PHPmyadmin, I don't have this option of INNODB.
What I have is the following:

heap
berkeley DB
ISAM
Merge

Kindly Advice which one should I choose pls ?

Thanks in advance

Bala

[michael_s]

If you dont have the option for INNODB, your host has disabled this table type. You must use ISAM.

[peterwilding]

my format for all that is MyISAM, should i change it??????????????
how???????????- above doesnt work as i cant find options

peter w

ps: u helped me whth this error thanks