Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
This week I installed Umbraco and Contour on Azure. It's not yet licenced, but when I try to hit send I get this error: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery.
I did find some old posts about stuff missing in the db, is this the problem here as well? Maybe because it's hosted on Azure. How can I fix it without breaking anything?
(Umbraco v6.0.5 + Contour version 3.0.11)
Hmm I'll need to check this, creating forms works, it's just submitting that throws the error?
At the moment I removed it from the page and made something myself, so I can't check it anymore.
But I was able to make a form, save it and add it to the page. When I tryed to submit it I got the error. Maybe something went wrong with installing. But I had a problem with removing forms I made as well. Looked like a problem with rights. Can't find anything in my logs about a problem with contour.
Ok thanks for the extra details, will do a test install on azure to see if I can reproduce ;)
I have the same problem. The problem occurs not only at submit but also at going to the next step. Is there any progress on this? I have also a problem with exporting the azure database because several UF* tables used by Contour do not have a clustered index, which looks similar to this problem: http://issues.umbraco.org/issue/CON-88 .. Maybe these two issues have a relation.
Yeah currently testing so hope to have something ready tomorrow
Excecuting the next script did the trick for me:CREATECLUSTEREDINDEX[UFFieldSettings_Index]ON[UFFieldSettings]([Field])CREATECLUSTEREDINDEX[UFRecordDataBit_Index]ON[UFRecordDataBit]([Key])CREATECLUSTEREDINDEX[UFRecordDataDateTime_Index]ON[UFRecordDataDateTime]([Key])CREATECLUSTEREDINDEX[UFRecordDataInteger_Index]ON[UFRecordDataInteger]([Key])CREATECLUSTEREDINDEX[UFRecordDataLongString_Index]ON[UFRecordDataLongString]([Key])CREATECLUSTEREDINDEX[UFRecordDataString_Index]ON[UFRecordDataString]([Key])
Is there any solution on this? I have the same issue. Creating forms is fine, just the error when submitting from end.
See my last reply on June 6th. It's a hotfix but it did the trick for me
I've tried to add run this script on azure backend and it says:
msg156, level 15, state 1, line 1
Incorect syntax near keyword 'ON'
Any idea why this would be?
Also, are there any versions of Contour that will work on azure out the box with Umbraco 6.1.2? I haven't been able to use this product at all.
@Scott can you try the latest stable so 3.0.14
I have the same problem with Contour 3.0.17, when I submit the contact form. I tried to reinstall contour, but the problem still exists.
Is there already any solution?
Umbraco 4.11.5 on Azure
I have had problems deleting forms, saving forms, running forms - it's been driving me nuts !... I ran the following SQL from Chuhukon and it has transformed the way Contour is behaving. The problem with his original SQL is it has stripped out all the spaces so gave errors. Enjoy :)
CREATE CLUSTERED INDEX [UFFieldSettings_Index] ON [UFFieldSettings]([Field])
CREATE CLUSTERED INDEX [UFRecordDataBit_Index] ON [UFRecordDataBit]([Key])
CREATE CLUSTERED INDEX [UFRecordDataDateTime_Index] ON [UFRecordDataDateTime]([Key])
CREATE CLUSTERED INDEX [UFRecordDataInteger_Index] ON [UFRecordDataInteger]([Key])
CREATE CLUSTERED INDEX [UFRecordDataLongString_Index] ON [UFRecordDataLongString]([Key])
CREATE CLUSTERED INDEX [UFRecordDataString_Index] ON [UFRecordDataString]([Key])
For anyone stumbling over this issue, that are running the database in SQL Azure.
As far as I can tell, there is currently only one table missing an index in the database: UFFieldSettings
To make things work, you can run this script on the database
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
CREATE CLUSTERED INDEX IX_UFFieldSettings ON dbo.UFFieldSettings
([Key]) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
ALTER TABLE dbo.UFFieldSettings SET (LOCK_ESCALATION = TABLE)
Happy Azure hosting
Cool Jesper, Thanks.Fixed my u 6.1.2 + c 3.0.19
is working on a reply...
Write your reply to:
Image will be uploaded when post is submitted