0015352: Sort by 'entered' and 'modified' not working on page 'users'

Create

Capture

Maintain

Audience

View Issue Details [ Jump to Notes ]

[ Print ]

Project

Category

View Status

Date Submitted

Last Update

0015352

phplist

User Management

public

22-10-09 09:30

19-04-10 19:49

Reporter

titobrasolin

Priority

normal

Severity

minor

Reproducibility

always

Status

resolved

Resolution

fixed

Platform

OS Version

Product Version

2.10.9

Target Version

2.10.12

Fixed in Version

2.10.12

Summary

0015352: Sort by 'entered' and 'modified' not working on page 'users'

Description

The 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;
  into
    $order = ' order by ' . "{$tables["user"]}.$sortby";

Relationships

Notes
There are no notes attached to this issue.