eZ Community » Forums » Developer » Fetch - Content - Search (MariaDB)
expandshrink

Fetch - Content - Search (MariaDB)

Fetch - Content - Search (MariaDB)

Wednesday 03 July 2013 12:19:38 pm - 3 replies

Hi,

is it possible that something like:

    {def $search=fetch('content', 'search', hash('text', ezhttp('zipcode', 'get'),
                                                                  'class_id', array( '65' ),
                                                                  'subtree_array', array('578'),
                                                                  'class_attribute_id', array('536'))) }

do not work on a mariadb database?

Dirk

Thursday 04 July 2013 10:17:11 am

Hi Dirk,

sorry, i dont know the MariaDB, but it sounds strange that it cannot understand that query.

I would suggest to turn on the Debug, that you can see the SQL statement.
Then try to request the same statement in a MariaDB included shell or workbench.
That should mention if the query is not compatible.

Mark

Saturday 06 July 2013 7:25:59 pm

personal opinion: the sql generated by the search engine is not the most beautiful you'll ever see.

ezfind is just better in every way happy.gif Emoticon

but find the offending statement and well try to fix it

Monday 08 July 2013 12:59:28 pm

Thanks for your replies. Found some time today to debug the sql. And it's not a MariaDB problem. It's an indexing problem. Content is never been indexed, so it can't be found. Switched to solr and ezfind and now it's working as expected.

Thanks anyway...

Dirk

expandshrink

You must be logged in to post messages in this topic!

36 542 Users on board!

Forums menu

Proudly Developed with from