Error display

[PVK]

When i try do do a backup of my database, this error comes up.

I have no idea what might be causing this.

I haven't done anything in the databse prior to this error and everything worked fine for a long time without any errors.

 

This is the error code i get:

 

 

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

 

show fields from whos_online

 

[TEP STOP]

 

 

 

I noticed after this message, that the who is online tabel in phpmyadmin sql database is empty [how is this possible or is this normal?]

 

:blink:

[PVK]

Fixed it.

 

I have done a :

 

DROP TABLE IF EXISTS `whos_online`;

CREATE TABLE `whos_online` (

`customer_id` int(11) default NULL,

`full_name` varchar(64) NOT NULL default '',

`session_id` varchar(128) NOT NULL default '',

`ip_address` varchar(15) NOT NULL default '',

`time_entry` varchar(14) NOT NULL default '',

`time_last_click` varchar(14) NOT NULL default '',

`last_page_url` varchar(64) NOT NULL default ''

) TYPE=MyISAM;

 

 

And now the structure is restored again and i can make a backup once again.

 

STILL, i have no idea what has caused this table to become empty ?

Anyone?

 

I use MS2.2

[PVK]

Happy again :)

[Guest]

you didnt need to do that, you could have used mysql or phpmyadmin and then using the tools function, highlight the table, choose repair and it would have recreated the index again. thus, if it happens to your products, are you going to delete and then create the table? you would loose your whole store, so the best thing to do is look at the tools functions, they will check, optimize, repair tables and or whole databases.

 

also the knowledge base has that error listed and how to repair.