Mono Support Cannot insert the value NULL into column 'DateCreated', table 'webmart_socialdb.dbo.Page'; column does not allow nulls. INSERT fails. The statement has been terminated Error 

Viewed 12516 time(s), 9 post(s), 2/16/2012 3:55:29 PM - by adegyves
2/16/2012 3:55:29 PM
25 Reputation 3 Total posts

Hello, I installed Mono X via Web Wizard. When it finished the installation, the site shows me an error, I modified the web.config (customErrors mode="Off") to show me the error and it shows me:

Cannot insert the value NULL into column 'DateCreated', table 'webmart_socialdb.dbo.Page'; column does not allow nulls. INSERT fails. The statement has been terminated

You could see it http://social.feriasdemexico.com.mx

1
2/16/2012 5:54:35 PM
1871 Reputation 252 Total posts

Hi Adgeyves,

Thats odd.. I installed Monox many times and never ran into that problem..
I used both the Monox Installer as well as the MS Windows project installer thing.

If your new to MonoX and this is your first install.. what you may be doing wrong is thinking MonoX will create the database for you..
It wont.. you need to make sure you create a database inside ms sql and grant it proper permissions before you can even use MonoX's Installer.

Also make sure your application pools are configure for the correct .NET version of the MonoX version you have installed..

Also when posting questions.. try to provide more information about what environment you are trying to install MonoX on..
Windows Version ? MS SQL Server Version ? .NET Version ? IIS Version ?

All these things will help the MonoX team help you figure out your issue.

Good Luck!

2
2/16/2012 6:05:05 PM
7207 Reputation 956 Total posts

I addition to Shawn's questions, could you please check the MonoX database that is created during the install process and let me know if there is default value or binding for the DateCreated column in the Page table? It should hold the getdate() SQL function, and it appears to me that for some strange reason the database creation scripts were not executed correctly (or executed at all).

3
2/16/2012 7:40:17 PM
25 Reputation 3 Total posts

Thank you. The database was create and there are not default value for DataCreated column, I add getdate() and now displays me the same error for CacheDuration column.

Cannot insert the value NULL into column 'CacheDuration'

I am using MS SQL 2008, .NET 4.0, Windows Server 2008, and IIS 7

4
2/16/2012 8:09:28 PM
7207 Reputation 956 Total posts

Could you try to reinstall it? This has to be some error on your SQL server end, since all default values are scripted together with other DB structures and values. It appears that they were not inserted in your DB, and I really cannot think of a way to achieve this.

5
2/18/2012 12:04:08 AM
25 Reputation 3 Total posts

I am trying to reinstall it but in diferent parts of the process it return me to Welcome to the MonoX installation wizard screen. Sometimes the process create database and when at process detail said Localization Source it return to Wizard home.

6
2/19/2012 8:22:21 AM
15993 Reputation 2214 Total posts

Hi,

can you send us an InMail message containing your SQL Server name and credentials so we can check the issue you have and also it would be great to check the error logs.

Regards

7
2/22/2012 8:17:46 AM
15993 Reputation 2214 Total posts

Hi,

I have checked and reproduced the issue you have but it seems to us that there is an issue related to a session. We can't be sure what exactly is causing the issue until we review the error logs, can you please provide us with the error logs from the following location:

C:\HostingSpaces\webmart\viajarenmexicoesincreible.com.mx\wwwroot\MonoX\ApplicationData\Logs 

Regards

8
2/23/2012 4:36:53 PM
15993 Reputation 2214 Total posts

Hi,

it seems to us that there is a session issue, and it looks like that session is lost for some reason. I have sent you an Url to new MonoX version, so please download that version and try to install it. When you do so please get back to us with the results.

In the meanwhile can you please check the session time out period and what session provider do you use (e.g. InProc, StateServer or ?).

Thanks

9
This is a demo site for MonoX. Please visit Mono Software for more info.