Helpdesk module and users table

[jwholdsworth]

I've been having trouble with the user_company field in the users table, in that everbody is assigned to company 0, instead of the actual company id they work for.

This also stopped the drop down list 'Assigned To' working in the helpdesk module.

I've been through the database table and adjusted this field manually, and now the assigned to field works. The other option was to remove the line of code:

WHERE ".getCompanyPerms("user_company", NULL, PERM_READ, $HELPDESK_CONFIG['the_company'])."

from line 280 of modules/helpdesk/list.php, which also worked, however this bypasses the permissions.

Does anybody know a way to fix this problem, and ensure people are assigned to the company id when they are entered into the system, as it gets tiresome when you have a large database to adjust!

Thanks.

[cookm]

Are you manually entering users and this happens, or using say, the LDAP contact import?

[jwholdsworth]

I manually enter users into the system by using the user admin facility within dotproject.

Even though I enter a department on the user admin form, the database doesn't display it. As a result, I've had a problem with the helpdesk, and manually entering companies into the database seems to have been the only way to solve this problem.

Thanks,
James.