WordPress.org

Support

Support » How-To and Troubleshooting » SQL syntax error & duplicate entry

SQL syntax error & duplicate entry

  • pcrproject
    Member

    @pcrproject

    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

Viewing 1 replies (of 1 total)
  • Does this look like an upgrade issue?

    It looks like a plugin issue…
    wp_bas_visitors – is not a WP table!

Viewing 1 replies (of 1 total)
  • The topic ‘SQL syntax error & duplicate entry’ is closed to new replies.