• In the past few weeks, I have a wordpress database error on my homepage:

    https://www.danblank.com

    However, this does not appear on other pages, such as this one:

    https://www.danblank.com/blog

    This is the error:
    WordPress database error: [Got error 134 from storage engine]
    SELECT * FROM wp_bas_visitors, wp_bas_refer, wp_bas_ua, wp_bas_os WHERE referer = referer_id AND osystem = os_id AND useragent = ua_id AND lasthere > DATE_SUB(NOW(), INTERVAL 20 MINUTE) AND visit_ip = 1129553631 AND ua_string = ‘Mozilla/5.0 (Macintosh; U; PPC Mac OS X; en-us) AppleWebKit/419 (KHTML, like Gecko) Safari/419.3’ ORDER BY lasthere DESC LIMIT 1

    I have no idea where to start. Please help!
    Thanks.
    -Dan

Viewing 3 replies - 1 through 3 (of 3 total)
  • Go into your database with phpmyadmin or whatever you use, and repair your tables.

    Thread Starter danblank

    (@danblank)

    Whooami – thanks for the help, but I am still not sure what to do. I ran a utility on it, and now even more messages appear on my homepage. (see below). Is “repairing my tables” something that I can do automatically, or do I have to look in the code?
    Thanks.
    -Dan

    WordPress database error: [File ‘./blog/wp_bas_visitors.MYD’ not found (Errcode: 13)]
    SELECT * FROM wp_bas_visitors, wp_bas_refer, wp_bas_ua, wp_bas_os WHERE referer = referer_id AND osystem = os_id AND useragent = ua_id AND lasthere > DATE_SUB(NOW(), INTERVAL 20 MINUTE) AND visit_ip = 1129553631 AND ua_string = ‘Mozilla/5.0 (Macintosh; U; PPC Mac OS X; en-us) AppleWebKit/419 (KHTML, like Gecko) Safari/419.3’ ORDER BY lasthere DESC LIMIT 1

    WordPress database error: [File ‘./blog/wp_bas_visitors.MYD’ not found (Errcode: 13)]
    INSERT INTO wp_bas_visitors (visit_ip, referer, osystem, useragent, lasthere) VALUES (1129553631, 1, 5, 2711, ‘2007-06-10 22:38:33’);

    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-06-10 22:38:33′, 0, 9)’ at line 1]
    INSERT INTO wp_bas_log (visit, stamp, outbound, page) VALUES (, ‘2007-06-10 22:38:33’, 0, 9);

    Hi Dan,

    I Solved the similar problem in my website https://www.dreameesoft.com.

    Just go to the Administration Panel of your WordPress, go to Plugins Section and Deactivate BAStats Plugin.

    That should fix the problem…

    If you come across a way to have the BAStats Plugin again (without the error ofcourse) kindly let me know.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Help! WordPress Database Error’ is closed to new replies.