Fixed Error 500 while searching list using filter

[7webcreator]

Hello,

After migrating my site to a new server with PHP 8.2.27, MySQL 8.0.41, and Joomla 4.4.12, I encountered the following error message when filtering my list on certain elements (user, database join):

"500 Fabrik has generated an incorrect query for the list gestione: <br /><br /><pre>Illegal argument to a regular expression.</pre>"

Any idea why and how to solve it, please?

 

[troester]

Enable J! System Debug to get the error stack.

 

[7webcreator]

Thank you for your reply. Please find below the screenshot displaying the error stack

 

[troester]

Do you have "Search all" enabled in list settings?
And/or "Full word match" in your elements' settings?

I assume it's your DB version, see e.g.
https://stackoverflow.com/questions...3685-illegal-argument-to-a-regular-expression

Fabrik is using [:<:]] etc.

Can you try in components\com_fabrik\models\list.php change line 5728 to
$value = "\"\\\\b" . $value . "\\\\b\"";

 

[7webcreator]

Thank you so much. It is working. Yes, I have "Full word match" enable in my elements' settings.

 

[troester]

You'll also have to adapt line 5718.

We'll have to test if this will break older MySQL DBs.

I only have access to MariaDBs. There it seems both versions are ok.

 

[7webcreator]

Do I have to enter $value = "\"\\\\b" . $value . "\\\\b\""; in line 5718 too?

 

[troester]

No, it's $v there (not $value)

$v = "\"\\\\b" . $v . "\\\\b\"";

I don't have an example for this array value, so not tested.

 

[7webcreator]

thank you. It is still working.

 

[troester]

Can you please test the complete fix (including version compare)?
https://bitbucket.org/fabrikar/fabrik/branch/MySQL-new-REGEXP

It would be great if you still have your old site with old DB and could test the same code there, too.

(I don't have any MySQL DBs, only Maria-DB and there both is working).

 

[7webcreator]

I have tested the fix on my old site with the old MySql DB and it is working too. However, the line numbers are different than the ones you have on Bitbucket.

 

[troester]

Which code did you test exactly? The complete commit including the version check etc?

The line numbers have changed because of the version check and start/end variables added (so old line 5728 is 5739 now).

 

[7webcreator]

I have pasted the complete commit that I have copied from here: https://bitbucket.org/fabrikar/fabr...om_fabrik/models/list.php?at=MySQL-new-REGEXP

I don't have issue on the site with the old database.

 

[troester]

Thanks, this is very helpful.