AI Assistant

Notifications

Clear all

Database table missing?

✦ Summarize Topic

How-To and Troubleshooting

Last Post by Astghik 8 years ago

8 Posts

3 Users

0 Reactions

5,560 Views

RSS

alertadigital

(@alertadigital)

New Member

Joined: 8 years ago

Posts: 3

Topic starter

Translate ▼

20/07/2018 8:12 pm [#2666]

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: 6645

Translate ▼

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

Posts: 3

Topic starter

Translate ▼

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

(@astgh)

Illustrious Member Admin

Joined: 8 years ago

Posts: 6645

Translate ▼

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.

ReplyQuote

alertadigital

(@alertadigital)

New Member

Joined: 8 years ago

Posts: 3

Topic starter

Translate ▼

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)

New Member

Joined: 8 years ago

Posts: 1

Translate ▼

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

(@astgh)

Illustrious Member Admin

Joined: 8 years ago

Posts: 6645

Translate ▼

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