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

PDO Error #122

Open
onurdev74 opened this issue May 6, 2020 · 2 comments
Open

PDO Error #122

onurdev74 opened this issue May 6, 2020 · 2 comments

Comments

@onurdev74
Copy link

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)

@ravee23
Copy link

ravee23 commented May 6, 2020

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

@Ezyweb-uk
Copy link

Ezyweb-uk commented May 6, 2020

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.

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

3 participants