XF 1.5 xf_attachment_data full

[kunik1962]

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"
}
}

 

[Chris D]

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.

 

[kunik1962]

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

 

[Paul B]

How many rows are in the table?

How many attachments are there in your forum?

 

[TPerry]

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.

 

[Chris D]

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.