Any chance of adding screen shots

peregrine

This discussion is related to the LatestPostList addon.

alway nice to see what the plugin does.

got this error. 
Table 'vanilla.GDN_discussion' doesn't exist
select d.InsertUserID as `InsertUserID`, d.DiscussionID as `DiscussionID`, d.Name as `PostName`, d.DateLastComment as `DateLastComment`, d.LastCommentUserID as `LastCommentUserID`, u.UserID as `CommenterID`, u.Name as `CommenterName`, p.UserID as `PosterID`, p.Name as `PosterName` from GDN_discussion d left join GDN_user u on u.UserID = d.LastCommentUserID left join GDN_user p on p.UserID = d.InsertUserID order by d.DateLastComment desc limit 5

if I remove the plugin I get no error. I don't have a production forum, so0 its not critical for me.

Aolee

should be GDN_Discussion i think?

Check out my other plugins here

UnderDog

It's some kind of case-sensitive problem, yes. We had something similar with the tagging plugins, some while ago.

peregrine

what's curious to me is how did anybody of the 90+ downloads get this plugin to work, without mentioning that it didn't work (without the change below), or is it OS or mysql specific.

presented a panel of latest discussions.

                        ->From('discussion d')
            ->Join('user u', 'u.UserID = d.LastCommentUserID', 'left')
            ->Join('user p', 'p.UserID = d.InsertUserID', 'left')


changed to:

            ->From('Discussion d')
            ->Join('User u', 'u.UserID = d.LastCommentUserID', 'left')
            ->Join('User p', 'p.UserID = d.InsertUserID', 'left')

another minor fix their needs to be a space between author and discussion in the panel for readability.

no comment from author of plugin as far as screenshots.

hgtonight

Added screenshots, fixed that bug (my localhost has lowercase table names), and made it look "good" with the default vanilla theme.