Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Try Vanilla Forums Cloud product

Error started happening without any site changes made [RESOLVED]

edited January 31 in Development

I haven't made any changes to my website or server or database in recent months, but just a few days ago I started getting this error ONLY ON DESKTOP. The error happens when I click on a discussion thread on desktop. The Vanilla forum appears to fine in all other areas on desktop including the forum dashboard, it's only when a discussion thread is clicked. On mobile, everything still works fine. Here is the error message:


I would appreciate any help in debugging this mystery. Thank you!

Comments

  • I was able to fix my own issue in case anybody else ever encounters this. I had to run the following code in mysql:


    SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));


    and viola, the fatal error in php.trigger_error() was fixed! the sql_mode=only_full_group_by was what tipped me off to this SO post: https://stackoverflow.com/a/36033983/3089840

  • You can also change the getData function in VanillaInThisDiscussion plugin in class.inthisdiscussionmodule.php file like this

        public function getData($discussionID, $limit = 50) {
            $sQL = Gdn::sql();
            $this->_UserData = $sQL
                ->select('u.UserID, u.Name, u.Photo')
                ->select('c.DateInserted', 'max', 'DateLastActive')
                ->from('User u')
                ->join('Comment c', 'u.UserID = c.InsertUserID')
                ->where('c.DiscussionID', $discussionID)
                ->groupBy('u.UserID, u.Name, u.Photo, c.DateInserted')
                ->orderBy('c.DateInserted', 'desc')
                ->limit($limit)
                ->get();
        }
    
Sign In or Register to comment.