1114 error MySQL database full

[DrByte]

The EXACT complete error message would be more helpful.

There's no good reason for you to be getting 1114 errors on a clean uncustomized install of Zen Cart with no addons ... unless your hosting company has sorely misconfigured (underconfigured) the server by a long shot.

You said that you have no addons. How are your customers paying for their orders? In what EXACT ways is your store different from a brand new fresh install out-of-the-box?

[BSClay]

1114 The table 'email_archive' is full
in:
[insert into email_archive ...

Here are the Modules being used. I am guessing that is where the add ons would be. http://bsclay.com/modules.jpg

We have a 8+ year database of customers and want to save them and not just make a whole new database and lose them. I really think my hosting did something bad because it just all of a sudden stopped working Saturday and they say my database looks suspiciusly low.

[DrByte]

If your email_archive table contains more than 2147483647 records, then it would indeed be "full".
If that is the case, then you need to do a database backup and then Truncate your email_archive table from your database by running the following SQL statement:

TRUNCATE TABLE email_archive;

DO A DATABASE BACKUP FIRST!!!

[BSClay]

Could you give me the steps on how to preform that, I know how to do the backup, did it with westhost the other day

[DrByte]

https://www.zen-cart.com/tutorials/i...hp?article=103

Use phpMyAdmin to do your backup. And use it to truncate the table.

[BSClay]

I ran the email thing and still get...

1114 The table 'email_archive' is full
in:
[insert into email_archive (email_to_name, email_to_address, email_from_name, email_from_address, email_subject, email_html, email_text, date_sent, module)

[BSClay]

It says it is empty yet it is throwing an error it is full. I am so confused