1114 error MySQL database full

[BSClay]

I got a 1114 error when trying to check out and make accounts. I have come to the conclusion it is because my database has reached it's limites and I have too many table columns. I know nothing of how to mess with mysql and am pretty new to the Zen Cart game. Can anyone help me please?

[Kim]

Please click the reply button and answer all the questions in the Posting Tips.

[BSClay]

You are presently using: v1.3.9h

Just started working on the site and it stopped working Saturday and nothing was touched by anyone. Happened after an order.

No add-ons that I know of.

It has a different template.

I am with West Host

http://www.torquerebooks.com

I looked for the answers and can not make heads or tails. This is my first time with Zen Cart and I am scared I will break it Lol. I was going to slowly learn but now it is a crash course.

West Host has been stringing me along for 4 days and we are loosing customers over this. Any help would be... helpful.

[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