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

Ajeh <[email protected]>
Newsgroups gmane.comp.web.oscommerce.installation
Message-ID <69a3387af7f3ddcdcd2e783f760b2123@osCommerce-Forums>
This message was sent from: Installation and Configuration
http://forums.oscommerce.com/viewtopic.php?p=227745#227745
----------------------------------------------------------------

[quote="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:[/quote]

Go into phpMyAdmin ...
Select your MySQL database ...
Click on SQL ...
Paste this into the Box ... and click GO ...
[code]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
);
[/code]

This will delete the whos_online table and remake it.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.