1. Fabrik 3.8.1 has been released. It is mostly bug fixes and feature enhancements, but does include two new plugins (push notifications, and the sequence element). As usual we strongly recommend testing the new release on a sandbox if your application is mission critical, and always do an Akeeba backup before updating.
    Dismiss Notice

Problem with dbjoin rendered as checkbox after updat

Discussion in 'Professional Support' started by Ecovoyageurs, Oct 2, 2018.

  1. Ecovoyageurs

    Ecovoyageurs Member

    Level: Professional
    Hi,
    I've updated Joomla and fabrik to the latest versions (from v3.4.3). I also updated from github to get the latest debugs.
    I think that from then, a dbjoin rendered as checkbox returns an sql error if it's empty :
    Code (Text):
    You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 3
    Now when I check the first option (value = 1) and validate the form it returns the following error :
    Code (Text):
    You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND `id` NOT IN ( 19)' at line 3
    I don't understand where this come from except that "19" is my joined list id.

    Nothing special about this dbjoin except that it is in a joined table (inner join).
    I unpublished all calcs based on this dbjoin. I also disabled all plugins on the form.
    The only way to get the errors disappear is to unpublish the dbjoin field.

    Do you have an idea ? Could you have a look ?
    How can I provide access ?
    Thanks !
     
  2. troester

    troester Well-Known Member Staff Member

    Level: Community
    Do you have some Data-where or Advanced settings in the dbjoin?
    Or a prefilter in the list?

    Updating from 3.4.3 (Joomla? or Fabrik?) is a big step.
    Did you install the Fabrik3.8.1 package?
     
  3. Ecovoyageurs

    Ecovoyageurs Member

    Level: Professional
    I was on Joomla 3.7.4 with fabrik 3.4.3
    Yep, I installed the fabrik package and all elements using the Joomla updater, then I did a github update on top.

    The join doesn't have any data where, nor concat, nor advanced setting... just standard params value and label.
    The list doesn't have any prefilters...
     
  4. cheesegrits

    cheesegrits Support Gopher Staff Member

    Level: Community
    Yeah, updating through 3 major releases in one step could potentially cause issues, although technically it should run all of our database updates, etc.

    The only way I'd be able to debug this one would be by getting an Akeeba copy of your site, and setting it up as a PHP Storm project here, so I can step debug it. I'm happy to do that, but there would have to be a charge for doing it, as it's about 45 mins just to do the Akeeba download, install and set up a PHP Storm project, just to get to the point where I can start debugging. Typically the actual debugging is quick, so I'd hope I could resolve it inside an hour. Then I have a copy of your site, so any other issues arising from this upgrade would be quicker to solve.

    -- hugh
     
  5. Ecovoyageurs

    Ecovoyageurs Member

    Level: Professional
    I've just sent a message with your new quote form. Did you receive it ?
     
  6. cheesegrits

    cheesegrits Support Gopher Staff Member

    Level: Community
    Those go to Robbie, and she's been out of pocket this week, her dad passed away.

    I'll get with her on Monday, and we'll play catch up on this weeks stuff.

    -- hugh
     
  7. Ecovoyageurs

    Ecovoyageurs Member

    Level: Professional
    I understand. Please let me now when it's possible for you/her to adress this.
    Thanks
     
  8. cheesegrits

    cheesegrits Support Gopher Staff Member

    Level: Community
    If you want to make an Akeeba available to me, I can go ahead and take a look. If it's something simple, I can just fix it. If it's not simple, we can figure out the cost.

    -- hugh
     

Share This Page