nuBuilder Forum


https://forums.nubuilder.cloud/

Question about cloning forms

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

Page 2 of 3

Re: Question about cloning forms

Posted: Fri Mar 15, 2024 11:58 am
by kknm
If you just use a cloner to clone the form.
The original form is -fro.
The cloner shows that it created the form fro_clone_1
All sections are present, but the fro_clone_1 form does not appear in the forms.
*************************************************
-- nuBuilder cloner SQL Dump
-- Version 1.21
-- Generation Time: March 15, 2024 01:44:11 PM
-- Form Description: ДСЗ 1 - Отсев
-- Form Code: fro
-- Form Table: frots
-- Form Type: browseedit
-- zzzzsys_form: fro_clone_1
*************************************
sections:
-- zzzzsys_tab
-- zzzzsys_select
-- zzzzsys_select_clause
-- zzzzsys_browse
-- zzzzsys_php
-- zzzzsys_object
*********************************************
All sections are filled - INSERT INTO ...
I can't take a screenshot because... it's bigger than the screen.

Re: Question about cloning forms

Posted: Fri Mar 15, 2024 12:32 pm
by kev1n
kev1n wrote: ↑Fri Mar 15, 2024 11:08 am zzzzsys_object doesn't contain the form code, just the form id.
Example: nunotes_clone_1 appears just one, it's just in the zzzzsys_form table, and not in the objects table.
What changes it the form id (here 65f43103340166b), which can also be found in zzzzsys_object.

In your case, if you want to change the table name, just replace it everywhere where it occurs before executing the query:

Code: Select all

-- nuBuilder cloner SQL Dump
-- Version 1.21
-- Generation Time: March 15, 2024 12:29:07 PM

-- Form Description: Notes
-- Form Code: nunotes
-- Form Table: zzzzsys_note
-- Form Type: browseedit


--
-- zzzzsys_form: nunotes_clone_1
--

INSERT INTO zzzzsys_form (zzzzsys_form_id, sfo_type, sfo_code, sfo_description, sfo_group, 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 ( '65f43103340166b', 'browseedit', 'nunotes_clone_1', 'Notes', NULL, '#not_title#|New', 'zzzzsys_note', 'zzzzsys_note_id', '', '0', '0', '0', NULL, 'SELECT\n    zzzzsys_note.*, noc_name\nFROM\n    zzzzsys_note\nLEFT JOIN zzzzsys_note_category ON not_zzzzsys_note_category_id = zzzzsys_note_category.zzzzsys_note_category_id\nORDER BY\n    not_title ASC', NULL, NULL, 'nuHide(\'label_not_title\');\nnuSetPlaceholder(\'not_title\', nuTranslate(\'Title\'));\n\nnuHide(\'label_not_zzzzsys_note_category_id\');\nnuSetPlaceholder(\'not_zzzzsys_note_category_idcode\', nuTranslate(\'Category\'));\n\nhandleKeys();\n\nfunction handleKeys() {\n\n    $(\'#not_title\').on(\'keydown\', function(evt) {\n      if (evt.key === \'Enter\') {\n        evt.preventDefault();        \n\n        $(\'.ql-editor\').trigger(\"focus\");\n\n        let tinyB = tinyMCE.get(\'not_content_container\').getBody();\n        if (tinyB !== null) tinyB.trigger(\"focus\");\n\n      }\n    });\n\n}\n\n', '', '', 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 ( '65f43103344ed94', '65f43103340166b', 'Notes', '10', '', 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 ( '65f431033484f7c', '65f43103340166b', 'Notes', 'not_title', 'l', '', '20', '720', 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 ( '65f4310334867f9', '65f43103340166b', 'Category', 'noc_name', 'l', '', '10', '150', 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 ( '65f43103348714d', '65f43103340166b', 'Updated on', 'not_updated_on', 'l', '', '30', '145', 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_access_condition, 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 ( '65f4310334c49a8', '65f43103340166b', 'zzzzsys_note', 'input', 'not_title', 'Title', '65f43103344ed94', '10', '26', '26', '601', '24', '0', 'left', '3', '0', '', '0', 'CSS', 'color: maroon; padding-left: 8; font-weight: bold; font-size: 15px', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', NULL, 'text', 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_access_condition, 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 ( '65f4310334cacbe', '65f43103340166b', 'zzzzsys_note', 'input', 'not_updated_on', 'Updated on', '65f43103344ed94', '40', '26', '1056', '130', '22', '0', 'left', '0', '1', '', '0', NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', '', '', '', NULL, '', '', NULL, '', '', '', '', '', '', '', '0', '', 'text', 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_access_condition, 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 ( '65f4310334cdc68', '65f43103340166b', 'zzzzsys_note', 'editor', 'not_content', 'Content', '65f43103344ed94', '30', '65', '26', '1167', '460', '1', 'left', '0', '0', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', NULL, '', '', NULL, NULL, NULL, '0', '', 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_access_condition, 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 ( '65f4310334d0e20', '65f43103340166b', 'zzzzsys_note', 'lookup', 'not_zzzzsys_note_category_id', 'Category', '65f43103344ed94', '20', '26', '648', '214', '24', '0', 'left', '0', '0', NULL, '0', NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', 'noc_name', 'noc_name', '0', NULL, 'nunotescategroy', '', NULL, 'zzzzsys_note_category', '', '', '', '', '', '', '0', '', '', NULL, '', NULL, NULL, '0', '', '', '', '', '', '', '', NULL, NULL );

Re: Question about cloning forms

Posted: Fri Mar 15, 2024 12:40 pm
by kknm
The fact of the matter is that a new form does not appear in zzzzsys_form when using the cloner.
PHP7.7.33
Server version: 5.7.42-0ubuntu0.18.04.1 - (Ubuntu)
*******************************

Code: Select all

-- nuBuilder cloner SQL Dump
-- Version 1.21
-- Generation Time: March 15, 2024 02:37:22 PM

-- Form Description: ДСЗ 1 - Отсев
-- Form Code: fro
-- Form Table: frots
-- Form Type: browseedit


--
-- zzzzsys_form: fro_clone_1
--

INSERT INTO zzzzsys_form (zzzzsys_form_id, sfo_type, sfo_code, sfo_description, sfo_group, 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 ( '65f432f2e016571', 'browseedit', 'fro_clone_1', 'ДСЗ 1 - Отсев', NULL, NULL, 'frots', 'frots_id', NULL, NULL, '30', '0', NULL, 'SELECT\n    frots.*,\n    tabel.*\n\nFROM\n    frots\n        JOIN tabel ON frots.fro_data = tabel.tabel_id\nORDER BY\n    frots_id DESC\n\n', 'if (nuFormType() == \'browse\') {\n    //increaseBrowseTitleHeight();\n    $(\'[data-nu-column=\"3\"]\').each(function(index) {\n        var color = Number($(this).html()) > 2 ? \'red\': \'black\';\n        $(this).css(\"color\", color);\n    });\n    $(\'[data-nu-column=\"4\"]\').each(function(index) {\n        var color = Number($(this).html()) > 12 ? \'red\': \'black\';\n        $(this).css(\"color\", color);\n    });\n}\n\nnuStopBrowserResize();', 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 ( '65f432f2e04372b', '65f432f2e016571', 'Main', '10', NULL, NULL, NULL ); 

--
-- zzzzsys_select
--

INSERT INTO zzzzsys_select (zzzzsys_select_id, sse_code, sse_description, sse_json, sse_sql, sse_edit, sse_system) 
VALUES ( '65f432f2e016571_BR', NULL, NULL, '{\"tables\":[{\"id\":\"boxc15885415473941001\",\"position\":{\"top\":25.000001907348633,\"left\":21.99652862548828},\"tablename\":\"frots\",\"alias\":\"\",\"checkall\":true,\"checkboxes\":[false,false,false,false,false,false,false]},{\"id\":\"boxc15885415526271002\",\"position\":{\"top\":22.986112594604492,\"left\":235.00001525878906},\"tablename\":\"tabel\",\"alias\":\"\",\"checkall\":true,\"checkboxes\":[false,false,false,false,false]}],\"joins\":{\"field_1_boxc15885415473941001--field_0_boxc15885415526271002\":\"\"}}', 'SELECT\n    frots.*,\n    tabel.*\n\nFROM\n    frots\n        JOIN tabel ON frots.fro_data = tabel.tabel_id\nORDER BY\n    frots_id DESC\n\n', NULL, '1' ); 

--
-- zzzzsys_select_clause
--

INSERT INTO zzzzsys_select_clause (zzzzsys_select_clause_id, ssc_zzzzsys_select_id, ssc_type, ssc_field, ssc_clause, ssc_sort, ssc_order, ssc_json) 
VALUES ( '65f432f2e075820', '65f432f2e016571_BR', '3', 'frots_id', NULL, 'DESC', 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 ( '65f432f2e091d56', '65f432f2e016571', 'Дата', 'DATE_FORMAT(tab_data, \"%d.%m.%Y %H:%i\")', 'l', '', '10', '120', 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 ( '65f432f2e094182', '65f432f2e016571', 'Время', 'fro_vrem', 'l', '', '20', '50', 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 ( '65f432f2e095179', '65f432f2e016571', 'Питатели', 'fro_pit', 'l', '', '30', '70', 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 ( '65f432f2e096f75', '65f432f2e016571', '10<br>(2)', 'fro_10', 'l', '', '40', '30', 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 ( '65f432f2e097e7c', '65f432f2e016571', '5<br>(12)', 'fro_5', 'l', '', '50', '30', 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 ( '65f432f2e098c16', '65f432f2e016571', 'Соотв', 'REPLACE(REPLACE(fro_soot,1,\'✔\'),0,\'\')', 'l', '', '60', '40', 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 ( '65f432f2e099ae8', '65f432f2e016571', 'd', 'tab_data', 'l', NULL, '70', '0', 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 ( '65f432f2e016571_BB', '65f432f2e016571_BB', 'System PHP', 'nubuilder', NULL, NULL, NULL, '1', '0', NULL, NULL ); 
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 ( '65f432f2e016571_BE', '65f432f2e016571_BE', '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_access_condition, 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 ( '65f432f2e0eec8c', '65f432f2e016571', 'frots', 'lookup', 'fro_data', 'Дата начала смены', '65f432f2e04372b', '10', '10', '150', '180', '20', '1', 'left', '0', '0', NULL, NULL, NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', 'tab_data', 'tab_data', '0', '', '5e8a26a53ce5f49', '', '', 'tabel', '', '', '', '', '', '', '0', 'D|dd-mm-yy', 'datetime-local', 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_access_condition, 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 ( '65f432f2e0f1d64', '65f432f2e016571', 'frots', 'input', 'fro_vrem', 'Время', '65f432f2e04372b', '20', '40', '235', '95', '20', '1', 'left', '0', '0', NULL, NULL, NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 'D|dd-mm-yy', 'time', 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_access_condition, 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 ( '65f432f2e0fcdab', '65f432f2e016571', 'frots', 'input', 'fro_pit', 'Питатели', '65f432f2e04372b', '30', '70', '210', '120', '20', '1', 'left', '0', '0', NULL, NULL, NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '', 'text', 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_access_condition, 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 ( '65f432f2e0fea99', '65f432f2e016571', 'frots', 'input', 'fro_10', '10 (2)', '65f432f2e04372b', '40', '100', '270', '60', '20', '1', 'right', '0', '0', NULL, NULL, NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 'N|1000.00', 'number', 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_access_condition, 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 ( '65f432f2e1010fd', '65f432f2e016571', 'frots', 'input', 'fro_5', '5 (12)', '65f432f2e04372b', '50', '130', '270', '60', '20', '1', 'right', '0', '0', NULL, NULL, NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 'N|1000.00', 'number', 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_access_condition, 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 ( '65f432f2e103730', '65f432f2e016571', 'frots', 'input', 'fro_soot', 'Соотв', '65f432f2e04372b', '60', '160', '270', '60', '20', '1', 'right', '0', '0', NULL, NULL, NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 'N|1000.00', 'checkbox', NULL, '', NULL, NULL, '0', '', '', '', '', '', '', '', NULL, NULL );

Re: Question about cloning forms

Posted: Fri Mar 15, 2024 1:07 pm
by kev1n
Did you run the SQL in e.g. phpMyAdmin? Then all rows will be inserted into the DB tables if there is no error.

Re: Question about cloning forms

Posted: Fri Mar 15, 2024 1:14 pm
by kknm
It was in phpMyAdmin that I looked for records and took a screenshot of the tables in zzzzsys_form and zzzzsys_object

Re: Question about cloning forms

Posted: Fri Mar 15, 2024 1:42 pm
by kev1n
kev1n wrote: ↑Fri Mar 15, 2024 1:07 pm Did you run the SQL in e.g. phpMyAdmin? Then all rows will be inserted into the DB tables if there is no error.
Did you successfully execute the query? And then, can the new form be found in zzzzsys_form ?

Re: Question about cloning forms

Posted: Fri Mar 15, 2024 2:18 pm
by kknm
I showed a screenshot of the fully completed cloning procedure above. The new form does not appear in zzzzsys_form.

If you simply clone the form from the original form, then it appears, but without the Edit fields in zzzzsys_form .
If you then clone with a cloner with the rewrite checkbox in a new form, then after completing the procedure it writes only to the ---zzzzsys_object - REPLACE INTO... section, but the EDIT fields do not appear on the new form.

Re: Question about cloning forms

Posted: Fri Mar 15, 2024 4:43 pm
by kev1n
I run your query in phpMyAdmin and saw your form right away under forms.
kknm wrote: ↑Fri Mar 15, 2024 12:40 pm The fact of the matter is that a new form does not appear in zzzzsys_form when using the cloner.
PHP7.7.33
Server version: 5.7.42-0ubuntu0.18.04.1 - (Ubuntu)
*******************************

Code: Select all

-- nuBuilder cloner SQL Dump
-- Version 1.21
-- Generation Time: March 15, 2024 02:37:22 PM

-- Form Description: ДСЗ 1 - Отсев
-- Form Code: fro
-- Form Table: frots
-- Form Type: browseedit


--
-- zzzzsys_form: fro_clone_1
--

INSERT INTO zzzzsys_form (zzzzsys_form_id, sfo_type, sfo_code, sfo_description, sfo_group, 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 ( '65f432f2e016571', 'browseedit', 'fro_clone_1', 'ДСЗ 1 - Отсев', NULL, NULL, 'frots', 'frots_id', NULL, NULL, '30', '0', NULL, 'SELECT\n    frots.*,\n    tabel.*\n\nFROM\n    frots\n        JOIN tabel ON frots.fro_data = tabel.tabel_id\nORDER BY\n    frots_id DESC\n\n', 'if (nuFormType() == \'browse\') {\n    //increaseBrowseTitleHeight();\n    $(\'[data-nu-column=\"3\"]\').each(function(index) {\n        var color = Number($(this).html()) > 2 ? \'red\': \'black\';\n        $(this).css(\"color\", color);\n    });\n    $(\'[data-nu-column=\"4\"]\').each(function(index) {\n        var color = Number($(this).html()) > 12 ? \'red\': \'black\';\n        $(this).css(\"color\", color);\n    });\n}\n\nnuStopBrowserResize();', 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 ( '65f432f2e04372b', '65f432f2e016571', 'Main', '10', NULL, NULL, NULL ); 

--
-- zzzzsys_select
--

INSERT INTO zzzzsys_select (zzzzsys_select_id, sse_code, sse_description, sse_json, sse_sql, sse_edit, sse_system) 
VALUES ( '65f432f2e016571_BR', NULL, NULL, '{\"tables\":[{\"id\":\"boxc15885415473941001\",\"position\":{\"top\":25.000001907348633,\"left\":21.99652862548828},\"tablename\":\"frots\",\"alias\":\"\",\"checkall\":true,\"checkboxes\":[false,false,false,false,false,false,false]},{\"id\":\"boxc15885415526271002\",\"position\":{\"top\":22.986112594604492,\"left\":235.00001525878906},\"tablename\":\"tabel\",\"alias\":\"\",\"checkall\":true,\"checkboxes\":[false,false,false,false,false]}],\"joins\":{\"field_1_boxc15885415473941001--field_0_boxc15885415526271002\":\"\"}}', 'SELECT\n    frots.*,\n    tabel.*\n\nFROM\n    frots\n        JOIN tabel ON frots.fro_data = tabel.tabel_id\nORDER BY\n    frots_id DESC\n\n', NULL, '1' ); 

--
-- zzzzsys_select_clause
--

INSERT INTO zzzzsys_select_clause (zzzzsys_select_clause_id, ssc_zzzzsys_select_id, ssc_type, ssc_field, ssc_clause, ssc_sort, ssc_order, ssc_json) 
VALUES ( '65f432f2e075820', '65f432f2e016571_BR', '3', 'frots_id', NULL, 'DESC', 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 ( '65f432f2e091d56', '65f432f2e016571', 'Дата', 'DATE_FORMAT(tab_data, \"%d.%m.%Y %H:%i\")', 'l', '', '10', '120', 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 ( '65f432f2e094182', '65f432f2e016571', 'Время', 'fro_vrem', 'l', '', '20', '50', 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 ( '65f432f2e095179', '65f432f2e016571', 'Питатели', 'fro_pit', 'l', '', '30', '70', 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 ( '65f432f2e096f75', '65f432f2e016571', '10<br>(2)', 'fro_10', 'l', '', '40', '30', 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 ( '65f432f2e097e7c', '65f432f2e016571', '5<br>(12)', 'fro_5', 'l', '', '50', '30', 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 ( '65f432f2e098c16', '65f432f2e016571', 'Соотв', 'REPLACE(REPLACE(fro_soot,1,\'✔\'),0,\'\')', 'l', '', '60', '40', 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 ( '65f432f2e099ae8', '65f432f2e016571', 'd', 'tab_data', 'l', NULL, '70', '0', 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 ( '65f432f2e016571_BB', '65f432f2e016571_BB', 'System PHP', 'nubuilder', NULL, NULL, NULL, '1', '0', NULL, NULL ); 
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 ( '65f432f2e016571_BE', '65f432f2e016571_BE', '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_access_condition, 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 ( '65f432f2e0eec8c', '65f432f2e016571', 'frots', 'lookup', 'fro_data', 'Дата начала смены', '65f432f2e04372b', '10', '10', '150', '180', '20', '1', 'left', '0', '0', NULL, NULL, NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', 'tab_data', 'tab_data', '0', '', '5e8a26a53ce5f49', '', '', 'tabel', '', '', '', '', '', '', '0', 'D|dd-mm-yy', 'datetime-local', 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_access_condition, 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 ( '65f432f2e0f1d64', '65f432f2e016571', 'frots', 'input', 'fro_vrem', 'Время', '65f432f2e04372b', '20', '40', '235', '95', '20', '1', 'left', '0', '0', NULL, NULL, NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 'D|dd-mm-yy', 'time', 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_access_condition, 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 ( '65f432f2e0fcdab', '65f432f2e016571', 'frots', 'input', 'fro_pit', 'Питатели', '65f432f2e04372b', '30', '70', '210', '120', '20', '1', 'left', '0', '0', NULL, NULL, NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '', 'text', 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_access_condition, 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 ( '65f432f2e0fea99', '65f432f2e016571', 'frots', 'input', 'fro_10', '10 (2)', '65f432f2e04372b', '40', '100', '270', '60', '20', '1', 'right', '0', '0', NULL, NULL, NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 'N|1000.00', 'number', 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_access_condition, 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 ( '65f432f2e1010fd', '65f432f2e016571', 'frots', 'input', 'fro_5', '5 (12)', '65f432f2e04372b', '50', '130', '270', '60', '20', '1', 'right', '0', '0', NULL, NULL, NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 'N|1000.00', 'number', 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_access_condition, 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 ( '65f432f2e103730', '65f432f2e016571', 'frots', 'input', 'fro_soot', 'Соотв', '65f432f2e04372b', '60', '160', '270', '60', '20', '1', 'right', '0', '0', NULL, NULL, NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 'N|1000.00', 'checkbox', NULL, '', NULL, NULL, '0', '', '', '', '', '', '', '', NULL, NULL );

Re: Question about cloning forms

Posted: Fri Mar 15, 2024 7:15 pm
by kknm
What does -'I run your query in phpMyAdmin' mean?

I can't paste the request text from the cloner into phpMyAdmin, it's probably too big

Re: Question about cloning forms

Posted: Fri Mar 15, 2024 7:49 pm
by kknm
I understand - you meant the request for zzzzsys_form. It is executed in my PhpMyAdmin and the form appears in Forms.

I can't even paste the request text from the cloner into phpMyAdmin for zzzzsys_object - it's probably too big
All times are UTC+02:00
Page 2 of 3

Powered by phpBB® Forum Software © phpBB Limited