Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 1.7
-
Fix Version/s: 1.7
-
Component/s: Administration
-
Labels:None
-
Environment:Moodle 1.7 beta with MSSQL 2005. Both database and Apache/PHP running on same windows XP box.
Using freetds to get to MSSQL
-
Database:Microsoft SQL
-
Affected Branches:MOODLE_17_STABLE
-
Fixed Branches:MOODLE_17_STABLE
Description
- Fresh install of Moodle 1.7 beta on SQL 2005
- Add 1 or 2 users
- Go to http://localhost/admin/user.php and select "Browse a list of users"
- Resulting page does not show actual users (though count of users is correct). INstead you get the message: "No users matching ' were found"
Probable cause: I traced the SQL with SQL Profiler and one of the queries fauils because it containts the "LIMIT" keyword (which mssql does not support). The offending query is:
SELECT id, username, email, firstname, lastname, city, country, lastaccess, confirmed
FROM mdl_user
WHERE deleted <> '1' AND username <> N'changeme' ORDER BY firstname ASC LIMIT 0,30
The full .sql file capturing the sql output when you select 'browe users' is attached.
Issue Links
Activity
Hi Alex,
I think the original problem hasn't too much to do with this. I'm running also latest Moodle 1.7+ code (moodle.org does that too) and the list of users seems to work perfectly.
Can you try to enable debug setting it to the max level in order to view if Moodle shows any error that can give us some hints?
TIA and ciao 
I cloned this issue because it appears to be exactly what I am experiencing. However, I am running Moodle 1.7+ (2006101007) on a Suse Linux Enterprise Server 10 server with MySQL 5. I had been on the verion 1.7 then updated via cvs to 1.7+ stable branch hoping this would fix the problem. However, despite the update and a reboot, the problem still exists.