Hi, you should write ... VALUES ('5', '') ...<br><br>Tell me that it works.<br><br><div class="gmail_quote">On Wed, May 21, 2008 at 8:50 PM, Christopher Beck <<a href="mailto:cbeck@emory.edu">cbeck@emory.edu</a>> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">When I go to import users, I get the following error message:<br>
<br>
SQL Statement: INSERT INTO APUserPrivileges (UserId, Privilege) VALUES ('5', )<br>
SQL Error: You have an error in your SQL syntax; check the manual that<br>
corresponds to your MySQL server version for the right syntax to use<br>
near ')' at line 1<br>
<br>
CWIS seems to import the rest of the information, but doesn't import<br>
the privileges.<br>
<br>
A related question. Can I specify a custom privilege flag that I have<br>
created when I import users or for new users when they register?<br>
<br>
Thanks,<br>
Chris<br>
<br>
Dr. Christopher Beck<br>
Department of Biology<br>
Emory University<br>
1510 Clifton Rd.<br>
Atlanta, GA 30322<br>
<br>
Email: <a href="mailto:christopher.beck@emory.edu">christopher.beck@emory.edu</a><br>
Phone: 404-712-9012<br>
FAX: 404-727-2880<br>
<br>
_______________________________________________<br>
SPT-CWIS-Users mailing list<br>
<a href="mailto:SPT-CWIS-Users@scout.wisc.edu">SPT-CWIS-Users@scout.wisc.edu</a><br>
<a href="http://www.scout.wisc.edu/mailman/listinfo/spt-cwis-users" target="_blank">http://www.scout.wisc.edu/mailman/listinfo/spt-cwis-users</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>Chesstrian!!!