Database table missing?  

  RSS

alertadigital
(@alertadigital)
New Member
Joined: 3 months  ago
Posts: 3
20/07/2018 8:12 pm  

Hi, im having a lot of errors like this:

AH01071: Got error 'PHP message: Error Table 'alertadigital.wp_wc_follow_users' doesn't exist de la base de datos de WordPress para la consulta SELECT `user_email` FROM `wp_wc_follow_users` WHERE `confirm` = 1 AND `follower_email` = 'useremail@gmail.com'; realizada por require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/AlertaDigital/single.php'), comments_template, require('/plugins/wpdiscuz/templates/comment/comment-form.php'), WpdiscuzCore->getWPComments, WpdiscuzCore->getCommentListArgs, WpdiscuzDBManager->getUserFollows\n'

The table wp_wc_follow_users doesn't exist in the database, i only have this tables with the 'wc' prefix:

wp_wc_avatars_cache
wp_wc_comments_subscription
wp_wc_phrases
wp_wc_users_voted

Because of this i'm having a lot of errors like that in the PHP error log.

Please, i need help.

Thanks.


ReplyQuote
Astghik
(@astghik)
Support Team Admin
Joined: 11 months  ago
Posts: 1180
21/07/2018 3:49 pm  

Hi alertadigital,

Please deactivate the wpDiscuz plugin then activate it and check again. 

 

 


ReplyQuote
alertadigital
(@alertadigital)
New Member
Joined: 3 months  ago
Posts: 3
24/07/2018 7:43 pm  
Posted by: Astghik

Hi alertadigital,

Please deactivate the wpDiscuz plugin then activate it and check again. 

This doesnt fix it... any other tip?.


ReplyQuote
Astghik
(@astghik)
Support Team Admin
Joined: 11 months  ago
Posts: 1180
25/07/2018 2:31 pm  

Hi @alertadigital,

Please execute this SQL in Hosting Service cPanel > phpMyAdmin database manager, navigate to SQL Tab. If your WordPress table prefix is not wp_   replace all wp_ prefixes in this code to your database table prefixes, if they are wp_ just use it as is:

CREATE TABLE IF NOT EXISTS `wp_wc_follow_users` (`id` int(11) NOT NULL AUTO_INCREMENT, `post_id` int(11) NOT NULL DEFAULT '0', `user_id` int(11) NOT NULL DEFAULT '0', `user_email` varchar(125) NOT NULL, `user_name` varchar(255) NOT NULL, `follower_id` int(11) NOT NULL DEFAULT '0', `follower_email` varchar(125) NOT NULL, `follower_name` varchar(255) NOT NULL, `activation_key` varchar(32) NOT NULL, `confirm` tinyint(1) NOT NULL DEFAULT '0', `follow_timestamp` int(11) NOT NULL, `follow_date` datetime NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `post_id` (`post_id`), KEY `user_id` (`user_id`), KEY `user_email` (`user_email`), KEY `follower_id` (`follower_id`), KEY `follower_email` (`follower_email`), KEY `confirm` (`confirm`), KEY `follow_timestamp` (`follow_timestamp`), UNIQUE KEY `follow_unique_key` (`user_email`, `follower_email`)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

Please let us know if the issue still exists. 

This post was modified 2 months  ago by Tom

ReplyQuote
alertadigital
(@alertadigital)
New Member
Joined: 3 months  ago
Posts: 3
31/07/2018 9:51 pm  

Thanks for the reply.

Now i have this error when insert the table:

#1067 - Invalid default value for 'follow_date'


ReplyQuote
fla
 fla
(@fla)
New Member
Joined: 2 months  ago
Posts: 1
02/08/2018 1:26 pm  

Dear I have the same error message when executing the sql request :  Invalid default value for 'follow_date', any help ?


ReplyQuote
Astghik
(@astghik)
Support Team Admin
Joined: 11 months  ago
Posts: 1180
02/08/2018 2:04 pm  

Dear users,

Please execute the following SQL instead of the previous one: 

CREATE TABLE IF NOT EXISTS `wp_wc_follow_users` (`id` int(11) NOT NULL AUTO_INCREMENT, `post_id` int(11) NOT NULL DEFAULT '0', `user_id` int(11) NOT NULL DEFAULT '0', `user_email` varchar(125) NOT NULL, `user_name` varchar(255) NOT NULL, `follower_id` int(11) NOT NULL DEFAULT '0', `follower_email` varchar(125) NOT NULL, `follower_name` varchar(255) NOT NULL, `activation_key` varchar(32) NOT NULL, `confirm` tinyint(1) NOT NULL DEFAULT '0', `follow_timestamp` int(11) NOT NULL, `follow_date` datetime NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `post_id` (`post_id`), KEY `user_id` (`user_id`), KEY `user_email` (`user_email`), KEY `follower_id` (`follower_id`), KEY `follower_email` (`follower_email`), KEY `confirm` (`confirm`), KEY `follow_timestamp` (`follow_timestamp`), UNIQUE KEY `follow_unique_key` (`user_email`, `follower_email`)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

Also please let us know MySQL version. 


ReplyQuote
Share: