crashnet

make sure to substitute “Prefix_” for your WP table Prefix, if you use one. Collation and DB Engine should be pretty similar to the ones below across the board.

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

CREATE TABLE IF NOT EXISTS <code>Prefix_commentmeta</code> (
  <code>meta_id</code> bigint(20) unsigned NOT NULL auto_increment,
  <code>comment_id</code> bigint(20) unsigned NOT NULL default '0',
  <code>meta_key</code> varchar(255) default NULL,
  <code>meta_value</code> longtext,
  PRIMARY KEY  (<code>meta_id</code>),
  KEY <code>comment_id</code> (<code>comment_id</code>),
  KEY <code>meta_key</code> (<code>meta_key</code>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

found the following in the error log

[Thu Apr 22 22:08:34 2010] [warn] mod_fcgid: stderr: WordPress database error Table 'iwKFRD4UBiNwordp.rpzf_commentmeta' doesn't exist for query SELECT comment_id FROM rpzf_commentmeta WHERE meta_key = '_wp_trash_meta_time' AND meta_value < '1269392914' made by do_action_ref_array, call_user_func_array, wp_scheduled_delete

this could be causing wp-cron to loop over and over.

running /wp-admin/upgrade.php says the DB is already up to date

sorry but I didnt mention I am running WP 2.9.2

any advice?

they were saved as UTF-8, because if i put UTF-8 in “Encoding for pages e feeds” the theme AND the admin display accents correctly. the good news: now NEW comments also appear correctly. problem was that after changed DB_COLLATE to empty and left UTF-8 for “Encoding for pages e feeds” i didnt submit a NEW comment to test. i just saw that the older comment, submitted prior to changing DB_COLLATE, was messed up and assumed that combination wasnt working.

in a few words, DB_COLLATE = ” fixed it.

thanks moshu!