Problem with dbjoin rendered as checkbox after updat

[Ecovoyageurs]

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 :

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 :

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 !

 

[troester]

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?

 

[Ecovoyageurs]

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...

 

[cheesegrits]

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

 

[Ecovoyageurs]

I've just sent a message with your new quote form. Did you receive it ?

 

[cheesegrits]

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

 

[Ecovoyageurs]

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

 

[cheesegrits]

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