database and tracking error

Home Forums AdRotate for WordPress Bug Reports database and tracking error

  • #97451

    mstaser
    Badges:

    This error is showing up on my page wherever I have any adrotate ad shown. The public is seeing this. I’ve tried turning trackings off, placing ads instead of groups and more. This just popped up

    WordPress database error: [Duplicate entry ‘12614914’ for key ‘PRIMARY’]
    INSERT INTO wp_kaq8a6bjdc_adrotate_tracker (ipaddress, timer, bannerid, stat) VALUES (‘192.137.57.133’, ‘1581674755’, ‘176’, ‘i’)

    Website is averageoutdoorsman.com

    #97470

    Arnan de Gans
    Badges:

    Try clicking the “clean database” button in Settings > Maintenance.
    That should clear things up 🙂

    #97472

    mstaser
    Badges:

    That made things worse. Now there’s more errors popping up where ads are placed and also this on top of my admin page.

    [Table ‘wp_kaq8a6bjdc_adrotate_tracker’ is marked as crashed and should be repaired]
    DELETE FROM wp_kaq8a6bjdc_adrotate_tracker WHERE timer < 1581604537;

    WordPress database error: [Table ‘averageo_o6352.wp_kaq8a6bjdc_adrotate_transactions’ doesn’t exist]
    DELETE FROM wp_kaq8a6bjdc_adrotate_transactions WHERE reference = ”;

    #97477

    mstaser
    Badges:

    I went ahead and uploaded an older version and everything is working now. Of course I didn’t backup and having to redo all the ads and groups from scratch.

    I’ll wait until next update and try it. That one that came out yesterday crashed my stuff.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.

You may be interested in