Forums

Hi, I did not find any helpful answer to this error message, hence my question:

I created a form which works fine. I automatically generated the table via the „Auto manage the data table“ button. It saved, and the data is stored correctly in the database.

However, when trying to open the form from within the „Forms manager“ menu it says

>> 1103 Incorrect table name '' <<

The field-names and the form-name seem to be correct: only 0-9, a-z and _

I have another, quite similar, form where in the Forms manager menu the form name is correctly:
„tbm2_chronoforms_data_name2“

The forms name of the problematic form, however, is not correct, it somehow changed from "tbm2_chronoforms_data_name1" to
„#__chronoforms_data_name1“
In the MySQL Database it is correct: „tbm2_chronoforms_data_name1“

Can anybody help?

PS: I set up a new form (Easy mode)
Title: "test_form"
Designer: Checkbox and Button
Setup: Save to Database "Auto manage"
​
1. When I saved the form, the automated alias was "test-form" -> could not open the table
2. I switched to advanced mode, and changed the alias to "test_form", which shows correctly -> could not open the table
3. I set up a the same form anew in advanced mode with the alias "test_form" -> was able to open the table
​
Is this a bug in Chronoforms? And if this the reason why I can't set up a correct table for my form, is there a way to change the alias?

PPS: I narrowed down the problem:

The problem appears whenever I save a newly created form for the second time!, even if I did not change the form before saving again, and also if I did not even close and reopened the form.
​
What happens is, that at first saving a "Data table" will be created (Auto manage) that can be opened.

At second saving, the prefix of the data table's name will somehow change (not within the "Setup" section, but only in the list "Data tables" in the "Forms manager") from (in my case) "tbm2_" to "#_" and the table cannot be opened again (error 1103 Incorrect table name).

This happens if also I create the table manually via the "Creating table" button in the "Forms manager", and linking it to the form in the form's Setup section.

Last post for today: Can anybody help?!
​
From MySQL I exported the first, correct data table, and the second, corrupt data table of form "test_test8". Here is the code comparing the changes from one to two.
​
Highlighted is text is text in table one that has been deleted in table two. Underlined is what has been added in the second table/or else has replaced the deleted sections).
​
(39,'test_test8','test_test8',1,1,'','{\"mode\":\"advanced\",\"permissions_deactivated\":\"1\",\"default_event\":\"load\",\"event_not_found\":\"\",\"limited_edition\":\"1\"}','{\"load\":{\"name\":\"load\",\"minimized\":\"0\",\"access_denied\":\"\",\"owner_id\":\"\"},\"submit\":{\"name\":\"submit\",\"minimized\":\"0\",\"access_denied\":\"\",\"owner_id\":\"\"}}','{\"one\":{\"name\":\"one\",\"minimized\":\"0\",\"owner_id\":\"\",\"auto\":\"1\",\"template\":\"<table width=\\\"100%\\\" cellpadding=\\\"3\\\" cellspacing=\\\"3\\\" border=\\\"0\\\" class=\\\"ui table\\\">\\n<tr><td width=\\\"30%\\\" valign=\\\"top\\\" align=\\\"right\\\"><strong>Checkbox<\\/strong><\\/td><td width=\\\"70%\\\" valign=\\\"top\\\" align=\\\"left\\\">{data:checkbox1}<\\/td><\\/tr>\\n<\\/table>\"}}','{\"1\":{\"_section\":\"one\",\"type\":\"field_checkbox\",\"name\":\"field_checkbox1\",\"category\":\"\",\"label\":\"Checkbox\",\"params\":{\"name\":\"checkbox1\",\"id\":\"checkbox1\",\"value\":\"1\",\"data-value\":\"\"},\"style\":\"\",\"checked\":\"\",\"dynamics\":{\"email\":{\"enabled\":\"1\"},\"save\":{\"enabled\":\"1\"}},\"validation\":{\"required\":\"\",\"disabled\":\"\",\"rules\":\"\"},\"verror\":\"\",\"description\":{\"text\":\"\"},\"tooltip\":{\"text\":\"\",\"class\":\"icon info circular blue inverted small\"},\"states\":{\"hidden\":\"\",\"disabled\":\"\"},\"ghost\":{\"enabled\":\"1\",\"value\":\"\"},\"checked_provider\":\"\",\"reload\":{\"event\":\"\"},\"attrs\":\"\",\"container\":{\"class\":\"field\"},\"events\":[{\"sign\":\"=\",\"identifier\":\"\"}],\"owner_id\":\"\",\"toggler\":\"\",\"rules\":{\"access\":{\"owner\":\"\",\"1\":\"\",\"2\":\"\",\"6\":\"\",\"7\":\"\",\"8\":\"\",\"13\":\"\",\"15\":\"\",\"18\":\"\",\"19\":\"\",\"20\":\"\",\"21\":\"\"}}},\"\":\"\"},\"2\":{\"_section\":\"one\",\"type\":\"field_button\",\"name\":\"field_button2\",\"category\":\"\",\"params\":{\"type\":\"submit\",\"name\":\"button2\",\"id\":\"button2\",\"value\":\"\",\"data-selections\":\"0\",\"data-message\":\"Please make a selection from the list\"},\"content\":\"Send\",\"color\":\"green\",\"class\":\"\",\"fluid\":\"0\",\"attrs\":\"\",\"container\":{\"class\":\"\"},\"toolbar\":{\"enabled\":\"0\"},\"events\":[{\"sign\":\"click\",\"identifier\":\"\"}],\"owner_id\":\"\",\"toggler\":\"\",\"rules\":{\"access\":{\"owner\":\"\",\"1\":\"\",\"2\":\"\",\"6\":\"\",\"7\":\"\",\"8\":\"\",\"13\":\"\",\"15\":\"\",\"18\":\"\",\"19\":\"\",\"20\":\"\",\"21\":\"\"}}}}\":\"\"}}','{\"0\":{\"_event\":\"load\",\"type\":\"display_section\",\"name\":\"display_section1\",\"sections\":\"one\",\"display_type\":\"form\",\"data_provider\":\"\",\"validation\":{\"type\":\"inline\"},\"event\":\"submit\",\"submit_animation\":\"1\",\"parameters\":\"\",\"dynamic\":\"\",\"invisible\":\"\",\"keepalive\":\"1\",\"class\":\"ui form\",\"formid\":\"\",\"attrs\":\"\",\"modal\":{\"enabled\":\"\",\"pageload\":\"1\",\"header\":\"\",\"delay\":\"\",\"scroll\":\"\",\"trigger\":\"\",\"replacement\":\"\",\"size\":\"fullscreen\",\"basic\":\"\",\"close_icon\":\"1\",\"closable\":\"1\",\"inverted\":\"1\"},\"owner_id\":\"\",\"display\":{\"minimized\":\"0\"}},\"4\":{\"_event\":\"submit\",\"type\":\"save_data\",\"name\":\"save_data4\",\"label\":\"\",\"enabled\":\"1\",\"autotable\":\"1\",\"model_name\":\"Data4\",\"db_table\":\"tbm2_\":\"#__chronoforms_data_test_test8\",\"data_provider\":\"\",\"action\":\"save\",\"insert_data_override\":\"created:{date:Y-m-d H:i:s}\\r\\nuser_id:{user:id}\",\"update_data_override\":\"modified:{date:Y-m-d H:i:s}\",\"autofields\":\"1\",\"where\":\"\",\"fields\":{\"special\":\"\"},\"_save\":\"1\",\"viewfields\":\"null\",\"\":\"{\\\"field_checkbox1\\\":\\\"checkbox1\\\",\\\"field_button2\\\":\\\"button2\\\"}\",\"db\":{\"enabled\":\"\",\"user\":\"\",\"pass\":\"\",\"name\":\"\",\"type\":\"\",\"host\":\"\",\"prefix\":\"\"},\"owner_id\":\"\",\"rules\":{\"access\":{\"owner\":\"\",\"1\":\"\",\"2\":\"\",\"6\":\"\",\"7\":\"\",\"8\":\"\",\"13\":\"\",\"15\":\"\",\"18\":\"\",\"19\":\"\",\"20\":\"\",\"21\":\"\"}},\"success\":{\"minimized\":\"0\"},\"fail\":{\"minimized\":\"0\"}}}','{\"en_GB\":{\"name\":\"en_GB\",\"content\":\"\"}}','[]');

The Joomla 3.9.3 database scheme is #__, whereas the installed datatable prefix is tbm2_
​
In CF5 I can create a form, manually add a table (the suggested name starts with #__), save, alter the form, and save the form again. The displayed data table name in the forms-manager starts with tbm2_
​
​
In CF6 I create a form, manually add a table (the suggested name starts with tbm2_), save the form. The displayed data table name in the forms-manager starts with tbm2_. When I change the form, and save it again, the displayed data table name in the forms-manager has changed to #__

Hi burf,
​
This is a known issue after the newest update and a new update should fix this soon.
​
Best regards

Thanks for the good news.
Carsten.

Wow, I thought I was going crazy as my forms worked great just two days ago and now with the latest update my live site is broken to my users. Hope the fix is soon. :-)

Same with me … Hope for a fix very soon.
​
Workaround: For the moment, when I have to change a form, I set the "Auto manage table" button, but deselect the already linked table, so that it will be created anew (or at least linked again with a correct name) when I save the form. The form data will not be lost. (Works only, if you need not make any manual changes to the table.)

Thanks for the workaround for CF6 database; however CC6 still is not working yet. :-( Still getting 1103 error message.

Can confirm this! Thanks a lot for the quick fix.
Best
Carsten