| Author |
 Topic  |
|
|
D3mon
Senior Member
United Kingdom
1685 Posts |
 Posted - 13 February 2008 : 09:16:04
|
Hi all,
Have just moved hosts and copied my MSSQL database from old host server to new host with DTSWizard. All seems to have transferred OK, but I'm left with an error when I or my members try to post:
Cannot insert the value NULL into column 'TOPIC_ID'.../forums/post_info.asp, line 841
A bit of reading suggests that it might be a permissions/user setup issue, but I'm a bit confused as to why its trying to insert a NULL into an ID field...
As a last resort option, I could ask for a backup then restore it to my new hosts, but it seems so close as it is... |
Snitz 'Speedball' : Site Integration Mod : Friendly Registration Mod
"In war, the victorious strategist only seeks battle after the victory has been won" |
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 13 February 2008 : 09:48:48
|
| you should create the tables using Snitz first, then do a transfer with DTS (enabling identity insert), otherwise it does not create the identity fields correctly |
 |
|
|
D3mon
Senior Member
United Kingdom
1685 Posts |
|
|
D3mon
Senior Member
United Kingdom
1685 Posts |
Posted - 13 February 2008 : 13:13:44
|
| That worked great, thanks. I had some trouble with a couple of mods that I'd installed, which had added extra fields into the source database tables, but once I'd updated the fields in the target tables, it all copied across nicely. |
Snitz 'Speedball' : Site Integration Mod : Friendly Registration Mod
"In war, the victorious strategist only seeks battle after the victory has been won" |
|
|
| |
Topic |
|
Topic Locked
