Working great for 2+ years, now this error and my site is down. Help needed!

[Guest]

Here's the error the public gets when trying to access anything OSCommerce on my site, and I get the same error from the admin side when trying to open and view customer orders. Please tell me how to fix!! (in beginner language if you can)

 

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

 

select counter from visitors where browser_ip = '74.130.88.79' AND browser_language = 'en-us,en;q=0.5'

 

 

 

Thanks!!

Abby

scrapbookloversdream.com

[Velveeta]

Here's the error the public gets when trying to access anything OSCommerce on my site, and I get the same error from the admin side when trying to open and view customer orders. Please tell me how to fix!! (in beginner language if you can)

 

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

 

select counter from visitors where browser_ip = '74.130.88.79' AND browser_language = 'en-us,en;q=0.5'

Thanks!!

Abby

scrapbookloversdream.com

 

I've gotten this error myself before, go into phpmyadmin if you have it, and run a repair on the visitors table, that should clear it up :)

 

Richard.

[davidinottawa]

Here's the error the public gets when trying to access anything OSCommerce on my site, and I get the same error from the admin side when trying to open and view customer orders. Please tell me how to fix!! (in beginner language if you can)

 

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

 

select counter from visitors where browser_ip = '74.130.88.79' AND browser_language = 'en-us,en;q=0.5'

Thanks!!

Abby

scrapbookloversdream.com

 

you need to repair your visitors table

you can do this using phpMyAdmin.

 

just type

repair table visitors

 

http://www.oscommerce.info/kb/osCommerce/G...mon_Problems/69

http://www.karakas-online.de/EN-Book/repai...rupt-table.html

 

david

[davidinottawa]

Here's the error the public gets when trying to access anything OSCommerce on my site, and I get the same error from the admin side when trying to open and view customer orders. Please tell me how to fix!! (in beginner language if you can)

 

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

 

select counter from visitors where browser_ip = '74.130.88.79' AND browser_language = 'en-us,en;q=0.5'

Thanks!!

Abby

scrapbookloversdream.com

 

whos_online - just keep going! lol.

 

david

[Guest]

where do I find phpMyAdmin? on the FTP site? on the admin side of OSCommerce? I'm just not seeing it anywhere.

 

Sorry to be such a ditz with this.

[davidinottawa]

where do I find phpMyAdmin? on the FTP site? on the admin side of OSCommerce? I'm just not seeing it anywhere.

 

Sorry to be such a ditz with this.

 

phpMyadmin is a 3rd party utility that should be provided by your host.

log in to your control panel with your host.

look for a link called mysql databases

near the bottom of this page will be a link to phpmyadmin

 

OR - if you are running Plesk, there will be a link that says Databases, and then another link that says DB Admin.

 

Once in phpmyadmin, there is a link that says SQL

click this link, and inside the box type your statments :

repair table vistors

hit go.

 

Thats it.

 

when was the last back up of you database ?

 

d

[Guest]

Hey, thanks d!

 

Backup...well..I bought this gig in July, and I know I haven't done one yet. I'd venture to say previous owner wasn't keeping up on that either. Guess I need to look into that.

[davidinottawa]

Hey, thanks d!

 

Backup...well..I bought this gig in July, and I know I haven't done one yet. I'd venture to say previous owner wasn't keeping up on that either. Guess I need to look into that.

 

yes.

 

if this app is critical to your business/site/sanity i would recommend automated back up at least once a week - of course this also depends on how often you make db modifications.

 

d