Unable to add user after data import

If you have questions about using mojoPortal, you can post them here.

You may want to first review our site administration documentation to see if your question is answered there.

This thread is closed to new posts. You must sign in to post in the forums.
2/21/2010 7:17:52 PM
adguy
Gravatar
Total Posts 15
View Posts

Unable to add user after data import

Joe,

After I imported about 1000 user from a flat file into mp_users I hav lost my ability to add a uaer though manageusers.aspx. The start of the error log is as follows:

2010-02-21 19:12:58,419 ERROR mojoPortal.Web.mojoBasePage - 74.99.223.207-en-US - /Admin/ManageUsers.aspx?userId=-1
System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'TimeOffsetHours', table 'CMS.dbo.mp_Users'; column does not allow nulls. INSERT fails.

 

2/22/2010 10:32:29 PM
adguy
Gravatar
Total Posts 15
View Posts

Re: Unable to add user after data import

I got my problem fixed by editing the table to use some default values where needed. Not sure how I got it messed up.

You must sign in to post in the forums. This thread is closed to new posts.