Filters (Search) not working after github Update

emcguire

emcguire

Member
Hello.

I updated my Fabrik to 3.9 yesterday. First from the Joomla update manager (3.9 from fabrik download page) and then grabbed the latest github update. Running latest J! version.

Update seemed to go ok. But now have discovered that when using my filter/search options on my lists - they all return 500 errors.

I saw some posts about using prefilters causing issues, So I disable all those - still getting 500 errors.

If I disable all the filters on the elements. the pages run fine. I just can;t use filters or search.

Any idea what's going on here? I have searched the forum for answers, but nothing I've tried is working. Should I revert back to pre-update and try again in a different manner? Everything was working fine prior to that.
 
Try to disable form groups one by one. If you find the problematic group then disable all elements in this group and then enable one by one.
 
Which Joomla and php version?

What is exactly "error on using my filter options..."?
Error when editing a list, displaying a list, clicking "Go" after setting a filter...?
 
The list loads fine initially, When I click GO on any search on any field that I have filters set up on. Let me try and get a better error message for you.
 
From which Fabrik version did you update?
Did you clear all Joomla and browser cache?

All your list? Is/are the list(s) ajaxfied?
 
Here is the error :

Fabrik has generated an incorrect query for the list Account List: <br /><br /><pre>Unknown column 'clinic' in 'where clause'</pre>

All cache cleared in browser and joomla. List is not Ajaxified,

update: when using a dropdown I get this

Fabrik has generated an incorrect query for the list Account List: <br /><br /><pre>Unknown column 'Secondary' in 'where clause'</pre>
 
Last edited:
Did you update your original site?
Or is it a "sandbox" copy (if yes, did you open/resave the Fabrik connection)?

All lists or only one?
 
Updated my original site. not a copy.

Connection seems to be ok. It connects fine when I test it. Do I need to fully delete and reset the connection? even if it is connecting ok when I test?

It is doing it on all lists. I have 3 of them they are all doing same thing when I try and use filters or search
 
Let me chime in... small chance but anyway:

Not knowing from which Fabrik version you updated, do you use custom Fabrik templates or view/layout overrides? What if you switch to Protostar?
 
I believe I updated from Fabrik 3.8

I'm not using view layout overides that I know of. I can try switching to ProtoStar and see if that does anything.
 
Do I need to fully delete and reset the connection?
Click to expand...
No, never delete a connection. Even with same parameters a new connection has a new ID and will be "an other one", not known to existing lists etc.

Really no idea what is going on.
Are 'clinic' and 'Secondary' existing, published, accessible elements (exactly these names, including cases) and existing columns in your database?
 
I didn't touch the connection.

clinic and secondary are search criteria, not an element/columns. "Clinic" was my search term I entered in text field. "Secondary" is a selection in a dropdown filter.
 
Can you enable Joomla debug? This should show additionally the generated query appended to the error message.
 
I do have debug enabled. When I add the &fabrikdebug=1 to the error page it changes from the generic ...

Fabrik has generated an incorrect query for the list Account List

and adds

Unknown column 'Secondary' in 'where clause'

Which is weird because as I said (and I didn't catch this before) 'Secondary' was the search term - not a column... the column/element it would be referring to would be 'category_type'
 
here is what I get with Joomla debug on



Fabrik has generated an incorrect query for the list Account List: <br /><br /><pre>Unknown column 'herbal' in 'where clause'</pre><br /><pre></pre><br />



Call stack
# Function Location
1 () JROOT/components/com_fabrik/models/list.php:948
2 FabrikFEModelList->getData() JROOT/components/com_fabrik/models/list.php:706
3 FabrikFEModelList->render() JROOT/components/com_fabrik/views/list/view.base.php:428
4 FabrikViewListBase->display() JROOT/components/com_fabrik/views/list/view.html.php:41
5 FabrikViewList->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102
6 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/components/com_fabrik/controllers/list.php:109
7 FabrikControllerList->display() JROOT/components/com_fabrik/controllers/list.php:181
8 FabrikControllerList->filter() JROOT/libraries/src/MVC/Controller/BaseController.php:710
9 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_fabrik/fabrik.php:181
10 require_once() JROOT/libraries/src/Component/ComponentHelper.php:402
11 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
12 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
13 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
14 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196
15 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49




I have to shelf this for today - I will be happy to up my subscription level next week to get this resolved.
 
Ok, I have rolled my joomla and fabrik back to pre-update status. I am now using Fabrik 3.8 and J! 3.9.5. The search/filter issue is not present now.

I thought maybe I'd try this again.

last time, I downloaded the download fabrik pkg 3.9 from the download page, installed it with the J! installer and then went and got the Github version and overwrote files with FTP.

Interestingly, when I was step-rolling my backups back to where I started. The search/filter issue was there with Fabrik 3.9 installed - before I updated from github. Point being that it wasn't anything in the github update that caused this, it was with the initial fabrik update to 3.9

Should I install the fabrik package with the J! installer again or just go right to the github files and upload them?
 
I'd just upload a full github. There's no database changes between 3.8 and 3.9, so no need to run the installer.

-- hugh
 
You must log in or register to reply here.

Useful links

  • Create a Fabrik Account (Downloads)
  • Create a Forum Account
  • Fabrik Wiki
  • Fabrik 4 Changelog /Install /Upgrade
    • We are in need of some funding.
    More details.

    Thank you.

    Staff online

    Members online

    Total: 111 (members: 1, guests: 110)
    Back
    Top