Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Solved] Error: Does not edit Menu items #100

Open
daltonmart opened this issue Mar 29, 2022 · 1 comment
Open

[Solved] Error: Does not edit Menu items #100

daltonmart opened this issue Mar 29, 2022 · 1 comment

Comments

@daltonmart
Copy link

daltonmart commented Mar 29, 2022

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

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

@daltonmart
Copy link
Author

This solution doesn't work... Need to add the table prefix to groups_menu.group_id 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 '|')

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant