Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15
  1. #11
    Join Date
    Jan 2004
    Posts
    66,444
    Plugin Contributions
    279

    Default Re: 1114 error MySQL database full

    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?
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  2. #12
    Join Date
    Mar 2012
    Posts
    9
    Plugin Contributions
    0

    Default Re: 1114 error MySQL database full

    When I turned it off that message went away. Does it need to be on for members and such?
    Last edited by BSClay; 22 Mar 2012 at 03:54 AM.

  3. #13
    Join Date
    Mar 2012
    Posts
    9
    Plugin Contributions
    0

    Default Re: 1114 error MySQL database full

    I want to thank you so much for helping me with issue and telling me something that would help me fix my issue. I am very new to Zen Cart and MySQL, I was just an html guy before and I gets me worried sometimes.

  4. #14
    Join Date
    Jan 2004
    Posts
    66,444
    Plugin Contributions
    279

    Default Re: 1114 error MySQL database full

    Turning that option off simply prevents the store from saving copies of outgoing emails. The option is normally off by default, partly because it generates a lot of content, and balloons your storage requirements significantly especially in busy stores. And, since most storeowners seem to have the store send them copies of all the emails anyway it's really not necessary except maybe if you're trying to troubleshoot a problem for a particular recipient who's complaining about not receiving emails.
    So, in short, leaving that off is probably not a bad idea.

    But, I'm still bothered that there's even a problem with that table. Your hosting company should really take a look at the database and fix up that table, even if it means rebuilding it (via a simple export of structure only, then drop and recreate using the exported sql text).
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  5. #15
    Join Date
    Mar 2012
    Posts
    9
    Plugin Contributions
    0

    Default Re: 1114 error MySQL database full

    DrByte, you know your stuff. Again I want to thank you. You made my week. The guy that set this up really did not do a good job and I am afraid to upgrade to 1.5 because so. I do not want to kill my employers store.

 

 
Page 2 of 2 FirstFirst 12

Similar Threads

  1. v135 1114 The table 'zen_user_tracking' is full
    By guide in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 8 Feb 2013, 02:00 PM
  2. MySQL database import error
    By xikan in forum Installing on a Linux/Unix Server
    Replies: 1
    Last Post: 24 Aug 2009, 02:39 AM
  3. Dreaded mYSQL 1064 error when importing MySQL 4 database into MySQL5
    By dml311071 in forum Installing on a Linux/Unix Server
    Replies: 4
    Last Post: 10 Jun 2008, 05:38 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg