1. Fabrik 3.9 has been released. If you have updated Joomla to 3.9, this is a required update.
    Dismiss Notice

Filters (Search) not working after github Update

Discussion in 'Community' started by emcguire, Jun 7, 2019.

  1. emcguire

    emcguire Member

    Level: Community
    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.
     
  2. startpoint

    startpoint Active Member

    Level: Community
    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.
     
  3. troester

    troester Well-Known Member Staff Member

    Level: Community
    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...?
     
  4. emcguire

    emcguire Member

    Level: Community
    Joomla 3.9.6
    PHP 7.1.30
     
  5. emcguire

    emcguire Member

    Level: Community
    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.
     
  6. troester

    troester Well-Known Member Staff Member

    Level: Community
    From which Fabrik version did you update?
    Did you clear all Joomla and browser cache?

    All your list? Is/are the list(s) ajaxfied?
     
  7. emcguire

    emcguire Member

    Level: Community
    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: Jun 7, 2019
  8. troester

    troester Well-Known Member Staff Member

    Level: Community
    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?
     
  9. emcguire

    emcguire Member

    Level: Community
    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
     
  10. lousyfool

    lousyfool Active Member

    Level: Community
    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?
     
  11. emcguire

    emcguire Member

    Level: Community
    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.
     
  12. troester

    troester Well-Known Member Staff Member

    Level: Community
    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?
     
  13. emcguire

    emcguire Member

    Level: Community
    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.
     
  14. troester

    troester Well-Known Member Staff Member

    Level: Community
    Can you enable Joomla debug? This should show additionally the generated query appended to the error message.
     
  15. emcguire

    emcguire Member

    Level: Community
    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'
     
  16. troester

    troester Well-Known Member Staff Member

    Level: Community
    Joomla System debug (in Joomla config) (additionally to Fabrik debug)
     
  17. emcguire

    emcguire Member

    Level: Community
    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.
     
  18. emcguire

    emcguire Member

    Level: Community
    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?
     
  19. cheesegrits

    cheesegrits Support Gopher Staff Member

    Level: Community
    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
     
  20. emcguire

    emcguire Member

    Level: Community
    Right on. I'll give it a shot and see where I'm at. Thanks
     
    cheesegrits likes this.

Share This Page