white screen of death on one board

[Norv]

What was the result of the query?

That the maintenance doesn't seem to work (or is slow) might mean there's a problem with the attachments though...
Please, post the results of the following sql query:

Code Select Expand


select id_attach, approved from smf_attachments as a, smf_messages where a.id_msg = smf_messages.id_msg and smf_messages.id_topic = 5034

(replace "smf_" with your actual database prefix)

[timned88]

Error

SQL query: Documentation

SELECT id_attach, approved
FROM smf_attachments AS a, smf_messages
WHERE a.id_msg = smf_messages.id_msg
AND smf_messages.id_topic =5034
LIMIT 0 , 30

MySQL said: Documentation
#1052 - Column 'approved' in field list is ambiguous


when i ran that sql query the first time you asked awhile back, it said 10 rows affected.  the second time i tried it i got the above statement.

[Norv]

Please try instead:

Code Select Expand


select id_attach, a.approved from smf_attachments as a, smf_messages where a.id_msg = smf_messages.id_msg and smf_messages.id_topic = 5034


[timned88]

Showing rows 0 - 9 (10 total, Query took 0.0006 sec)
SQL query:
SELECT id_attach, a.approved
FROM smf_attachments AS a, smf_messages
WHERE a.id_msg = smf_messages.id_msg
AND smf_messages.id_topic =5034
LIMIT 0 , 30
Profiling
[ Edit ] [ Explain SQL ] [ Create PHP Code ] [ Refresh ]

       
row(s) starting from record #
in mode and repeat headers after cells
      
Full Texts    id_attach    approved
   Edit    Delete    13325    0
   Edit    Delete    13471    0
   Edit    Delete    13472    0
   Edit    Delete    13473    0
   Edit    Delete    13474    0
   Edit    Delete    13475    0
   Edit    Delete    13476    0
   Edit    Delete    13477    0
   Edit    Delete    13478    0
   Edit    Delete    13487    0
With selected: Check All / Uncheck All With selected: Change Delete Export

       
row(s) starting from record #
in mode and repeat headers after cells
      
Query results operations Print viewPrint view    Print view (with full texts)Print view (with full texts)    ExportExport    CREATE VIEWCREATE VIEW

[Norv]

1) Please, try removing temporarily the files attached to the problematic topic. Copying them down on your computer from FTP, to keep a copy, and then removing them or renaming them in the current location might be the way to do that. (in case you are using FileZilla, please make sure that the option "Treat files without extension as ASCII" in  Edit > Preferences > Transfer is unchecked)
The attached files are the files your ./attachments directory whose names start with each of the id_attach in your previous list: the file named 13325_something, 13471_something, 13472_something... and so on, all the 10 in your previous list. In case you are using multiple attachment directories (which is highly recommended for a forum with many attachments like yours) you might need to check the last attachment folder in your attachment folders list.
For the record, how many attachments does the last folder have?

2) Please try using the tool 'Find and repair errors' from the forum Maintenance section.
Also, can you tell, about the previously discussed 'Maintain' tool in your Attachments and avatars > File Maintenance, did it finish running in the end?

Try accessing the topic after removing attachments.
If all fails, you might want to note that, as gbsothere pointed out, removing the thread might solve the problem, and the only attachments of the topic are these 10 files referred above. So save them, and you can try reusing them in another topic, even one by one would be useful, to see if any is causing issues, and which on the contrary can be used further.
Make a database backup just in case, before.

Please eventually note that I will not be available for several hours now, but I hope it will work out just fine!

[timned88]

i made a clean install of the forum to a different directory on my server and dropped the database on top of it and the offending thread now works.  i have not reinstalled any mods, changes, attachments or anything.

[Norv]

Well, I hope you don't need to do that, just try to remove the attachments from that one thread.

But sure, continue as you wish, please, let us know how it goes.

[timned88]

Out of curiosity, what makes you think it's an attachment
and not a mod?   Trying to understand.  Thanks again for all your help- I created the duplicate forum just for kicks- not planning on doing the whole thing over if I can avoid it.  At least it's not a database issue. 

[Norv]

Out of experience, image attachments that are corrupted in some way may lead to this 'white screen of death' when PHP attempts to read or display them. Not having the webserver logs with the cause of PHP crashing, I cannot tell if it is the case here or not, so it's simply possible. Also, it is hard to conceive that a mod has this result on only one topic, and no others, while in case it's a particular attachment of a post in this topic, then it's easier to understand.
However, I am not saying a corrupted attachment is the cause, I am saying it seems a higher probability explanation, and I think it's worth checking, and eliminating (if it will prove false).

There are 10 attachments in that thread, those whose names start with the ids listed before. Removing them temporarily from the location they're in will at least ensure PHP is not reading them at all, thus they don't interfere in any way.

[timned88]

Thanks for the great explanation.  I will give it a shot in a little bit.

[timned88]

norv, you are good!  i was able is isolate the problem to where a member had attached a full-sized attachment instead of a scaled down attached.  my guess is that rendering the full-sized image caused a timeout of some sort which crashed the page.  thanks for your patience and persistance, much appreciated.

[Norv]

Cheers! good to hear you got to the bottom of it!
Surely, simply removing that particular attachment or otherwise edit it before re-adding it in the attachments folder will allow the topic to be viewed normally now?

In any case, please feel free to mark the topic as solved using the green link at the bottom-left of the page, in case you will consider it solved.

[timned88]

yup, i removed the attachment, resized and reuploaded it and we are in business.  this happened in another thread and i was able to quickly resolve that issue as well.   THANK YOU!   THANK YOU!   THANK YOU!   THANK YOU!   THANK YOU!