Site: http://tokiohotelfiction.com/
Version: 3.3.1
Bridges: None
Modules: Not sure
PHP: 5.1.6 (this may be wrong)
MySQL: 4.1.21
Have you searched for your problem: Yes
If so, what terms did you try: Fatal Mysql, Error 1030
State the nature of your problem:
I apologize in advance if this problem has been answered somewhere else. When you try to access my site, the layout and all the content isn't visible on the front page (but all the rest of the content and layout seems to be working in all the other sections), just this error message:
A fatal MySQL error was encountered.
Query: SELECT stories.*, author.penname as penname, UNIX_TIMESTAMP(stories.date) as date, UNIX_TIMESTAMP(stories.updated) as updated FROM (fanfiction_authors as author, fanfiction_stories as stories) WHERE author.uid = stories.uid AND stories.validated > 0 ORDER BY rand( ) DESC LIMIT 1
Error: (1030) Got error 28 from storage engine
I think it's trying to tell me what to do to fix this issue, but I really don't understand the language. I am practically a novice with PHP and MYSQL, etc, so if anyone knows how to resolve this issue, I may need a little help understanding some of the jargon.
Thank you for any help you can give, I appreciate it, and if this was answered somewhere else, please let me know! 🙂
-Arianne
edit: Oh! And I haven't made any changes to the site recently. This just randomly happened on its own. It was fine one minute and the next I was encountering this error. I don't know if that helps!
this somehow resolved itself!
I've got the same problem:(
I've installed a new version of eFiction today. and everytime I try to see the stories in categories (link: http://www.chameleongirl.net/fanfiction/browse.php?type=categories&id=154) I see this:
A fatal MySQL error was encountered.
Query: SELECT stories.*, author.penname as penname, UNIX_TIMESTAMP(stories.date) as date, UNIX_TIMESTAMP(stories.updated) as updated FROM (fanfiction_authors as author, fanfiction_stories as stories) WHERE author.uid = stories.uid AND stories.validated > 0 AND (FIND_IN_SET(154, stories.catid) > 0 ) ORDER BY updatesort DESC LIMIT 0, 10
Error: (1054) Unknown column 'updatesort' in 'order clause'
Upd. It was a problem with my language file, I've change the site language to Eng, and the error was fixed.
