RE: [Phphelpdesk-help] I get some error when i added division in new user

[<rb...@vo...>]

I had the same problem when I first set up PHP Helpdesk.  Here is the
solution I got from a previous post. You should try reading through the
previous posts.  Usually they have solutions for most problems.

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 ";


-----Original Message-----
From: bw...@it... [mailto:bw...@it...]
Sent: Wednesday, January 30, 2002 9:38 PM
To: php...@li...
Subject: [Phphelpdesk-help] I get some error when i added division in
new user


Dear Sir ,

I try to view some sql statment but i can't solve the sql error problem .

So would you help me to fix sql error problem ??


SQL ERROR: You have an error in your SQL syntax near '='echeung'' at line 1

 <<SQL error.doc>>