AdRotate Tracker Database Errors

  • Resolved adjunctadvocate

    (@adjunctadvocate)


    8 years, 2 months ago

    Hi,

    I have a query tracker installed and this error is coming up. I had the most recent version of your plugin installed and then rolled back to 4.7 and 4.6 with the same database error coming up.

    SELECT timer
    FROM wp_adrotate_tracker
    AND stat = ‘i’
    AND bannerid = 3
    ORDER BY timer DESC
    LIMIT 1;
    publisher_get_view()
    get_sidebar(‘primary’)
    wp-includes/general-template.php:122
    locate_template()
    wp-includes/template.php:643
    load_template(‘~/wp-content/themes/publisher/sidebar-primary.php’)
    wp-includes/template.php:684
    dynamic_sidebar(‘primary-sidebar’)
    wp-includes/widgets.php:738
    WP_Widget->display_callback()
    wp-includes/class-wp-widget.php:395
    adrotate_widgets->widget()
    wp-content/plugins/adrotate/adrotate-widget.php:63
    adrotate_ad()
    wp-content/plugins/adrotate/adrotate-output.php:46
    adrotate_count_impression()
    wp-content/plugins/adrotate/adrotate-statistics.php:501
    Plugin: adrotate 144 Table ‘./xxxxxxx/wp_adrotate_tracker’ (I have removed the name of the database table for security) is marked as crashed and last (automatic?) repair failed

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Plugin Author Arnan

    (@adegans)

    8 years, 1 month ago

    Try repairing the table from Phpmyadmin.
    If that doesn’t work, you can disable the plugin, delete the entire table (from phpmyadmin again) and re-activate the plugin.

    The table holds temporary data, so it’s data is not really relevant to keep.
    Activating the plugin will run a check for missing tables and add it if something is amiss.

Viewing 1 replies (of 1 total)

The topic ‘AdRotate Tracker Database Errors’ is closed to new replies.