New to the community? Start here

Can’t Manage FAQ Categories or Questions

When I click on the Manage FAQ Categories from the link on the FAQ Manager, i get the following error:

WordPress database error Field ‘qcount’ doesn’t have a default value for query INSERT INTO wp_support_faq_cats (site_id, cat_name, defcat) VALUES (‘1’, ‘General Questions’, ‘1’:wink: made by require_once, do_action, call_user_func_array, incsub_support_faqadmin, incsub_support_faqadmin_categories

When I click on the Manage FAQ Questions from the link on the FAQ Manager, i get the following error:

WordPress database error Column count doesn’t match value count at row 1 for query INSERT INTO wp_support_faq_cats (site_id, cat_name, defcat) VALUES (‘1’, ‘General Questions’:wink: made by require_once, do_action, call_user_func_array, incsub_support_faqadmin, incsub_support_faqadmin_questions, incsub_support_faqadmin_postbox

This is obviously preventing me from really using the plug-in.

Tue, 30 Jun 2009 16:49:50
  • Andrew
    • Champion of Loops

    I just installed the support system plugin on two different 2.7.1 installs (different servers) without a problem.

    Try clearing the tables and recreating them using the sql in sql.txt. If your prefix is different from wp_ then be sure to update the sql accordingly.

    Thanks,

    Andrew

  • jnthibeault
    • WPMU DEV Initiate

    Okay, tried that. Same error. Look at this error, though:

    WordPress database error Field ‘qcount’ doesn’t have a default value for query INSERT INTO wp_support_faq_cats (site_id, cat_name, defcat) VALUES (‘1’, ‘General Questions’, ‘1’:wink: made by require_once, do_action, call_user_func_array, incsub_support_faqadmin, incsub_support_faqadmin_categories

    the Insert query clearly doesn’t specify a qcount value yet when I look at the table structure in the db, qcount is set to "not null."

    I just changed the qcount "not null" requirement in the table to allow null values and it fixed the problem. Not sure how I am getting the error and you are not.

    Regardless, seems fixed. I hope that my table change doesn’t cause other issues.

    J

  • Andrew
    • Champion of Loops

    Glad to hear it’s working.

    Not sure how I am getting the error and you are not.

    Not just me I’m afraid. The Support System plugin has been downloaded over 1,300 times and no one has ever reported that error. My guess is that it’s due the server config.

    Thanks,

    Andrew