nuBuilder Forum


https://forums.nubuilder.cloud/

Subform not saved on a new registration

https://forums.nubuilder.cloud/viewtopic.php?t=12016

Page 1 of 2

Subform not saved on a new registration

Posted: Sat May 06, 2023 7:05 am
by johan
Hi
In a new database I run into a problem.
If I create a new form and immediately enter data into the subform, the data from the subform is not saved.
If I add data on an existing form, the data from the subform is added.
Is this a known problem?

Re: Subform not saved on a new registration

Posted: Sat May 06, 2023 7:37 am
by kev1n
Hi johan,

I'm unable to replicate this using the latest version. Did you verify that the configuration is correct (Forein Key etc)?

Re: Subform not saved on a new registration

Posted: Sat May 06, 2023 7:50 am
by johan
Yes, the foreign key is correct. When I add info to an existing form the info is saved correct.

I've created my subforms with fastform.
This problem exist in all my forms in this database.
Johan

Re: Subform not saved on a new registration

Posted: Sat May 06, 2023 7:57 am
by kev1n
Would you be able to provide me with a minimal example by uploading a dump? You can use the cloner to generate a dump of your form and subform. Also create dumps of the relevant tables. This will make it easier for me to reproduce the issue.

Otherwise, I would require detailed, step-by-step instructions on how to reproduce it. Thank you!

Re: Subform not saved on a new registration

Posted: Sat May 06, 2023 8:13 am
by kev1n
This is how I was trying to replicate the issue: https://streamable.com/sk0hsi

Re: Subform not saved on a new registration

Posted: Sat May 06, 2023 8:17 am
by johan
Kev1n
This is the result of thé cloner

Code: Select all

  -- nuBuilder cloner SQL Dump
-- Version 1.21
-- Generation Time: May 06, 2023 05:09:23 AM

-- Form Description: beton
-- Form Code: contracten
-- Form Table: contracten
-- Form Type: browseedit


--
-- zzzzsys_form: contracten_clone_1
--

INSERT INTO zzzzsys_form (zzzzsys_form_id, sfo_type, sfo_code, sfo_description, sfo_breadcrumb_title, sfo_table, sfo_primary_key, sfo_browse_redirect_form_id, sfo_browse_row_height, sfo_browse_rows_per_page, sfo_browse_title_multiline, sfo_browse_autoresize_columns, sfo_browse_sql, sfo_javascript, sfo_browse_javascript, sfo_edit_javascript, sfo_style, sfo_mobile_view, sfo_json) 
VALUES ( '6455ef139aee78f', 'browseedit', 'contracten_clone_1', 'beton', 'beton', 'contracten', 're_id', NULL, '22', '20', '1', '1', 'select distinct a.re_id ,m.naam ,b.name afdeling , c.name functie ,a.re_start , a.re_eind , a.re_vte from `reg_personeel`.contracten a inner join `reg_personeel`.list b on b.id = a.re_afdeling inner join `reg_personeel`.list c on c.id = a.re_functie left join `reg_personeel`.titularis ti on ti.contract_id = a.re_id and (coalesce(ti.eind,curdate())>= curdate() OR ti.eind =\'0000-00-00\') left join `reg_personeel`.medewerkers m on m.id = ti.medewerker where (coalesce(a.re_eind,curdate()) >= curdate() OR a.re_eind = \'0000-00-00\' ) order by b.name, a.re_id;', 'function controle() {\n\nvar A = nuGetValue(\'re_vte\');\nvar B =  nuGetValue(\'controle\');\nvar C = A < B ;\n\nif (C == true)\n{\n\nnuMessage(\'Er wordt meer ingezet dan VTE in dit contract\');\n\nreturn false;\n}\n}\n', NULL, '', NULL, '', NULL ); 

--
-- zzzzsys_tab
--

INSERT INTO zzzzsys_tab (zzzzsys_tab_id, syt_zzzzsys_form_id, syt_title, syt_order, syt_help, syt_access, syt_json) 
VALUES ( '6455ef139b3b1f3', '6455ef139aee78f', 'contract', '10', NULL, NULL, NULL ); 

--
-- zzzzsys_browse
--

INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 
VALUES ( '6455ef139b9e7be', '6455ef139aee78f', 'id', 're_id', 'l', NULL, '10', '100', NULL ); 
INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 
VALUES ( '6455ef139b9f7dc', '6455ef139aee78f', 'afdeling', 'b.name', 'l', NULL, '20', '300', NULL ); 
INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 
VALUES ( '6455ef139ba0157', '6455ef139aee78f', 'titularis', 'm.naam', 'l', NULL, '30', '300', NULL ); 

--
-- zzzzsys_php
--

INSERT INTO zzzzsys_php (zzzzsys_php_id, sph_code, sph_description, sph_group, sph_php, sph_run, sph_zzzzsys_form_id, sph_system, sph_global, sph_hide, sph_json) 
VALUES ( '6455ef139aee78f_BS', '6455ef139aee78f_BS', 'System PHP', 'nubuilder', NULL, NULL, NULL, '1', '0', NULL, NULL ); 

--
-- zzzzsys_object
--

INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 
VALUES ( '6455ef139beb2a9', '6455ef139aee78f', 'contracten', 'select', 're_afdeling', 'Afdeling', '6455ef139b3b1f3', '10', '77', '111', '300', '22', '1', 'left', '1', '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', 'select id, name from list where listid = \'afdeling\'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ); 
INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 
VALUES ( '6455ef139bee5ff', '6455ef139aee78f', 'contracten', 'input', 're_start', 'startdatum', '6455ef139b3b1f3', '30', '127', '110', '300', '22', '1', 'left', '1', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '0', '0', 'select id, name from list where listid = \'afdeling\'', '', '', '', NULL, '', '', NULL, '', '', '', '', '', '', '', '0', 'D|dd-mm-yyyy', 'nuDate', '', '', '', '', '0', '', '', '', '', '', '', '', '', NULL ); 
INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 
VALUES ( '6455ef139bf0a14', '6455ef139aee78f', 'contracten', 'input', 're_eind', 'einddatum', '6455ef139b3b1f3', '50', '127', '560', '300', '22', '1', 'left', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '0', '0', 'select id, name from list where listid = \'afdeling\'', '', '', '', NULL, '', '', NULL, '', '', '', '', '', '', '', '0', 'D|dd-mm-yyyy', 'nuDate', '', '', '', '', '0', '', '', '', '', '', '', '', '', NULL ); 
INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 
VALUES ( '6455ef139bf2db9', '6455ef139aee78f', 'contracten', 'input', 're_vte', 'vte', '6455ef139b3b1f3', '70', '154', '560', '100', '22', '1', 'left', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '0', '0', 'select id, name from list where listid = \'afdeling\'', '', '', '', NULL, '', '', NULL, '', '', '', '', '', '', '', '0', 'N|1000.00', 'nuNumber', '', '', '', '', '0', '', '', '', '', '', '', '', '', NULL ); 
INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 
VALUES ( '6455ef139bfe80f', '6455ef139aee78f', 'contracten', 'subform', 'Sub2', 'bron', '6455ef139b3b1f3', '40', '225', '119', '1050', '300', '0', 'left', '0', '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '6411e0e33608165', 'bron_contract_id', '1', '1', 'g', 'bron', '0', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ); 
INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 
VALUES ( '6455ef139c00820', '6455ef139aee78f', 'contracten', 'display', 'info', ' ', '6455ef139b3b1f3', '60', '38', '558', '300', '50', '1', 'left', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', 'select concat(\'titularis:\', \'  \', a.naam)  from titularis x \ninner join medewerkers a on a.id = x.medewerker \n\nwhere x.contract_id = \'#re_id#\'  and x.start <= curdate() and (coalesce(x.eind,curdate()) >= curdate() OR x.eind =\'0000-00-00\')', '0', '0', 'select id, name from list where listid = \'afdeling\'', '', '', '', NULL, '', '', NULL, '', '', '', '', '', '', '', '0', '', '', '', '', '', '', '0', '', '', '', '', '', '', '', '', NULL ); 
INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 
VALUES ( '6455ef139c030ce', '6455ef139aee78f', 'contracten', 'select', 're_functie', 'Functie', '6455ef139b3b1f3', '20', '103', '111', '300', '22', '1', 'left', '1', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '0', '0', 'select id, name from list where listid = \'functie\'', '', '', '', NULL, '', '', NULL, '', '', '', '', '', '', '', '0', '', '', '', '', '', '', '0', '', '', '', '', '', '', '', '', NULL ); 

--
-- zzzzsys_form: FF1_clone_1
--

INSERT INTO zzzzsys_form (zzzzsys_form_id, sfo_type, sfo_code, sfo_description, sfo_breadcrumb_title, sfo_table, sfo_primary_key, sfo_browse_redirect_form_id, sfo_browse_row_height, sfo_browse_rows_per_page, sfo_browse_title_multiline, sfo_browse_autoresize_columns, sfo_browse_sql, sfo_javascript, sfo_browse_javascript, sfo_edit_javascript, sfo_style, sfo_mobile_view, sfo_json) 
VALUES ( '6455ef139cfb68a', 'subform', 'FF1_clone_1', 'Fast Form 1', NULL, 'bron', 'bron_id', '', '0', '0', '0', NULL, 'SELECT * FROM bron', NULL, NULL, NULL, NULL, NULL, NULL ); 

--
-- zzzzsys_tab
--

INSERT INTO zzzzsys_tab (zzzzsys_tab_id, syt_zzzzsys_form_id, syt_title, syt_order, syt_help, syt_access, syt_json) 
VALUES ( '6455ef139d38316', '6455ef139cfb68a', 'Main', '10', NULL, NULL, NULL ); 

--
-- zzzzsys_object: UPDATE subform ID
--

UPDATE zzzzsys_object SET sob_subform_zzzzsys_form_id = '6455ef139cfb68a' WHERE sob_subform_zzzzsys_form_id = '6411e0e33608165';

--
-- zzzzsys_object
--

INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 
VALUES ( '6455ef139dd2fd3', '6455ef139cfb68a', 'bron', 'select', 'bron_bron', 'bron', '6455ef139d38316', '0', '10', '150', '200', '22', '1', 'left', '1', '0', '0', NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '0', '1', 'select id, name from list where listid = \'bron\'', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '', '', NULL, '', NULL, NULL, '0', '', '', '', '', '', '', '', NULL, NULL ); 
INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 
VALUES ( '6455ef139dd5910', '6455ef139cfb68a', 'bron', 'select', 'bron_specifiek', 'specifiek', '6455ef139d38316', '5', '42', '150', '200', '22', '1', 'left', '1', '0', '0', NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '0', '1', 'select id , name from list where listid = \'werking\'', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '', '', NULL, '', NULL, NULL, '0', '', '', '', '', '', '', '', NULL, NULL ); 
INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 
VALUES ( '6455ef139de01b9', '6455ef139cfb68a', 'bron', 'select', 'bron_inzet', 'inzet', '6455ef139d38316', '10', '74', '150', '200', '22', '1', 'left', '1', '0', '0', NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '0', '1', 'select id , name from list where listid = \'inzet\'', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '', '', NULL, '', NULL, NULL, '0', '', '', '', '', '', '', '', NULL, NULL ); 
INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 
VALUES ( '6455ef139de2940', '6455ef139cfb68a', 'bron', 'select', 'bron_cluster', 'cluster', '6455ef139d38316', '15', '106', '150', '300', '22', '1', 'left', '1', '0', '0', NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '0', '1', 'select id , name from list where listid = \'cluster\'', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '', '', NULL, '', NULL, NULL, '0', '', '', '', '', '', '', '', NULL, NULL ); 
INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 
VALUES ( '6455ef139de4cb6', '6455ef139cfb68a', 'bron', 'input', 'bron_vte', 'vte', '6455ef139d38316', '20', '138', '150', '90', '22', '1', 'right', '1', '0', '1', NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 'N|1000.00', 'nuNumber', NULL, '', NULL, NULL, '0', '', '', '', '', '', '', '', NULL, NULL ); 

--
-- zzzzsys_event
--

INSERT INTO zzzzsys_event (zzzzsys_event_id, sev_zzzzsys_object_id, sev_event, sev_javascript, sev_json) 
VALUES ( '6455ef139e85d3f', '6455ef139de4cb6', 'onchange', 'controle(this);\n', NULL );

Re: Subform not saved on a new registration

Posted: Sat May 06, 2023 8:56 am
by kev1n
Is it also possible to create a dump of the db schema (using phpMyAdmin etc.)?

Re: Subform not saved on a new registration

Posted: Sat May 06, 2023 9:24 am
by johan
Kev1n
This are my tables used in this form.
Johan

Re: Subform not saved on a new registration

Posted: Sat May 06, 2023 9:42 am
by kev1n
One table seems to be missing:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nubuilder.titularis' doesn't exist

Re: Subform not saved on a new registration

Posted: Sat May 06, 2023 9:51 am
by kev1n
Problem found: The primary key must be a varchar(25) and not AUTO_INCREMENT in a subform.

Change bron_id to VARCHAR(25)

Code: Select all

ALTER TABLE `bron` CHANGE `bron_id` `bron_id` VARCHAR(25) NOT NULL;
All times are UTC+02:00
Page 1 of 2

Powered by phpBB® Forum Software © phpBB Limited