1. Fabrik 3.5.2 is now available to download. Read the blog for highlights about this release.

    As always, please back up your site prior to updating and if possible test in a dev environment first.

    Also, our 3.5.1 package file was hacked, the effected dates were 1/15/2017 - 1/17/2017. If during those days you downloaded the 3.5.1 package file from the JED or our site download page, please re-install the package with a fresh copy or upgrade to Fabrik 3.5.2. Github downloads were not effected.

Renamed internal ID and now get table error

Discussion in 'Standard Support' started by JDub2300, Jun 14, 2010.

Thread Status:
Not open for further replies.
  1. JDub2300

    JDub2300 New Member

    Level: Standard
    I am working on a form. I changed the name of some "fabrik_internal_ID" elements to names like "Medical_fabrik_interal_ID". I also changed the "Show in table" options for some elements in the same groups to "No".

    Now when I try to "view data" for that form, I get a page of errors and no data. Here is the first part of the error message:

    Code (Text):
    getData: Unknown column 'Class_Registrants.Medical_fabrik_internal_id' in 'field list' SQL=SELECT DISTINCT `Class_Registrants`.`ClassRegistrants_fabrik_internal_id` AS `Class_Registrants___ClassRegistrants_fabrik_internal_id`
    I tried to revert the id's to their original names, "fabrik_internal_ID", but Fabrik will not allow me to use the same name for multiple elements!

    I also tried to "update database" on the form and got this error:

    Code (Text):
    amend table: Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `Class_Registrants` ADD COLUMN `medical_fabrik_internal_id` INT(6) NOT NULL AUTO_INCREMENT null AFTER `text_blank_line_9`
    Then I tried to change some settings in medical_fabrik_internal_id and received the error:

    Code (Text):
    500 - An error has occurred
    alter structure: Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `Class_Registrants` ADD COLUMN `Medical_fabrik_internal_id` INT(6) NOT NULL AUTO_INCREMENT AFTER `text_blank_line_9`


    Is there a way to fix this inside Fabrik?
    If not,what do I change in the SQL database to fix this? Thanks.
     
  2. JDub2300

    JDub2300 New Member

    Level: Standard
    SOLVED IT. I deleted the ID value of 'Medical_fabrik_internal_ID' via SQL and re-saved the element in Fabrik. Perhaps, somehow, the ID '6' was used by multiple elements?? *Shrug* As long as it is working for the moment!
     
Thread Status:
Not open for further replies.

Share This Page