• Hello Fabrik Community

    Fabrik is now in the hands of the development team that brought you Fabrik for Joomla 4. We have recently transitioned the Fabrik site over to a new server and are busy trying to clean it up. We have upgraded the site to Joomla 4 and are running the latest version of Fabrik 4. We have also upgraded the Xenforo forum software to the latest version. Many of the widgets you might have been used to on the forum are no longer operational, many abandoned by the developers. We hope to bring back some of the important ones as we have time.

    Exciting times to be sure.

    The Fabrik 4.0 Official release is now available. In addition, the Fabrik codebase is now available in a public repository. See the notices about these in the announcements section

    We wish to shout out a very big Thank You to all of you who have made donations. They have really helped. But we can always use more...wink..wink..

    Also a big Thank You to those of you who have been assisting others in the forum. This takes a very big burden off of us as we work on bugs, the website and the future of Fabrik.

sequence element problem

Good evening, I have another problem that I can't solve.

I set an element as "sequence element" set Affix and all.

but when I go to the form to insert a new element it gives me this error

"Field 'date_created' doesn't have a default value"

and in fact looking at the database it does not generate any data in the fabrik_sequences table
Can you change

->set($db->quoteName('sequence') . ' = ' . $sequence,$db->quoteName('date_created') . ' = NOW()')
Correction made and everything works perfectly.

another question
Is it possible to create and save the fabrik_sequences data not on the site database but on the one where I save all the form data?
The sequence data (sequence number including affix) is always saved in your form data (in the column of your sequence element).

The Fabrik meta table is needed to create the correct next sequence value.

my problem is that I have to create 2 sites that read the same data table and that increase in the same way.

if I have fabrik_sequences on two different databases it increments incorrectly
This is pretty corner case. You can try use the "Use PK" method (I didn't test).

Or don't use the sequence element but standard field elements and form php to create the sequence yourself on both sites.
Unfortunately it's not that simple

I have multiple users entering data, each user I need to have an Affix and then the increment. On the second site I have other users including some who can choose the Affix (of the first site) and therefore increase
As I said: You can do it yourself with form php plugins.
If you are running Fabrik with multiple connections you must know what you are doing. Fabrik doesn't support cross-joining.
Especially if you are using something like an "external data database" from two different Joomla installations.
Things like ACL handling are always related to the J! main database.
We are in need of some funding.
More details.

Thank you.

Members online