Sorry, i think that my suggestion does not works because the fields in the table APUserPrivileges is not null, so maybe you can install phpmyadmin to manage yours DB, you can export your DB again and try import to new database.<br>
<br><div class="gmail_quote">On Thu, May 22, 2008 at 1:32 PM, Christian Gutierrez <<a href="mailto:chesstrian@gmail.com">chesstrian@gmail.com</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;">
Hi, you should write ... VALUES ('5', '') ...<br><br>Tell me that it works.<div><div></div><div class="Wj3C7c"><br><br><div class="gmail_quote">On Wed, May 21, 2008 at 8:50 PM, Christopher Beck <<a href="mailto:cbeck@emory.edu" target="_blank">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" target="_blank">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" target="_blank">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></div></div><font color="#888888">-- <br>Chesstrian!!!
</font></blockquote></div><br><br clear="all"><br>-- <br>Chesstrian!!!