lefty 1/12/2017 | |
I am having a hard time with the joined field. I have the account table made up and one of the fields is Joined which is to be auto filled in. I also have LastedEdited that works great. For the Joined I put in the add to Events - Add page - Before record added $values["Joined"]=now(); return true; The one that works I added to events - Edit page - Before record updated $values["LastEdited"]=now(); return true; So why would the Joined field not be working? I can go into the database on my server and add Field: Joined Type: TIMESTAMP Default: CURRENT_TIMESTAMP That works fine until I try to put it back into PHPRunner. Then I get an error? Thank for any help I might get on this. Oh and I took it from the forum template but noticed it does not work there either now.
|
Tandy author 1/12/2017 | |
Thank You John, I just tried that way and it still does not put the joined date in. |
admin 1/12/2017 | |
Make sure that Joined field's data type is in fact DateTime and not Timestamp as were specified in first post. Also make sure that field name is correct as 'Joined' and 'joined' are two different field names. |
Tandy author 1/12/2017 | |
Make sure that Joined field's data type is in fact DateTime and not Timestamp as were specified in first post. Also make sure that field name is correct as 'Joined' and 'joined' are two different field names.
|
lefty 1/13/2017 | |
It is DateTime. And I even copied it to the events. Like I said the LastedEdited works great. It is just the Joined that does not work. Every way I tried it.
|
Tandy author 1/13/2017 | |
I did like you said. I have attached some screen shots.
|
admin 1/13/2017 | |
If you have a valid support contract I suggest posting your project to Demo Account and contacting support directly. Without seeing your project and database we can only guess while this should be something relatively simple. |
romaldus 1/13/2017 | |
Tandy author 1/13/2017 | |
|
lefty 1/13/2017 | |
Sorry That did not work either. I will just close this and take out the Joined Date all together. Thanks all for trying to help.. James
|
romaldus 1/13/2017 | |
I've never experienced anything like this in phprunner since 2008. |
Tandy author 1/14/2017 | |
Thanks guys for trying to help. I am just redoing the whole project and keeping joined date out. It does not seem that maybe it is my server will not put the date in on someone joining the site. It did put it in after registered and they updated there account information but not when joining. It is not that big of a deal. The project is mainly for me keeping track of my trip sheets being a trucker. |