AI Search
Classic Search
 Search Phrase:
 Search Type:
Advanced search options
 Search in Forums:
 Search in date period:

 Sort Search Results by:

AI Assistant
Notifications
Clear all

[Solved] 1.4.2 Database fatal errors

8 Posts
2 Users
1 Reactions
4,562 Views
Posts: 1593
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@anonymous20)
Noble Member
Joined: 10 years ago
[#5119]

 

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: 10733
Admin
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@robert)
Support Team
Joined: 2 months 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: 1593
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@anonymous20)
Noble Member
Joined: 10 years ago

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


1 Reply
(@anonymous20)
Joined: 10 years ago

Noble Member
Posts: 1593
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian

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

Thanks


Robert
Posts: 10733
Admin
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@robert)
Support Team
Joined: 2 months 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: 1593
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@anonymous20)
Noble Member
Joined: 10 years ago

Fixed already. Thanks.


Page 1 / 2
Share: