Gravatar plugin doesn't work with 2.0.18.1

ronakg

I upgraded my forum http://www.ronakg.com/discussions from 2.0.18 beta2 to latest. Since then the Gravatar plugin is not working. Here are the errors I get when I enable Gravatar.

Unknown column 'iu.Email' in 'field list'
select iu.Email as `InsertEmail`, d.*, w.DateLastViewed as `DateLastViewed`, w.Dismissed as `Dismissed`, w.Bookmarked as `Bookmarked`, w.CountComments as `CountCommentWatch`, d.DateLastComment as `LastDate`, d.LastCommentUserID as `LastUserID` from GDN_Discussion d left join GDN_UserDiscussion w on d.DiscussionID = w.DiscussionID and w.UserID = 1 where d.DiscussionID = :dDiscussionID

The error occurred on or near: /htdocs/forum/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: }

Variables in local scope:

[Sql] 'select iu.Email as `InsertEmail`, d.*, w.DateLastViewed as `DateLastViewed`, w.Dismissed as `Dismissed`, w.Bookmarked as `Bookmarked`, w.CountComments as `CountCommentWatch`, d.DateLastComment as `LastDate`, d.LastCommentUserID as `LastUserID`
from GDN_Discussion d
left join GDN_UserDiscussion w on d.DiscussionID = w.DiscussionID and w.UserID = 1
where d.DiscussionID = :dDiscussionID'

[InputParameters] array (
':dDiscussionID' => '24',
)

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

[ReturnType] 'DataSet'

[PDOStatement] array (
'queryString' => 'select iu.Email as `InsertEmail`, d.*, w.DateLastViewed as `DateLastViewed`, w.Dismissed as `Dismissed`, w.Bookmarked as `Bookmarked`, w.CountComments as `CountCommentWatch`, d.DateLastComment as `LastDate`, d.LastCommentUserID as `LastUserID`
from GDN_Discussion d
left join GDN_UserDiscussion w on d.DiscussionID = w.DiscussionID and w.UserID = 1
where d.DiscussionID = :dDiscussionID',
)

Linc

Gravatar is bundled with Vanilla. Be sure you copied the plugins folder over too.

Aolee

get the gravatar plugin from the latest version and overwrite the one in your webserver. when u did the upgrade, your avartar director could have not been overwritten / updated with the new version, (maybe due to file/folder permission). that's what happened to me.

ronakg

Getting latest Gravatar plugin is part of the problem too. Now I
can't locate it on the add-ons page.

Linc

Gravatar is bundled with Vanilla. Be sure you copied the plugins folder over too.

Aolee

Gravatar is bundled with Vanilla. Be sure you copied the plugins folder over too.

<= this is the one im talking about. the one bundled.sorry for the confusion.