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

[SOLVED] Upsert problem

rodeokid

Member
I use the upsert plugin on one form to send only important infos from this form to another table for our needs. Everything works fine for all elements except date_time , when the upsert plugin sends the data, the second table have 0000-00-00 00:00:00 for date_time.
Both are in UTC. Same database table structure.
I can't find the bug.

Thanks.
rodeokid
 
Last edited:
I can't replicate this, dates upsert correctly in both my upsert test forms.

What are the exact settings of your date element? Either screenshot them, or if it's on your Naya site, let me know which form / element it is and I'll look.

-- hugh
 
Sorry for the delay... busy weekend.
Yes it's my Naya site.

You can find the original form here : index.php?option=com_fabrik&view=list&listid=48&Itemid=237
Here is the second form that receive the upsert datas : index.php?option=com_fabrik&view=list&listid=55&Itemid=266

Original database table : rapport_production_embouteillage_1
Upsert database table : rapport_production_par_quart

I left one entry in the upsert database table so that you can see the date_time bug.

Thanks...

rodeokid
 
I am just moving my site to another folder right now...lolll...give me a minute, it will be ok.

And it happens on both...New record or updating existing one.

rodeokid
 
By the way, this site is a work in progress, we are not working live on it, just test purpose for now, so don't worry testing what you want...lollll
 
OK, try now. I haven't tested as I don't want to mess with your data, but I hope that'll fix it.

The issue seems to be that your date element is a link, so the non-raw placeholder has the link HTML wrapped around it ... so I've added _raw to the placeholder name, which will get you the raw date without the formatting.

-- hugh
 
Oups...now i have an error whenever i try to save the form... syntax error, unexpected '05' (T_LNUMBER)

05 is the first 2 digits of the hour... i tried another one starting with 02, and the error is the same but with '02'
No upsert at all...
rodeokid
 
Ok i saw that you worked on it... it works now but in access you had to set everything to public, so i guess it's not finished yet ?
Thanks

rodeokid
 
I don't remember changing any access settings, so just set 'em how you want 'em.

Thought I'd replied about that error ... I forgot to set the 'eval' option back to No after doing some testing.

-- hugh
 
We are in need of some funding.
More details.

Thank you.

Members online

Back
Top