Created 2 records in table. Created a new element in my form of type username named joomla_id and set it to id. Then added a new entry . Checked table view and did not see joomla_id. Logged back into back end and then in form view selected update tables. Then creating a new record it throws a error.
Upon checking the contents of the DB with phpmyadmin the 3rd record is missing fabrik_internal_id. The only other change made was to turn fabrik_internal_id off in Show in table view, it is still published, joomla_id also never was filled.
Code:
Duplicate entry '' for key 1 SQL=INSERT INTO jos_fabrik_formdata_2 ( `fabrik_internal_id`,`time_date`,`name`,`city`,`state`,`sex`,`reason`,`joomla_id` ) VALUES ( '','2007-07-12','John Doe','Santa Rosa','CA','Male','For being himself.','63' )
Upon checking the contents of the DB with phpmyadmin the 3rd record is missing fabrik_internal_id. The only other change made was to turn fabrik_internal_id off in Show in table view, it is still published, joomla_id also never was filled.