Sequence plugin error

[jo-ka]

Hello.
Using J!3.9.8 and latest Fabrik from Github.

When using the sequence plugin with this configuration, I get an error:

1064 - 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 1



If I disable the plugin, everything works OK.

What can possibly be wrong? BR

 

[bea]

Hi,
I m wondering, that you have the query option.
Can you please uninstall the plugin and install the plugin from download area?
Also 2019- as suffix makes no sense.

Cheers,
Bianka

 

[jo-ka]

Ok, uninstalling and install the plugin seemed to work.
Also the suffix was just for explanation purposes, as the field is filled with a placeholder ({fab_tickets___PatSerie}/)

Thanks for the suggestion. it worked.

 

[troester]

The query option was added only 5 days ago (so it's in the recent GitHub).
But maybe there's something missing now in the settings... (I didn't test).

So uninstalling and installing a plugin will install the original Fabrik3.9 plugin.
Which may do in this case but is usually no good idea because you are then running mixed code versions.

 

[jo-ka]

Dear troester,
After uploading the Github version, then yes, the error is displayed.

So that's probably an error on the Github file.

BR

 

[troester]

Yup, with "on submit" the error is replicatable (ok with "PK")

 

[jo-ka]

OK, I'll wait for the correction.

Meanwhile I'll use the site version, as I don't need SQL query for this website.

 

[cheesegrits]

Should be fixed in github.

https://github.com/Fabrik/fabrik/commit/30e0d4c0808550c1e81089917163f3926b50b284

-- hugh

 

[jo-ka]

Hello. Solved.
Thanks hugh.

BR