Wordpress Internal Server Errors

wordpress

#1

Our site wordpress has been down for 2 days with 500 Internal server errors. It has been happening off and over the last 2 weeks. Other sites and html pages are working fine.

DH support sent us this
http://wiki.dreamhost.com/index.php/Finding_Causes_of_Heavy_Usage

We identified that php.cgi seems to be the offending script and located at dh/cgi-system/php/cgi

The traffic load is as usual and the site is still running due to supercache cached pages. Dreamhost staff is not able to figure out the cause of sudden corruption of this script.They have not been able to fix the server errors

Can anyone please advise. Thanks.

Quick Online Tips
Technology News, Blogging Tips and Web 2.0


#2

I have this problem as of today. All of the Wordpress based sites and the forum have File 500 errors. My plain html site is fine.

I checked the link provided above (“Finding Causes of Heavy Usage”) but I haven’t a clue what it is telling me (enter command where?). I have looked at one of the error logs but, again, I don’t know how to interpret what I am reading.

HR (aka Paula O.)

writer me - http://paulaoffutt.com
blogging fool me - http://paulaoffutt.com/blog/
my dawg - http://mike.holyroller.org


#3

Same issue here. Have reported multiple times to DreamHost staff without resolution.


#4

If I only knew where the fault lay. With Dreamhost script error? With WP or phpBB? I can get my ZenPhoto to load. But nothing else.

I sent in a tech assist form earlier today. Hopefully, I’ll hear soon. Meanwhile, I’m going to have to make a “Site Down” page so folks won’t think it is a problem on their end.

HR (aka Paula O.)

writer me - http://paulaoffutt.com
blogging fool me - http://paulaoffutt.com/blog/
my dawg - http://mike.holyroller.org


#5

I’m getting the same thing. Lots of 505 and Internal Server errors. I’m on the giancana server.


#6

Have you blokes customised anything?

Maximum Cash Discount on any plan with MAXCASH

How To Install PHP.INI / ionCube on DreamHost


#7

Anything as in what?

I just tried the .htaccess or whatever modifications according to the link above. (added in several IP addresses I got from the error log)

I also bumped the server resources, too. (which has promptly been exceeded again!)

I dumped SpamKarma’s logs and spams.

I put in a robots.txt file

I haven’t sacrificed any virginal chickens yet, though.

HR (aka Paula O.)

writer me - http://paulaoffutt.com
blogging fool me - http://paulaoffutt.com/blog/
my dawg - http://mike.holyroller.org


#8

Check procs (top), cgi permissions, .htaccess, caching, recently modified files.

Maximum Cash Discount on any plan with MAXCASH

How To Install PHP.INI / ionCube on DreamHost


#9

What is procs? Processes? How do I check those?

I blocked some IPs via the .htaccess already.

No files have been changed just prior to this. Everything was working fine, actually.

The resource/memory usage dropped from 493mb to just over 100mb finally so something changed.

But I still have Internal Error messages.

I haven’t checked the error logs yet today.

HR (aka Paula O.)

writer me - http://paulaoffutt.com
blogging fool me - http://paulaoffutt.com/blog/
my dawg - http://mike.holyroller.org


#10

My membership site curetinnitus.org is down with a 500 internal server error, which was first a database error (connection to DB), and then the error message changed. The site is a growing membership site, and I am using wordpress with a few plugins and a fairly common template.

Here is the last bit of my log file:

[Fri Apr 03 00:36:31 2009] [error] [client 64.1.215.163] Premature end of script headers: php.cgi
[Fri Apr 03 00:37:30 2009] [error] [client 91.205.124.7] Premature end of script headers: php.cgi
[Fri Apr 03 05:08:03 2009] [error] [client 91.115.170.142] Premature end of script headers: php.cgi, referer: http://www.curetinnitus.org/community/wp-admin/page.php?action=edit&post=865&message=4
[Fri Apr 03 05:08:59 2009] [error] [client 66.249.71.107] ADODB Error: Can’t connect to MySQL server on ‘mysql.curetinnitus.org’ (4)
[Fri Apr 03 05:10:03 2009] [error] [client 91.115.170.142] Premature end of script headers: php.cgi, referer: http://www.curetinnitus.org/community/wp-admin/page.php?action=edit&post=865&message=4
[Fri Apr 03 06:46:57 2009] [error] [client 71.222.175.34] 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 ‘(wp_posts.post_status = ‘publish’) ) AND (ID NOT IN ( 662,666,2,670,692,734,743,’ at line 1 for query SELECT SQL_CALC_FOUND_ROWS wp_posts., wp_sticky.sticky_status FROM wp_posts LEFT JOIN wp_sticky ON wp_sticky.sticky_post_id = wp_posts.ID WHERE 1=1 AND ( wp_posts.ID NOT IN (349,315,320,309,300,222,209,198,196,194,192,190,188,186,184,182,180,178,176,174,172,170,168,166,164,162,160,158,156,154,152,150,148,146,144,141,139,137,135,132,130,125,121,118,116,109,107,104,100,75,77,79,81,49,48,47,45,43,40,37,31,33,28,25,22,20,15,13,11,9,240,399,385,383,384,381,382,380,366,363,364,362,360,361,359,356,578,576,574,566,565,488,468,452,440,437,433,402,401,400,4,572,588,600,603,607,619,628,635,637,639,641,643,652,662,692,698,705,715,720,790,833,836,852) AND wp_posts.ID NOT IN ( SELECT tr.object_id FROM wp_term_relationships AS tr INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy = ‘category’ AND tt.term_id IN (‘179’, ‘207’, ‘180’, ‘204’, ‘205’, ‘206’, ‘182’, ‘183’, ‘184’, ‘199’, ‘200’, ‘201’, ‘202’, ‘203’, ‘180’, ‘182’, ‘183’, ‘184’) ) AND wp_posts.(wp_posts.post_status = ‘publish’) ) AND (ID NOT IN ( 662,666,2,670,692,734,743,793,865 )) ORDER BY (wp_sticky.sticky_status = 2 AND wp_sticky.sticky_status IS NOT NULL) DESC, DATE_FORMAT(wp_posts.post_date,’%Y-%m-%d’) DESC, (wp_sticky.sticky_status = 1 AND wp_sticky.sticky_status IS NULL) DESC, DATE_FORMAT(wp_posts.post_date,’%T’) DESC LIMIT 0, 5 made by require, require_once, include, get_footer, locate_template, load_template, require_once, get_sidebar, locate_template, load_template, require_once, dynamic_sidebar, call_user_func_array, widget_logic_redirected_callback, call_user_func_array, wp_widget_recent_entries, wp_query->wp_query, wp_query->query, wp_query->get_posts, referer: http://www.curetinnitus.org/join-us/
[Fri Apr 03 06:49:42 2009] [error] [client 71.222.175.34] 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 ‘(wp_posts.post_status = ‘publish’) ) AND (ID NOT IN ( 662,666,2,670,692,734,743,’ at line 1 for query SELECT SQL_CALC_FOUND_ROWS wp_posts.
, wp_sticky.sticky_status FROM wp_posts LEFT JOIN wp_sticky ON wp_sticky.sticky_post_id = wp_posts.ID WHERE 1=1 AND ( wp_posts.ID NOT IN (349,315,320,309,300,222,209,198,196,194,192,190,188,186,184,182,180,178,176,174,172,170,168,166,164,162,160,158,156,154,152,150,148,146,144,141,139,137,135,132,130,125,121,118,116,109,107,104,100,75,77,79,81,49,48,47,45,43,40,37,31,33,28,25,22,20,15,13,11,9,240,399,385,383,384,381,382,380,366,363,364,362,360,361,359,356,578,576,574,566,565,488,468,452,440,437,433,402,401,400,4,572,588,600,603,607,619,628,635,637,639,641,643,652,662,692,698,705,715,720,790,833,836,852) AND wp_posts.ID NOT IN ( SELECT tr.object_id FROM wp_term_relationships AS tr INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy = ‘category’ AND tt.term_id IN (‘179’, ‘207’, ‘180’, ‘204’, ‘205’, ‘206’, ‘182’, ‘183’, ‘184’, ‘199’, ‘200’, ‘201’, ‘202’, ‘203’, ‘180’, ‘182’, ‘183’, ‘184’) ) AND wp_posts.(wp_posts.post_status = ‘publish’) ) AND (ID NOT IN ( 662,666,2,670,692,734,743,793,865 )) ORDER BY (wp_sticky.sticky_status = 2 AND wp_sticky.sticky_status IS NOT NULL) DESC, DATE_FORMAT(wp_posts.post_date,’%Y-%m-%d’) DESC, (wp_sticky.sticky_status = 1 AND wp_sticky.sticky_status IS NULL) DESC, DATE_FORMAT(wp_posts.post_date,’%T’) DESC LIMIT 0, 5 made by require, require_once, include, get_footer, locate_template, load_template, require_once, get_sidebar, locate_template, load_template, require_once, dynamic_sidebar, call_user_func_array, widget_logic_redirected_callback, call_user_func_array, wp_widget_recent_entries, wp_query->wp_query, wp_query->query, wp_query->get_posts, referer: http://www.curetinnitus.org/join-us/
[Fri Apr 03 06:49:54 2009] [error] [client 71.222.175.34] 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 ‘(wp_posts.post_status = ‘publish’) ) AND (ID NOT IN ( 662,666,2,670,692,734,743,’ at line 1 for query SELECT SQL_CALC_FOUND_ROWS wp_posts., wp_sticky.sticky_status FROM wp_posts LEFT JOIN wp_sticky ON wp_sticky.sticky_post_id = wp_posts.ID WHERE 1=1 AND ( wp_posts.ID NOT IN (349,315,320,309,300,222,209,198,196,194,192,190,188,186,184,182,180,178,176,174,172,170,168,166,164,162,160,158,156,154,152,150,148,146,144,141,139,137,135,132,130,125,121,118,116,109,107,104,100,75,77,79,81,49,48,47,45,43,40,37,31,33,28,25,22,20,15,13,11,9,240,399,385,383,384,381,382,380,366,363,364,362,360,361,359,356,578,576,574,566,565,488,468,452,440,437,433,402,401,400,4,572,588,600,603,607,619,628,635,637,639,641,643,652,662,692,698,705,715,720,790,833,836,852) AND wp_posts.ID NOT IN ( SELECT tr.object_id FROM wp_term_relationships AS tr INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy = ‘category’ AND tt.term_id IN (‘179’, ‘207’, ‘180’, ‘204’, ‘205’, ‘206’, ‘182’, ‘183’, ‘184’, ‘199’, ‘200’, ‘201’, ‘202’, ‘203’, ‘180’, ‘182’, ‘183’, ‘184’) ) AND wp_posts.(wp_posts.post_status = ‘publish’) ) AND (ID NOT IN ( 662,666,2,670,692,734,743,793,865 )) ORDER BY (wp_sticky.sticky_status = 2 AND wp_sticky.sticky_status IS NOT NULL) DESC, DATE_FORMAT(wp_posts.post_date,’%Y-%m-%d’) DESC, (wp_sticky.sticky_status = 1 AND wp_sticky.sticky_status IS NULL) DESC, DATE_FORMAT(wp_posts.post_date,’%T’) DESC LIMIT 0, 5 made by require, require_once, include, get_footer, locate_template, load_template, require_once, get_sidebar, locate_template, load_template, require_once, dynamic_sidebar, call_user_func_array, widget_logic_redirected_callback, call_user_func_array, wp_widget_recent_entries, wp_query->wp_query, wp_query->query, wp_query->get_posts, referer: http://www.curetinnitus.org/?s=neuromonicx
[Fri Apr 03 07:29:50 2009] [error] [client 91.115.170.142] 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 ‘(wp_posts.post_status = ‘publish’) ) AND (ID NOT IN ( 662,666,2,670,692,734,743,’ at line 1 for query SELECT SQL_CALC_FOUND_ROWS wp_posts.
, wp_sticky.sticky_status FROM wp_posts LEFT JOIN wp_sticky ON wp_sticky.sticky_post_id = wp_posts.ID WHERE 1=1 AND ( wp_posts.ID NOT IN ( SELECT tr.object_id FROM wp_term_relationships AS tr INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy = ‘category’ AND tt.term_id IN (‘179’, ‘207’, ‘180’, ‘204’, ‘205’, ‘206’, ‘182’, ‘183’, ‘184’, ‘199’, ‘200’, ‘201’, ‘202’, ‘203’, ‘180’, ‘182’, ‘183’, ‘184’) ) AND wp_posts.(wp_posts.post_status = ‘publish’) ) AND (ID NOT IN ( 662,666,2,670,692,734,743,793,865 )) ORDER BY (wp_sticky.sticky_status = 2 AND wp_sticky.sticky_status IS NOT NULL) DESC, DATE_FORMAT(wp_posts.post_date,’%Y-%m-%d’) DESC, (wp_sticky.sticky_status = 1 AND wp_sticky.sticky_status IS NULL) DESC, DATE_FORMAT(wp_posts.post_date,’%T’) DESC LIMIT 0, 5 made by require, require_once, include, get_footer, locate_template, load_template, require_once, get_sidebar, locate_template, load_template, require_once, dynamic_sidebar, call_user_func_array, widget_logic_redirected_callback, call_user_func_array, wp_widget_recent_entries, wp_query->wp_query, wp_query->query, wp_query->get_posts, referer: http://www.curetinnitus.org/ask-the-experts/
[Fri Apr 03 07:37:13 2009] [error] [client 91.115.170.142] Premature end of script headers: php.cgi, referer: http://www.curetinnitus.org/community/wp-admin/page.php?action=edit&post=865&message=4
[Fri Apr 03 08:37:05 2009] [error] [client 71.222.175.34] 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 ‘(wp_posts.post_status = ‘publish’) ) AND (ID NOT IN ( 662,666,2,670,692,734,743,’ at line 1 for query SELECT SQL_CALC_FOUND_ROWS wp_posts.*, wp_sticky.sticky_status FROM wp_posts LEFT JOIN wp_sticky ON wp_sticky.sticky_post_id = wp_posts.ID WHERE 1=1 AND ( wp_posts.ID IN (3,666,0,54,239,295,296,297,298,757,610,241,64,203,2,670,734,743,793,865,779,812,831,52,593,660,661,717,722,758,862,692,607,572,4,790,836,833,603,639,628,578,11,9,240,49,48,47,45,43,40,37,31,33,28,25,22,20,15,13,135,132,130,125,121,118,116,109,107,104,100,75,77,79,81,166,164,162,160,158,156,154,152,150,148,146,144,141,139,137,196,194,192,190,188,186,184,182,180,178,176,174,172,170,168,363,364,362,360,361,359,356,349,315,320,309,300,222,209,198,452,440,437,433,402,401,400,399,385,383,384,381,382,380,366,619,600,588,576,574,566,565,488,468,720,715,705,698,652,643,641,637,635,852) AND wp_posts.ID NOT IN ( SELECT tr.object_id FROM wp_term_relationships AS tr INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy = ‘category’ AND tt.term_id IN (‘179’, ‘207’, ‘180’, ‘204’, ‘205’, ‘206’, ‘182’, ‘183’, ‘184’, ‘199’, ‘200’, ‘201’, ‘202’, ‘203’, ‘180’, ‘182’, ‘183’, ‘184’) ) AND wp_posts.(wp_posts.post_status = ‘publish’) ) AND (ID NOT IN ( 662,666,2,670,692,734,743,793,865 )) ORDER BY (wp_sticky.sticky_status = 2 AND wp_sticky.sticky_status IS NOT NULL) DESC, DATE_FORMAT(wp_posts.post_date,’%Y-%m-%d’) DESC, (wp_sticky.sticky_status = 1 AND wp_sticky.sticky_status IS NULL) DESC, DATE_FORMAT(wp_posts.post_date,’%T’) DESC LIMIT 0, 5 made by require, require_once, include, get_footer, locate_template, load_template, require_once, get_sidebar, locate_template, load_template, require_once, dynamic_sidebar, call_user_func_array, widget_logic_redirected_callback, call_user_func_array, wp_widget_recent_entries, wp_query->wp_query, wp_query->query, wp_query->get_posts, referer: http://www.curetinnitus.org/has-anyone-found-tinnitus-relief-from-vitamin-b12-and-folic-acid-just-starting-it-from-hearsay/
[Fri Apr 03 10:09:10 2009] [error] [client 66.249.71.107] Premature end of script headers: php.cgi
[Fri Apr 03 11:57:29 2009] [error] [client 68.112.172.91] ADODB Error: Can’t connect to MySQL server on ‘mysql.curetinnitus.org’ (4)
[Fri Apr 03 12:37:03 2009] [error] [client 66.249.71.107] ADODB Error: Can’t connect to MySQL server on ‘mysql.curetinnitus.org’ (4)

I am starting to get donations and members are relying on this site. Please help me ensure uptime.

Best,
Dainis


#11

The second I posted, the site came back online. My other sites like dainis.info go down too, when this happens. Please advise as to how to ensure uptime, because the sites were down for a few hours. That’s just not OK for my member community.

Best,
Dainis


#12

I have this same problem. I have put in a robots.txt to to block those constant crawls, banned spam IP addresses as they come, trouble shot plugins, installed WP Super Cache, etc, etc. I’ve done what is suggested and I still get 500 Internal Server Errors (as well as the occasional 503 error). Nothing I do seems to fix the problem and I’m told time and time again that I need to move to a private server. I don’t get THAT much traffic, so it’s all rather vexing.


#13

My sites are all back up. It seems the combination of stuff finally worked. Either that or the virginal chicken sacrifice worked.

I did, however, find several THOUSAND spam that hit during a +/- 24hr window on one of the sites. Of course, this was after the site was back up.

http://paulaoffutt.com/blog/2009/04/oy-what-happened/

Check the database for the comment/spam table (depends on what plugin you use as to what it is called). I dumped all of mine (kept the blacklists). Some of them were over 5 yrs old. I did NOT dump the comments, just the ones SpamKarma was holding onto.

Also, hit refresh after you’ve done everything else. I thought mine were still down then did a reload/refresh and there it was.

HR (aka Paula O.)

writer me - http://paulaoffutt.com
blogging fool me - http://paulaoffutt.com/blog/
my dawg - http://mike.holyroller.org


#14

I’m experiencing the same thing now, it’s just a basic wordpress site, nothing fancy and nothing has been changed except for the fact that i just did one post last night, when I checked it this morning it just gave the “500 Internal Server Error message”

I tried changing permissions for php files & folders to 755, similiar to what the wiki (http://wiki.dreamhost.com/Internal_Server_Error) says, but still nothing…

Anybody here has this same error too?


#15

I definitely have this same error with a WordPress-like software called Omeka. It’s driving me nuts.


#16

Hey, it turns out that changing the permissions helped get rid of the errors – I chmodded everything to 755 and that worked.

Of course, this sucks, because it breaks the workaround I had developed so that I could create individual FTP users who only had access to one directory of the site. I was creating one UNIX group per user, assigning that group as group owner of a particular directory, then making a symlink in the users home directory. Worked like a charm, but it required 775 permissions on the directory. Now I guess I’ll have to either deny everyone FTP access or let everyone have access to the whole dang site using the same login.