Title: Database errors? Last modified: August 18, 2016 --- # Database errors? * [khaled](https://wordpress.org/support/users/khaled/) * (@khaled) * [21 years, 4 months ago](https://wordpress.org/support/topic/database-errors-1/) * I’ve moved hosts and I’ve moved all the files with me. Everything seems to be working fine, except any comments that are added automatically change name etc to admin settings. So basically if you post a comment the name is changed to admin, no matter who actually types it in. * I’ve uploaded the database again several times, just constantly gives me this problem. * When editing the comment after deleting or whatever, under the manage >post tab * I get the following message: * WordPress database error: [Unknown column ‘comment_status’ in ‘where clause’] SELECT * FROM wp_comments WHERE comment_post_ID = 553 AND comment_status != ‘ spam’ ORDER BY comment_date * Using 1.5 gamma, any ideas ? Viewing 15 replies - 1 through 15 (of 15 total) * Thread Starter [khaled](https://wordpress.org/support/users/khaled/) * (@khaled) * [21 years, 4 months ago](https://wordpress.org/support/topic/database-errors-1/#post-140489) * Also seems to only have this problem in FF. In IE there doesn’t seem to be any problem. I’m confused now. * [Michael Adams (mdawaffe)](https://wordpress.org/support/users/mdawaffe/) * (@mdawaffe) * [21 years, 4 months ago](https://wordpress.org/support/topic/database-errors-1/#post-140490) * That’s the new default behavior for 1.5 [http://wordpress.org/support/topic.php?id=22378](http://wordpress.org/support/topic.php?id=22378)( the bug discussed there has been resolved – no need to worry about the code posted) * If you’re logged in, WordPress will generate the comment fields from the info from your User Profile. To change “admin” to “khaled”, make “khaled” your nickname in Users->Your Profile, click the “Update Profile” button at the bottom of the page, then select the appropriate item from the “How to display name” dropdown and click the “Update Profile” button again. * Or, if you really don’t want comments posted from the “admin” account for some reason, make a new (say level 9) user account for yourself and log in as that account before posting comments. * As for the database error, what do you mean by “editing the comment after deleting or whatever”? If you’ve deleted the comment… you can’t edit it. * If you mean after deleting the database, did you run `wp-admin/upgrade.php` after upgrading? Try running it again. * [Michael Adams (mdawaffe)](https://wordpress.org/support/users/mdawaffe/) * (@mdawaffe) * [21 years, 4 months ago](https://wordpress.org/support/topic/database-errors-1/#post-140491) * Which problem is only FF? * Thread Starter [khaled](https://wordpress.org/support/users/khaled/) * (@khaled) * [21 years, 4 months ago](https://wordpress.org/support/topic/database-errors-1/#post-140492) * Ah ok, that makes sense now, just realised that the problem only exists if I’m logged in. So that’s cool, no worries now. * I’ve been running on 1.3 for a while and I only recently upgraded to 1.5 so I’m not completely clear about all the little tweaks etc, but that’s really helpful actually puts my mind at ease that things are working properly, or as they are intended to. * As for the error, once I’ve edited the comment, be it deleted it or whatever, I’m taken back to the managa > pages tab. Which is fine, except that like I said I get the error message, once I refesh no message there. Guess it’s just a bug that needs sorting out. It’s cool, hey I chose to run my site on pre released stuff, so I should expect little things like this (but it’s soo good ^_^). * [Mark (podz)](https://wordpress.org/support/users/podz/) * (@podz) * [21 years, 4 months ago](https://wordpress.org/support/topic/database-errors-1/#post-140494) * “That’s the new default behavior for 1.5” * Edit:: Problems abounded. Log out. Clear cookies. Clear cache Log in. I had protected cookies so it took a couple of goes. * [Mark (podz)](https://wordpress.org/support/users/podz/) * (@podz) * [21 years, 4 months ago](https://wordpress.org/support/topic/database-errors-1/#post-140520) * “WordPress database error: [Unknown column ‘comment_status’ in ‘where clause’] SELECT * FROM wp_comments WHERE comment_post_ID = 1119 AND comment_status != ‘ spam’ ORDER BY comment_date “ * Same here. * [xerocool](https://wordpress.org/support/users/xerocool/) * (@xerocool) * [21 years, 4 months ago](https://wordpress.org/support/topic/database-errors-1/#post-140521) * Like I said in the other thread, Delete the test comment If it still exists. If you have a couple of comments on your site and think you dont need them, Delete it and It should go away. Thats my solution because It worked for me fine 🙂 * [xerocool](https://wordpress.org/support/users/xerocool/) * (@xerocool) * [21 years, 4 months ago](https://wordpress.org/support/topic/database-errors-1/#post-140526) * Ok. My crap didnt work. * I get: * I see it has: comment_status != ‘spam’ . Hmm…Something is screwed so…. * [Mark (podz)](https://wordpress.org/support/users/podz/) * (@podz) * [21 years, 4 months ago](https://wordpress.org/support/topic/database-errors-1/#post-140527) * I have nearly 1000 posts and 2000 comments. Which one do you suggest I delete????????????????? * [xerocool](https://wordpress.org/support/users/xerocool/) * (@xerocool) * [21 years, 4 months ago](https://wordpress.org/support/topic/database-errors-1/#post-140532) * Neither. Lol. * [NuclearMoose](https://wordpress.org/support/users/nuclearmoose/) * (@nuclearmoose) * [21 years, 4 months ago](https://wordpress.org/support/topic/database-errors-1/#post-140538) * I installed the 2005/02/05 on my test site and I got the same error as well. It appears that perhaps a field wasn’t added to a table when running `upgrade. php`. * [xerocool](https://wordpress.org/support/users/xerocool/) * (@xerocool) * [21 years, 4 months ago](https://wordpress.org/support/topic/database-errors-1/#post-140539) * So how do we fix it? * Thread Starter [khaled](https://wordpress.org/support/users/khaled/) * (@khaled) * [21 years, 4 months ago](https://wordpress.org/support/topic/database-errors-1/#post-140541) * oops seems like I opened a whole can of worms there. Could we go back to one of the older nightlies? * [Mark (podz)](https://wordpress.org/support/users/podz/) * (@podz) * [21 years, 4 months ago](https://wordpress.org/support/topic/database-errors-1/#post-140542) * Nah .. that would be no fun at all ! * Nothing will go bang 🙂 * [Michael Adams (mdawaffe)](https://wordpress.org/support/users/mdawaffe/) * (@mdawaffe) * [21 years, 4 months ago](https://wordpress.org/support/topic/database-errors-1/#post-140617) * I think this just got [fixed](http://cvs.sourceforge.net/viewcvs.py/cafelog/wordpress/wp-admin/edit.php?r1=1.42&r2=1.43&sortby=date). [bug report](http://mosquito.wordpress.org/view.php?id=807) * (Note to self: check database before assuming code is correct `:)` ) Viewing 15 replies - 1 through 15 (of 15 total) The topic ‘Database errors?’ is closed to new replies. * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 15 replies * 5 participants * Last reply from: [Michael Adams (mdawaffe)](https://wordpress.org/support/users/mdawaffe/) * Last activity: [21 years, 4 months ago](https://wordpress.org/support/topic/database-errors-1/#post-140617) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics