News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

white screen of death on one board

Started by timned88, September 05, 2009, 01:46:26 AM

Previous topic - Next topic

timned88

http://www.themagicinpixels.com/forum/index.php?topic=5034.0

is giving me a white screen of death.  as far as i know, there are no other boards with that problem.  the main forum is working fine and people are posting up a storm.  i have no idea why that particular page is giving me an issue.  i split it off the end of another thread that was working properly to isolate the problem (ie. pages 1-6 of that thread where fine, page 7 came up white screen of death).

here are the error log entries for that particular board... any help would be much appreciated.

http://www.themagicinpixels.com/forum/index.php?topic=5034.0
8: Undefined index: topbottom4
File: /home/themagic/public_html/forum/Sources/Subs.php
Line: 3961

http://www.themagicinpixels.com/forum/index.php?topic=5034.0
8: Undefined index: enableShoutBox
File: /home/themagic/public_html/forum/Themes/default/Display.template.php (body_above sub template - eval?)
Line: 514


line 3961 in subs.php reads:
return '<img src="' . $settings['images_url'] . '/buttons/' . $name . '" alt="' . $txt[$alt] . '" ' . $custom . ' />' . ($label != '' ? '<b>' . $txt[$label] . '</b>' : '');


line 514 in display.template.php reads:
// How about... even... remove it entirely?!

PLEASE HELP!

tyty1234

Here's what you should do.

Download this mod, delete those two errors, go back to the page where the errors came from, and go back into your error log. Tell me the errors you get afterwards. :)
My Activity: Inactive
My Links: tyty1234's SMF Site | SMF Package Parser | SMF Helper | My Mods [5]
Subscribe to my SMF blog for updates
PMs for support will not be accepted, unless requested otherwise.

Norv

#2
Please post as attachment here your file index.template.php (from ./Themes/{your_theme} directory, if any, or from ./Themes/default directory otherwise).

Does the thread's posts have attachments?
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

timned88

Quote from: tyty1234 on September 05, 2009, 04:21:43 AM
Here's what you should do.

Download this mod, delete those two errors, go back to the page where the errors came from, and go back into your error log. Tell me the errors you get afterwards. :)


same error messages as before... with this one now as well...

http://www.themagicinpixels.com/forum/index.php?topic=5034.0
8: Undefined index: enableShoutBox
File: /home/themagic/public_html/forum/Themes/default/index.template.php
Line: 514

http://www.themagicinpixels.com/forum/index.php?topic=5034.0
8: Undefined index: topbottom4
File: /home/themagic/public_html/forum/Sources/Subs.php
Line: 3961

http://www.themagicinpixels.com/forum/index.php?topic=5034.0
8: Undefined index: enableShoutBox
File: /home/themagic/public_html/forum/Themes/default/Display.template.php (body_above sub template - eval?)
Line: 514

timned88

Quote from: Norv on September 05, 2009, 06:51:45 AM
Please post as attachment here your file index.template.php (from ./Themes/{your_theme} directory, if any, or from ./Themes/default directory otherwise).

Does the thread's posts have attachments?

here is the file you requested...  i am sure there are attachments in that thread.  it is a photo forum so that sounds likely.  thanks for your help.


Norv

#5
The errors with undefined indexes, like the ones you listed above, could be fixed. In order to do that, can you please tell, did you have a ShoutBox installed, and which that was? Is it still installed?

However, I doubt these little errors have something to do with the white page on that thread. Rather, it is possible that one or more of the attachments to the posts in that thread got corrupted or otherwise leading PHP into troubles. An option to discover which that (or those) pictures is to try checking Admin > Attachments and avatars > Browse Attachments.
Alternatively, try from the File Maintenance tab, 'Maintain'.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

timned88

i have ajax chat installed, not a shoutbox.  not really sure where that came from as i don't recall ever installing shoutbox.

timned88

as far as i can tell, there are no corrupted attachments in that thread.

Norv

To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

timned88

hi norv, i tried the file that you gave me and it did not work.  same result as before.

here are the new error messages:

   

http://www.themagicinpixels.com/forum/index.php?topic=5034.0
8: Undefined index: topbottom4
File: /home/themagic/public_html/forum/Sources/Subs.php
Line: 3961
   
http://www.themagicinpixels.com/forum/index.php?topic=5034.0
8: Undefined index: smf251
File: /home/themagic/public_html/forum/Sources/Subs.php
Line: 3961
   
http://www.themagicinpixels.com/forum/index.php?topic=5034.0
8: Undefined index: action
File: /home/themagic/public_html/forum/Sources/Load.php
Line: 1330
   
http://www.themagicinpixels.com/forum/index.php?http://www.themagicinpixels.com/forum/
8: Undefined index: action
File: /home/themagic/public_html/forum/Sources/Load.php
Line: 1330

Norv

Actually it seems you have no more errors in Display.template.php, which were the ones that the file could fix. :)

Please post as attachment also ./Sources/Subs.php, ./Sources/Load.php, ./Themes/default/Modifications.english.php. Is your forum language english, or english-utf8 ?

On another note: could you please find and post the webserver's error log? It could be in your host's cpanel.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

timned88

there are no cpanel errors for this.  the forum is english, not uft-8
here are the files that you requested:


Norv

The first two errors seem related to the mod: http://custom.simplemachines.org/mods/index.php?mod=2053
Perhaps you could uninstall it for now, and see if it still happens.

The last is very curious, and I'm not sure what lead to it. Are you sure logging is enabled for the webserver errors, or, in case you are choosing the errors to post, please consider that anything that may put PHP in trouble might be related. A blank page can be due to the PHP engine crashing, and there should be a trace of it.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

timned88

ok, i removed the go up mod but still getting the white screen!  here are the newest error messages!

http://www.themagicinpixels.com/forum/index.php?topic=5034.0
Undefined index: enableShoutBox
File: /home/themagic/public_html/forum/Themes/default/index.template.php
Line: 514
   
http://www.themagicinpixels.com/forum/index.php?topic=5034.0
8: Undefined variable: i
File: /home/themagic/public_html/forum/Themes/default/index.template.php
Line: 739
   
http://www.themagicinpixels.com/forum/index.php?topic=5034.0
8: Undefined index: action
File: /home/themagic/public_html/forum/Sources/Load.php
Line: 1330

http://www.themagicinpixels.com/forum/index.php?http://www.themagicinpixels.com/forum/
8: Undefined index: enableShoutBox
File: /home/themagic/public_html/forum/Themes/default/index.template.php
Line: 514
   
http://www.themagicinpixels.com/forum/index.php?http://www.themagicinpixels.com/forum/
8: Undefined variable: i
File: /home/themagic/public_html/forum/Themes/default/index.template.php
Line: 739
   
http://www.themagicinpixels.com/forum/index.php?http://www.themagicinpixels.com/forum/
8: Undefined index: action
File: /home/themagic/public_html/forum/Sources/Load.php
Line: 1330
   
http://www.themagicinpixels.com/forum/index.php?action=admin;area=logs;sa=errorlog;desc
8: Undefined index: enableShoutBox
File: /home/themagic/public_html/forum/Themes/default/index.template.php
Line: 514
   
http://www.themagicinpixels.com/forum/index.php?action=admin;area=logs;sa=errorlog;desc
8: Undefined variable: i
File: /home/themagic/public_html/forum/Themes/default/index.template.php
Line: 739

Norv

Can you please tell, are you by any chance using again the original ./Themes/default/index.template.php file? Post it here.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

timned88

i did try it with a clean version of index.template.php straight from the large installer.  still no dice.

Norv

Please try, in phpmyadmin or another database management tool offered by your host, this SQL code:

update smf_attachments as a, smf_messages set a.approved = 0 where a.id_msg = smf_messages.id_msg and smf_messages.id_topic = 5034

(replace "smf_" with your actual database prefix).
then, try to see the topic as guest.
The above code attempts to set all attachments in that particular topic as not-approved, thus as guest one should be able to access the topic without displayed attachments.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

gbsothere

*watching and trying to learn*


I wonder if just deleting that topic you split off (topic=5034.0, pages 7...) would right things?  But, since it's a photo site, I would suppose you'd rather save it, if you can.
My apologies, but I am taking a break from accepting PM requests for support.  If I am not currently assisting you, please do not ask as long as this notice is posted.  Thank you.

I Don't Want To Grow Old Alone


It has been proven that Steely Dan reduces the occurrence of road rage, according to an independent study.



A reminder about admin / ftp passwords etc.

Norv

Quote from: gbsothere on September 05, 2009, 05:39:45 PM
I wonder if just deleting that topic you split off (topic=5034.0, pages 7...) would right things?  But, since it's a photo site, I would suppose you'd rather save it, if you can.
Quite surely it would, though I hope we can get to the bottom of this with a minimum of losses. I would actually try to separate the attached images (put them elsewhere), for the moment, but that's a little difficult to explain, and the Browse attachments interface is not that refined...
Though, perhaps running its Attachments and Avatars > File Maintenance > Maintain tool will help.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

timned88

the sql query did not work.  i tried the file maintenance thing and i just kept spinning in circles not appeared to do anything.  just kept counting down, refreshing, but never got past 1%.  i let it run for a few mins like that.

i do thank you for your patience with this.  hopefully the end is in sight!

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:

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)
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

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

#22
Please try instead:

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

To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

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!
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

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.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

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.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

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.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

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!   

Advertisement: