violation of primary key contour

René 327 posts 852 karma points

Feb 16, 2013 @ 15:58

Violation of PRIMARY KEY - Contour

Hi

Umbraco version 4.11.4

Contour version 3.0.6

I m only allowed to create 1 form.

When i try to create form number 2 i get this error:

Violation of PRIMARY KEY constraint 'PK_UFForms'. Cannot insert duplicate key in object 'dbo.UFForms'. The duplicate key value is (6f2903fc-e27a-4d68-88d7-8d948746a6fe).

Here is the content from the database:

The id is the same, but i think i choould just create a new one on the next row.

6f2903fc-e27a-4d68-88d7-8d948746a6fe QuickContact 2013-02-16 10:37:00.377 False 0 Thank you NULL False False {0} is mandatory {0} is not valid 0   False True False 0 0

Any suggestions?

Best regards René

Copy Link

René 327 posts 852 karma points

Feb 16, 2013 @ 19:09

HI again

I have looked at this a little futher.

It is only if i choose the template "Contact", if i choose "none" it works.

Copy Link

Tim Geyssens 6562 posts 15373 karma points MVP 2x c-trib

Feb 18, 2013 @ 09:13

Yeah it's a bug in 3.0.6 that got fixed in 3.0.7 http://nightly.umbraco.org/Umbraco%20Contour/3.0.7/changes.txt

Copy Link

René 327 posts 852 karma points

Feb 18, 2013 @ 09:24

Hi

But at the http://our.umbraco.org/projects/umbraco-pro/contour it says

To install on Umbraco 4.X

Either install diretcly from the umbraco repository, or install the Contour 3.0.6.zip (newer versions won't work) as a local package under developer / packages in the umbraco backoffice

So i can not install 3.0.7 on the Umbraco version 4.11.4 - and for the moment i do not want to upgrade to Umbraco version 6.0

Kindly René

Copy Link

Tim Geyssens 6562 posts 15373 karma points MVP 2x c-trib

Feb 18, 2013 @ 09:30

You could update the form templates (found in \Umbraco\plugins\umbracoContour\templates ) and update the id from what it is (all the way at the bottom) to all zeros

Copy Link

René 327 posts 852 karma points

Feb 18, 2013 @ 09:37

Hi Tim

Just vant to be sure of what you mean...

Is it this you mean, that every ID i set to 00000000-0000-0000-0000-000000000000 AFTER i Update vith the versions from Contour 3.0.7

<?xml version="1.0" encoding="utf-8"?>
<Form xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="UmbracoContour">
  <Name>Contact</Name>
  <Created>2012-11-19T12:26:50.927</Created>
  <FieldIndicationType>NoIndicator</FieldIndicationType>
  <Indicator />
  <ShowValidationSummary>false</ShowValidationSummary>
  <HideFieldValidation>false</HideFieldValidation>
  <RequiredErrorMessage>{0} is mandatory</RequiredErrorMessage>
  <InvalidErrorMessage>{0} is not valid</InvalidErrorMessage>
  <MessageOnSubmit>Thank you</MessageOnSubmit>
  <GoToPageOnSubmit>0</GoToPageOnSubmit>
  <ManualApproval>false</ManualApproval>
  <Archived>false</Archived>
  <StoreRecordsLocally>true</StoreRecordsLocally>
  <DisableDefaultStylesheet>false</DisableDefaultStylesheet>
  <Pages>
    <Page>
      <FieldSets>
        <FieldSet>
          <Fields>
            <Field>
              <PreValues />
              <Caption>Name</Caption>
              <ToolTip />
              <SortOrder>0</SortOrder>
              <PageIndex>0</PageIndex>
              <FieldsetIndex>0</FieldsetIndex>
              <Id>00000000-0000-0000-0000-000000000000</Id>
              <FieldSet>3dce7e6e-6b94-4b4f-9e43-58f1687d980b</FieldSet>
              <Form>6f2903fc-e27a-4d68-88d7-8d948746a6fe</Form>
              <FieldTypeId>3f92e01b-29e2-4a30-bf33-9df5580ed52c</FieldTypeId>
              <Mandatory>true</Mandatory>
              <RegEx />
              <RequiredErrorMessage />
              <InvalidErrorMessage />
              <PreValueSourceId>00000000-0000-0000-0000-000000000000</PreValueSourceId>
              <Settings />
              <Condition>
                <Id>7eb5cf20-0df9-4b6a-9e9e-0613525aa4dc</Id>  set to 00000000-0000-0000-0000-000000000000
                <Field>5674fa29-4ae2-4090-a0ce-2a2e70c35dfc</Field>
                <Enabled>false</Enabled>
                <ActionType>Show</ActionType>
                <LogicType>All</LogicType>
                <Rules />
              </Condition>
            </Field>
            <Field>
              <PreValues />
              <Caption>Email</Caption>
              <ToolTip />
              <SortOrder>1</SortOrder>
              <PageIndex>0</PageIndex>
              <FieldsetIndex>0</FieldsetIndex>
              <Id>00000000-0000-0000-0000-000000000000</Id>
              <FieldSet>3dce7e6e-6b94-4b4f-9e43-58f1687d980b</FieldSet>
              <Form>6f2903fc-e27a-4d68-88d7-8d948746a6fe</Form>
              <FieldTypeId>3f92e01b-29e2-4a30-bf33-9df5580ed52c</FieldTypeId>
              <Mandatory>true</Mandatory>
              <RegEx>^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,4})$</RegEx>
              <RequiredErrorMessage />
              <InvalidErrorMessage />
              <PreValueSourceId>00000000-0000-0000-0000-000000000000</PreValueSourceId>
              <Settings />
              <Condition>
                <Id>102477ed-50a8-4af6-a40b-b315e96fead4</Id>
                <Field>d222a759-d74e-4d6c-a6d5-23ffc4bda09b</Field>
                <Enabled>false</Enabled>
                <ActionType>Show</ActionType>
                <LogicType>All</LogicType>
                <Rules />
              </Condition>
            </Field>
            <Field>
              <PreValues />
              <Caption>Message</Caption>
              <ToolTip />
              <SortOrder>2</SortOrder>
              <PageIndex>0</PageIndex>
              <FieldsetIndex>0</FieldsetIndex>
              <Id>00000000-0000-0000-0000-000000000000</Id>
              <FieldSet>3dce7e6e-6b94-4b4f-9e43-58f1687d980b</FieldSet>
              <Form>6f2903fc-e27a-4d68-88d7-8d948746a6fe</Form>
              <FieldTypeId>023f09ac-1445-4bcb-b8fa-ab49f33bd046</FieldTypeId>
              <Mandatory>true</Mandatory>
              <RegEx />
              <RequiredErrorMessage />
              <InvalidErrorMessage />
              <PreValueSourceId>00000000-0000-0000-0000-000000000000</PreValueSourceId>
              <Settings />
              <Condition>
                <Id>4949846c-bc24-49db-9bdd-b7c1eb6179c8</Id>
                <Field>753ba791-0089-4342-8289-29e987518a35</Field>
                <Enabled>false</Enabled>
                <ActionType>Show</ActionType>
                <LogicType>All</LogicType>
                <Rules />
              </Condition>
            </Field>
          </Fields>
          <Caption>Contact</Caption>
          <SortOrder>0</SortOrder>
          <Id>00000000-0000-0000-0000-000000000000</Id>
          <Page>684d6d0a-11ba-4e22-a9fa-4a518c180835</Page>
        </FieldSet>
      </FieldSets>
      <Caption>Contact</Caption>
      <SortOrder>0</SortOrder>
      <Id>00000000-0000-0000-0000-000000000000</Id>
      <Form>6f2903fc-e27a-4d68-88d7-8d948746a6fe</Form>
    </Page>
  </Pages>
  <DataSource>00000000-0000-0000-0000-000000000000</DataSource>
  <Id>6f2903fc-e27a-4d68-88d7-8d948746a6fe</Id>
</Form>

Copy Link

Tim Geyssens 6562 posts 15373 karma points MVP 2x c-trib

Feb 18, 2013 @ 10:03

Just the one at the bottom so before the </form> tag the rest doesn't matter

Copy Link

is working on a reply...

This forum is in read-only mode while we transition to the new forum.

You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Flag this post as spam?

Violation of PRIMARY KEY - Contour

Violation of PRIMARY KEY constraint 'PK_UFForms'. Cannot insert duplicate key in object 'dbo.UFForms'. The duplicate key value is (6f2903fc-e27a-4d68-88d7-8d948746a6fe).