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:

    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