[solved] Self Registration / Front End Users - Expire 0000-00-00 00:00:00

[michaywood]

Hello CMSMSers,

I am running into a predicament with Self-Registration and FEU. I have them both setup and working well together, except for one small problem. When a person registers themselves, it then passes their info from Self-Registration to FEU, like it should, but then it gives it an expiration date of 0000-00-00 00:00:00 . So when the user tries to automatically login, it says their account is expired. I then have to go in as an admin and change the expiration date to the future so the person can login. This gets cumbersome!

Is there a way for Self-Registration to tell FEU that the expiration date is like 2040-01-01 01:01:01 ?

Please help!

[jmcgin51]

version information please

and have you set the default expiration time (in months) in the FEU preferences?

[michaywood]

CMS Version 1.6.7
FEU Version 1.8.2
Self-Reg Version 1.3.2

PHP 5.2.1
MySQL 5.0.32


Default user expiry period is set to the default of 520 (months). I don't think this has anything to do with it, though. It's when a user registers themselves, and Self-Registration imports their information into FEU, it sets their expire date as 0000-00-00 00:00:00 .

[orb42]

hello,
i got same versions as you and had same pb when  I choiced first 400 months.
changed it to shorter 240 months and it works now. Mybe be it did not record correctly in database?

[michaywood]

yes! That solved it! For some reason my FEU module can't set an expiration date later than like 2030. So setting the expiry month to 240 did the trick! Worked perfectly! Thanks so much, orb42! Hopefully this will help others who have had the same problem as well!

[Tetsuo]

I am having a similar problem.

When I import a database via a .CSV file (Frontend User Management > Admin> Input CSV File) all fields get added fine, EXCEPT the "Expires" field, which always defaults to 0000-00-00 00:00:00, no matter what value is actually in the CSV.

Please help.
Thanks

[Tetsuo]

I appear to have found the cause of the problem

When adding data into the createdate field, you get away with entering in the format mm-dd-yyyy and the data is added.

With expires you have to be more specific with the format: mm-dd-yyy hh:mm:ss
Otherwise the filed will just default to 0000-00-00 00:00:00.

I have noticed that I was then getting error messages on another field, but because the date fields are different formats.

What you must do for both date-type fields (createdate + expires) is have the format mm-dd-yyy hh:mm:ss (eg: 01/01/2010 23:59:00)

I hope that helps anyone else who has the same problem!