Suddenly can't see/edit users!!? HELPPP!

[GameboyRMH]

Sooo popped into the office this morning, thought I'd edit a user and

SQL ERROR

Error retrieving User list: Query Failed:SELECT users.* FROM users where users.deleted=0 ORDER BY name ASC LIMIT 21,1::MySQL error 1054:

It was working fine when I went home yesterday. This thing seems to have broken itself at random. Any ideas on how I can see the users again?

[GameboyRMH]

Phew found a solution:

http://www.sugarcrm.com/forums/showthread.php?p=91468

Now that I think of it, I did click "sort by name" right before leaving yesterday. Turns out this bug's been around since 4.5.1g.

[kuske]

It seems to be the problem where in config.php the line

'db_type' => 'mysql',

is missing or incorrect.
Only if this value is set, the filed "name" will be calculated correctly.

[GameboyRMH]

Mine actually has that

[kuske]

mmmh,
can you post your diagnostic file?

Are the any hints in the logfile when you set the logging-level to debug?

hk