1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.5 xf_attachment_data full

Discussion in 'Troubleshooting and Problems' started by kunik1962, Oct 5, 2015.

  1. kunik1962

    kunik1962 Member

    I decided to try out the add-on Convert Image All (v3.9)and things seemed to work fine after I converted 200 images. I then removed the add-on.

    Now I am getting errors in my log anytime anyone tries to upload a file telling me the xf_attachment_data is full. Am I screwed and is there a way to fix this?

    Here is the request State
    array(3) {
    ["url"] => string(103) "http://xlnation.city/attachments/do...164f61da1b59754e05904720f70&content_type=post"
    ["_GET"] => array(2) {
    ["hash"] => string(32) "684e0164f61da1b59754e05904720f70"
    ["content_type"] => string(4) "post"
    }
    ["_POST"] => array(7) {
    ["Filename"] => string(11) "images.jpeg"
    ["content_data"] => array(1) {
    ["thread_id"] => string(1) "6"
    }
    ["_xfToken"] => string(8) "********"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
    ["_xfSessionId"] => string(32) "a057af189a100de28e449338d3912cb9"
    ["Upload"] => string(12) "Submit Query"
    }
    }
     
  2. Chris D

    Chris D XenForo Developer Staff Member

    What is the actual error message? It could be relevant.

    If it's a MySQL related error, then it's most likely something your host will need to help you with.
     
  3. kunik1962

    kunik1962 Member

    The actual error in the xenforo log is: Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : The table 'xf_attachment_data' is full - library/Zend/Db/Statement/Mysqli.php:214

    Its my own server so I will have to fix it I guess
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    How many rows are in the table?

    How many attachments are there in your forum?
     
  5. Tracy Perry

    Tracy Perry Well-Known Member

    If it was me, and it was due to the removal of the add-on, try installing the add-on back and then see if that resolves it for now. Then contact @AndyB and let him know that it has caused an issue. It could be that he's not aware of it.
     
  6. Chris D

    Chris D XenForo Developer Staff Member

    FWIW, it's not related to an add-on, as such, because it's a OS/server limit.

    This may be relevant:
    https://dev.mysql.com/doc/refman/5.0/en/table-size-limit.html

    The constraints are actually at the file system level.

    Aside from that, you're going to need to look at reducing the size of that table. That's not likely to be a simple task, either.
     

Share This Page