Fatal error in /messages/all

SE_Crew

Users get BONK message in private message section. How to fix it?

Error -1 in table:

select c.*, lm.InsertUserID as `LastMessageUserID`, lm.DateInserted as `DateLastMessage`, lm.Body as `LastMessage`, lm.Format as `Format`, lmu.Name as `LastMessageName`, lmu.Photo as `LastMessagePhoto`, c.CountMessages - uc.CountReadMessages as `CountNewMessages`, uc.LastMessageID as `LastMessageID`, uc.CountReadMessages as `CountReadMessages`, uc.DateLastViewed as `DateLastViewed`, uc.Bookmarked as `Bookmarked` from GDN_Conversation c join GDN_UserConversation uc on c.ConversationID = uc.ConversationID and uc.UserID = 1 join GDN_ConversationMessage lm on uc.LastMessageID = lm.MessageID join GDN_User lmu on lm.InsertUserID = lmu.UserID where uc.Deleted = :ucDeleted order by c.DateUpdated desc limit 50

The error occurred on or near: /public_html/library/database/class.database.php
276: 
277:          if (!is_object($PDOStatement)) {
278:             trigger_error(ErrorMessage('PDO Statement failed to prepare', $this->ClassName, 'Query', $this->GetPDOErrorMessage($this->Connection()->errorInfo())), E_USER_ERROR);
279:          } else if ($PDOStatement->execute($InputParameters) === FALSE) {
280:             trigger_error(ErrorMessage($this->GetPDOErrorMessage($PDOStatement->errorInfo()), $this->ClassName, 'Query', $Sql), E_USER_ERROR);
281:          }
282:       } else {
283:          $PDOStatement = $this->Connection()->query($Sql);
284:       }

Backtrace:

/public_html/library/database/class.database.phpPHP::Gdn_ErrorHandler();
[/public_html/library/database/class.database.php:280] PHP::trigger_error();
[/public_html/library/database/class.sqldriver.php:1657] Gdn_Database->Query();
[/public_html/library/database/class.sqldriver.php:683] Gdn_SQLDriver->Query();
[/public_html/applications/conversations/models/class.conversationmodel.php:102] Gdn_SQLDriver->Get();
[/public_html/applications/conversations/controllers/class.messagescontroller.php:182] ConversationModel->Get();
[/public_html/applications/conversations/controllers/class.messagescontroller.php:182] MessagesController->All();
[/public_html/library/core/class.dispatcher.php:322] PHP::call_user_func_array();
[/public_html/index.php:53] Gdn_Dispatcher->Dispatch();

Variables in local scope:

[Sql] 'select c.*, lm.InsertUserID as `LastMessageUserID`, lm.DateInserted as `DateLastMessage`, lm.Body as `LastMessage`, lm.Format as `Format`, lmu.Name as `LastMessageName`, lmu.Photo as `LastMessagePhoto`, c.CountMessages - uc.CountReadMessages as `CountNewMessages`, uc.LastMessageID as `LastMessageID`, uc.CountReadMessages as `CountReadMessages`, uc.DateLastViewed as `DateLastViewed`, uc.Bookmarked as `Bookmarked`
from GDN_Conversation c
join GDN_UserConversation uc on c.ConversationID = uc.ConversationID and uc.UserID = 1
join GDN_ConversationMessage lm on uc.LastMessageID = lm.MessageID
join GDN_User lmu on lm.InsertUserID = lmu.UserID
where uc.Deleted = :ucDeleted
order by c.DateUpdated desc
limit 50'

[InputParameters] array (
  ':ucDeleted' => 0,
)

[Options] array (
  'ReturnType' => 'DataSet',
)

[ReturnType] 'DataSet'

[PDOStatement] array (
  'queryString' => 'select c.*, lm.InsertUserID as `LastMessageUserID`, lm.DateInserted as `DateLastMessage`, lm.Body as `LastMessage`, lm.Format as `Format`, lmu.Name as `LastMessageName`, lmu.Photo as `LastMessagePhoto`, c.CountMessages - uc.CountReadMessages as `CountNewMessages`, uc.LastMessageID as `LastMessageID`, uc.CountReadMessages as `CountReadMessages`, uc.DateLastViewed as `DateLastViewed`, uc.Bookmarked as `Bookmarked`
from GDN_Conversation c
join GDN_UserConversation uc on c.ConversationID = uc.ConversationID and uc.UserID = 1
join GDN_ConversationMessage lm on uc.LastMessageID = lm.MessageID
join GDN_User lmu on lm.InsertUserID = lmu.UserID
where uc.Deleted = :ucDeleted
order by c.DateUpdated desc
limit 50',
)

Additional information for support personnel:

    Application: Vanilla
    Application Version: 2.0.18.10
    PHP Version: 5.2.17

peregrine

I would upgrade vanilla to 2.1.6

troubleshooting insecure versions of vanilla is a waste of your energy.

peregrine

I would upgrade vanilla to 2.1.6

troubleshooting insecure versions of vanilla is a waste of your energy.

SE_Crew

OK, I can upgrade, but will the problem disappear?

peregrine

@SE_Crew said:
OK, I can upgrade, but will the problem disappear?

you tell me, after you upgrade.