[SPT/CWIS] importing users

[Christian Gutierrez]

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.

On Thu, May 22, 2008 at 1:32 PM, Christian Gutierrez <chesstrian at gmail.com>
wrote:

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




-- 
Chesstrian!!!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.scout.wisc.edu/pipermail/spt-cwis-users/attachments/20080522/4dc6779b/attachment.html