vanillaforums/Garden — Issue #1165: possible IE bug tagging plugin van version 2.0.18RC2
Author: camosreptiles
Created: 2011-10-18 18:23:11+00:00
State: open

In IE only, clicking a tag gives folloeing error..

Just discovered clicking a tag throws the following error in IE browser only

Fatal Error in Gdn_Database.Query();
Unknown column 'd.DiscussionID' in 'on clause'
select c.*, lc.DateInserted as `DateLastComment`
from GDN_Category c
join GDN_TagDiscussion td on d.DiscussionID = td.DiscussionID
left join GDN_Comment lc on c.LastCommentID = lc.CommentID
where td.TagID in ('6')
order by c.TreeLeft asc
limit 15
The error occurred on or near: /s101-2/home6/camosreptiles/forum/library/database/class.database.php

283: $PDOStatement = $this->Connection()->query($Sql); 284: } 285: 286: if ($PDOStatement === FALSE) { 287: trigger_error(ErrorMessage($this->GetPDOErrorMessage($this->Connection()->errorInfo()), $this->ClassName, 'Query', $Sql), E_USER_ERROR); 288: } 289: 290: // Did this query modify data in any way? 291: if ($ReturnType == 'ID') {
Backtrace:

/s101-2/home6/camosreptiles/forum/library/database/class.database.phpPHP::Gdn_ErrorHandler(); [/s101-2/home6/camosreptiles/forum/library/database/class.database.php:287] PHP::trigger_error(); [/s101-2/home6/camosreptiles/forum/library/database/class.sqldriver.php:1650] Gdn_Database->Query(); [/s101-2/home6/camosreptiles/forum/library/database/class.sqldriver.php:676] Gdn_SQLDriver->Query(); [/s101-2/home6/camosreptiles/forum/applications/vanilla/models/class.categorymodel.php:90] Gdn_SQLDriver->Get(); [/s101-2/home6/camosreptiles/forum/applications/vanilla/models/class.discussionmodel.php:446] CategoryModel::Categories(); [/s101-2/home6/camosreptiles/forum/applications/vanilla/models/class.discussionmodel.php:55] DiscussionModel::CategoryPermissions(); [/s101-2/home6/camosreptiles/forum/applications/vanilla/models/class.discussionmodel.php:137] DiscussionModel->DiscussionSummaryQuery(); [/s101-2/home6/camosreptiles/forum/plugins/Tagging/class.tagging.plugin.php:106] DiscussionModel->Get(); [/s101-2/home6/camosreptiles/forum/library/core/class.pluginmanager.php:713] TaggingPlugin->DiscussionsController_Tagged_Create(); [/s101-2/home6/camosreptiles/forum/library/core/class.dispatcher.php:313] Gdn_PluginManager->CallNewMethod(); [/s101-2/home6/camosreptiles/forum/index.php:53] Gdn_Dispatcher->Dispatch();
Variables in local scope:

[Sql] 'select c.*, lc.DateInserted as `DateLastComment`
from GDN_Category c
join GDN_TagDiscussion td on d.DiscussionID = td.DiscussionID
left join GDN_Comment lc on c.LastCommentID = lc.CommentID
where td.TagID in (\'6\')
order by c.TreeLeft asc
limit 15' [InputParameters] array (
) [Options] array (
'ReturnType' => 'DataSet',
) [ReturnType] 'DataSet' [PDOStatement] false