MonoX support board

Start the conversation, ask questions and share tips and solutions with fellow developers.

Non-registered users can only browse through our support boards. Please register now if you want to post your questions. It takes a second and it is completely free. Alternatively, you can log in without registration using your credentials at major sites such as Google, Microsoft Live, OpenId, Facebook, LinkedIn or Yahoo.

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  (Mono Support )

Viewed 11245 time(s), 9 post(s) 2/16/2012 3:55:29 PMby adegyves
adegyves

adegyves

2/16/2012 3:55:29 PM
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
This content has not been rated yet. 
25 Reputation 3 Total posts
shawndg

shawndg

2/16/2012 5:54:35 PM
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!
This content has not been rated yet. 
1871 Reputation 252 Total posts
denis

denis

2/16/2012 6:05:05 PM
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).
This content has not been rated yet. 
7207 Reputation 956 Total posts
adegyves

adegyves

2/16/2012 7:40:17 PM
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
This content has not been rated yet. 
25 Reputation 3 Total posts
denis

denis

2/16/2012 8:09:28 PM
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.
This content has not been rated yet. 
7207 Reputation 956 Total posts
adegyves

adegyves

2/18/2012 12:04:08 AM
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.
This content has not been rated yet. 
25 Reputation 3 Total posts
khorvat

khorvat

2/19/2012 8:22:21 AM
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
This content has not been rated yet. 
15993 Reputation 2214 Total posts
khorvat

khorvat

2/22/2012 8:17:46 AM
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
This content has not been rated yet. 
15993 Reputation 2214 Total posts
khorvat

khorvat

2/23/2012 4:36:53 PM
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
This content has not been rated yet. 
15993 Reputation 2214 Total posts