NOTE:: Before reporting an issue, make sure you are running the latest version, currently 3.3.1

View Issue Details Jump to Notes ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0015352phplist applicationUser Managementpublic22-10-09 10:3019-04-10 20:49
PlatformOSOS Version
Product Version2.10.9 
Target Version2.10.12Fixed in Version2.10.12 
Summary0015352: Sort by 'entered' and 'modified' not working on page 'users'
DescriptionThe error is: "Database error 1052 while doing query Column 'entered' in order clause is ambiguous"

Looks like it happens only with MySQL 5.0.51 (we have phplists 2.10.9 on MySQL 5.0.41 works fine)

=Suggested fix=
  file: admin/commonlib/pages/users.php
  line 272: change
    $order = ' order by ' . $sortby;
    $order = ' order by ' . "{$tables["user"]}.$sortby";
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
There are no notes attached to this issue.

Copyright © 2000 - 2017 MantisBT Team
Powered by Mantis Bugtracker