Notifications
Clear all
Topic starter
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.
21/07/2018 3:49 pm
Hi alertadigital,
Please deactivate the wpDiscuz plugin then activate it and check again.
Topic starter
24/07/2018 7:43 pm
Hi alertadigital,
Please deactivate the wpDiscuz plugin then activate it and check again.
This doesnt fix it... any other tip?.
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.
Topic starter
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'
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 ?
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.