WordPress.org

1. khaled
   Member
   Posted 4 years ago #

   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 ?

2. khaled
   Member
   Posted 4 years ago #

   Also seems to only have this problem in FF. In IE there doesn't seem to be any problem. I'm confused now.

3. mdawaffe
   Member
   Posted 4 years ago #

   That's the new default behavior for 1.5
   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.

4. mdawaffe
   Member
   Posted 4 years ago #

   Which problem is only FF?

5. khaled
   Member
   Posted 4 years ago #

   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 ^_^).

6. podz
   Support Maven
   Posted 4 years ago #

   "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.

7. podz
   Support Maven
   Posted 4 years ago #

   "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.

8. XeroCool
   Member
   Posted 4 years ago #

   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 :)

9. XeroCool
   Member
   Posted 4 years ago #

   Ok. My crap didnt work.

   I get:

   I see it has: comment_status != 'spam' . Hmm...Something is screwed so....

10. podz
    Support Maven
    Posted 4 years ago #

    I have nearly 1000 posts and 2000 comments.
    Which one do you suggest I delete ?????????????????

11. XeroCool
    Member
    Posted 4 years ago #

    Neither. Lol.

12. NuclearMoose
    Member
    Posted 4 years ago #

    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.

13. XeroCool
    Member
    Posted 4 years ago #

    So how do we fix it?

14. khaled
    Member
    Posted 4 years ago #

    oops seems like I opened a whole can of worms there. Could we go back to one of the older nightlies?

15. podz
    Support Maven
    Posted 4 years ago #

    Nah .. that would be no fun at all !

    Nothing will go bang :)

16. mdawaffe
    Member
    Posted 4 years ago #

    I think this just got fixed. bug report

    (Note to self: check database before assuming code is correct :) )

Topic Closed

This topic has been closed to new replies.