Title: bchen's Replies | WordPress.org --- # bchen [ ](https://wordpress.org/support/users/bchen/) * [Profile](https://wordpress.org/support/users/bchen/) * [Topics Started](https://wordpress.org/support/users/bchen/topics/) * [Replies Created](https://wordpress.org/support/users/bchen/replies/) * [Reviews Written](https://wordpress.org/support/users/bchen/reviews/) * [Topics Replied To](https://wordpress.org/support/users/bchen/replied-to/) * [Engagements](https://wordpress.org/support/users/bchen/engagements/) * [Favorites](https://wordpress.org/support/users/bchen/favorites/) Search replies: ## Forum Replies Created Viewing 6 replies - 1 through 6 (of 6 total) * Forum: [Installing WordPress](https://wordpress.org/support/forum/installation/) In reply to: [WordPress database errors during 2.0 upgrade](https://wordpress.org/support/topic/wordpress-database-errors-during-20-upgrade/) * Thread Starter [bchen](https://wordpress.org/support/users/bchen/) * (@bchen) * [20 years, 4 months ago](https://wordpress.org/support/topic/wordpress-database-errors-during-20-upgrade/#post-305013) * I’m going to go ahead and close this thread. The problem seems specific to the MySQL version that I have on my workstation. The upgrade proceeded without problems on my hosting provider. I guess someone should note that with MySQL 4.1.13a-nt that the alter table statements to add defaults don’t seem to work. * Forum: [Installing WordPress](https://wordpress.org/support/forum/installation/) In reply to: [WordPress database errors during 2.0 upgrade](https://wordpress.org/support/topic/wordpress-database-errors-during-20-upgrade/) * Thread Starter [bchen](https://wordpress.org/support/users/bchen/) * (@bchen) * [20 years, 4 months ago](https://wordpress.org/support/topic/wordpress-database-errors-during-20-upgrade/#post-304839) * I’ve been trying to make the changes to the MySQL database by hand, and I found that the ALTER TABLE {$table} ALTER COLUMN {$tablefield->Field} SET DEFAULT… statements cannot be run in isolation. They have to all be part of a single statement with multiple ALTER COLUMN specifications separated by commas. I don’t know if this is specific to my version of MySQL, but this wouldn’t succeed until I could run all of these defaults in one go. * The comment_count error is because the addition of comment_count appears later in the list of changes, I believe. * Forum: [Installing WordPress](https://wordpress.org/support/forum/installation/) In reply to: [WordPress database errors during 2.0 upgrade](https://wordpress.org/support/topic/wordpress-database-errors-during-20-upgrade/) * Thread Starter [bchen](https://wordpress.org/support/users/bchen/) * (@bchen) * [20 years, 4 months ago](https://wordpress.org/support/topic/wordpress-database-errors-during-20-upgrade/#post-304823) * My workstation is running Windows XP. I have MySQL version 4.1.13a-nt. The database is something that I backed up from my hosting provider and restored on my workstation. The hosting provider is running RedHat Linux (not sure of the specifics beyond that) and MySQL 4.0.17-standard. * I restored my backup and went through the process again. This time I deleted my wp-content folder entirely instead of just overwriting it. I also deleted . htaccess. I got the same database errors, but it looks like the Firefox problem has gone away. * I also have found that the comment count seems to be incorrect. When I go to the Posts tab under “Manage”, there are errors which say: * “WordPress database error: [Unknown column ‘column_count’ in ‘field list’] SELECT comment_count FROM em_posts WHERE ID = ’65′” * This error repeats for every post listed. Is it possible that with the earlier errors that the comment_count wasn’t added as a column properly? * Forum: [Installing WordPress](https://wordpress.org/support/forum/installation/) In reply to: [WordPress database errors during 2.0 upgrade](https://wordpress.org/support/topic/wordpress-database-errors-during-20-upgrade/) * Thread Starter [bchen](https://wordpress.org/support/users/bchen/) * (@bchen) * [20 years, 4 months ago](https://wordpress.org/support/topic/wordpress-database-errors-during-20-upgrade/#post-304755) * I’m attempting this upgrade on my local machine first before I do it at my hosting provider, so it’s not a problem with ASCII mode transfers. I’m just copying the files from the extracted zip file to the folder where I have a local copy of my site. * When I look at the column “auto_toggle” on em_linkcategories, it is of type enum(‘ Y’,’N’), but I don’t see a default for it. I tried setting the default to ‘Y’ by editing the field in phpmyadmin, but it doesn’t seem to stick. There is no error, but I don’t see a default still. * For the Firefox formatting, I did try a hard refresh. Is there a way to attach an to this thread to show what I mean? I guess it’s good to know that it’s supposed to work with Firefox. * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [Upgrading to WP 2.0](https://wordpress.org/support/topic/upgrading-to-wp-20/) * [bchen](https://wordpress.org/support/users/bchen/) * (@bchen) * [20 years, 4 months ago](https://wordpress.org/support/topic/upgrading-to-wp-20/page/7/#post-302866) * After these errors, I continued on to the admin pages for my site, and it looks like things are more or less working, though I haven’t really probed things. * One thing I did notice is that the formatting is all messed up in Firefox, but not IE. Is this intentional? The expandable boxes are in the wrong places on the page and overlaps other text on the page. * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [Upgrading to WP 2.0](https://wordpress.org/support/topic/upgrading-to-wp-20/) * [bchen](https://wordpress.org/support/users/bchen/) * (@bchen) * [20 years, 4 months ago](https://wordpress.org/support/topic/upgrading-to-wp-20/page/7/#post-302855) * I’m attempting an upgrade from wp 1.5.2, and when I run upgrade.php and go to step 1, I get some database errors that look like this: * > WordPress database error: [Invalid default value for ‘comment_approved’] > > ALTER TABLE em_comments CHANGE COLUMN user_id user_id bigint(20) NOT NULL default‘ > 0’ > WordPress database error: [Invalid default value for ‘auto_toggle’] > ALTER > TABLE em_linkcategories CHANGE COLUMN show_images show_images enum(‘Y’,’N’) > NOT NULL default ‘Y’ > WordPress database error: [Invalid default value for ‘auto_toggle’] > ALTER > TABLE em_linkcategories ALTER COLUMN show_images SET DEFAULT ‘Y’ * Any ideas? Viewing 6 replies - 1 through 6 (of 6 total)