2
Quote:
Shine wrote:
All of a sudden all of my soapbox articles weren't reachable for my users.
It said: There are no articles. But there are for sure!! The admin sais so!
A brief look within the sql learned me that the msgs at this table was: 'in use'.
Cleaning (empty it) wouldn't be the solution because then I got also be rid of all the articles. I want to keep them!
The solution for this could be:
- Enter within the querie table:
REPAIR TABLE xoops_sbarticle;
This worked for me.
No, after givin'this small tip my questions:
1).Do other soapbox user enter this problem
2). Why and how can such sql errors occur? What causes this?
Grtz., and thanks, Shine
Thank you so much for posting this. I have been banging my head for a day trying to figure wtf was wrong with my sql. I was not able to login. I mean, it would say thank you for logging in, then after redirection, you were back to being logged out, hence no admin area. Anyway I was getting error can not open xoops_session.MYI or something like that.
So I found your post via google search went to
http://www.mywebsite.com/phpMyAdmin, then I clicked on the xoops_sessions (I was just guessing this was the problem, since it wasn't keeping me logged in.) and sure enough, it said it couldn't open xoops_sessions.MYI. So I took your advice and entered Quote:
REPAIR TABLE 'xoops_sessions'
It then reported that it changed the number 126 to 120 and that it was ok.
Thanks so much for sharing your fix.
-chip