- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'search_result.score'
Hello,
Have you ever found a solution to this problem? I am actually facing the same issue with Magento 2.3.1 and Porto.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'search_result.score'
I'm ALSO "in" for the answer to this miserable problem! PLEASE SOMEONE HELP!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'search_result.score'
After hours of research and debugging, I finally found that modifying the Cataclog Search settings from MySQL to Elasticsearch6+ fixed the problem on my website. NOTE: Your webhosting provider has to support this extension.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'search_result.score'
@dBox did you enable via the admin interface or via CLI? We've enabled ES6+ but still hit the error, pulling my hair out...
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'search_result.score'
I changed from MySQL to elasticsearch6+ and then tested the connection, it shows could not be connected, from Magento admin panel. Please suggest.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'search_result.score'
Hi all,
Since I started the question I am able to answer the solution too.
The Porto theme is using extensions from Mageplaza and they need some updating.
What I did myself was disable the Magaplaza extensions, including the Mageplaza core extension. After that I installed the extensions from Mageplaza.
- Mageplaza Core
- AjaxLayer
- Search
After installing them again I got the search to work again.
I don't use Composer to install extensions. I installed them manually in the app/code folder.
Chaning to Elastisearch won't work because you're provider needs to support this and has nothing to do why we get this error. It apparently has to do with the Mageplaza extensions which the Porto developers neglected to update. April 2019 was the last update on the theme and I'm waiting for a new update (hoping a lot of bugs are fixed).
If you have more questions please don't hesitate to ask ;-)
Br,
Steve
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'search_result.score'
- « Previous
-
- 1
- 2
- Next »