Unknown column ‘spam’

Viewing 4 replies - 1 through 4 (of 4 total)

  • Hi @sujaljain007

    Please, take a look at this post.

    Have a nice day

    Thread Starter Sujal Jain

    (@sujaljain007)

    Hi there, I did follow the steps, but it looks like there’s already a column name spam in users table and since I am the only user with user id 1, the spam shows 0 (if this can help somehow).

    When I follow the steps, as you might know, it shows duplicate column error. I tried deleting the column and follow the steps again and it did add the same column again but that didn’t help as I get the same error again.

    Looking forward for someone’s response, thank you.

    Heya! Make sure to use the correct table name. In your case it should be:
    ALTER TABLE QdcpzrKAusers ADD spam TINYINT

    Thread Starter Sujal Jain

    (@sujaljain007)

    Hi everyone, thanks for your support.
    I am late but I managed to resolve the error. A lot was going on with that WordPress site and eventually, some administrators made some big changes so I had to put that site down and create a fresh start and import content through different importers for page builders and content.

    I know there could have been other ways to solve this but since the site had not had much audience and content at the time, it was worth it as the database is also quite small and everything is nice and clean up to now.

    I am marking this topic as resolved for now. I would encourage moderators to close this topic to new replies if that’s suitable and even possible.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Unknown column ‘spam’’ is closed to new replies.