1114 error MySQL database full

[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

[DrByte]

Very bizarre. In 8 years of working with this I've never seen that happen.

In the short term, turn off Email Archiving: Admin->Configuration->Email Options
Then does the error start happening on another table suddenly?

[BSClay]

When I turned it off that message went away. Does it need to be on for members and such?