LocostUSA.com
https://locostusa.com/forums/

SQL ERROR [ mysql4 ]
https://locostusa.com/forums/viewtopic.php?f=34&t=16448
Page 1 of 1

Author:  waltj [ June 8, 2014, 6:08 pm ]
Post subject:  SQL ERROR [ mysql4 ]

This error has been showing up for the last week or so. Thus far it has been just a nuisance, but it is often accompanied by some slowness on the site.

Here are the errors as they are displayed:

This was from a couple of days ago, while trying to log in.

General Error
SQL ERROR [ mysql4 ]

Table 'phpbb_sessions' is marked as crashed and should be repaired [1194]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
Please notify the board administrator or webmaster: locost84@locostusa.com
Powered by phpBB® Forum Software © phpBB Group


This was from today @2:53PM PDT as I was logging out.

General Error
SQL ERROR [ mysql4 ]

Table 'phpbb_sessions' is marked as crashed and should be repaired [1194]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
Please notify the board administrator or webmaster: locost84@locostusa.com
Powered by phpBB® Forum Software © phpBB Group

Author:  Lonnie-S [ June 9, 2014, 11:42 pm ]
Post subject:  Re: SQL ERROR [ mysql4 ]

I've been getting similar messages when I login and logout. I do a "reload page" from my browser in both cases and everything works out as it should.

Yes, it is getting annoying. I've written to the hosting company on other issues (like the almost 3-day unavailability of the site) and never received the courtesy of a reply so far. Twits!

Cheers,

Author:  nick47 [ June 10, 2014, 11:27 am ]
Post subject:  Re: SQL ERROR [ mysql4 ]

Maybe time to upgrade to MySQL 5.

Author:  carguy123 [ June 10, 2014, 11:52 am ]
Post subject:  Re: SQL ERROR [ mysql4 ]

I usually find that and super slow speed is a prelude to the site crashing.

You're getting that and I'm getting the super slow speeds so I'm expecting the site to go down again very soon.

Author:  nick47 [ June 10, 2014, 12:06 pm ]
Post subject:  Re: SQL ERROR [ mysql4 ]

I have a couple of websites using MySQL. Table metadata gets corrupted from time to time, especially on very active tables, and as a result the table can no longer be accessed. If it's a critical table, like for example the one containing forum posts, the site will be down. If it's less critical, like a tracking or statistics table, you might just see errors, and the site could slow down. The corrupted table can be fixed in a few seconds, but to do that you need access to a MySQL client.

Author:  Lonnie-S [ June 10, 2014, 12:09 pm ]
Post subject:  Re: SQL ERROR [ mysql4 ]

nick47 wrote:
I have a couple of websites using MySQL. Table metadata gets corrupted from time to time, especially on very active tables, and as a result the table can no longer be accessed. If it's a critical table, like for example the one containing forum posts, the site will be down. If it's less critical, like a tracking or statistics table, you might just see errors, and the site could slow down. The corrupted table can be fixed in a few seconds, but to do that you need access to a MySQL client.


It sounds like you should be hosting the system, Nick. :wink:

Cheers,

Page 1 of 1 All times are UTC - 5 hours [ DST ]
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/