1016-Can?t open file?products_description.MYI?(errno:145)

[Happy Delivery]

Hello, these error appears in left side of my store, I can?t acces the catalogue even from the administrator, how can I correct these error? what do I do wrong? :cry:

I hope someone could guide me out of these problem.

 

Thanks

[oilzzz]

This has happened to me twice in the last 3 days.

 

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

 

The first time I restored the database from a backup which fixed it. I've had no problems since I opened my store but now it appears a lot of people are getting this error.

 

Is this a bug? Is someone exploiting our shops?

[oilzzz]

Did a search and found an easy fix using phpmyadmin

[Ajeh]

Did a search and found an easy fix using phpmyadmin

 

And you were going to enlighten us with this fix so that others can benefit ... correct? :wink:

[Happy Delivery]

Thanks everyone, after posting this message I found its a common problem and also the way to fix it. :wink:

Best Regards

[RWParts]

I am still searching for the answer to this question. Please tell how you fixed it?

[RWParts]

I have been deligently reading the threads turned up in searches on Can't open file: 'products_description.MYI'. (errno: 145) including this one: http://faq.ozoneasylum.com/896/rating/ but I am afraid that they are not of any help.

 

Does anyone have time to direct me, please? My host has a link to MySQL and the PHPMyAdmin, but there does not appear to be a command line so I can take advantage of the tips provided in my search results.

 

You can tell by now that I am not able to code. A developer suggested I use OS and downloaded a template and I've been on my own ever since.

[Ajeh]

I have been deligently reading the threads turned up in searches on Can't open file: 'products_description.MYI'. (errno: 145) including this one: http://faq.ozoneasylum.com/896/rating/ but I am afraid that they are not of any help.  

 

Does anyone have time to direct me, please?  My host has a link to MySQL and the PHPMyAdmin, but there does not appear to be a command line so I can take advantage of the tips provided in my search results.

 

You can tell by now that I am not able to code.  A developer suggested I use OS and downloaded a template and I've been on my own ever since.

 

You could try going into phpMyAdmin and Select your MySQL database, then select the products_description table and run the Repair on it and see if this fixes it.

 

I would try to do a backup before doing this. Not sure if that will work based on the error. But couldn't hurt to try.

[markchiu]

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

 

delete from whos_online where time_last_click < '1063257756'

 

[TEP STOP]

 

 

 

please please please tell us how to fix or any more directions...please :cry: ....i just run into this as well... :cry:

[Ajeh]

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

 

delete from whos_online where time_last_click < '1063257756'

 

[TEP STOP]

 

please please please tell us how to fix or any more directions...please :cry: ....i just run into this as well... :cry:

 

Go into phpMyAdmin ...

Select your MySQL database ...

Click on SQL ...

Paste this into the Box ... and click GO ...

DROP TABLE IF EXISTS whos_online;

CREATE TABLE whos_online (

 customer_id int,

 full_name varchar(64) NOT NULL,

 session_id varchar(128) NOT NULL,

 ip_address varchar(15) NOT NULL,

 time_entry varchar(14) NOT NULL,

 time_last_click varchar(14) NOT NULL,

 last_page_url varchar(255) NOT NULL

);

 

This will delete the whos_online table and remake it.

[markchiu]

aj...still thank you so much for your more posting ....i know you guys really don't want to hear this kind same old problem again....after i post here...i did the search...then i ran into the problem...delted the whos_online file..then didn't know how to create a new one...because i ran into these commands..and don't know what each function for??

 

Structure

Browse

SQL

Select

Insert

Export

Operations

Options

Empty

Drop

 

 

......especially at beginning didn't know that drop means "deleting"

 

 

Thank you so much again..you helped me again :cry: :cry: :oops: :D

[Ajeh]

Glad to be of help to you ... sometimes it just takes a little fussing around and patience.

 

People try to get to the messages as quickly as possible to find the answers. Good luck to you!

[RWParts]

Yes, quite a bit of fussing around but I found it. I didn't realize that phpmyadmin and mysql were programs resident on my host's cpanel. I still can't find a command line to enter the code that appears above.

 

My particular instance is fixed. I found he database list and then later found the "repair" command buried in a drop-down box. That worked for me.

 

Even though the problem is fixed, I will continue to browse around until I find a way to enter the commands in the hint above.

 

Thank you all for your patience with a novice.

[Ajeh]

Yes, quite a bit of fussing around but I found it.  I didn't realize that phpmyadmin and mysql were programs resident on my host's cpanel.  I still can't find a command line to enter the code that appears above.

 

My particular instance is fixed.  I found he database list and then later found the "repair" command buried in a drop-down box.  That worked for me.

 

Even though the problem is fixed, I will continue to browse around until I find a way to enter the commands in the hint above.

 

Thank you all for your patience with a novice.

 

If you click on SQL you get a large white box ...

 

Paste the code in there and click Go ... :D

[triktoys]

I love you, you just save my butt! It Worked! Thank you Thank you Thank you!!!

[rmahawaii]

WOW...this save our site!!!! THANK YOU SO MUCH!

[NemoTech]

I was unable to figure out how to repair the table for orders.MYI.

 

I`m receiving the following error,

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

 

any assistance will be greatly appreciated. Please. Thanks.