#1 WordPress forum plugin created by gVectors Team

wpForo – WordPress Forum Plugin
  • Home
  • Forum
  • Migrate to wpForo
  • Addons
  • Addons Demo
  • Documentation

Forum

Home | Forum

wpDiscuz - WordPress Comment Plugin
  • Forums
  • Members
  • Recent Posts
Forums
Main Support Forums
How-to and Troubles...
1.4.2 Database fata...
 
Share:
Share
Tweet
Share
Notifications
Clear all

[Solved] 1.4.2 Database fatal errors

Page 1 / 2 Next
    Last Post
RSS

Anonymous20
Posts: 1602
 Anonymous20
Topic starter
October 23, 2017 3:08 pm
(@anonymous20)
Noble Member
Joined: 6 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: 9090
Robert - Twitter
 Robert
Admin
October 23, 2017 3:15 pm
(@robert)
Support Team
Joined: 6 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.

 

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.

Reply
Anonymous20 liked
Anonymous20
Posts: 1602
 Anonymous20
Topic starter
October 23, 2017 3:21 pm
(@anonymous20)
Noble Member
Joined: 6 years ago

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

Reply
1 Reply
Anonymous20
 Anonymous20
(@anonymous20)
Joined: 6 years ago

Noble Member
Posts: 1602
October 23, 2017 3:25 pm
Reply toAnonymous20Anonymous20

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

Thanks

Reply
Robert
Posts: 9090
Robert - Twitter
 Robert
Admin
October 23, 2017 3:30 pm
(@robert)
Support Team
Joined: 6 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`);

 

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.

Reply
Anonymous20
Posts: 1602
 Anonymous20
Topic starter
October 23, 2017 3:34 pm
(@anonymous20)
Noble Member
Joined: 6 years ago

Fixed already. Thanks.

Reply
Page 1 / 2 Next
  All forum topics
  Previous Topic
Next Topic  

Forum Search

Join Us!

Download wpForo plugin
on WordPress.org

wpForo Addons

wpforo-private-messages wpforo-advanced-attachments-128x128 wpforo-embeds-128x128 wpForo User Custom Fields addon wpForo – Blog Cross Posting addon wpForo Ads Manager wpForo – WooCommerce Memberships Integration wpForo Emoticons wpForo – Tenor GIFs Integration
View all Addons »

Recent Topics

  • Suggestion How to make new user to get approve manually before creating post and profile.

    By Adhyansh21, 9 hours ago

  • Posts deleted in database still show up on front-end

    By nylex, 11 hours ago

  • Not all links are automatically added with the "nofollow" attribute

    By st7878, 14 hours ago

  • Editors assign users to groups

    By mike_netinfo, 16 hours ago

  • Set password link opens forum login page instead of set password page

    By JanJan, 17 hours ago

  • User banned for using icons?

    By JanJan, 17 hours ago

Topic Tags

  • css52
  • translation50
  • plugin conflict48
  • seo47
  • new features45
  • buddypress43
  • avatar41
  • moderation40
  • ultimate member40
  • login40
  • forum40
  • registration37
  • threaded layout35
  • cache34
  • editor33
  • menu33
  • spam32
  • shortcode32
  • forum accesses30
  • widget29
View all tags (2190)

Recent Posts

  • RE: recover deleted forum categories

    I didn't delete the categories on the forum, just did s...

    By Asmadi1, 2 hours ago

  • recover deleted forum categories

    hi I need help, I accidentally deleted categories and f...

    By Asmadi1, 2 hours ago

  • RE: Not all links are automatically added with the "nofollow" attribute

    I have no idea, i guess not.

    By dimalifragis, 3 hours ago

  • RE: How to make new user to get approve manually before creating post and profile.

    Thanks again

    By Adhyansh21, 7 hours ago

  • RE: Posts deleted in database still show up on front-end

    Ok then, wait until someone from wpForo support will he...

    By dimalifragis, 9 hours ago

  • RE: Set password link opens forum login page instead of set password page

    Hi @janjan, Go to Dashboard > Forums > Settings...

    By Chris, 14 hours ago

  • RE: Editors assign users to groups

    Hi @mike_netinfo, Only administrators can change user...

    By Chris, 15 hours ago

Share:
Share
Tweet
Share
  Forum Statistics
21 Forums
9,933 Topics
50.2 K Posts
7 Online
48 K Members

Latest Post: recover deleted forum categories Our newest member: fun88casino17 Recent Posts Unread Posts Tags

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo | Copyright © 2016-2022 gVectors Team
Copyright Registration Service - Click here for more information or to register work
wpForo is Registered with the IP Rights Office
Copyright Registration Service

Ref: 4477265538
  • Home
  • Forum
  • Migrate to wpForo
  • Addons
  • Addons Demo
  • Documentation