Advertisement:

Author Topic: Missing pictures  (Read 1961 times)

Offline pocttopus

  • Jr. Member
  • **
  • Posts: 191
    • @pocttopus on Twitter
Re: Missing pictures
« Reply #40 on: January 10, 2018, 10:04:58 AM »
is there anything in your error log that is generated when you open a post with an attachment ?

OK, the attachments don't display but do they download when you click on them AND and can you view them once downloaded ?
No, there is no error because I cannot click them. There is no links for the attachments

what happens when you create a new post and add an attachment to it -- does it then display at least for that post ?
After the migration to the new host, new attachments are fine. This is the issue only for older attachments from the previous host.

what bothers me is that you had a huge discrepancy when you fixed them via the Maintenance option - are you sure that you have the same amount of attachments in both systems ?

try to gather more symptoms and if we still get nowhere then maybe try the whole migration again ?
Yes, I click fix the errors and the list of all the attachments is shorter now. I believe that now I had lost the connection with the database to them.  :-\
Now there is no errors but there are no attachments as well displayed, only the new ones from the actual hosting.

I cannot migrate again because the old database is almost a year old. That's too long for our community.
I don't know how can I merge new post/topics with the old database. :-\
« Last Edit: January 10, 2018, 10:06:49 AM by Illori »

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 7,354
  • There's someone in my head but it's not me.
Re: Missing pictures
« Reply #41 on: January 10, 2018, 11:50:50 AM »
The attachment links are missing from the posts?  Believe I've seen this before on a broken forum, can't remember which, but I think it got fixed.  Will have a look through my notes, see if I can find it.

Offline pocttopus

  • Jr. Member
  • **
  • Posts: 191
    • @pocttopus on Twitter
Re: Missing pictures
« Reply #42 on: January 10, 2018, 12:06:27 PM »
The attachment links are missing from the posts?  Believe I've seen this before on a broken forum, can't remember which, but I think it got fixed.  Will have a look through my notes, see if I can find it.
Thanks @Sir Osis of Liver
You are very kind.

Offline pocttopus

  • Jr. Member
  • **
  • Posts: 191
    • @pocttopus on Twitter
Re: Missing pictures
« Reply #43 on: January 10, 2018, 06:22:33 PM »
Also I had another issue with displaying images from photobucket. I don't know why are not displayed?
There is no SSL certificate, and I don't know if there is any modification who can cause this issue.  :-\
Here is the example: http://forum.mkreef.com/index.php?topic=516.msg2017#msg2017

Any advice for this too?  :-[

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 68,361
    • Arantor on GitHub
Re: Missing pictures
« Reply #44 on: January 10, 2018, 06:39:38 PM »
There's no SSL cert but yet the image proxy is turned on and likely Photobucket notices and blocks the attempt, especially if it's not a paid account.
To assume is to hope that those who came before had the presence of mind and capacity to implement the dreams of those who would come after.

You either die a hero or live long enough to see yourself become the villain. It seems you have chosen which, and now I must do the same.

Offline pocttopus

  • Jr. Member
  • **
  • Posts: 191
    • @pocttopus on Twitter
Re: Missing pictures
« Reply #45 on: January 10, 2018, 06:53:59 PM »
There's no SSL cert but yet the image proxy is turned on and likely Photobucket notices and blocks the attempt, especially if it's not a paid account.
Thanks, I had solved this with disabling the proxy for images.  :)

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 7,354
  • There's someone in my head but it's not me.
Re: Missing pictures
« Reply #46 on: January 10, 2018, 09:28:20 PM »
Ok, there are a couple of things that can cause an attachment link to disappear from a post -

Group permission to view attachments can be disabled, this is default setting for guests.  If you are viewing posts as admin, you should see the links. 

If the _attachments table in database is missing an attachment or is damaged, link will not be displayed for any users. 

If attachment file has been deleted or corrupted, or /attachments directory is missing, the link will remain, you'll get a 404 if you click on it.  Look at your _attachments table, see what's in it.


« Last Edit: January 10, 2018, 09:41:47 PM by Sir Osis of Liver »

Offline pocttopus

  • Jr. Member
  • **
  • Posts: 191
    • @pocttopus on Twitter
Re: Missing pictures
« Reply #47 on: January 11, 2018, 03:42:09 AM »
Firstly I had to return a database backup because I had lost a connection with couple of avatars and attachments.

When I go to "Admin > Forum > Attachments and Avatars > Browse Files"  i got an error 404 - Attachment Not Found
There is attachments table in the database and there so no error when I select that.




Offline aegersz

  • Sophist Member
  • *****
  • Posts: 1,185
  • Gender: Male
  • "mods" junkie
    • dopetalk
Re: Missing pictures
« Reply #48 on: January 11, 2018, 05:54:03 AM »
btw, i backup my database (mysql/InnoDB) every damn hour for 4 days on the server, clone it daily and then copy it to 2 other Intranets weekly, keep all the generations, then I rsync them to a hard drive AND Clonezilla image to another 2 hard drives !!

ABSOLUTE and TOTAL overkill but i am that precious about it.

Don't do it annually, please !

I also backup all attachments, other data and software simultaneously.

The point i am am trying to make is that you have nothing to lose with over, over, overkill.

Please devote as much time as you need to preserve your data, be it files AND database.

there is no such thing as too many backups.

my content and years in building my site must never be lost.

I hope my obsessive behaviour encourages you to avoid such personal aggravation in the future. trust noone or any single/double or even triple points of failure.
« Last Edit: January 11, 2018, 06:10:43 AM by aegersz »
SMF 2.0: 135+ mods installed (the full list can be seen at http://forum.drugs-and-users.org/index.php/topic,3301)

Offline pocttopus

  • Jr. Member
  • **
  • Posts: 191
    • @pocttopus on Twitter
Re: Missing pictures
« Reply #49 on: January 11, 2018, 07:21:13 AM »
btw, i backup my database (mysql/InnoDB) every damn hour for 4 days on the server, clone it daily and then copy it to 2 other Intranets weekly, keep all the generations, then I rsync them to a hard drive AND Clonezilla image to another 2 hard drives !!

ABSOLUTE and TOTAL overkill but i am that precious about it.

Don't do it annually, please !

I also backup all attachments, other data and software simultaneously.

The point i am am trying to make is that you have nothing to lose with over, over, overkill.

Please devote as much time as you need to preserve your data, be it files AND database.

there is no such thing as too many backups.

my content and years in building my site must never be lost.

I hope my obsessive behaviour encourages you to avoid such personal aggravation in the future. trust noone or any single/double or even triple points of failure.
I have enough backups from database and ftp files. Also I am testing on localhost just to be sure that everything will be fine on live. :)
I appreciate your opinion but I don't know how this would be helpful to solve the issue of missing attachments?  :-[
Are you referring that someone had made an attack to the forum?  ???

Maybe I had not made a good migrating to this new hosting because missing attachments are after migrating.  :-\

These are the errors and statistics:


Offline Illori

  • Project Manager
  • SMF Master
  • *
  • Posts: 48,393
Re: Missing pictures
« Reply #50 on: January 11, 2018, 07:40:16 AM »
your attachment folder, is it on the server with a lowercase a in attachments?

Offline aegersz

  • Sophist Member
  • *****
  • Posts: 1,185
  • Gender: Male
  • "mods" junkie
    • dopetalk
Re: Missing pictures
« Reply #51 on: January 11, 2018, 07:40:53 AM »
no, you are right - it isn't helpful but i was horrified when you said that your last backup was a year old !

by contrasting that to my ridiculous other extreme, i was hoping that it would help you keep many more frequent DB+file copies so you don't have to revisit this upsetting time for you.

but you are in good hands here and i hope you get the help to restore much or if not all forum intrgrity.
SMF 2.0: 135+ mods installed (the full list can be seen at http://forum.drugs-and-users.org/index.php/topic,3301)

Offline pocttopus

  • Jr. Member
  • **
  • Posts: 191
    • @pocttopus on Twitter
Re: Missing pictures
« Reply #52 on: January 11, 2018, 07:50:37 AM »
no, you are right - it isn't helpful but i was horrified when you said that your last backup was a year old !
Last backup from previous hosting is almost a year old, but not from current hosting.
I think this is misunderstanding.  :-\

by contrasting that to my ridiculous other extreme, i was hoping that it would help you keep many more frequent DB+file copies so you don't have to revisit this upsetting time for you.

but you are in good hands here and i hope you get the help to restore much or if not all forum intrgrity.
Yes, I have enough backups but this issue with attachments slipped before my eyes/fingers.  :-[

your attachment folder, is it on the server with a lowercase a in attachments?

Offline aegersz

  • Sophist Member
  • *****
  • Posts: 1,185
  • Gender: Male
  • "mods" junkie
    • dopetalk
Re: Missing pictures
« Reply #53 on: January 11, 2018, 08:23:23 AM »
oh, my mistake - that gives me hope.

it does sound like possible corruption then.

wait for Sir Osis to get back to you if illori doesn't track down the error soon.
SMF 2.0: 135+ mods installed (the full list can be seen at http://forum.drugs-and-users.org/index.php/topic,3301)

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 7,354
  • There's someone in my head but it's not me.
Re: Missing pictures
« Reply #54 on: January 11, 2018, 03:12:09 PM »
your attachment folder, is it on the server with a lowercase a in attachments?

You can rename /attachments directory, or delete it entirely, broken links will remain.  He's not seeing the links.

@pocttopus - Can you dump smf_attachments table and attach it here?

Offline pocttopus

  • Jr. Member
  • **
  • Posts: 191
    • @pocttopus on Twitter
Re: Missing pictures
« Reply #55 on: January 11, 2018, 05:26:10 PM »
your attachment folder, is it on the server with a lowercase a in attachments?

You can rename /attachments directory, or delete it entirely, broken links will remain.  He's not seeing the links.

@pocttopus - Can you dump smf_attachments table and attach it here?
Here it is: https://mega.nz/#!VpVzHJrT!PnLpVslQwmU7PeGKTMzsH8QUmgj78pTAsdXY0riyKMg

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 7,354
  • There's someone in my head but it's not me.
Re: Missing pictures
« Reply #56 on: January 12, 2018, 12:32:06 PM »
Will take a look at it tonight.

Offline pocttopus

  • Jr. Member
  • **
  • Posts: 191
    • @pocttopus on Twitter
Re: Missing pictures
« Reply #57 on: January 12, 2018, 12:59:04 PM »
Thanks @Sir Osis of Liver, you are very kind and I appreciate your dedication for help me.  :)

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 7,354
  • There's someone in my head but it's not me.
Re: Missing pictures
« Reply #58 on: January 12, 2018, 10:44:32 PM »
There are several things not quite right in your smf_attachments, but I'm not able to duplicate the problem on a test install. 

- The first 500 rows are missing file_hash, the field is blank.  These would be the 500 oldest attachments.  Deleting the field on test install does not remove link in post, it goes 404.

- There's a duplicate index, attachment_type and attachmentType, that shouldn't cause a problem.

- There's no PRIMARY index, it should be id_attach, but removing it as PRIMARY on test install does not affect attachment in post.

- As mentioned earlier, deleting the attachment from /attachments, or renaming or deleting directory, does not remove link.

Only thing I can find that deletes the link from a post is deleting id_attach for that attachment, but that column is populated in your table.  I'm also not seeing anything that would explain why new attachments are working.  Only thing I can suggest is do a clean install in another directory, copy over /attachments, connect it to the database, run repair_settings, see what you get.

Offline pocttopus

  • Jr. Member
  • **
  • Posts: 191
    • @pocttopus on Twitter
Re: Missing pictures
« Reply #59 on: January 13, 2018, 06:24:22 PM »
Thanks @Sir Osis of Liver
I will try and inform you all what happened.

Thanks again! :)