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 12006 time(s), 9 post(s) 16.02.2012 15:55:29by adegyves
adegyves

adegyves

16.02.2012 15:55:29
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
Dieser Inhalt wurde noch nicht bewertet. 
25 Reputation 3 Total posts
shawndg

shawndg

16.02.2012 17:54:35
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!
Dieser Inhalt wurde noch nicht bewertet. 
1871 Reputation 252 Total posts
denis

denis

16.02.2012 18:05:05
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).
Dieser Inhalt wurde noch nicht bewertet. 
7207 Reputation 956 Total posts
adegyves

adegyves

16.02.2012 19:40:17
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
Dieser Inhalt wurde noch nicht bewertet. 
25 Reputation 3 Total posts
denis

denis

16.02.2012 20:09:28
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.
Dieser Inhalt wurde noch nicht bewertet. 
7207 Reputation 956 Total posts
adegyves

adegyves

18.02.2012 00:04:08
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.
Dieser Inhalt wurde noch nicht bewertet. 
25 Reputation 3 Total posts
khorvat

khorvat

19.02.2012 08:22:21
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
Dieser Inhalt wurde noch nicht bewertet. 
15993 Reputation 2214 Total posts
khorvat

khorvat

22.02.2012 08:17:46
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
Dieser Inhalt wurde noch nicht bewertet. 
15993 Reputation 2214 Total posts
khorvat

khorvat

23.02.2012 16:36:53
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
Dieser Inhalt wurde noch nicht bewertet. 
15993 Reputation 2214 Total posts