Hello there Sebastian,

I ran your query  to eliminate the problem in the feedback module and tried running turboDNN742 script again.

This time I got a different error:

System.Data.SqlClient.SqlException (0x80131904): The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_CAT_AdvCatProducts_Products". The conflict occurred in database "dotnetnuke2", table "dbo.CAT_Products", column 'ProductID'.

   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

   at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)

   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)

   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

   at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script)

ClientConnectionId:c13da449-a345-4e16-bb82-e5f63fe2fdcd

Error Number:547,State:0,Class:16

-- drop AF foregn keys with known issues:

IF EXISTS (SELECT * FROM Sys.Foreign_Keys WHERE Parent_Object_id = OBJECT_ID(N'dbo.[activeforums_ForumTopics]') 

                             AND name = N'FK_activeforums_ForumTopics_activeforums_Replies')

ALTER TABLE dbo.[activeforums_ForumTopics] 

DROP CONSTRAINT [FK_activeforums_ForumTopics_activeforums_Replies]

-- make sure, all constraints are enabled

IF (ServerProperty(N'EngineEdition') != 5) --Check for not running on SQL Azure

EXEC sp_msforeachtable "ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all"

Ok I'm contacting the Catalook guys for the Catalook error.

The execution of TurboDNN742 with the error left my installation unstable. Each time I tried to view the existing Superuser account DNN threw an error, so I restored my DB once again. I executed the AdjustDNNPortalSettings742.sql script again but the problems are still there.

Still can't make the Controlbar work. Each time I try to add a module the little animation spins forever. Moreover when I try to change the website splash page or the login redirect a popup window appears and throws an error. If I disable the Popup windows in the Site Manager the popup error disappears but the animation spins forever and no page i found for some obscure reason.

I was trying to upload the image in order to link it to the post and show you but I discovered another pretty thing. The File Manager is not working either.

Ok forget about the duplicate Key error Now it's gone for some reason...

Here is the part of the website that keeps generating the popup window with the error

And here is the popup that keeps throwing the error each time I touch one of the dropdowns. Same thing happens when the Welcome to your website page is active. It keeps throwing the same error.

Any clue as to what on earth could be wrong? 

Do I need an exorcist?

Thanks for any help

Hello Sebastian and thank you again for answering.

I did had not installed the language pack yet (I just did) because the situation was so messed up I did not want to add another variable to the confusion.

I also noticed I have a bunch of available stuff in the Further extensions tab and I wanted to know if you think it would be wise to go ahead and install them or not.

I have:

DotNetNuke ASP2 Menu Navigation Provider

DNNConnect CKEditorProvider

DotNetNuke DNN DropDown Navigation Provider - and this could be interesting for my Controlbar issue...

DotNetNuke DNN Tree Navigation Provider

DotNetNuke Solpart Menu Navigation Provider

I thought all this stuff was already installed but obviously it is not. What should I do? Should I try to install the stuff and see if it fixes my problems?

By the way, the people at Catalook were surprised your script was trying to alter Catalook tables and wanted to know if it was a customized version. I told them It was just the standard TurboDNN script you can download from Codeplex. I'm still waiting for their answer in order to solve the foreing key error issue.

Thanks again

Edoardo