I have recently purchased Contour for a client and went to install it via the install local package in the developer section got past all the questions to say I accept the the T&C's got to the install and got hte following error;
Cannot insert the value NULL into column 'id', table 'XXX.dbo.cmsMacro'; column does not allow nulls. INSERT fails. The statement has been terminated
looks like your database is missing something. By default, the column id in the table cmsMacro has Identity set to true. This means, when you insert a record, it gets a new number automatically.
How did you install the database? Did you use the umbraco-install procedure or did you restore a backup or something?
Error on installing Contour
Hi All,
I have recently purchased Contour for a client and went to install it via the install local package in the developer section got past all the questions to say I accept the the T&C's got to the install and got hte following error;
Any help would be much appreciated
Thanks
Tom
Hi Tom,
looks like your database is missing something. By default, the column id in the table cmsMacro has Identity set to true. This means, when you insert a record, it gets a new number automatically.
How did you install the database? Did you use the umbraco-install procedure or did you restore a backup or something?
HTH,
Peter
Hi Peter,
It was a DTS from the Live to a dev database box.
Tom
That probably is the cause. You must have more problems on the dev-box then as well, like creating a new textpage.
You can better create a backup from the DB on the live-server and then restore that on the dev-box. That way the DB stays intact like it should.
HTH,
Peter
Your right, the DTS has stripped all the Primary Keys out on hte dev box.
so errors galore!!
Thanks
Pete
is working on a reply...