Comment 2 for bug 1702198

Niranjan (niranjan528) wrote :

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