mySQL problems in admin only?

well the site is called “Broken kode” rather aptly. Can you check what version of PHP and Zend you’re running? It might give you a clue if it is either of those.

The irony is NEVER lost on me every time something like this happens and it happens often for some f?￡$ked up reason. Nothing pisses me off than that. I come off as completely hysterical when sending support e-mails to my hosting company, but I really can’t help it.

Hey, Khaled, I’m a DreamHost user and am experiencing no such problems. You may want to try optimizing your MySQL database. Go to phpmyadmin, view the database structure, check all tables, and choose “Optimize” from the pulldown menu. That will both analyse and repair your tables. If that doesn’t work, try disabling all plugins. And, if that doesn’t help, contact DreamHost support, they’re very good with WordPress.

okay PHP Version 4.3.10
Zend Engine v1.3.0

I’ll try that macmanx, thanks. Disabling 26 plugins would effectively kill my website though. I’ll try the optimize function though.

PHP Version 4.3.10
Zend Engine v1.3.0

That’s exactly what I have too.

Optimised, even got rid of the BA stats data in the mysql database to make it completely clean, and still no cigar. It some times works, if I right complete rubbish, and when I copy paste a proper post, it just gives me this error:

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 ‘ve been having some serious WordPress funkiness going on, somet]
UPDATE wp_posts SET post_content = ‘I’ve been having some serious WordPress funkiness going on, something to do with mySQL and stuff. Hardly what I want to talk about today but anyway, if you see an error message, it’s not me having a laugh, just so you know. ‘, post_excerpt = ”, post_title = ‘code’, post_date_gmt = ‘2005-04-13 22:39:16’, post_date = ‘2005-4-13 22:39:16’, post_status = ‘draft’, comment_status = ‘open’, ping_status = ‘open’, post_author = ‘1’, post_password = ”, post_name = ‘code’, to_ping = ”, post_modified = ‘2005-04-13 22:39:36’, post_modified_gmt = ‘2005-04-13 22:39:36’, menu_order = ‘0’, post_parent = ‘0’ WHERE ID = 669

Warning: Cannot modify header information – headers already sent by (output started at /home/.langer/emmortel/brokenkode.com/wp-includes/wp-db.php:98) in /home/.langer/emmortel/brokenkode.com/wp-admin/post.php on line 381

Warning: Invalid argument supplied for foreach() in /home/.langer/emmortel/brokenkode.com/wp-admin/post.php on line 403

Warning: Invalid argument supplied for foreach() in /home/.langer/emmortel/brokenkode.com/wp-admin/post.php on line 409

Okay I sorted it out. I remembered that this morning I actually updated one single plugin, which the plugin creator made a big deal about that it was important to update.

Hmm now I’ve got to tell him it’s causing problems. It’s for the miniblog plugin.