Open daltonmart opened 2 years ago
When editing a menu item the following error is generated:
[HTTP/2 500 Internal Server Error 1745ms] type "mysqli_sql_exception" code 500 message "Unknown column 'groups_menu.group_id' in 'field list'" type "->" args [ "SELECT test_menu.id, test_menu.parent_id, test_menu.active, test_menu.title, test_menu.icon, test_menu.route, test_groups_menu.menu_id, test_groups_menu.group_id, group_concat( groups_menu.group_id SEPARATOR '|') as group_id\nFROM test_menu\nLEFT JOIN test_groups_menu ON test_menu.id = test_groups_menu.menu_id\nLEFT JOIN test_auth_groups ON test_groups_menu.group_id = test_auth_groups.id\nWHERE test_menu.id = '9'" ] Object { file: "/home3/ensanuve/public_html/ci/vendor/agungsuiarto/boilerplate/src/Models/MenuModel.php", line: 98, function: "get", … } line 98
test_menu
id
parent_id
active
title
icon
route
test_groups_menu
menu_id
group_id
test_auth_groups
To fix this, enclose the groups_menu.group_id field in quotes as follows: group_concat( 'groups_menu.group_id' SEPARATOR '|') in MenuModel.php line 94
This solution doesn't work... Need to add the table prefix to groups_menu.groupid for it to work on line 94 For example if the prefix is "tbl" it would be group_concat( tbl_groups_menu.group_id SEPARATOR '|')
When editing a menu item the following error is generated:
[HTTP/2 500 Internal Server Error 1745ms] type "mysqli_sql_exception" code 500 message "Unknown column 'groups_menu.group_id' in 'field list'" type "->" args [ "SELECT
test_menu
.id
,test_menu
.parent_id
,test_menu
.active
,test_menu
.title
,test_menu
.icon
,test_menu
.route
,test_groups_menu
.menu_id
,test_groups_menu
.group_id
, group_concat( groups_menu.group_id SEPARATOR '|') as group_id\nFROMtest_menu
\nLEFT JOINtest_groups_menu
ONtest_menu
.id
=test_groups_menu
.menu_id
\nLEFT JOINtest_auth_groups
ON test_groups_menu
.group_id
=test_auth_groups
.id
\nWHEREtest_menu
.id
= '9'" ] Object { file: "/home3/ensanuve/public_html/ci/vendor/agungsuiarto/boilerplate/src/Models/MenuModel.php", line: 98, function: "get", … } line 98To fix this, enclose the groups_menu.group_id field in quotes as follows: group_concat( 'groups_menu.group_id' SEPARATOR '|') in MenuModel.php line 94