Unable to logon after removing year from admin's birthday

[Allan Mitch]

I was successfully going along setting up Church.IO.  All was well.  After getting a feel for adding members and making families, I wanted to import our membership spreadsheet.  The membership spreadsheet I have does not always have in the persons birthday their year of birth.  To better understand row headers expected by Church.IO and acceptable formats for birthdates I was going to do a Church.IO export of the data I had manually entered to see how the program handled dates without years.  So, I  removed the year from my birthday and then saved my profile.  But, before I could do an export Church.IO booted me out of the program.  When I went to log in, it told me that since I might be 13 or younger, I could not log into the application!

So how to I get access again?  I'm using the virtual appliance, so I have access to the console.

[Tim Morgan]

You can fix that with the mysql console...

BUT MAKE A BACKUP FIRST! https://github.com/churchio/onebody/wiki/Backups

mysql -u root onebody

update people set birthday = '1980-01-01' where id = 1;

exit

On Wed, Jan 31, 2018 at 7:15 PM Allan Mitch <allan...@gmail.com> wrote:

I was successfully going along setting up Church.IO.  All was well.  After getting a feel for adding members and making families, I wanted to import our membership spreadsheet.  The membership spreadsheet I have does not always have in the persons birthday their year of birth.  To better understand row headers expected by Church.IO and acceptable formats for birthdates I was going to do a Church.IO export of the data I had manually entered to see how the program handled dates without years.  So, I  removed the year from my birthday and then saved my profile.  But, before I could do an export Church.IO booted me out of the program.  When I went to log in, it told me that since I might be 13 or younger, I could not log into the application!

So how to I get access again?  I'm using the virtual appliance, so I have access to the console.

--
https://church.io
https://github.com/churchio
http://chat.church.io
---
You received this message because you are subscribed to the Google Groups "Church.IO" group.
To unsubscribe from this group and stop receiving emails from it, send an email to churchio+u...@googlegroups.com.
To post to this group, send email to chur...@googlegroups.com.
Visit this group at https://groups.google.com/group/churchio.
For more options, visit https://groups.google.com/d/optout.

[Allan Mitch]

Thank!  I think I can follow.  However, my installation does not have

/var/www/onebody

Has the onebody folder structure been moved to a different location?

[Tim Morgan]

I believe it's in /opt/onebody given how you installed it.

Try that.

[Allan Mitch]

That did it.  Changed as directed above, no errors.  But... I still can't log in.  Same "UNAUTHORIZED" screen. Do I need to restart a service or something for the new value to take effect?

[Tim Morgan]

Hmm, that's weird. OK make sure you're not marked as a child:

mysql -u root onebody

update people set child = 0 where id = 1;

exit

While you're there, be sure your user is the one with id 1. :-)

select first_name, last_name from people where id = 1;

[Allan Mitch]

Yep, I was marked as a child.  Once i changed child=0 then I could log in!

Thanks a lot for the prompt help!

[Tim Morgan]

Yay glad that worked!