Note: This issue is probably related to the different MySQL version and may not affect others. Tested on 10.5.5-MariaDB Homebrew. Confirmation needed if the issue is reproducable on other configurations.
I got an Illuminate\Database\QueryException error on a frontend search:
Steps to reproduce:
1) Fresh install and seed a Laracom project
2) Create a product on the backend (to ensure that you can except a valid result)
3) Search for the product name on the frontend
4) See error
The issue can be fixed by setting the 'strict' => false in config/database.php file in the connections[mysql] section
jsdecena
commented
2 years ago
Note: This issue is probably related to the different MySQL version and may not affect others. Tested on
10.5.5-MariaDB Homebrew. Confirmation needed if the issue is reproducable on other configurations.I got an Illuminate\Database\QueryException error on a frontend search:
Steps to reproduce: 1) Fresh install and seed a Laracom project 2) Create a product on the backend (to ensure that you can except a valid result) 3) Search for the product name on the frontend 4) See error
The issue can be fixed by setting the
'strict' => falseinconfig/database.phpfile in theconnections[mysql]section