Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
Options

Gravatar plugin doesn't work with 2.0.18.1

ronakgronakg New
edited November 2011 in Vanilla 2.0 - 2.8
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',
)

Best Answer

  • Options
    LincLinc Detroit Admin
    Answer ✓
    Gravatar is bundled with Vanilla. Be sure you copied the plugins folder over too.

Answers

  • Options
    AoleeAolee Hobbyist & Coder ✭✭
    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.
  • Options
    Getting latest Gravatar plugin is part of the problem too. Now I
    can't locate it on the add-ons page.
  • Options
    LincLinc Detroit Admin
    Answer ✓
    Gravatar is bundled with Vanilla. Be sure you copied the plugins folder over too.
  • Options
    AoleeAolee Hobbyist & Coder ✭✭
    edited November 2011
    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.
Sign In or Register to comment.