About every 10 days or so my website goes down for the count and I have to repair the sessions database. Does anybody know how to permanently fix this or what might be causing this?
This is the error page I get:
Database error: 1194 : Table ‘cscart_sessions’ is marked as crashed and should be repaired
Invalid query: SELECT session_id FROM cscart_sessions WHERE session_id=‘1dc318beb04c97684744dab015746fe9’ AND expiry>‘1287424911’
I also have this problem in versino 1.3.5
This is a Project issue (bad planned) and I don’t know if there is any fix to this.
What I do to avoid it is to Optimize the database 1 or 2 times a week.
But if you have a lot of access, this is going to happen. I hope that they have done something about this on the new versions.
If anybody has some information about it, please post here.
Hmm, well its really weird. My site has been running just fine for years, the only new difference is that I recently did a major inventory update, traffic remains the same. So I assume it has something to do with that. How do you optimize the database, I’m not too familiar with this stuff?