WordPress.org

Ready to get started?Download WordPress

Forums

WP SlimStat
[resolved] getting wordpress DB errors after the last update (7 posts)

  1. Ovidiu
    Member
    Posted 1 year ago #

    Updated Wp to 3.4 and all plugins to the latest version and now I get these errors all over:

    WordPress database error: [Table 'knightsenglish_com.ke_slim_content_info' doesn't exist]
    SELECT content_info_id FROM ke_slim_content_info WHERE content_type = 'page' AND author = 'Mike'
    
    WordPress database error: [Table 'knightsenglish_com.ke_slim_content_info' doesn't exist]
    INSERT INTO ke_slim_content_info ( content_type, author ) SELECT 'page','Mike' FROM DUAL WHERE NOT EXISTS ( SELECT content_info_id FROM ke_slim_content_info WHERE content_type = 'page' AND author = 'Mike' )
    
    WordPress database error: [Table 'knightsenglish_com.ke_slim_content_info' doesn't exist]
    SELECT content_info_id FROM ke_slim_content_info WHERE content_type = 'page' AND author = 'Mike'

    tried deactivating/reactivating this plugin but that doesn't help. Any ideas? I have meanwhile deactivated it while waiting for help in this thread.

    http://wordpress.org/extend/plugins/wp-slimstat/

  2. camu
    Member
    Plugin Author

    Posted 1 year ago #

    Please run this query in phpMyAdmin:

    CREATE TABLE IF NOT EXISTS knightsenglish_com.ke_slim_content_info (
    				content_info_id MEDIUMINT UNSIGNED NOT NULL auto_increment,
    				content_type VARCHAR(64) DEFAULT '',
    				category VARCHAR(256) DEFAULT '',
    				author VARCHAR(64) DEFAULT '',
    				PRIMARY KEY (content_info_id)
    			)

    Would be interesting to check the MySQL logfile to see why this table hadn't been created. You may also want to make sure all the tables are up-to-date, by comparing their structure with the one described at the end of this page

    http://wordpress.org/extend/plugins/wp-slimstat/faq/

    Cheers,
    Camu

  3. camu
    Member
    Plugin Author

    Posted 1 year ago #

    I found the bug, I'm about to release a new version to fix it.

  4. Ovidiu
    Member
    Posted 1 year ago #

    Thanks, will check again after the update.

  5. camu
    Member
    Plugin Author

    Posted 1 year ago #

    Sure, let me know how it goes.

  6. Ovidiu
    Member
    Posted 1 year ago #

    got another, similar error:

    WordPress database error: [File './knightsenglish_com/ke_slim_stats.MYD' not found (Errcode: 13)]
    INSERT INTO ke_slim_stats ( user, ip, other_ip, language, country, searchterms, resource, visit_id, content_info_id, browser_id, dt ) SELECT 'admin','3302457704','3302457704','en-us','za','','/','1728','2','218','1343403715' FROM DUAL WHERE NOT EXISTS ( SELECT id FROM ke_slim_stats WHERE user = 'admin' AND ip = '3302457704' AND other_ip = '3302457704' AND language = 'en-us' AND country = 'za' AND searchterms = '' AND resource = '/' AND visit_id = '1728' AND content_info_id = '2' AND browser_id = '218' AND (TIME_TO_SEC(TIMEDIFF(FROM_UNIXTIME('1343403715'),FROM_UNIXTIME(dt))) < 30) LIMIT 1)
    
    WordPress database error: [File './knightsenglish_com/ke_slim_stats.MYD' not found (Errcode: 13)]
    SELECT id FROM ke_slim_stats WHERE user = 'admin' AND ip = '3302457704' AND other_ip = '3302457704' AND language = 'en-us' AND country = 'za' AND searchterms = '' AND resource = '/' AND visit_id = '1728' AND content_info_id = '2' AND browser_id = '218' AND (TIME_TO_SEC(TIMEDIFF(FROM_UNIXTIME('1343403715'),FROM_UNIXTIME(dt))) < 30)

    Have disabled the plugin for now, will wait for your reply and then try and fix it with your help.

  7. camu
    Member
    Plugin Author

    Posted 1 year ago #

    Your db seems to be corrupted. Ask your provider for more information. And remember that google is your friend ;)

    Http://lmgtfy.com/?q=File+myd+not+found

    And

    http://themanbehindthecode.com/2011/04/14/fix-myisam-myd-file-not-found-errcode2/

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.