WordPress.org

Ready to get started?Download WordPress

Forums

SQL syntax error & duplicate entry (2 posts)

  1. pcrproject
    Member
    Posted 7 years ago #

    Hello,
    We received the following error messages over the weekend:

    WordPress database error: [Duplicate entry '106451' for key 1]
    INSERT INTO wp_bas_visitors (visit_ip, referer, osystem, useragent, lasthere) VALUES (644092098, 1, 1, 467, '2007-07-09 13:58:05');

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND referer = referer_id AND osystem = os_id AND useragent = ua_]
    SELECT * FROM wp_bas_visitors, wp_bas_refer, wp_bas_ua, wp_bas_os WHERE visit_id = AND referer = referer_id AND osystem = os_id AND useragent = ua_id

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' '2007-07-09 13:58:05', 0, 1)' at line 1]
    INSERT INTO wp_bas_log (visit, stamp, outbound, page) VALUES (, '2007-07-09 13:58:05', 0, 1);

    Does this look like an upgrade issue? We've not upgraded to the new version(s) - could this be the problem? I don't have a manual for the MySQL server.

    Thank you,
    PCR Project

  2. moshu
    Member
    Posted 7 years ago #

    Does this look like an upgrade issue?

    It looks like a plugin issue...
    wp_bas_visitors - is not a WP table!

Topic Closed

This topic has been closed to new replies.

About this Topic