Notifications
Clear all

Limited Support

Our support team is currently on holiday from December 25, 2025 to January 7, 2026, and replies may be delayed during this period.

We appreciate your patience and understanding while our team is away. Thank you for being part of the gVectors community!

Merry Christmas and Happy Holidays! 🎄

Database table missing?

8 Posts
3 Users
0 Reactions
5,430 Views
(@alertadigital)
New Member
Joined: 7 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: 8 years ago
Posts: 6581
 

Hi alertadigital,

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

 

 



   
ReplyQuote
(@alertadigital)
New Member
Joined: 7 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: 8 years ago
Posts: 6581
 

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: 7 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: 7 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: 8 years ago
Posts: 6581
 

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