violation of primary key contour - 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

Comment author was deleted

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

Comment author was deleted

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

Comment author was deleted

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...

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).