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

Create

Capture

Maintain

Audience

Viewing Issue Simple Details [ Jump to Notes ]

[ << ] [ >> ]

[ View Advanced ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0015352

[phplist] User Management

minor

always

22-10-09 09:30

Reporter

titobrasolin

View Status

public

Assigned To

Priority

normal

Resolution

open

Status

new

Product Version

2.10.9

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";

Additional Information

Relationships