Buy Now
Sign in

Save Data Override not saving field

apabiona , January 23 2020, 07:02
A
apabiona 23
January 23 2020, 07:02 #390863
Hi,
I am doing a form with email verification. I have followed the steps that GreyHead outlined here - https://www.chronoengine.com/forums/posts/t105356/verify-confirm-an-email-address (thanks GreyHead!)
I have one last hurdle, the modified date does not update, I can change the status from pending to confirmed but for some reason the modified date doesn't save.
Is this is a bug or am I doing something wrong?
Debug code shows the modified field value but it does not update it.
I have set 'modified' value to {date:Y-m-d H:i:s} on Data Overrides section along with the 'status' override
[save_data20] => Array
(
[data] => Array
(
[status] => confirmed
[modified] => 2020-01-23 06:52:56
)

[_success] => Data saved successfully
[log] => Array
(
[0] => UPDATE `request_privacy` AS `Data20` SET `status` = 'confirmed';
)

[var] => Array
(
[status] => confirmed
)

)
healyhatman 9
January 23 2020, 09:36 #390864
Screenshot of your save data action please. Make sure you've put "on update" next to that data override section.
Web developer at SkySpider.com.au - I DO NOT work for ChronoEngine!
Donations: paypal.me/healyhatman
Professional Work: kamron@skyspider.com.au
Custom CF / CC Plugins and Extensions: skyspider.com.au/store
A
apabiona 23
January 24 2020, 08:49 #390896
Hi,
Here's my save data action. I did select 'on update'
savedata.png
Attachments
savedata.png
savedata.png
(68.67 KiB)
82 Downloads/Views
A
apabiona 23
January 24 2020, 09:11 #390897
Since I couldn't get this to work I just used PHP to update the tables needed.
healyhatman 9
January 24 2020, 12:21 #390899
You haven't put anything in update conditions, so it's basically saying "update this table where (absolutely nothing)"
Web developer at SkySpider.com.au - I DO NOT work for ChronoEngine!
Donations: paypal.me/healyhatman
Professional Work: kamron@skyspider.com.au
Custom CF / CC Plugins and Extensions: skyspider.com.au/store
A
apabiona 23
January 24 2020, 21:16 #390909
Yes, I didn't put the update conditions yet, the status field was getting updated for all rows but not the modified field.
EDIT: Tried it again and it just worked with/without update conditions and I dunno why. Atleast it is resolved
Thank you for your toime!