[Host issue, not a bug] Mass Log File Issue and Site is Down

[MortalWombat]

Hello

Overnight, something seems to have happened to our Zen Cart installation, as we are now being bombarded by log files by the hundred. We've made no changes to any files, aside from images, etc.

The more worrying aspect is that the site is down and producing the following error on both admin and store pages:
WARNING: An Error occurred, please refresh the page and try again.

The log files created are both admin- and store-side, with an identical error inside:

[27-Jan-2016 10:52:40] PHP Fatal error: 126:Incorrect key file for table '/tmp/#sql_c11_0.MYI'; try to repair it :: show fields from orders_status_history ==> (as called by) /shop/includes/classes/sniffer.php on line 46 <== in /shop/includes/classes/db/mysql/query_factory.php on line 155

Another error for store-side:

[27-Jan-2016 03:33:09] PHP Fatal error: 126:Incorrect key file for table '/tmp/#sql_c11_0.MYI'; try to repair it :: select distinct p.products_id, p.products_image, pd.products_name, p.master_categories_id,pd.products_description
from (products p
left join featured f on p.products_id = f.products_id
left join products_description pd on p.products_id = pd.products_id )
where p.products_id = f.products_id
and p.products_id = pd.products_id
and p.products_status = 1 and f.status = 1
and pd.language_id = '1' ==> (as called by) /shop/includes/modules/morphling/featured_products.php on line 63 <== in /shop/includes/classes/db/mysql/query_factory.php on line 155

And another:

[27-Jan-2016 10:51:41] PHP Fatal error: 126:Incorrect key file for table '/tmp/#sql_c11_0.MYI'; try to repair it :: select p.products_image, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status
from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p2c.products_id = s.products_id
where p.products_status = 1
and p.products_id = p2c.products_id
and pd.products_id = p2c.products_id
and pd.language_id = '1'
and p2c.categories_id = '78' order by p.products_sort_order, pd.products_name ==> (as called by) /shop/includes/templates/morphling/templates/tpl_index_product_list.php on line 46 <== in /shop/includes/classes/db/mysql/query_factory.php on line 155

And another one for admin-side:

[20-Jan-2016 12:30:12] PHP Warning: mysql_query(): Access denied for user 'apache'@'localhost' (using password: NO) in /shop/admin/orders.php on line 1233
[20-Jan-2016 12:30:12] PHP Warning: mysql_query(): A link to the server could not be established in /shop/admin/orders.php on line 1233
[20-Jan-2016 12:30:12] PHP Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /shop/admin/orders.php on line 1234

And one more for the admin:

[22-Jan-2016 13:54:49] PHP Warning: array_merge(): Argument #1 is not an array in /shop/admin/customers.php on line 1108
[22-Jan-2016 13:54:49] PHP Warning: array_merge(): Argument #2 is not an array in /shop/admin/customers.php on line 1110
[22-Jan-2016 13:54:49] PHP Warning: reset() expects parameter 1 to be array, null given in /shop/admin/includes/classes/object_info.php on line 29
[22-Jan-2016 13:54:49] PHP Warning: Variable passed to each() is not an array or object in /shop/admin/includes/classes/object_info.php on line 30

In addition to these errors, hundreds more logs are being created that are completely empty -- again both admin- and store-side.

And, to top it off, emails don't seem to be working, which indicates an issue with the server, however, since I don't understand the errors above, I really have no idea what's going on.

HELP!

[Ajeh]

This sounds like a database issue. Who are you hosting with? Have you contacted them about the sudden database problems?

Are you able to get into you cPanel for your site and phpMyAdmin to do a complete backup of your database? (Do not wipe out any old backups you might have)

After the backup of your database, are you able to do a Repair on the database tables?

Once the database is fixed, you can delete the debug in the /logs directory ... as they all seem related to this database issue, you could delete them and see what new ones are being generated ...

[MortalWombat]

Thanks for the fast reply, Ajeh.

I've actually have been trying to connect to our server since my original post -- alas, it is currently completely inaccessible.

We are currently hosted with GoDaddy, and have been for many years now, though we have just purchased some hosting with another company, A Small Orange, and will be migrating the site to them soon.

We're on the phone with GoDaddy right now, so hopefully they'll be able to get the server back up and running -- the wait is quite a long one usually, so I'll be back with an update as soon as we've spoken to them.

[MortalWombat]

OK, good news -- we're back up and running. Turns out GoDaddy was/is having some pretty serious trouble with their servers and that was the cause of the issue.

In my earlier haste, I hadn't realised that the following logs were dated from a week ago... In actual fact, these errors have been popping up intermittently since we upgraded to v1.5.4 a few months back. Any ideas as to what would be causing these?

[20-Jan-2016 12:30:12] PHP Warning: mysql_query(): Access denied for user 'apache'@'localhost' (using password: NO) in /shop/admin/orders.php on line 1233
[20-Jan-2016 12:30:12] PHP Warning: mysql_query(): A link to the server could not be established in /shop/admin/orders.php on line 1233
[20-Jan-2016 12:30:12] PHP Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /shop/admin/orders.php on line 1234

[22-Jan-2016 13:54:49] PHP Warning: array_merge(): Argument #1 is not an array in /shop/admin/customers.php on line 1108
[22-Jan-2016 13:54:49] PHP Warning: array_merge(): Argument #2 is not an array in /shop/admin/customers.php on line 1110
[22-Jan-2016 13:54:49] PHP Warning: reset() expects parameter 1 to be array, null given in /shop/admin/includes/classes/object_info.php on line 29
[22-Jan-2016 13:54:49] PHP Warning: Variable passed to each() is not an array or object in /shop/admin/includes/classes/object_info.php on line 30

[Ajeh]

Do you have any logs that are dated today after GoDaddy fixed their server?

[MortalWombat]

Alas, I spoke too soon when I said we were back up... There were some problems that persisted through on the database that have only just now finally been corrected.

There have been no further logs created so far, but I'll need to keep an close eye on it for the next little bit and report back if we get anything more.