Forums - Save Data Override not saving field

apabiona , January 23 2020, 07:02

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'

Attachments

(68.67 KiB)

75 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!