View Issue Details

IDProjectCategoryView StatusLast Update
0010310mantisbtotherpublic2010-04-23 23:22
Reportermcheck Assigned Todhx  
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionduplicate 
Product Version1.2.0a3 
Summary0010310: 'Hide Inactive' filter on Manage Users page produces SQL error
Description

With several inactive users, applying the 'Hide Inactive' filter on the Manage Users page produces this error:

Database query failed. Error received from database was 0001064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?) - TO_DAYS(last_visit) < '7')
ORDER BY username ASC LIMIT 0,50' at line 3 for the query: SELECT *
FROM mantis_user_table
WHERE (1 = 1) AND (TO_DAYS(?) - TO_DAYS(last_visit) < '7')
ORDER BY username ASC.

TagsNo tags attached.

Relationships

duplicate of 0010393 closeddhx SQL error with "hide inactive filter" feature on manage_user_page.php 

Activities

There are no notes attached to this issue.