MantisBT - ATutor
View Issue Details
0003549ATutorUpgradingpublic2008-09-02 06:412014-08-06 21:32
IndieRect 
cindy 
normalminoralways
closedfixed 
1.6.1 
1.6.4 
SVN
0003549: TIMESTAMP: Member profile date reset to current during upgrade
When upgrading, column `creation_date` in `AT_members` is set to current time for all members.
It's yet another TIMESTAMP-related issue.

The bug source is in install/db/atutor_upgrade_1.6_to_1.6.1.sql on line 33.
Also run 'grep -R UPDATE * | grep TABLE_PREFIX | grep members | grep -v creation_date' from an installation root. Being a rough approach that gives both false positives and, probably, false negatives, it nevertheless discovers at least four more bugs (one in install area).

Suggested fix:
Add "creation_date=creation_date, last_login=last_login" to SET clause of those five SQL queries.
No tags attached.
Issue History
2008-09-02 06:41IndieRectNew Issue
2008-09-02 06:41IndieRectAffects version => SVN
2008-09-25 07:39gregStatusnew => resolved
2008-09-25 07:39gregFixed in Version => 1.6.2
2008-09-25 07:39gregResolutionopen => fixed
2008-09-25 07:39gregAssigned To => greg
2008-09-25 07:39gregNote Added: 0003190
2008-11-14 08:23gregStatusresolved => closed
2009-08-12 01:36IndieRectStatusclosed => feedback
2009-08-12 01:36IndieRectResolutionfixed => reopened
2009-08-12 01:36IndieRectNote Added: 0003751
2009-11-05 09:59gregStatusfeedback => assigned
2009-11-05 09:59gregAssigned Togreg => cindy
2009-11-09 09:17cindyStatusassigned => resolved
2009-11-09 09:17cindyFixed in Version1.6.2 => 1.6.4
2009-11-09 09:17cindyResolutionreopened => fixed
2009-11-09 09:17cindyNote Added: 0003850
2009-12-01 08:41gregStatusresolved => closed
2011-01-11 12:39gregChangeset attached => http://svn.atutor.ca/repos/atutor [^] trunk r7936
2011-01-11 12:39gregChangeset attached => http://svn.atutor.ca/repos/atutor [^] trunk r7937
2011-01-11 12:39gregChangeset attached => http://svn.atutor.ca/repos/atutor [^] trunk r7938
2014-08-06 21:32gregChangeset attached => Import 2014-08-06 19:06:05 master d6889ce6
2014-08-06 21:32gregChangeset attached => Import 2014-08-06 19:06:05 master dd075262
2014-08-06 21:32gregChangeset attached => Import 2014-08-06 19:06:05 master a2d1396e

Notes
(0003190)
greg   
2008-09-25 07:39   
added creation_date=creation_date to UPDATE sql in

ustep_pwd_encryt.php
password_reminder.php
confirm.php
atutor_upgrade_1.6_to_1.6.1.sql
(0003751)
IndieRect   
2009-08-12 01:36   
Please fix one more such bug in admin/user_status.php, line 33.
(0003850)
cindy   
2009-11-09 09:17   
SVN revision: 8893

Solution: add " creation_date = creation_date" into SQLs of updating members table.

Affected scripts:
admin/user_status.php
install/include/ustep_pwd_encryt.php