Notifications
Clear all

Database table missing?

8 Posts
3 Users
0 Likes
4,343 Views
(@alertadigital)
New Member
Joined: 6 years ago
Posts: 3
Topic starter  

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.


   
Quote
Astghik
(@astgh)
Illustrious Member Admin
Joined: 6 years ago
Posts: 5874
 

Hi alertadigital,

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

 

 


   
ReplyQuote
(@alertadigital)
New Member
Joined: 6 years ago
Posts: 3
Topic starter  
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
(@astgh)
Illustrious Member Admin
Joined: 6 years ago
Posts: 5874
 

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. 


   
ReplyQuote
(@alertadigital)
New Member
Joined: 6 years ago
Posts: 3
Topic starter  

Thanks for the reply.

Now i have this error when insert the table:

#1067 - Invalid default value for 'follow_date'


   
ReplyQuote
 fla
(@fla)
New Member
Joined: 6 years ago
Posts: 1
 

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


   
ReplyQuote
Astghik
(@astgh)
Illustrious Member Admin
Joined: 6 years ago
Posts: 5874
 

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:
Scroll to top