 |
|
|
www.taxiroute.co.uk
Joined: 7/16/2004
Posts: 207
|
|
|
it just doesnt make sense.
i just cant think where to look.
my feeling is that its db related and not dnn. permissions or something.
i never give up!
thanks for the help seb
www.taxiroute.co.uk - Get a Fare Price!
|
| |
|
|
 | |
|
|
|
most likely it is an issue of the database, like a wrong version of a sproc being used
|
| |
|
|
| |
|
|
Joined: 4/15/2004
Posts: 87
|
|
|
Hello Trevor
Sorry, I don't have an answer to your problem but what Sebastian said may be true, also if your Add... Stored Procedures are not getting the right values from DNN then the inserts will fail too.
What stands out to me is that anything that tries to insert a record fails with similar error "column does not allow nulls. INSERT fails."
You could check your StoredProcs against a fresh install of DNN same version, see if everything looks similar, I'd start with all of the Add... StoredProcs.
If that's not it and if you are able to run a source version and step into the AddTab function, check the values of the variables before they're sent to the DB but this seems less likely since the TabID is an autoid on the table itself.
Last gasp could be to run the fresh install to a new DB, then do an Import of your existing data into the new Tables then point your site to the new DB.
Typically when doing the Import you can specify in the "Edit Mappings" option to "Delete rows in destination table" & "Enable identity insert". Make sure the column mappings check out and then go. You can do one or many tables at once.
Either way, good luck!
Josh
|
| |
|
|
| |
|
|
 |
Joined: 9/22/2006
Posts: 262
|
|
|
This is happening during the move of the database, isn't it? I just solved a very similar error, but on a different table.
I have solved the problem by checking my transfer of data procedure. I am not an SQL expert, but this error seems to indicate that the transfer of data has not gone well (though you might have seen no error output). Visual Studio 2008 allows you to Publish a database for the web by saving the script file to rebuild the complete database. This script can be executed on the destination server. I had to split up my script in parts coz otherwise the SQL Manager ran out of memory.
You can then also inspect the script file, it's plain text. You of course have to start from a working DNN instance (I mean without the error)
If you get errors during the execution of the scripts, research those. If you have no errors, your installation should work.
____________________________________
The one-eyed in the land of the blind.
|
| |
|
|
| |
|
|
www.taxiroute.co.uk
Joined: 7/16/2004
Posts: 207
|
|
|
ok, my plan was tonight to go back to basics. to try and add a page to the database from underneath dnn. at db level to see if i still got errors.
i wrote the following sql to mimic adding a page but still hitting and error. anyone know what FK is blocking me?
First the error:
Msg 547, Level 16, State 0, Line 1
The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "FK_Tabs_Tabs". The conflict occurred in database "Dotnetnuke", table "dbo.Tabs", column 'TabID'.
The statement has been terminated.
and the sql it tried:
INSERT INTO dbo.Tabs (
PortalId,
TabName,
IsVisible,
DisableLink,
ParentId,
IconFile,
Title,
Description,
KeyWords,
IsDeleted,
Url,
SkinSrc,
ContainerSrc,
TabPath,
StartDate,
EndDate,
RefreshInterval,
PageHeadText,
IsSecure,
PermanentRedirect
)
VALUES (
0,
'From SQL Manual Query',
1,
0,
0,
0,
'From SQL Manual Query',
'From SQL Manual Query',
'From SQL Manual Query',
0,
NULL,
NULL,
'//SQL'
,NULL,
NULL,
NULL,
NULL,
0,
0,
0);
www.taxiroute.co.uk - Get a Fare Price!
|
| |
|
|
| |