Advertisement
Guest User

SS Blog Module Error Message

a guest
Mar 17th, 2016
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.51 KB | None | 0 0
  1. [17-Mar-2016 16:11:00] Error at framework/model/connect/DBConnector.php line 55: Uncaught SS_DatabaseException: Couldn't run query:
  2.  
  3. SELECT DISTINCT "PublishDate" IS NULL AS "_SortColumn0", "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."URLSegment", "SiteTree"."Title", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."MetaDescription", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."ReportClass", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Priority", "SiteTree"."MetaTitle", "SiteTree"."Version", "SiteTree"."ParentID", "BlogPost"."PublishDate", "BlogPost"."AuthorNames", "BlogPost"."Summary", "BlogPost"."InheritSideBar", "BlogPost"."SideBarID", "SiteTree"."ID",
  4. CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName"
  5. ELSE 'SiteTree' END AS "RecordClassName"
  6.  
  7. FROM "SiteTree"
  8. LEFT JOIN "BlogPost" ON "BlogPost"."ID" = "SiteTree"."ID"
  9.  
  10. WHERE ("SiteTree"."ParentID" = ?)
  11. AND ("SiteTree"."ClassName" IN (?, ?))
  12.  
  13. GROUP BY DATE_FORMAT("PublishDate", '%Y')
  14.  
  15. ORDER BY "_SortColumn0" DESC, "PublishDate" DESC
  16.  
  17. LIMIT 5
  18.  
  19. 42000-1055: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'kh.BlogPost.PublishDate' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (http://<my_website>/home/blog/new-blog-post/?stage=Stage)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement