Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Database Optimizer.. is this necessary?


JoeWoodworker

Recommended Posts

I have been having a problem with the whos_online table corrupting. It did it twice yesterday. Fortunately, a suggestion was posted that worked at first but then was it happened again.

 

The hosting company said nothing had been changed on the server. I have another test Osc cart running on the same server and it is running fine with no errors in the db.

 

The only difference between the two installations is that my cart has the advanced whos online contribution.

 

I am wondering if my database or maybe even my Osc software is corrupt. Would a data base optimizer help? I saw one on the contributions page that I thought I might try out. http://www.oscommerce.com/community/contri...tions,61/page,5

 

Any suggestions?

 

Thanks

Joe

 

 

 

PS This is the error message I got ..

 

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

 

delete from whos_online where time_last_click < '1051204798'

 

[TEP STOP]

Evil will always triumph over good...

Because good is dumb.

- D.H.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...