Hello,

We had a web site built on xoops (PHP) and I'm portig all data to a new DNN web site. Users are already been imported. Now I'm working with the Forum. Forum Groups and Forum Forums have been recreated. Now I suppose I must import Forum Users in the first place, then Threads and then Posts.

In the Host-SQL page, I'm trying to add a new Forum User using this query:

INSERT INTO r5dbadmin.Forum_Users 
(UserId, 
Signature,
PostCount,
LastActivity,
IsTrusted,
EnableOnlineStatus,
ThreadsPerPage,
PostsPerPage,
ViewDescending,
EnableModNotification,
EmailFormat,
PortalId,
EnablePublicEmail,
TrackingDuration,
LockTrust,
IsBanned,
LiftBanDate,
EnableSelfNotifications,
EnableProfileWeb,
EnableDefaultPostNotify,
StartBanDate)
(4090,
null,
0,
08/16/2012 06:53:13,
0,
0,
10,
5,
0,
0,
1,
0,
0,
1000,
0,
0,
null,
0,
1,
0,
null )

But I'm getting an error. Could some of you help me please?

Thanks in advance.

P.D. I know it would be easier if I could use Management Studio, but my hosting doesn't allow it.