Notifications
Clear all

wpForo 1.x.x [Solved] 1.4.2 Database fatal errors

8 Posts
2 Users
1 Likes
2,696 Views
Posts: 1602
Topic starter
(@anonymous20)
Noble Member
Joined: 8 years ago

 

Not sure from where those came from:

 

[22-Oct-2017 18:00:17 UTC] WordPress database error Unknown column 'wp_wpforo_posts.private' in 'where clause' for query SELECT count(*) FROM `wp_wpforo_posts` WHERE `wp_wpforo_posts`.`status` = 0 AND `wp_wpforo_posts`.`private` = 0 ORDER BY `created` DESC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/justwrite/index.php'), get_footer, locate_template, load_template, require_once('/themes/justwrite/footer.php'), dynamic_sidebar, WP_Widget->display_callback, wpForo_Widget_recent_replies->widget, wpForoPost->get_posts_filtered, wpForoPost->get_posts

 

[22-Oct-2017 18:00:17 UTC] WordPress database error Unknown column 'wp_wpforo_posts.private' in 'where clause' for query SELECT * FROM `wp_wpforo_posts` WHERE `wp_wpforo_posts`.`status` = 0 AND `wp_wpforo_posts`.`private` = 0 ORDER BY `created` DESC LIMIT 5 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/justwrite/index.php'), get_footer, locate_template, load_template, require_once('/themes/justwrite/footer.php'), dynamic_sidebar, WP_Widget->display_callback, wpForo_Widget_recent_replies->widget, wpForoPost->get_posts_filtered, wpForoPost->get_posts

 

7 Replies
Robert
Posts: 10503
Admin
(@robert)
Support Team
Joined: 8 years ago

Please navigate to Dashboars and call this URL:

http:// example.com/wp-admin/admin.php?page=wpforo-community&action=wpfdb&wpfv=142

If it doesn't help, execute this SQL in database:

UPDATE `wp_wpforo_posts`, `wp_wpforo_topics` SET `wp_wpforo_posts`.`private` = `wp_wpforo_topics`.`private` WHERE `wp_wpforo_posts`.`topicid` = `wp_wpforo_topics`.`topicid`

Don't forget to change table prefix if yours is not wp_

This issue will be fixed in next release very soon. It's only related to forums who had not private topics and creates one.

 

Posts: 1602
Topic starter
(@anonymous20)
Noble Member
Joined: 8 years ago

The first solution gives me "Permission denied" i will try to second.

1 Reply
(@anonymous20)
Joined: 8 years ago

Noble Member
Posts: 1602

Second (scipt) executed well, i will see if any more errors appear.

Thanks

Robert
Posts: 10503
Admin
(@robert)
Support Team
Joined: 8 years ago

Ok, I see the problem. The update process was incomplete on your forum and the new field in wpforo_posts table is not created. Please make sure the _wpforo_posts table has "private" field (it's the last field). if its not there please execute this SQL:

ALTER TABLE `wp_wpforo_posts` ADD `private` TINYINT(1) NOT NULL DEFAULT '0' AFTER `email`, ADD INDEX `is_private` (`private`);

 

Posts: 1602
Topic starter
(@anonymous20)
Noble Member
Joined: 8 years ago

Fixed already. Thanks.

Page 1 / 2