Users not showing up in User Management

[lchavez]

When I go to the User Management area under Admin section, none of the users that I have created show up. I checked the database table to make sure they were added and they are, but not showing in in the UI. I just recently updated to 4.5.1g, but that did not help. Anyone else experiencing this or know what the problem is?

Here are some entries in the sugarcrm.log file. Not sure if this has anything to do with it..

Tue Oct 23 18:45:07 2007,393 [16048] FATAL SugarCRM - MySQL error 1054: Unknown column 'contact_name' in 'field list'
Tue Oct 23 18:46:05 2007,523 [16046] FATAL SugarCRM - MySQL error 1054: Unknown column 'contact_name' in 'field list'
Tue Oct 23 20:51:00 2007,312 [16107] FATAL SugarCRM - createRelationshipMeta: Metadata for table tracker does not exist
Tue Oct 23 20:51:00 2007,500 [16107] FATAL SugarCRM - createRelationshipMeta: Metadata for table tracker does not exist


Cent OS 4.4.3
Sugar CRM Version 4.5.1g (Build 1003)
Apache 2.0.52
PHP 5.1.6
MySQL 5.0.48

[sacramentojoe]

Did this work BEFORE you upgraded or did you upgrade after?
Are you in a position where you can re-install?

[kuske]

Did you set an advanced filter to the useres? Switch to basic search and use clear button.

[lchavez]

This has never worked from the beginning. I could reinstall, although I'm not sure if that would solve anything since this is a brand new installation anyway. I installed 4.5.1f, poked around, started adding users and noticed they weren't showing up in the User Management area. Did searches on the issue and came up with nothing. Now I'm here.

I have no filters set, but I did clear the list just in case. No luck.

Should I try reinstalling?

Thanks for your help!

[kuske]

2 proposals:

1.) correct the bug in modules/users/searchform.html

locate the line

<td  class="dataField"><slot><select size="3" name='status[]' tabindex='1' multiple="true">{STATUS_OPTIONS}</select></slot></td>

and remove the [] behind status.

2.) enable tracing of DEBUG level by removing the // in line
//log4php.rootLogger=debug, A2
of file log4php.properties

and then search the logfile for more information.

At the moment it looks as there would be a corrupted call or meeting because contact_name is a contruct out of contacts.firstname and contact.lastname build at each sugar call.

regard
hk

[lchavez]

Thanks. I did as suggested and looked through the log. Here's where I think the problem is:

Fri Oct 26 12:33:09 2007,507 [17318] INFO SugarCRM - Query: SELECT users.id , as name, users.last_name , users.first_name , users.user_name , users.department , users.email1 , users.phone_work , users.status , users.is_admin , users.created_by FROM users where users.deleted=0 ORDER BY users.is_admin DESC LIMIT 0,21
Fri Oct 26 12:33:09 2007,507 [17318] INFO SugarCRM - Query Execution Time:0.00013199999999991
Fri Oct 26 12:33:09 2007,507 [17318] ERROR SugarCRM - MySQL error 1064: 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 'as name, users.last_name , users.first_name , users.user_name , users.department' at line 1
Fri Oct 26 12:33:09 2007,523 [17318] INFO SugarCRM - Query:SELECT id, name FROM saved_search ^M

I run that query against the DB manually and get the same error. If I remove the comma after "SELECT users.id" then it returns the rows appropriately, which I suspected. So, where do I change that SELECT statement in the code so I can remove the comma? Does this qualify as a valid bug?

Thanks again...

[kuske]

Hi,
reading your output I would suggest, that you have cleared out your "Name Display Format".
Please check "My Account" - "Edit" , Section Local Settings the Field "Name Display Format"
and in config.php the line
'default_locale_name_format' => 's f l',

Perhaps this solves your problem.

regards
hk

[lchavez]

Thanks. That did not appear to help any. Should I submit this as a bug?

[kuske]

Normally an empty setting is set to the default 's f l'.
I have no idea how this can happen.
I think it is no real bug, but a nice to have plausi check.

regards
hk

[akimeu]

I'm having the same issue with my clean install... anyone any other advice???
Here is my cry for help... <http://www.sugarcrm.com/forums/showthread.php?t=27247>