WordPress.org

Ready to get started?Download WordPress

Forums

YOP Poll
[resolved] Database Errors (3 posts)

  1. Dirty Bill
    Member
    Posted 8 months ago #

    Error logs have started filling up with database errors for YOP tables:

    [Wed Oct 23 10:59:29 2013] [error] [client 166.147.88.48] WordPress database error Table 'wp_yop_poll_votes_custom_fields' already exists for query CREATE TABLE wp_yop_poll_votes_custom_fields (\r\n\t\t\tid int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\tpoll_id int(11) NOT NULL,\r\n\t\t\tvote_id varchar(255) NOT NULL,\r\n\t\t\tcustom_field_id int(11) NOT NULL,\r\n\t\t\tuser_id int(11) NOT NULL,\r\n\t\t\tuser_type ENUM( 'facebook', 'wordpress', 'anonymous', 'default' ) NOT NULL DEFAULT 'default',\r\n\t\t\tcustom_field_value text NOT NULL,\r\n\t\t\ttr_id varchar(255) NOT NULL,\r\n\t\t\tvote_date datetime NOT NULL,\r\n\t\t\tPRIMARY KEY  (id),\r\n\t\t\tKEY poll_id (poll_id)) CHARSET=utf8  made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), call_user_func_array, Yop_Poll_Admin->db_update, Yop_Poll_DbSchema::create_poll_votes_custom_fields_table, dbDelta, referer: http://<ourwebsite>.com/

    Not sure what brought this on, but can't repair the databases, only thing that does it is killing YOP. Open for any suggestions.

    http://wordpress.org/plugins/yop-poll/

  2. YOP
    Member
    Plugin Author

    Posted 8 months ago #

    Hi Bill,

    Please edit wp_options table and look for the entry that has "option_name"
    "yop_poll_version" (option_name = 'yop_poll_version').

    For this entry set "option_value" to 4.5

    Best wishes,

    YOP Team

  3. Dirty Bill
    Member
    Posted 8 months ago #

    Mysql identifies it as a corrupt table with an incompatible format - can't repair it. Setting the option_name didn't fix. Hated to lose the data, but dropped the offending tables (3 of them), disabled then re-enable the plugin - let it restore the tables. No more errors...or log data.

    This is a good plugin, unfortunate hiccup, but will keep using.

Reply

You must log in to post.

About this Plugin

About this Topic