Results 1 to 2 of 2
  1. #1
    Junior Member
    Join Date
    Oct 2015
    Posts
    1

    Exclamation DB error Table 'wordpress.wp_likebtn_item' doesn't exist

    Hello. My site sometimes get down and I find out this error.
    PHP Code:

    [Thu Oct 29 15:37:24 2015] [error] [client 46.241.250.197WordPress database error Table 'wordpress.wp_likebtn_item' doesn't exist for query SELECT likes, dislikes\n                
    FROM wp_likebtn_item\n                
    WHERE identifier = '
    post_18725' made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), 
    require_once('
    wp-settings.php'), do_action('init'), call_user_func_array, likebtn_init, _likebtn_plugin_on_load, LikeBtnLikeButton->runSyncVotes, LikeBtnLikeButton->syncVotes, LikeBtnLikeButton->updateVotes, LikeBtnLikeButton->updateCustomFields, 
    referer: http://m.facebook.com 
    How can I solve this problem ?


  2. #2
    Admin LikeBtn's Avatar
    Join Date
    Sep 2011
    Posts
    320
    Try to activate and deactivate the plugin.

    If it will not help run the following queries in your DB:

    CREATE TABLE IF NOT EXISTS wp_likebtn_item ( `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `identifier` text NOT NULL,
    `identifier_hash` varchar(32) NOT NULL,
    `url` text,
    `title` text,
    `description` text,
    `image` text,
    `likes` int(11) NOT NULL DEFAULT '0',
    `dislikes` int(11) NOT NULL DEFAULT '0',
    `likes_minus_dislikes` int(11) NOT NULL DEFAULT '0',
    PRIMARY KEY (`ID`),
    UNIQUE KEY `identifier_hash` (`identifier_hash`),
    KEY `title` (`title`(1)),
    KEY `likes` (`likes`),
    KEY `dislikes` (`dislikes`),
    KEY `likes_minus_dislikes` (`likes_minus_dislikes`),
    KEY `identifier` (`identifier`(1))
    );
    CREATE TABLE IF NOT EXISTS wp_likebtn_vote (
    `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `identifier` text NOT NULL,
    `identifier_hash` varchar(32) NOT NULL,
    `client_identifier` varchar(32) NOT NULL,
    `type` tinyint(1) NOT NULL,
    `user_id` bigint(20) DEFAULT 0,
    `ip` varchar(40) NOT NULL,
    `lat` float(10, 6) NULL,
    `lng` float(10, 6) NULL,
    `created_at` datetime NOT NULL,
    PRIMARY KEY (`ID`),
    UNIQUE KEY `identifiers` (`identifier_hash`, `client_identifier`, `user_id`),
    KEY `identifier` (`identifier`(7)),
    KEY `created_at` (`created_at`),
    KEY `user_id` (`user_id`),
    KEY `ip` (`ip`)
    );


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •