0

enter image description here

The problem we are experiencing is very new to us. We did not experience this ever before with our website or with our web server (in last 8 years). Just recently for last 2 week we have this issue and it happened over 3 times.

Problem Description

Our site is experiencing "White Screen of Death". We do not see any error. Please see screenshot for better understanding. its just that. The site just tries to load but cannot.

enter image description here

Findings : what we have done to fix this

We can fix it (temporarily) if we reboot the server (restarting the whole virtual machine).

But this is not a viable solution . As we have other Wordpress and non-Wordpress websites in that server which does not have that issue. And rebooting the server means all sites in the server are down for 5-10 minutes. After rebooting the server site comes back and works fine as usual.

But This problem occurred at least 3 times since last week. We cannot replicate the error by clicking on any page. There is no particular time of the day when this happens.

Further information

The only significant change we can think of is upgrading the PHP version for the site from 5.3 to 7.2 in our web server. FYI we have upgraded the PHP version last month. And for approximately 3 weeks we have not seen this or any other issue. The wordpress version of the site is 4.9.1

Webserver - Apache

Database - My SQL 5.1.7

We have plenty free disk space in the server

We have tried to look in to the error log at the time of the problem . but we could not find any thing relevant. This is the error we could see on error log. Although I didn't think it was the issue but I have corrected the SQL query mentioned in the error log. But we have faced the same issue again today.

I can see the following log files from my cpanel

Webserver error log enter image description here Web server ssl error log enter image description here

web server transfer log enter image description here

webserver ssl transfer log enter image description here

[Tue Apr 23 13:48:35 2019] [error] [client 101.180.145.79] FastCGI: server "/var/run/psychicf-remi-safe-php72.fcgi" stderr: PHP message: WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY number DESC' at line 1 for query SELECT * FROM  view_site_numbers WHERE campaign_id = "7" AND `use` = "PPC" LIMIT 2 ORDER BY number DESC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/psychicFuture/css/content-all-horoscopes.php'), get_header, locate_template, load_template, require_once('/themes/psychicFuture/header.php'), do_shortcode, preg_replace_callback, do_shortcode_tag, get_prs_number_register, referer: https://thehoroscopejunkie.ca/weekly_horoscopes.html

PHP Compatibility checker plugin showing the following error enter image description here I do not know where to look at. Can you please advice ?

Improve this question
3
  • Welcome to WordPress Stack Exchange. We love to help. Questions that are too localized (such as syntax errors, code with restricted access, hacked sites, hosting or support issues) are not in scope. Many thanks – leymannx May 1 '19 at 8:39
  • @leymannx : I asked this question in "stackoverflow" and they suggested me to ask here. . I just need advice on which area i should focus on to resolve this issue. At this moment I am totally blank. – Bashabi May 1 '19 at 8:46
  • I'd recommend to ask this here: webmasters.stackexchange.com. – leymannx May 1 '19 at 9:00
1

I don't think this can provide a solution but hopefully I can help you troubleshoot a little.

Firstly, let's go over debugging:

Debugging

You're saying "white screen of death", but the screenshot you provided looks more like it's hanging while trying to load the page. Typically, the WSOD appears as exactly that - a completely blank page. Your screenshot shows the default "New Tab" view and a loading spinner, suggesting that the server is not responding.

If you leave this page "loading" for a bit of time (several minutes at least), do you get any kind of error? Usually, Chrome will eventually kick in with a message like "Too many redirects" or something similar when it finally gives up or does it actually finally fail with a white screen?

wp-admin and White Screen

If it is a white screen, what do you get when trying to go to /wp-admin/? This is important, because WordPress will surface some debugging-related information if there is a problem in your installation's database setup when you access /wp-admin/ that would otherwise not appear on the front-end.

WordPress debug log

WordPress also includes internal debugging that is disabled by default. In your question, you note that you checked the error logs, but didn't specify which ones. It could be helpful to do the following:

  • Add these lines to wp-config.php:
define( 'WP_DEBUG', true );
define( 'WP_DEBUG_LOG', true );

This will enable debug logging to the file /wp-content/debug.log. Try loading your site again and waiting until the load fails (server timeout, too many redirects, etc). Check the log to see if you find any errors

The SQL Error

While likely not the cause of your issues, the SQL error can be easily handled. Your custom query should have the LIMIT statement after the ORDER BY clause:

SELECT * FROM  view_site_numbers WHERE campaign_id = "7" AND `use` = "PPC"  ORDER BY number DESC LIMIT 2

Further investigation

As others have noted, it may be worth looking at stackoverflow.com for more help, as the issue definitely "feels" server-related. You said you recently upgraded your PHP version - it might not hurt to see if you can downgrade and see if the issue persists, however, I can't think of anything off the top of my head that might cause an issue like this (if it is infinite loading and not a direct white screen).

Also, given that it only happens intermittently, makes me think it's less to do with the application code than something going on with the server itself. If you have access to access logs you could check for DDOS attempts. You should also check your processes to see if anything is leaking and eating more and more memory without being properly stopped, or just running forever and eating away at your CPU.

Good luck!

Improve this answer
2
  • Thank you for the detailed answer. We have not actually waited to long enough to see what error message we get. I am not sure "White screen of death" is the right term for this problem or not. When this problem occurs i cannot access wp-admin. I face same issue with loading. We are planning to upgrade the wordpress version today. If this doesn't solve the issue I will leave the debug mode on. Or downgrade the PHP version. But this problem occured nearly after 3 weeks of PHP upgrade. So We are confused in that area as well. I have corrected the SQL query although I dont think its relavant – Bashabi May 2 '19 at 9:28
  • I will forward your answer to our server administrator. As our sites are self hosted. Thank you so much . – Bashabi May 2 '19 at 9:30
0

I'd recommend updating WP, and all themes and plugins to current versions. And you might check the version of PHP actually being used. (create a template and replace the 'loop' with a phpinfo() function, or look via your hosting cpanel).

Perhaps the 'fastcgi' option is not good for your site, so try going back to 'regular' PHP 7.x.

The error log should give you more info, but you mentioned already looking there. Your hosting support might be helpful. (If you have hosting for your site; although it appears you are self-hosted.)

Improve this answer
3
  • Thank you for your reply. We are upgrading the wordpress version today. To see if that solves the problem. if not we are going to downgrade the PHP version. Our websites are self hosted. I will forward this answer to our server engineer – Bashabi May 2 '19 at 9:07
  • As a note: I have several WP sites on a hosted platform running PPH 7.x, FastCGI seems to work better, especially if you have a site with higher volume. But I update everything on all my sites; using the "Infinite WP" plugin that allows me to monitor multiple sites, and update all of them with one click. (Recommended if you manage multiple sites. Great program for managing multiple sites..) It would be useful to others if you post your ultimate solution here. – Rick Hellewell May 2 '19 at 20:52
  • Thank you Rick for your answer. We still do not know what is causing the issue. Once I have the answer I sure will post the answer here. – Bashabi May 3 '19 at 8:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.