Database Errors

  • Resolved Dirty Bill

    (@dirty-bill)


    11 years, 4 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: https://<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.

    https://www.ads-software.com/plugins/yop-poll/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author YOP

    (@yourownprogrammer)

    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

    Thread Starter Dirty Bill

    (@dirty-bill)

    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.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Database Errors’ is closed to new replies.