Steps to reproduce-
1. Connect to database using below credential
<<sudo -u postgres psql>>
<<\c "name of the database"
2. Run below SQL command to check the time of admin user creation
<<Select ctime from usr where username='admin';>>
Expected result- Creation time and date of admin user should be
displayed.
Actual result- No rows displayed and the database is empty.
3. Run the patch and upgrade the site.
4. Run the step 2 SQL command again.
Expected result- Creation time and date of admin user should be
displayed.
Actual result- 2017-07-26 11:48:28 ( This is the date when refreshed the
databse)
5. Clean the dababase by running below command-
<<sudo -u postgres dropdb "name of the database">>
6. Create a new database using below commnad-
<<sudo -u postgres createdb -Omaharauser "name of the database">>
7. upgrade the site and run step2 again-
Expected result- Creation time and date of admin user should be
displayed.
Actual result- 2017-08-01 12:28:52
--
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask
on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1702198
Title:
When creating a site the 'admin' and 'root' users do not have ctime
set
Status in Mahara:
In Progress
Bug description:
All true users should have a ctime set when they are first created
So we should fix this up for 'admin' user but not the 'root' user
This will be useful for statistics / reports
To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1702198/+subscriptions
_______________________________________________
Mailing list: https://launchpad.net/~mahara-contributors
Post to : [email protected]
Unsubscribe : https://launchpad.net/~mahara-contributors
More help : https://help.launchpad.net/ListHelp
