Fatal Error in Gdn_Database.Query();

Table 'thenerd5_vanilla.GDN_Discussion' doesn't exist

select distinct c.Name as `Name`, c.CategoryID as `CategoryID`, c.TreeRight as `TreeRight`, c.TreeLeft as `TreeLeft`, c.Depth as `Depth`, c.Description as `Description`, c.CountDiscussions as `CountDiscussions`, c.CountComments as `CountComments`, c.UrlCode as `UrlCode`, c.LastCommentID as `LastCommentID`, c.PermissionCategoryID as `PermissionCategoryID`, co.DateInserted as `DateLastComment`, co.InsertUserID as `LastCommentUserID`, cu.Name as `LastCommentName`, cu.Photo as `LastCommentPhoto`, co.DiscussionID as `LastDiscussionID`, d.Name as `LastDiscussionName` from GDN_Category c inner join GDN_Permission _p on _p.JunctionID = c.PermissionCategoryID inner join GDN_UserRole _ur on _p.RoleID = _ur.RoleID left join GDN_Comment co on c.LastCommentID = co.CommentID left join GDN_User cu on co.InsertUserID = cu.UserID left join GDN_Discussion d on d.DiscussionID = co.DiscussionID where (_ur.UserID = :_urUserID and (_p.`Vanilla.Discussions.Add` = :_pVanillaDiscussionsAdd) and c.AllowDiscussions = :cAllowDiscussions) order by TreeLeft asc

The error occurred on or near: /home/thenerdgamers/thenerdgamers.com/forum/library/database/class.database.php

225: 
226:          if (!is_object($PDOStatement)) {
227:             trigger_error(ErrorMessage('PDO Statement failed to prepare', $this->ClassName, 'Query', $this->GetPDOErrorMessage($this->Connection()->errorInfo())), E_USER_ERROR);
228:          } else if ($PDOStatement->execute($InputParameters) === FALSE) {
229:             trigger_error(ErrorMessage($this->GetPDOErrorMessage($PDOStatement->errorInfo()), $this->ClassName, 'Query', $Sql), E_USER_ERROR);
230:          }
231:       } else {
232:          $PDOStatement = $this->Connection()->query($Sql);
233:       }

Backtrace:

/home/thenerdgamers/thenerdgamers.com/forum/library/database/class.database.phpPHP::Gdn_ErrorHandler();
[/home/thenerdgamers/thenerdgamers.com/forum/library/database/class.database.php:229] PHP::trigger_error();
[/home/thenerdgamers/thenerdgamers.com/forum/library/database/class.sqldriver.php:1584] Gdn_Database->Query();
[/home/thenerdgamers/thenerdgamers.com/forum/library/database/class.sqldriver.php:639] Gdn_SQLDriver->Query();
[/home/thenerdgamers/thenerdgamers.com/forum/applications/vanilla/models/class.categorymodel.php:274] Gdn_SQLDriver->Get();
[/home/thenerdgamers/thenerdgamers.com/forum/applications/vanilla/controllers/class.postcontroller.php:80] CategoryModel->GetFull();
[/home/thenerdgamers/thenerdgamers.com/forum/applications/vanilla/controllers/class.postcontroller.php:80] PostController->Discussion();
[/home/thenerdgamers/thenerdgamers.com/forum/library/core/class.dispatcher.php:299] PHP::call_user_func_array();
[/home/thenerdgamers/thenerdgamers.com/forum/index.php:38] Gdn_Dispatcher->Dispatch();

Variables in local scope:

[Sql] 'select distinct c.Name as `Name`, c.CategoryID as `CategoryID`, c.TreeRight as `TreeRight`, c.TreeLeft as `TreeLeft`, c.Depth as `Depth`, c.Description as `Description`, c.CountDiscussions as `CountDiscussions`, c.CountComments as `CountComments`, c.UrlCode as `UrlCode`, c.LastCommentID as `LastCommentID`, c.PermissionCategoryID as `PermissionCategoryID`, co.DateInserted as `DateLastComment`, co.InsertUserID as `LastCommentUserID`, cu.Name as `LastCommentName`, cu.Photo as `LastCommentPhoto`, co.DiscussionID as `LastDiscussionID`, d.Name as `LastDiscussionName`
from GDN_Category c
inner join GDN_Permission _p on _p.JunctionID = c.PermissionCategoryID
inner join GDN_UserRole _ur on _p.RoleID = _ur.RoleID
left join GDN_Comment co on c.LastCommentID = co.CommentID
left join GDN_User cu on co.InsertUserID = cu.UserID
left join GDN_Discussion d on d.DiscussionID = co.DiscussionID
where (_ur.UserID = :_urUserID
   and (_p.`Vanilla.Discussions.Add` = :_pVanillaDiscussionsAdd)
  and c.AllowDiscussions = :cAllowDiscussions)
order by TreeLeft asc'
[InputParameters] array (
  ':_urUserID' => 0,
  ':_pVanillaDiscussionsAdd' => 1,
  ':cAllowDiscussions' => '1',
)
[Options] array (
  'ReturnType' => 'DataSet',
)
[PDOStatement] array (
  'queryString' => 'select distinct c.Name as `Name`, c.CategoryID as `CategoryID`, c.TreeRight as `TreeRight`, c.TreeLeft as `TreeLeft`, c.Depth as `Depth`, c.Description as `Description`, c.CountDiscussions as `CountDiscussions`, c.CountComments as `CountComments`, c.UrlCode as `UrlCode`, c.LastCommentID as `LastCommentID`, c.PermissionCategoryID as `PermissionCategoryID`, co.DateInserted as `DateLastComment`, co.InsertUserID as `LastCommentUserID`, cu.Name as `LastCommentName`, cu.Photo as `LastCommentPhoto`, co.DiscussionID as `LastDiscussionID`, d.Name as `LastDiscussionName`
from GDN_Category c
inner join GDN_Permission _p on _p.JunctionID = c.PermissionCategoryID
inner join GDN_UserRole _ur on _p.RoleID = _ur.RoleID
left join GDN_Comment co on c.LastCommentID = co.CommentID
left join GDN_User cu on co.InsertUserID = cu.UserID
left join GDN_Discussion d on d.DiscussionID = co.DiscussionID
where (_ur.UserID = :_urUserID
   and (_p.`Vanilla.Discussions.Add` = :_pVanillaDiscussionsAdd)
  and c.AllowDiscussions = :cAllowDiscussions)
order by TreeLeft asc',
)

Need Help?

If you are a user of this website, you can report this message to a website administrator.

If you are an administrator of this website, you can get help at the Vanilla Community Forums.

Additional information for support personnel: