mahara-contributors team mailing list archive

[Niranjan <1702198@xxxxxxxxxxxxxxxxxx>]

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