I'm having major problems with ChronoForms. After migrating to Joomla 3.4, my old forms display almost properly (but the ReCaptchas don't show up) and my onsubmit actions seem to have disappeared. The forms show up as custom code even though I created them in the wizard, so the wizard (designer) page is blank.
So I thought I'd just create new forms. But although I can create the shell of a form, the minute I add anything to the designer and try to save, I'm getting SQL error 1062, duplicate key. I'm pasting the error message (minus a few key bits for security reasons) below.
Duplicate entry '0' for key 'PRIMARY' SQL=INSERT INTO `XXXX_chronoengine_chronoforms` (`id`, `title`, `params`, `published`, `app`, `form_type`, `content`, `extras`) values ('0', 'newsupport', '{\"description\":\"New Support Form\",\"setup\":\"0\",\"theme\":\"bootstrap3\",\"tight_layout\":\"0\",\"rtl_support\":\"0\",\"labels_right_aligned\":\"0\",\"labels_auto_width\":\"0\",\"js_validation_language\":\"\"}', '1', '', '1', '<div class=\"form-group gcore-form-row\" id=\"form-row-custom\"><label for=\"custom\" class=\"control-label gcore-label-left\">Header</label>\n<div class=\"gcore-input gcore-display-table\" id=\"fin-custom\">WHEATSTONE SUPPORT CONTACT FORM\r\n\r\nPlease use this form only to contact Wheatstone\'s technical support department. There\'s a separate form for sales inquiries that will get your question or request to the right people.\r\n\r\nPLEASE NOTE: This form sends an e-mail to our technical support department. It may take up to two business days to receive a response. If your need is more urgent than that, please call Wheatstone at (252) 638-XXXX to speak with a technical support specialist.\r\n</div></div>', 'YToyOntzOjY6ImZpZWxkcyI7YToxOntpOjE7YTo3OntzOjU6ImxhYmVsIjtzOjY6IkhlYWRlciI7czo5OiJwdXJlX2NvZGUiO3M6MToiMCI7czo0OiJjb2RlIjtzOjQ4NDoiV0hFQVRTVE9ORSBTVVBQT1JUIENPTlRBQ1QgRk9STQ0KDQpQbGVhc2UgdXNlIHRoaXMgZm9ybSBvbmx5IHRvIGNvbnRhY3QgV2hlYXRzdG9uZSdzIHRlY2huaWNhbCBzdXBwb3J0IGRlcGFydG1lbnQuIFRoZXJlJ3MgYSBzZXBhcmF0ZSBmb3JtIGZvciBzYWxlcyBpbnF1aXJpZXMgdGhhdCB3aWxsIGdldCB5b3VyIHF1ZXN0aW9uIG9yIHJlcXVlc3QgdG8gdGhlIHJpZ2h0IHBlb3BsZS4NCg0KUExFQVNFIE5PVEU6IFRoaXMgZm9ybSBzZW5kcyBhbiBlLW1haWwgdG8gb3VyIHRlY2huaWNhbCBzdXBwb3J0IGRlcGFydG1lbnQuIEl0IG1heSB0YWtlIHVwIHRvIHR3byBidXNpbmVzcyBkYXlzIHRvIHJlY2VpdmUgYSByZXNwb25zZS4gSWYgeW91ciBuZWVkIGlzIG1vcmUgdXJnZW50IHRoYW4gdGhhdCwgcGxlYXNlIGNhbGwgV2hlYXRzdG9uZSBhdCAoMjUyKSA2MzgtNzAwMCB0byBzcGVhayB3aXRoIGEgdGVjaG5pY2FsIHN1cHBvcnQgc3BlY2lhbGlzdC4NCiI7czo0OiJuYW1lIjtzOjY6ImN1c3RvbSI7czoxMToicmVuZGVyX3R5cGUiO3M6NjoiY3VzdG9tIjtzOjQ6InR5cGUiO3M6NjoiY3VzdG9tIjtzOjEyOiJjb250YWluZXJfaWQiO3M6MToiMCI7fX1zOjM6IkROQSI7YToyOntzOjQ6ImxvYWQiO3M6MDoiIjtzOjY6InN1Ym1pdCI7czowOiIiO319');
So I thought I'd just create new forms. But although I can create the shell of a form, the minute I add anything to the designer and try to save, I'm getting SQL error 1062, duplicate key. I'm pasting the error message (minus a few key bits for security reasons) below.
Duplicate entry '0' for key 'PRIMARY' SQL=INSERT INTO `XXXX_chronoengine_chronoforms` (`id`, `title`, `params`, `published`, `app`, `form_type`, `content`, `extras`) values ('0', 'newsupport', '{\"description\":\"New Support Form\",\"setup\":\"0\",\"theme\":\"bootstrap3\",\"tight_layout\":\"0\",\"rtl_support\":\"0\",\"labels_right_aligned\":\"0\",\"labels_auto_width\":\"0\",\"js_validation_language\":\"\"}', '1', '', '1', '<div class=\"form-group gcore-form-row\" id=\"form-row-custom\"><label for=\"custom\" class=\"control-label gcore-label-left\">Header</label>\n<div class=\"gcore-input gcore-display-table\" id=\"fin-custom\">WHEATSTONE SUPPORT CONTACT FORM\r\n\r\nPlease use this form only to contact Wheatstone\'s technical support department. There\'s a separate form for sales inquiries that will get your question or request to the right people.\r\n\r\nPLEASE NOTE: This form sends an e-mail to our technical support department. It may take up to two business days to receive a response. If your need is more urgent than that, please call Wheatstone at (252) 638-XXXX to speak with a technical support specialist.\r\n</div></div>', 'YToyOntzOjY6ImZpZWxkcyI7YToxOntpOjE7YTo3OntzOjU6ImxhYmVsIjtzOjY6IkhlYWRlciI7czo5OiJwdXJlX2NvZGUiO3M6MToiMCI7czo0OiJjb2RlIjtzOjQ4NDoiV0hFQVRTVE9ORSBTVVBQT1JUIENPTlRBQ1QgRk9STQ0KDQpQbGVhc2UgdXNlIHRoaXMgZm9ybSBvbmx5IHRvIGNvbnRhY3QgV2hlYXRzdG9uZSdzIHRlY2huaWNhbCBzdXBwb3J0IGRlcGFydG1lbnQuIFRoZXJlJ3MgYSBzZXBhcmF0ZSBmb3JtIGZvciBzYWxlcyBpbnF1aXJpZXMgdGhhdCB3aWxsIGdldCB5b3VyIHF1ZXN0aW9uIG9yIHJlcXVlc3QgdG8gdGhlIHJpZ2h0IHBlb3BsZS4NCg0KUExFQVNFIE5PVEU6IFRoaXMgZm9ybSBzZW5kcyBhbiBlLW1haWwgdG8gb3VyIHRlY2huaWNhbCBzdXBwb3J0IGRlcGFydG1lbnQuIEl0IG1heSB0YWtlIHVwIHRvIHR3byBidXNpbmVzcyBkYXlzIHRvIHJlY2VpdmUgYSByZXNwb25zZS4gSWYgeW91ciBuZWVkIGlzIG1vcmUgdXJnZW50IHRoYW4gdGhhdCwgcGxlYXNlIGNhbGwgV2hlYXRzdG9uZSBhdCAoMjUyKSA2MzgtNzAwMCB0byBzcGVhayB3aXRoIGEgdGVjaG5pY2FsIHN1cHBvcnQgc3BlY2lhbGlzdC4NCiI7czo0OiJuYW1lIjtzOjY6ImN1c3RvbSI7czoxMToicmVuZGVyX3R5cGUiO3M6NjoiY3VzdG9tIjtzOjQ6InR5cGUiO3M6NjoiY3VzdG9tIjtzOjEyOiJjb250YWluZXJfaWQiO3M6MToiMCI7fX1zOjM6IkROQSI7YToyOntzOjQ6ImxvYWQiO3M6MDoiIjtzOjY6InN1Ym1pdCI7czowOiIiO319');
Hi kd4dcy,
It looks as though the table hasn't installed properly or has been corrupted somehow.We've seen similar errors before when the Primary Key isn't set to Auto-increment or, I think, when the key counter is set to start at zero.
If you don't have any forms saved I suggest that you uninstall CFv5, check that the table has been deleted, then re-install
Bob
It looks as though the table hasn't installed properly or has been corrupted somehow.We've seen similar errors before when the Primary Key isn't set to Auto-increment or, I think, when the key counter is set to start at zero.
If you don't have any forms saved I suggest that you uninstall CFv5, check that the table has been deleted, then re-install
Bob
I have about five or six forms installed. None of them are working correctly now, but I'd really rather not duplicate the effort it took to create them in the first place or I would have already deleted and reinstalled. If necessary it would not be impossible, but it would take me off several other important things I should be doing for a day or two.🙂
This topic is locked and no more replies can be posted.
