[Phphelpdesk-help] SOLVED - Error adding user

[Mitchell K. S. <mk...@pa...>]

For those of us suffering with the error:

<snip>
>When I am adding a user, I select the available departments for the user
and
>hit Add.
>
>I get the following error.
>In this case I was adding a user called test and I chose one department.
>
>SQL ERROR: You have an error in your SQL syntax near '='test'' at line 1
>
>If I select multiple departments, I will get the same error repeated like
>so:
>SQL ERROR: You have an error in your SQL syntax near '='test'' at line 1
>
>SQL ERROR: You have an error in your SQL syntax near '='test'' at line 1
>
>SQL ERROR: You have an error in your SQL syntax near '='test'' at line 1
>
<snip>

Here is the answer:

Edit your adduser.scp.php file.

Look for a line that ends with ...userdepartments";
Add a space before the " so it reads
...userdepartments ";



Mitchell K. Smith
Service and Information Systems Manager
ePlus Technology of PA
130 Futura Drive
Pottstown, PA  19464
610-495-7800 ext. 264
mk...@pa...