Mysql Errors and Mo...
 
Notifications
Clear all

Mysql Errors and More!

4 Posts
3 Users
0 Reactions
1,200 Views
(@cynical_terror)
Posts: 27
Eminent Member
Topic starter
 

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 am having some issues with efiction running on my site. A few days ago I posted here with this problem:

*********

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.

**********

This somehow seemed to resolve itself and the site ran fine on its own for two days.

Today when I logged on the same thing happened. Then, about ten minutes later the site displayed a blank page with this error:

"_FATALERROR _NOTCONNECTED"

I contacted my webhost, which is "hostmonster" and the man I spoke with told me that it wasn't a server problem but probably something in the PHP. I read in the forum here that this IS PROBABLY an issue with my server, but since they say it isn't, they won't help me.

Is there anything I can do? And is there any reason I keep getting this fata Mysql error?

Thanks in advance for any help!

-Arianne


 
Posted : 05/11/2007 2:08 am
(@carissa)
Posts: 791
Member Moderator
 

If you are getting a not connected error, then your site is not connecting to your database. If you didn't change your config file, the it's definitely your host. If you had syntax error that resolves itself, this is also probably your host.


 
Posted : 05/11/2007 2:14 am
(@cynical_terror)
Posts: 27
Eminent Member
Topic starter
 

If you are getting a not connected error, then your site is not connecting to your database. If you didn't change your config file, the it's definitely your host. If you had syntax error that resolves itself, this is also probably your host.

Do you recommend I contact my host again and push the issue?

Thanks for your quick response!


 
Posted : 05/11/2007 2:19 am
(@chelle)
Posts: 122
Estimable Member
 

I would.  At the most it could be something as simple as them having to restart the mySQL server on the machine where your account is hosted.  I would specifically cite the connection issues and tell them that your configuration file to connect is fine [because it worked before and you have not altered it recently]


 
Posted : 06/11/2007 11:09 am
Share: