You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Illuminate \ Database \ QueryException (42000) SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '>'$."price"') as aggregate from listingswherelistings.deleted_at is null' at line 1 (SQL: select min(meta->'$."price"') as aggregate from listingswherelistings.deleted_at is null)
The text was updated successfully, but these errors were encountered:
This is due to MariaDB/Mysql server version issue. You must be using a version less than 5.7.
You need to upgrade to 5.7. I have tried doing it in my Centos 7 distro which it did not allow or work. So, I tried using the latest 10.4 version, it worked but new BC Math extension issue cropped up. Even After Installing the BC Math extension i am not able to get through the error. Any help or workaround
I had to install https://github.com/ybr-nx/laravel-mariadb to get my installation to work with MariaDB 10.4. It seems to work but it's only a test site, not production.
Illuminate \ Database \ QueryException (42000) SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '>'$."price"') as aggregate from
listingswhere
listings.
deleted_atis null' at line 1 (SQL: select min(
meta->'$."price"') as aggregate from
listingswhere
listings.
deleted_atis null)
The text was updated successfully, but these errors were encountered: