I am new to CakePHP and working through the bookmarker tutorial. I have gotten to the step where you are adding a tags.ctp page. When I add the code per the instructions I get the following error.
Error: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #9 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘cake_bookmarks.BookmarksTags.tag_id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
I have made no changes to the bookmarks table or to the query. What am I doing wrong? Thanks in advance.
I have found that it is in the grouping of the query and that the newer versions don’t allow. The problem is that I can’t figure out how to correct it. I believe it is in the BookmarksTable.php, is that correct? How do I change the query?
Thank you! Item #1 worked. Would you be able to clarify where I would add additional fields to the query grouping. I have been reading documentation and working tutorials and having a really hard time with where that is coming from.