WP database error...any help? - GoFuckYourself.com

King Soil · 11-19-2006, 11:28 PM

I was adding a post to wordpress when I got this weird db error..

WordPress database error: [Got error 28 from table handler]
SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= '2006-11-20 07:04:59' AND (post_status = "publish") AND post_status != "attachment" GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 10, 10

any php or wordpress gurus able to help or lead me in the right direction?

StickyGreen · 11-19-2006, 11:29 PM

i'll holla

teksonline · 11-19-2006, 11:30 PM

that looks wrong in many ways, DISTINCT *? lol and != "attachment"?

Jace · 11-19-2006, 11:35 PM

Put this line somewhere in the wp-settings.php file (for example at the
end of the code before the do_action(init) call):

$wpdb->hide_errors();

in line 60 of wp-settings.php change to:

error_reporting(0);

King Soil · 11-19-2006, 11:36 PM

Actually I looked it up on the codex and found it. Its an error to do with a harddrive running out of space. So its on my hosts end..

King Soil · 11-19-2006, 11:57 PM

btw codex.wordpress.org is such a helpful place to visit for learning the ins and outs of WP

nofx · 11-20-2006, 12:01 AM

tell your host to check the email box

this happened to me once and an inbox apparently had like fucking 32874298347 mails and it filled up the HD like whoa...

King Soil · 11-20-2006, 12:05 AM

Quote:

Originally Posted by nofx

tell your host to check the email box

this happened to me once and an inbox apparently had like fucking 32874298347 mails and it filled up the HD like whoa...

Yeah I contacted them to clear up some space. I need to go ahead and think about a dedicated box soon for these blogs..

11-19-2006, 11:28 PM	#1
King Soil Confirmed User Join Date: Oct 2006 Posts: 195	WP database error...any help? I was adding a post to wordpress when I got this weird db error.. WordPress database error: [Got error 28 from table handler] SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= '2006-11-20 07:04:59' AND (post_status = "publish") AND post_status != "attachment" GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 10, 10 any php or wordpress gurus able to help or lead me in the right direction?

11-19-2006, 11:29 PM	#2
StickyGreen . Industry Role: Join Date: Oct 2003 Posts: 13,076	i'll holla __________________ Refer Cam Girls and Take Home 10% of Everything They Make For Life

11-20-2006, 12:01 AM	#7
nofx Too lazy to set a custom title Join Date: Nov 2002 Location: Virgin Mary's womb Posts: 16,826	tell your host to check the email box this happened to me once and an inbox apparently had like fucking 32874298347 mails and it filled up the HD like whoa... __________________ Often times I wonder why There's love and hate, theres live or die. When sickness comes I must decide: When feelings go, theres suicide.

11-19-2006, 11:30 PM	#3
teksonline So Fucking Banned Join Date: Jan 2005 Location: At My Desk Posts: 2,904	that looks wrong in many ways, DISTINCT *? lol and != "attachment"?

11-19-2006, 11:35 PM	#4
Jace FBOP Class Of 2013 Industry Role: Join Date: Jan 2004 Location: bumfuck, ky Posts: 35,562	Put this line somewhere in the wp-settings.php file (for example at the end of the code before the do_action(init) call): $wpdb->hide_errors(); in line 60 of wp-settings.php change to: error_reporting(0);

11-19-2006, 11:36 PM	#5
King Soil Confirmed User Join Date: Oct 2006 Posts: 195	Actually I looked it up on the codex and found it. Its an error to do with a harddrive running out of space. So its on my hosts end..

11-19-2006, 11:57 PM	#6
King Soil Confirmed User Join Date: Oct 2006 Posts: 195	btw codex.wordpress.org is such a helpful place to visit for learning the ins and outs of WP