Can not see user account information from admin area

[DGiscombe +]

Hey,

From the admin area, if I go to Users>Manage Users, I would be able to see usename, name and email. But if I click on any of the users, the account information page does not show any info on the user.

I checked the table in my database under users, and the information such as firstname, city etc is definitely stored there.

I then tried to click on the export info to excel button to see if this page was pulling the info from the database correctly, and this error popped up:

Notice: Query failed: 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 '-15, 15' at line 5 SQL: SELECT id, firstname, lastname, address, city, state, zip, country, email, phone, username, joindate, custip, level FROM mvox_users WHERE 1=1 AND level=2 ORDER BY id desc LIMIT -15, 15 in ~/includes/classes/database/mysql.php on line 143

I hope this is something simple that can be fixed, let me know if you need any more info.

[Lhotch +]

This issue has already been reported in the issue tracker. However, it may help the dev team if you could post in the issue tracker as well and ideally rename the siteinfo.txt file to siteinfo.php that is located in the /administration folder and post a link to it so they can get some more info regarding your server config.

Also, can you exactly state which beta release you are using?

[John Snyder +]

Looks like it is possible to get 0 for the page number in the latest code. Probably best fixed in includes/classes/kernel/Users.php

Just below :

PHP Code:

function getAllUsers ($options, $page, $csv = false)
{ 


Add this:

PHP Code:

$page = (int)$page;
if ($page == 0) {
    $page = 1;
} 


I added it to the bug tracker.