artkonekt / gears Goto Github PK

Laravel 8 is out. Any plans on releasing a new version?

SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation '=' (SQL: select `value` from `preferences` where `key` = appshell.quicklinks and `user_id` = 1 limit 1) (View: /...../vendor/konekt/appshell/src/resources/views/layouts/default/_header.blade.php)

I got this error when I logged in, on my fresh setup of Vanilo 2.0-dev.
I solved it by changing the charset of preferences.key column.
I think I will also need to change settings.id column charset since I found it in the migration code.

Is there any specific reason that you are using latin1 charset for those columns?

In my project, helper function setting is conflict with Voyager's helper function setting.

If add function_exists condition to avoid conflict would be great 👍

I have sent a PR #2

Thanks