MantisBT
Main | My View | View Issues | Change Log | Roadmap | Wiki | ManTweet | Repositories
  

View Issue Details [ Jump to Notes ] [ Wiki ] [ Related Changesets ] [ Issue History ] [ Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0007680mantisbtsignuppublic2006-12-21 21:012012-06-13 05:31
Reportervboctor 
Assigned Tovboctor 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version1.1.0a2 
Target Version1.1.0Fixed in Version1.1.0a3 
Summary0007680: Successful Sign up should set login count to 1
DescriptionUsers who sign up and visit the site to set the password and visit the rest of the site are reported as never logged in and can potentially be pruned by the administrator if they don't login again.

The query to fix those instances is:
UPDATE `mantis_user_table` SET LOGIN_COUNT = 1 WHERE `date_created` <>
`last_visit`

Also the query that retrieves the users who have never logged in can be changed to include two checks: ( login_count = 0 ) AND ( date_created = last_visit )
TagsNo tags attached.
Attached Files

- Relationships
related to 0014387closeddregad $g_max_failed_login_count Enabled Prevents User from logging after passwd reset 

-  Notes
User avatar (0013857)
exk72 (reporter)
2006-12-22 00:44
edited on: 2006-12-22 01:17

 why not add user_increment_login_count to verify.php

may want the ability to also prune accounts that have only logged in once

may want to alter the above SQL to include in the WHERE clause an AND LOGIN_COUNT = 0
User avatar (0013858)
vboctor (administrator)
2006-12-22 01:56

 Yep, the main fix planned for this feature is to increment the login count when the users verifies the email address. However, the other information was included in order to document solutions for handling existing users who are currently marked as never logged in although they did. This may not be a common scenario, but it was a common scenario for the Mantis demo bug tracker.
User avatar (0014066)
vboctor (administrator)
2007-02-19 23:45

 The fix included the following:

- Fixed the SQL query that prunes accounts that never logged in and has been registered for more than a week.
- Fixed the query that shows the users who never logged in to also check that last login time != registration time.
- Fixed the verify script to increment the login count.

- Related Changesets
MantisBT: master d306af51
Timestamp: 2007-02-20 05:43:25
Author: vboctor
[ Details ] [ Diff ] 		Fixed 0007680: Successful Sign up should set login count to 1.

git-svn-id: http://mantisbt.svn.sourceforge.net/svnroot/mantisbt/trunk@4276 [^] /?p=mantisbt.git;a=object;h=f5dc347c-c33d-0410-90a0-b07cc1902cb9
mod - manage_user_page.php [ Diff ] [ File ]
mod - verify.php [ Diff ] [ File ]
mod - manage_user_prune.php [ Diff ] [ File ]

- Issue History
Date Modified Username Field Change
2006-12-21 21:01 vboctor New Issue
2006-12-21 21:01 vboctor Status new => confirmed
2006-12-21 21:01 vboctor Target Version => 1.1.0
2006-12-22 00:44 exk72 Note Added: 0013857
2006-12-22 01:17 exk72 Note Edited: 0013857
2006-12-22 01:56 vboctor Note Added: 0013858
2007-02-19 23:45 vboctor Status confirmed => resolved
2007-02-19 23:45 vboctor Fixed in Version => 1.1.0a3
2007-02-19 23:45 vboctor Resolution open => fixed
2007-02-19 23:45 vboctor Assigned To => vboctor
2007-02-19 23:45 vboctor Note Added: 0014066
2007-05-08 03:43 vboctor Status resolved => closed
2007-12-21 23:16 vboctor Target Version 1.1.1 => 1.1.0
2012-06-13 05:31 dregad Changeset attached => MantisBT master d306af51
2012-06-13 05:31 dregad Relationship added related to 0014387

MantisBT 1.2.16dev master-1.2.x-05091f5 [^]
Copyright © 2000 - 2013 MantisBT Team
Time: 0.0769 seconds.
memory usage: 2,817 KB
Powered by Mantis Bugtracker