Been offline ages now, when is mysql back online?

[petemint]

My site has now been offline for ages now, most of yesterday, and still offline today.
Any idea when mysql will be coming online again?
I really need to get some work done to my site.

 

[tnl2k7]

MySQL should be online, please try removing and re-adding your MySQL user in cPanel, then link it to your database again. Don't remove your databases though, these are unaffected by the MySQL issue, which seems to have affected a small minority of users on Cossacks, I'm not sure of the cause.

-Luke.

 

[petemint]

On the "hosting services up/down" page it shows mysql being offline?

 

[tnl2k7]

That's because of the firewall, it blocks external connections. This of course causes the service to show as offline, despite it being online and running. Unless you get socket errors in your scripts, MySQL is online and running.

-Luke.

 

[petemint]

The error I get is this.

"SQL ERROR [ mysqli ]

Table 'petemint_forumupdate.ANNOUNCEMENTS_CENTRE_TABLE' doesn't exist [1146]

SQL

SELECT * FROM ANNOUNCEMENTS_CENTRE_TABLE

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 143
CALL: dbal->sql_error()

FILE: includes/functions_announcements.php
LINE: 114
CALL: dbal_mysqli->sql_query()

FILE: includes/functions.php
LINE: 3458
CALL: get_announcement_data()

FILE: index.php
LINE: 149
CALL: page_header()"
Edit:
I've checked in phpmyadmin, nd the table is there.

 

[tnl2k7]

That's because a table that the script is trying to access doesn't exist in your MySQL database. You should try restoring a backup of your database from before the error started occurring or contact the script vendor to fix it - we don't provide support for 3rd party scripts and applications in here.

-Luke.

 

[petemint]

The table does exist, I've checked. Also, it worked fine yesterday, and I've changed nothing?

 

[tnl2k7]

Try going into phpMyAdmin and trying to repair the database. I'm not sure what's up with it, but if the table does exist and it's corrupted, that should fix it.

-Luke.

 

[petemint]

How do I repair a database?
Edit:
Ah well, I'll just delete my site, and start all over. I wanted a new look anyway, lol.
Just hope my sql database isn't corrupt, it has loads of data in it I can't afford to lose.

 

[tnl2k7]

Select the database in phpmyAdmin, which can be accessed from within cPanel, then check the name of the troublesome table (or check all if you want to fix the whole thing). Then choose Repair from the With Selected: dropdown menu, it'll repair the table(s) you selected.

-Luke.