XF 1.2 Forum Watch Error

DRE · Jun 19, 2013

I clicked on a subforum and got a forum watch error that would not let me view the subforum.

Disabled all listeners and I still get this same error.

Server Error
Mysqli prepare error: Unknown column 'forum_watch.node_id' in 'on clause'

Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 753
Zend_Db_Adapter_Abstract->fetchRow() in XenForo/Model/Forum.php at line 29
XenForo_Model_Forum->getForumById() in XenForo/ControllerHelper/ForumThreadPost.php at line 177
XenForo_ControllerHelper_ForumThreadPost->getForumOrError() in XenForo/ControllerHelper/ForumThreadPost.php at line 38
XenForo_ControllerHelper_ForumThreadPost->assertForumValidAndViewable() in XenForo/ControllerPublic/Forum.php at line 88
XenForo_ControllerPublic_Forum->actionForum() in XenForo/FrontController.php at line 335
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
XenForo_FrontController->run() in abadelabhaha/index.php at line 13

Rigel Kentaurus · Jun 19, 2013

Mike said:
Yeah, that's not our version. The previous post applies.

What about doing a DROP TABLE IF EXISTS before creating it?
Or ... renaming the table if exists.

For a popular add-on that might be better than answering the question over and over again.

(Yes, if the add-on is not disabled, the add-on might fail since it will not be expecting that table structure, but at least the installer would succeed)

xf_phantom · Jun 19, 2013

Rigel Kentaurus said:
What about doing a DROP TABLE IF EXISTS before creating it?
Or ... renaming the table if exists.

For a popular add-on that might be better than answering the question over and over again.

(Yes, if the add-on is not disabled, the add-on might fail since it will not be expecting that table structure, but at least the installer would succeed)

http://xenforo.com/community/threads/xenforo-upgrade-improvement.52864/

DRE · Jun 19, 2013

I get this error when I click the 'Watched Forums' link so I'm going to remove the Watched Forums link from the site.

Code:

An exception occurred: Invalid argument supplied for foreach() in /var/www/vhosts/8thos.com/httpdocs/library/XenForo/ViewPublic/Watched/Forums.php on line 21


XenForo_Application::handlePhpError() in XenForo/ViewPublic/Watched/Forums.php at line 21
XenForo_ViewPublic_Watched_Forums->renderHtml() in XenForo/ViewRenderer/Abstract.php at line 220
XenForo_ViewRenderer_Abstract->renderViewObject() in XenForo/ViewRenderer/HtmlPublic.php at line 67
XenForo_ViewRenderer_HtmlPublic->renderView() in XenForo/FrontController.php at line 569
XenForo_FrontController->renderView() in XenForo/FrontController.php at line 156
XenForo_FrontController->run() in blahblahblah/index.php at line 13

rdn · Jun 19, 2013

DRE said:

I get this error when I click the 'Watched Forums' link so I'm going to remove the Watched Forums link from the site.

Code:

An exception occurred: Invalid argument supplied for foreach() in /var/www/vhosts/8thos.com/httpdocs/library/XenForo/ViewPublic/Watched/Forums.php on line 21


XenForo_Application::handlePhpError() in XenForo/ViewPublic/Watched/Forums.php at line 21
XenForo_ViewPublic_Watched_Forums->renderHtml() in XenForo/ViewRenderer/Abstract.php at line 220
XenForo_ViewRenderer_Abstract->renderViewObject() in XenForo/ViewRenderer/HtmlPublic.php at line 67
XenForo_ViewRenderer_HtmlPublic->renderView() in XenForo/FrontController.php at line 569
XenForo_FrontController->renderView() in XenForo/FrontController.php at line 156
XenForo_FrontController->run() in blahblahblah/index.php at line 13

Mine, After running this query:
Error Fixed

xf_phantom said:

Code:

    CREATE TABLE xf_forum_watch (
        `user_id` int(10) unsigned NOT NULL,
        `node_id` int(10) unsigned NOT NULL,
        `notify_on` enum('','thread','message') NOT NULL,
        `send_alert` tinyint(3) unsigned NOT NULL,
        `send_email` tinyint(3) unsigned NOT NULL,
        PRIMARY KEY (`user_id`,`node_id`),
        KEY `node_id_notify_on` (`node_id`,`notify_on`)
    ) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci

DRE · Jun 19, 2013

I been did that.

xfrocks · Jun 20, 2013

Just FYI, the existing data will be migrated to XenForo 1.2 table in the next version of [bd] Forum Watch (to be released soon). Make sure you update the latest version of the add-on before you upgrade to 1.2. Sorry all for the problem.

Wildcat Media · Jun 20, 2013

xf_phantom said:
I hope you ALL had your lesson!

DON'T RUN BETA on your livesite if you're not knowing what you're doing!

Likewise, add-ons should not interfere with the base XF installation. Any add-on specific tables should use a unique prefix.

Sheratan · Jul 2, 2013

DRE said:

I get this error when I click the 'Watched Forums' link so I'm going to remove the Watched Forums link from the site.

Code:

An exception occurred: Invalid argument supplied for foreach() in /var/www/vhosts/8thos.com/httpdocs/library/XenForo/ViewPublic/Watched/Forums.php on line 21


XenForo_Application::handlePhpError() in XenForo/ViewPublic/Watched/Forums.php at line 21
XenForo_ViewPublic_Watched_Forums->renderHtml() in XenForo/ViewRenderer/Abstract.php at line 220
XenForo_ViewRenderer_Abstract->renderViewObject() in XenForo/ViewRenderer/HtmlPublic.php at line 67
XenForo_ViewRenderer_HtmlPublic->renderView() in XenForo/FrontController.php at line 569
XenForo_FrontController->renderView() in XenForo/FrontController.php at line 156
XenForo_FrontController->run() in blahblahblah/index.php at line 13

I've got this error too today. Never install [bd] forum watch.

login to phpMyAdmin, I had xf_forum_watch table.

http://xenforo.com/community/goto/post?id=565823#post-565823 Can I use this?

FredC · Jul 16, 2013

xf_phantom said:

Code:

    CREATE TABLE xf_forum_watch (
        `user_id` int(10) unsigned NOT NULL,
        `node_id` int(10) unsigned NOT NULL,
        `notify_on` enum('','thread','message') NOT NULL,
        `send_alert` tinyint(3) unsigned NOT NULL,
        `send_email` tinyint(3) unsigned NOT NULL,
        PRIMARY KEY (`user_id`,`node_id`),
        KEY `node_id_notify_on` (`node_id`,`notify_on`)
    ) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci

Umm how would one go about executing this little dittiy??

Paul B · Jul 16, 2013

Using phpMyAdmin.

HenrikHansen · Jul 26, 2013

VonDoom said:
Umm how would one go about executing this little dittiy??

How do you dot that, I receive #1050 - Table 'xf_forum_watch' already exists?

(I completely forgot all about this before I upgraded to 1.2 RC2)

HenrikHansen · Jul 26, 2013

HenrikHansen said:
How do you dot that, I receive #1050 - Table 'xf_forum_watch' already exists?

OK, tried again by renaming old forum watch table, so now suceeeded. Still seing those errors the main admin page, though

Mysqli prepare error: Unknown column 'template_map.template_final' in 'field list'

Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219
XenForo_Model->fetchAllKeyed() in TMS/Model/Template.php at line 228
TMS_Model_Template->fetchAllKeyed() in XenForo/Model/Template.php at line 431
XenForo_Model_Template->getOutdatedTemplates() in XenForo/ControllerAdmin/Home.php at line 26
XenForo_ControllerAdmin_Home->actionIndex() in XenForo/FrontController.php at line 337
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/euinfo/public_html/usanet.dk/admin.php at line 13

MattW · Jul 26, 2013

HenrikHansen said:
OK, tried again by renaming old forum watch table, so now suceeeded. Still seing those errors the main admin page, though

Mysqli prepare error: Unknown column 'template_map.template_final' in 'field list'

Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115

Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381

Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478

Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219

XenForo_Model->fetchAllKeyed() in TMS/Model/Template.php at line 228

TMS_Model_Template->fetchAllKeyed() in XenForo/Model/Template.php at line 431

XenForo_Model_Template->getOutdatedTemplates() in XenForo/ControllerAdmin/Home.php at line 26

XenForo_ControllerAdmin_Home->actionIndex() in XenForo/FrontController.php at line 337

XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134

XenForo_FrontController->run() in /home/euinfo/public_html/usanet.dk/admin.php at line 13

That is the Template Modification System add-on causing that error:

http://xenforo.com/community/threads/template-modification-system-tms.27973/page-30#post-592896

Uninstall it.

nukedi · Jul 31, 2013

xf_phantom said:

Code:

    CREATE TABLE xf_forum_watch (
        `user_id` int(10) unsigned NOT NULL,
        `node_id` int(10) unsigned NOT NULL,
        `notify_on` enum('','thread','message') NOT NULL,
        `send_alert` tinyint(3) unsigned NOT NULL,
        `send_email` tinyint(3) unsigned NOT NULL,
        PRIMARY KEY (`user_id`,`node_id`),
        KEY `node_id_notify_on` (`node_id`,`notify_on`)
    ) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci

Thx... you saved my day

Surf3rDud3 · Aug 2, 2013

I currently have this error and I have ran the Query and still no luck. The error still occurs?

Code:

An exception occurred: Invalid argument supplied for foreach() in /library/XenForo/ViewPublic/Watched/Forums.php on line 21

XenForo_Application::handlePhpError() in XenForo/ViewPublic/Watched/Forums.php at line 21
XenForo_ViewPublic_Watched_Forums->renderHtml() in XenForo/ViewRenderer/Abstract.php at line 227
XenForo_ViewRenderer_Abstract->renderViewObject() in XenForo/ViewRenderer/HtmlPublic.php at line 67
XenForo_ViewRenderer_HtmlPublic->renderView() in XenForo/FrontController.php at line 572
XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
XenForo_FrontController->run() in /index.php at line 13

Mike · Aug 2, 2013

This has only been known to happen with the forum watch add-on. If you still have it installed, you need to uninstall it.

Surf3rDud3 · Aug 2, 2013

The only thing I have is the same addon by the same author called Widget Framework.

Case · Aug 12, 2013

Surf3rDud3 said:

I currently have this error and I have ran the Query and still no luck. The error still occurs?

Code:

An exception occurred: Invalid argument supplied for foreach() in /library/XenForo/ViewPublic/Watched/Forums.php on line 21

XenForo_Application::handlePhpError() in XenForo/ViewPublic/Watched/Forums.php at line 21
XenForo_ViewPublic_Watched_Forums->renderHtml() in XenForo/ViewRenderer/Abstract.php at line 227
XenForo_ViewRenderer_Abstract->renderViewObject() in XenForo/ViewRenderer/HtmlPublic.php at line 67
XenForo_ViewRenderer_HtmlPublic->renderView() in XenForo/FrontController.php at line 572
XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
XenForo_FrontController->run() in /index.php at line 13

I've just noticed this server error myself. I've never used the forum watch add-on.

I do use Widget Framework though.

X3nman · Aug 30, 2013

I had the same error and didn't solve it using the information here.
There is another addon causing this error or relating to this error...

Add Username Style to Last Post

Read this for the edits that fix it.
http://xenforo.com/community/threads/add-username-style-to-last-post.36509/page-2

Tize · Nov 12, 2013

Hi all, I have the same problem now and not Quebo do.
Someone could post some help on how to solve this problem please?

XF 1.2 Forum Watch Error

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

XenForo moderator

Well-known member

Well-known member

Well-known member

Member

Member

XenForo developer

Member

Well-known member

Member

Active member

Similar threads

We value your privacy