Script for updating Relastionships?

Hi Everyone,

I just installed 8.03 on a new server, but I did this from an update from 7.x.

What I did was transfer over my current forums via MS Eterprise Mgr. This created all my tables (7.x) and brought over all my data along with it to my new MSSQL server.

I then ran the update script to upgrade to 8.x tables. This worked fine too.

I'm now trying to update the new forum permissions and I'm getting this error.

Microsoft OLE DB Provider for SQL Server error '80040e2f' Cannot insert the value NULL into column 'Author_ID', table 'tds_db.dbo.tblPermissions'; column does not allow nulls. INSERT fails. /forum/admin_forum_details.asp, line 308

I'm guessing it's becuase during the transfer to my new server the relationship between the tables was not kept.

Any sql scripts I can run to update these relationships?

Thanks,
Chris

I've discovered the problem. I re-did everything and I was getting the same result.

I had to go into the permissions table and change all fields to allow nulls to get rid of the error and discovered that it is not inserting the Author_ID into the table.

This is the problem and I'm not sure why or how to fix it.

Any ideas why I can log on fine but yet this field is not being stored correctly?