0015203: Error Sign Displayed on 'users' page when not logged in as admin

Create

Capture

Maintain

Audience

Viewing Issue Simple Details [ Jump to Notes ]

[ View Advanced ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0015203

[phplist] Interface - Backend

minor

have not tried

12-12-08 11:43

17-12-08 11:05

Reporter

julian

View Status

public

Assigned To

Priority

normal

Resolution

fixed

Status

resolved

Product Version

2.10.7

Summary

0015203: Error Sign Displayed on 'users' page when not logged in as admin

Description

Copied from http://mantis.tincan.co.uk/view.php?id=17317 [^] :

When logged in as admin (2.10.7 version), the 'users' page (/lists/admin/?page=users) does not display any error, but when logged in as a regular user, it displays :

Database error 1064 while doing query 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 '*) FROM phplist_user_user' at line 1
Database error 1064 while doing query 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 '*) FROM phplist_user_user where !confirmed' at line 1

Logged in once again as admin, the error goes away.

Additional Information

Notes
(0050265) chdelgado (administrator) 17-12-08 11:05	SQL query fixed to solve the problem.