Error in Database.

  • Resolved noobieboy

    (@noobieboy)


    5 years, 4 months ago

    Hi,
    I’m facing some db errors with WP-Foro plugin.
    I checked the debug tab in tools. It was showing following errors

    Table: wpt1_wpforo_posts
Missing fields:  postid, parentid, forumid, topicid, userid, title, body, created, modified, likes, votes, is_answer, is_first_post, status, name, email, private, root
    Table: wpt1_wpforo_posts
Missing keys:  postid, title, body, title_plus_body, topicid, forumid, userid, created, parentid, is_answer, is_first_post, status, email, is_private, root, forumid_status, topicid_status, topicid_solved, topicid_parentid, forumid_status_private, forumid_answer_first

    I tried [Solve Database Problems] button. but still this error message is there.
    I deactivated and activated this plugin. Still the error message is there.

    My PHP Version 7.4.12
    MySQL Version 5.6.41

    • This topic was modified 5 years, 4 months ago by noobieboy.
Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support gVectors Support

    (@gvectorssupport)

    5 years, 4 months ago

    Hi @noobieboy,

    Please click on the “Uninstall” button to remove all forum data, options and tables, then activate the plugin again.

    Thread Starter noobieboy

    (@noobieboy)

    5 years, 4 months ago

    Hi @gvectorssupport ,
    As you said uninstall will remove all forum data right? If I activate the forum after removing data, will I be able to display current contents in my forums?

    Plugin Support gVectors Support

    (@gvectorssupport)

    5 years, 4 months ago

    @noobieboy,

    Yes, the current contents will not be available anymore. As we see in the error message the info on wpforo_posts table is missing so, in any case, the information in the table will be lost.

    Thread Starter noobieboy

    (@noobieboy)

    5 years, 4 months ago

    @gvectorssupport ,
    What may be the cause of this error? Even if I follow above steps, is there any chance of occurrence of this error in future?

    Plugin Support gVectors Support

    (@gvectorssupport)

    5 years, 4 months ago

    @noobieboy,

    The wpForo doesn’t have such a core issue. This may be a result of database manipulation. You may contact your hosting support and ask them to provide you with the history of the actions that caused this issue.

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

The topic ‘Error in Database.’ is closed to new replies.

Tags