Cover image disappears

Post I just got from a member

What is the wall? Had some pics posted there but were gone a day later....

So it appears on my site, the images delete the first time you upload them, when you upload images a 2nd time, they stay.

Any ideas why this would be?

Same problem here.

Happening to me as well, going to try that .htaccess fix from earlier in the thread.

Hey there. Just popping in to mention I may have found the actual solution to this issue. What I did is:

Go to the ext/canidev/follower/cron folder

In there, open up the file called tiny.php

Go to line 73 where it looks like this:

Code: Select all

      // Delete orphan attachments
      $attach_ary = [];

      $sql = 'SELECT item_id, item_data
         FROM ' . $this->tables['data'] . '
         WHERE item_type = ' . constants::ITEM_ATTACHMENT . '
         AND comment_id = 0

after the line AND comment_id = 0

ADD:

Code: Select all

         AND user_id = 0

save.

If you did my previous htaccess change, revert it back to normal.

With that change I have tested it and the cover image is no longer deleting. It appears to look into the database and see there is no comment ID associated with that file, considers it an orphan attachment, and deletes it. With having it consider if a user ID is attached to the file (aka is not 0), it is no longer considered orphan, and leaves it.

Back up your own copy of the extension, just in case. But that extra line addition is working perfectly in my case. As always, YMMV. Hope it helps.

Hey there. Just popping in to mention I may have found the actual solution to this issue. What I did is:

Go to the ext/canidev/follower/cron folder

In there, open up the file called tiny.php

Go to line 73 where it looks like this:

Code: Select all

      // Delete orphan attachments
      $attach_ary = [];

      $sql = 'SELECT item_id, item_data
         FROM ' . $this->tables['data'] . '
         WHERE item_type = ' . constants::ITEM_ATTACHMENT . '
         AND comment_id = 0

after the line AND comment_id = 0

ADD:

Code: Select all

         AND user_id = 0

save.

If you did my previous htaccess change, revert it back to normal.

With that change I have tested it and the cover image is no longer deleting. It appears to look into the database and see there is no comment ID associated with that file, considers it an orphan attachment, and deletes it. With having it consider if a user ID is attached to the file (aka is not 0), it is no longer considered orphan, and leaves it.

Back up your own copy of the extension, just in case. But that extra line addition is working perfectly in my case. As always, YMMV. Hope it helps.

Thank you for this, I just gave it a try, hope it works! Just out of curiosity, what was changing that was allowing the image to stay when added a second time? For my site, the image would delete after first uploading, but if you re-did it, it would stay permanent.