Would it be feasible to take my list of attachments_ids I want deleted, and to edit the xf_attachment table to change the 'unassociated' column to '1'?
I did that on one of the attachments and was able to delete it in the attachment browser.
If anyone has a really good reason not to do that...
Oh, additionally when I try to delete an attachment from the attachment browser I get the following error:
ErrorException: [E_WARNING] Attempt to read property "title" on null in src/XF/ModeratorLog/Post.php at line 61
XF::handlePhpError() in src/XF/ModeratorLog/Post.php at line 61...
Here is the python code that is used to delete threads:
def delete_thread(thread_id, lot_id, hard_delete=True):
if not thread_id:
if LOGLEVEL >= 1:
logger.warning("Thread ID is empty, skipping delete.")
return
# Set the value of hard_delete based on the...
The thread was hard deleted via the API but the posts and attachments were not deleted. The posts exist in xf_post and the attachments exist in xf_attachment, xf_attachment_data, and xf_attachment_view. I can view all the attachments still when I go to the Attachment browser and view by user...
Hello!
So I've been using the API to post threads for sales items and delete them after an expiration. So the threads get posted, attachments get attached, and threads get removed. No problem!
But then I noticed my disk space isn't freeing up... the attachments AND the posts are not removed...
I checked and it does seem like the specific attachment wasn't set up correctly.
Right now, the content_id is 0, and there a temp_hash as well as unassociated '1' set.
So I dug around a little more because there are also attachments that ARE set up correctly and I realized this may have been a...
It was a user key, but I tried to use a super user as well, setting up both the XF-Api-User header, and then simply trying api_bypass_permissions=1, and both return the same error.
INFO:main:Response status code: 403
INFO:main:Response content: b'{\n "errors": [\n {\n...
Hello,
I've been trying to figure out why I'm getting permission errors during a DELETE attachment API call.
The API user is the same as I've used to upload the attachments, and the attachments are attached to the post by posting the thread first, and using the first_post_id return data to...
So the problem was definitely in corrupted uploads.
We fixed the problem by writing a shell script to basically run the code that xf imports on every attachment we had. Every time it got the fatal error, it wrote the filename down in a log file for us. Once we had that, we deleted all the...
Well, we got rid of one failed attachment and it chugged along for a while before crashing out again. Here is the error in the db log:
*** 794. row ***
error_id: 794
exception_date: 1549495770
user_id: 0
ip_address:
exception_type: ErrorException
message: Fatal Error...
So an update: I'm going to run the importer from blank again. This time everything except the attachments, and then run the attachments separately.
I do want to see what the status is of everything outside of the attachments first. I wasn't able to find the .gif on the disk, though it's...
Running from the CLI with verbose turned on didn't give me any more info. But I think I found the file that comes after the last successful file. It's named a653ae1a13c2e40093a010fd7784c1a4.gif and has an 'attachmentid' in the VB database one increment higher than the last attachment found in...
So I'm doing a fairly large board import from VB to XF and have tried twice, running from the CLI, only to have the import fail in a non-recoverable state during the attachments import.
I imagine there is a file that it's dying at, but it's not giving filenames and I don't know of any logfile...