XF 1.3 Errors after 1.3.2 upgrade

[Temexter]

After very succesful upgrade to 1.3.2 from 1.2.1, couple of errors appeared in sever error log:

Server Error Log
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'forum.find_new' in 'where clause' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Unknown Account, 3 minutes ago
Stack Trace
#0 /var/www/prteamwork.com/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('?????SELECT thr...')
#1 /var/www/prteamwork.com/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '?????SELECT thr...')
#2 /var/www/prteamwork.com/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('?????SELECT thr...')
#3 /var/www/prteamwork.com/library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('?????SELECT thr...', Array, 2)
#4 /var/www/prteamwork.com/library/XenForo/Model/Thread.php(527): XenForo_Model->fetchAllKeyed('?????SELECT thr...', 'thread_id')
#5 /var/www/prteamwork.com/library/XenForo/ControllerPublic/FindNew.php(163): XenForo_Model_Thread->getThreads(Array, Array)
#6 /var/www/prteamwork.com/library/XenForo/ControllerPublic/FindNew.php(35): XenForo_ControllerPublic_FindNew->findNewPosts()
#7 /var/www/prteamwork.com/library/XenForo/FrontController.php(347): XenForo_ControllerPublic_FindNew->actionPosts()
#8 /var/www/prteamwork.com/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#9 /var/www/prteamwork.com/index.php(13): XenForo_FrontController->run()
#10 {main}
Request State
array(3) {
["url"] => string(50) "http://prteamwork.com/find-new/129580/posts?page=2"
["_GET"] => array(2) {
["/find-new/129580/posts"] => string(0) ""
["page"] => string(1) "2"
}
["_POST"] => array(0) {
}
}

Server Error Log
Error Info
ErrorException: Undefined index: node_name - library/XenForo/ControllerPublic/FindNew.php:77
Generated By: Unknown Account, 12 minutes ago
Stack Trace
#0 /var/www/prteamwork.com/library/XenForo/ControllerPublic/FindNew.php(77): XenForo_Application::handlePhpError(8, 'Undefined index...', '/var/www/prteam...', 77, Array)
#1 /var/www/prteamwork.com/library/XenForo/FrontController.php(347): XenForo_ControllerPublic_FindNew->actionPosts()
#2 /var/www/prteamwork.com/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#3 /var/www/prteamwork.com/index.php(13): XenForo_FrontController->run()
#4 {main}
Request State
array(3) {
["url"] => string(47) "http://www.prteamwork.com/find-new/233119/posts"
["_GET"] => array(1) {
["/find-new/233119/posts"] => string(0) ""
}
["_POST"] => array(0) {
}
}

Any idea of reason for these or way to fix?

Cheers,

Temexter

 

[Paul B]

Which add-ons do you have installed or have had installed in the past?

You appear to be missing at least one column from a table.

 

[Temexter]

Installed Add-ons

1. AVForums Moderator Checkpoint System 1.0.3
2. Bb Codes & Buttons Manager 2.8.0
3. Bb Codes & Buttons Manager - Advanced Bb Codes 3.6.1
4. BBM - Button Bb Code 1.2
5. Cliptheapex.com's Countdown Timer 1.7.5.00_EQnoble
6. Custom Fields by Waindigo 2.0.6
7. Digital Point Syntax Highlighter 1.3.0
8. Display Staff Members 1.1.2
9. Donation Manager 1.2.0
10. Double Post Merge 1.0.9
11. Downloads Manager 1.0.2
12. Install and Upgrade by Waindigo 1.1.4
13. LiquidPro Simple Forms 2.1.3
14. Nodes As Tabs 1.2.2
15. Roster 1.0.0
16. Separate Sticky and Normal Threads 1.0
17. Show XenForo Version 1.0.0
18. Steam Auth 1.4.4
19. TaigaChat Pro 1.2.0
20. Tapatalk 2.1.0
21. Teamspeak 1.3.8 Alpha
22. Template Modification System 1.3.0
23. XF QapTcha 1.1
24. [8wayRun.Com] XenPorta (Portal) 1.6.0
25. [bd] Medal 1.4.5b
26. [bd] Medal - Trophy Extension 0.9.2
27. [RT] Online Status Ribbon 1.3.7

The 0nes with strike-through are disabled.

All add-ons are most recent versions, except TaigaChat Pro 1.2.0...

Both errors started after 1.3.2 upgrade.

Add-ons installed after upgrade:
Show XenForo Version 1.0.0
LiquidPro Simple Forms 2.1.3 (version for XF 1.3)
Custom Fields by Waindigo to version 2.0.6. (upgrade)
Install and Upgrade by Waindigo 1.1.4 (upgrade)

I disabled those for a while and errors kept coming in :/

 

[Paul B]

Do you know how to use phpMyAdmin?

Can you run this query?

show create table xf_forum;

Then select full texts and post the output here in a code box.

 

[Temexter]

show create table xf_forum;

Here you are:

xf_forum CREATE TABLE `xf_forum` (
`node_id` int(10) unsigned NOT NULL,
`discussion_count` int(10) unsigned NOT NULL DEFAULT '0',
`message_count` int(10) unsigned NOT NULL DEFAULT '0',
`last_post_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Most recent post_id',
`last_post_date` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Date of most recent post',
`last_post_user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'User_id of user posting most recently',
`last_post_username` varchar(50) NOT NULL DEFAULT '' COMMENT 'Username of most recently-posting user',
`last_thread_title` varchar(150) NOT NULL DEFAULT '' COMMENT 'Title of thread most recent post is in',
`moderate_messages` tinyint(3) unsigned NOT NULL DEFAULT '0',
`allow_posting` tinyint(3) unsigned NOT NULL DEFAULT '1',
`count_messages` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT 'If not set, messages posted (directly) within this forum will not contribute to user message totals.',
`find_new` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT 'Include posts from this forum when running /find-new/threads',
`prefix_cache` mediumblob NOT NULL COMMENT 'Serialized data from xf_forum_prefix, [group_id][prefix_id] => prefix_id',
`default_prefix_id` int(10) unsigned NOT NULL DEFAULT '0',
`require_prefix` tinyint(3) unsigned NOT NULL DEFAULT '0',
`allowed_watch_notifications` varchar(10) NOT NULL DEFAULT 'all',
`default_sort_order` varchar(25) NOT NULL DEFAULT 'last_post_date',
`default_sort_direction` varchar(5) NOT NULL DEFAULT 'desc',
`field_cache` mediumblob COMMENT 'Serialized data from xf_forum_field, [group_id][field_id] => field_id',
`custom_fields` mediumblob,
`required_fields` mediumblob,
`post_field_cache` mediumblob COMMENT 'Serialized data from xf_forum_post_field, [group_id][field_id] => field_id',
`custom_post_fields` mediumblob,
`required_post_fields` mediumblob,
`social_forum_field_cache` mediumblob COMMENT 'Serialized data from xf_social_forum_field, [group_id][field_id] => field_id',
`custom_social_forum_fields` mediumblob,
`required_social_forum_fields` mediumblob,
`bbm_bm_editor` varchar(25) NOT NULL DEFAULT 'disable',
PRIMARY KEY (`node_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

 

[Paul B]

Can you disable all listeners by adding this to your config.php file?

$config['enableListeners'] = false;

Then perform the same action to try and trigger the error again, presumably by clicking on New Posts.

 

[Temexter]

After disabling listeners, no errors, i hit "New posts" with two user accounts and created new posts, waited a while, like 5 minutes...
when i changed it back, both errors instantly came back.

 

[Paul B]

In which case the problem is due to an add-on.

Disable them all and re-enable one at a time to determine which one.

Then contact the developer.

 

[Temexter]

In which case the problem is due to an add-on.

Disable them all and re-enable one at a time to determine which one.

Then contact the developer.

Okay. Thanks for your help