I'm having two Gallery 3.1.12 installations one on DNN 4.4.0 and the other one on DNN 4.4.1.

On both installations I cannot add security roles to the gallery, after opening the popup I get following error in my server application log:

Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 12.02.2007 06:50:28
Event time (UTC): 12.02.2007 05:50:28
Event ID: 30e7d2b63df845c6a315475a23e5ca57
Event sequence: 97
Event occurrence: 6
Event detail code: 0
 
Application information:
    Application domain: /LM/W3SVC/1720904576/Root-3-128157315244238192
    Trust level: Full
    Application Virtual Path: /
    Application Path: C:\Hosting\entwicklerey\dnn\
    Machine name: ZELOSVM10
 
Process information:
    Process ID: 4572
    Process name: w3wp.exe
    Account name: NT AUTHORITY\NETWORK SERVICE
 
Exception information:
    Exception type: SqlException
    Exception message: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ModuleSettings_Modules". The conflict occurred in database "DNNentwicklerey", table "dbo.Modules", column 'ModuleID'.

I actually check out the problem on the SQL server, if I can resolve I will post the solution.

I could not fix the problem myself. Here some additional information:

From the error stack in serverlog:

Request information:  Request URL: http://www.entwicklerey.ch/DesktopModules/Gallery/Popup/popupdata.aspx?datasource=gallery&objectclasses=102&tabid=85&mid=0&objectclass=102&location=&searchvalue=administrators
Here the javascript error on client side:

.. runtime error ..
Line: 22
Error: Object expected

I added the security roles manually in table modulesettings: downloadroles: value: ;3

No way doesn't work.

I tested the whole stuff on my local DNN337 installation and there all is working fine.

Can I correct the problem temporary with some manual corrections?

Please gimmie an advice, it's quite urgent.

Thank you and best regards

Daniel