Fabrik 4.0 Zeta & Joomla 5.0.0: Search Problem

[arief8992@gmail.com]

I run Fabrik 4.0 Zeta & Joomla 5 works fine except if on Search of List if I enter only number will show up:
array_key_exists(): Argument #2 ($array) must be of type array, string given.

Any one has a solution? Please let me know. Thanks.

 

[arief8992@gmail.com]

I am able to solve by setting Search all and Extended search all to Yes. Previous setting that had a problem, Search all was Yes and Extended was No.

 

[troester]

Can you enable J! System Debug to get the error stack?

I have a J!5/Zeta test site and no problem with search all (without Extended).

What are your exact settings? Which elements did you select?
What do you mean with "if I enter only number"?

 

[gabriel.deluca]

I have same error, i want search by date in a list
Field date in a SQL Table is in format Y-m-d

 

[gabriel.deluca]

I run Fabrik 4.0 Zeta & Joomla 5 works fine except if on Search of List if I enter only number will show up:
array_key_exists(): Argument #2 ($array) must be of type array, string given.

Any one has a solution? Please let me know. Thanks.

in element type, select field plugin

 

[arief8992@gmail.com]

I use J 5.0.0 and Fabrikar 4.0 with attached setting, everything works fine except below condition
I put a parenthesis in the search "(" or ")", it will give error as below; I try to use #, . In order to reopen the list, I have to log out and log back in. Please find attached the call stack. Thank you.

The requested page can't be found.​

An error has occurred while processing your request.
You may not be able to visit this page because of:

• an out-of-date bookmark/favourite
• a mistyped address
• a search engine that has an out-of-date listing for this site
• you have no access to this page

Go to the Home Page
Home Page

---

If difficulties persist, please contact the website administrator and report the error below.

500 Fabrik has generated an incorrect query for the list "name of my list": <br />

 

[troester]

@arief8992@gmail.com
Searching for e.g ( in SearchAll seems to be an issue already since F3.
I don't think this is related to array_key_exists.

@gabriel.deluca
Please post screenshots, not files.


For array_key_exists error:
Can you try in
components\com_fabrik\models\element.php
modify line 1604 to
if (is_array($data) && array_key_exists('rowid',$data) && !empty($data['rowid'])) {

and report back?

 

[arief8992@gmail.com]

@troester
I created a new thread to disconnect with array_key_exists issue. Thanks.

 

[gabriel.deluca]

@arief8992@gmail.com
Searching for e.g ( in SearchAll seems to be an issue already since F3.
I don't think this is related to array_key_exists.

@gabriel.deluca
Please post screenshots, not files.


For array_key_exists error:
Can you try in
components\com_fabrik\models\element.php
modify line 1604 to
if (is_array($data) && array_key_exists('rowid',$data) && !empty($data['rowid'])) {

and report back?

With this modification the error disappears, but the search only works with the
field plugin,
with the
jdate and
date plugins it does not bring the expected results

this is the search executed

and this is the change made

 

[troester]

So this is a "Search all" search field?

Which elements did you select in "Elements"?

 

[gabriel.deluca]

So this is a "Search all" search field?

Which elements did you select in "Elements"?

 

[troester]

Searching for a "string" in a date is tricky, dates are stored in SQL format, time UTC or local depending on your element settings.
(For Advanced Search All you can't use (j)date or id elements anyway).

Fabrik is trying to convert your search string for (j)date elements into a meaningful "BETWEEN" condition.
Your search string has to be in SQL format (no matter what your list date format is set to).

It's working on my site. But there may be timezone issues etc.
Enable FabrikDebug (in Fabrik Options/Debugging) and append &fabrikdebug=1 to your list URL.

In 'table:mergeJoinedData get ids' or 'list GetData...' you should see the generated query.