Browse screen and pagination

[BDemeuse]

Cloner for only my own form BRECTT_clone_1 ?
What about my prod data ?

[kev1n]

The cloner just clones the form + object but not the tables. So after cloning, just use the newly created form.

[BDemeuse]

I have got the following errors

14:08:50 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) VALUES ( '622f3bfcc64685f', 'browseedit', 'BRECTT_clone_1_clone_1', 'Liste Edit Contacts', NULL, 'tr_contact', 'ctt_id', NULL, NULL, '20', '1', NULL, 'SELECT * FROM tr_contact\norder by ctt_nom, ctt_prenom', 'if (! nuIsNewRecord()) {\n nuDisable(\'ctt_nom\');\nnuDisable(\'ctt_prenom\');\n}\n', NULL, NULL ) Error Code: 1054. Unknown column 'sfo_breadcrumb_title' in 'field list' 0.00062 sec

14:08:50 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) VALUES ( '622f3bfcc64685f', 'browseedit', 'BRECTT_clone_1_clone_1', 'Liste Edit Contacts', NULL, 'tr_contact', 'ctt_id', NULL, NULL, '20', '1', NULL, 'SELECT * FROM tr_contact\norder by ctt_nom, ctt_prenom', 'if (! nuIsNewRecord()) {\n nuDisable(\'ctt_nom\');\nnuDisable(\'ctt_prenom\');\n}\n', NULL, NULL ) Error Code: 1054. Unknown column 'sfo_breadcrumb_title' in 'field list' 0.00062 sec

[kev1n]

That means your destination db is not up-to-date and one (or more columns) are missing there.
Remove those from the sql insert statements.

The first insert would then become:

Code: Select all

INSERT INTO zzzzsys_form (zzzzsys_form_id, sfo_type, sfo_code, sfo_description, 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) VALUES ( '622f3bfcc64685f', 'browseedit', 'BRECTT_clone_1_clone_1', 'Liste Edit Contacts', 'tr_contact', 'ctt_id', NULL, NULL, '20', '1', NULL, 'SELECT * FROM tr_contact\norder by ctt_nom, ctt_prenom', 'if (! nuIsNewRecord()) {\n nuDisable(\'ctt_nom\');\nnuDisable(\'ctt_prenom\');\n}\n', NULL, NULL )

You'll have to remove other columns if they do not exist in your destination db as well.

[BDemeuse]

I have applied you new insert into zzzz_sys_form and again an error

14:52:52 INSERT INTO zzzzsys_form (zzzzsys_form_id, sfo_type, sfo_code, sfo_description, 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) VALUES ( '622f3bfcc64685f', 'browseedit', 'BRECTT_clone_1_clone_1', 'Liste Edit Contacts', 'tr_contact', 'ctt_id', NULL, NULL, '20', '1', NULL, 'SELECT * FROM tr_contact\norder by ctt_nom, ctt_prenom', 'if (! nuIsNewRecord()) {\n nuDisable(\'ctt_nom\');\nnuDisable(\'ctt_prenom\');\n}\n', NULL, NULL ) /* -- -- zzzzsys_tab -- INSERT INTO zzzzsys_tab (zzzzsys_tab_id, syt_zzzzsys_form_id, syt_title, syt_order, syt_help, syt_access) VALUES ( '622f3bfcc6a856f', '622f3bfcc64685f', 'Test', '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) VALUES ( '622f3bfcc6d70bd', '622f3bfcc64685f', 'Nom', 'ctt_nom', 'l', '', '10', '280' ); INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width) VALUES ( '622f3bfcc6d85d2', '622f3bfcc64685f', 'Prenom', 'ctt_prenom', 'l', '', '20', '150' ); INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width) VALUES ( '622f3bfcc6d9491', '622f3bfcc64685f', 'Telephone', 'ctt_telephone', 'l', '', '30', '150' ); INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width) VALUES ( '622f3bfcc6d9e12', '622f3bfcc64685f', 'Email', 'ctt_email', 'l', '', '40', '250' ); INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width) VALUES ( '622f3bfcc6da745', '622f3bfcc64685f', 'Rue', 'ctt_rue', 'l', '', '50', '300' ); INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width) VALUES ( '622f3bfcc6db0c6', '622f3bfcc64685f', 'Code Postal', 'ctt_code_postal', 'l', '', '60', '60' ); INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width) VALUES ( '622f3bfcc6dbac0', '622f3bfcc64685f', 'Ville', 'ctt_ville', 'l', '', '70', '200' ); INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width) VALUES ( '622f3bfcc6dc3e0', '622f3bfcc64685f', 'Code Pays', 'ctt_code_pays', 'l', '', '80', '60' ); INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width) VALUES ( '622f3bfcc6dcce9', '622f3bfcc64685f', 'MaJ Date', 'ctt_sys_changed', 'l', 'D|dd-mm-yy', '90', '80' ); INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width) VALUES ( '622f3bfcc6dd64c', '622f3bfcc64685f', 'MaJ Usr', 'ctt_user_id', 'l', NULL, '100', '80' ); -- -- 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) VALUES ( '622f3bfcc64685f_BB', '622f3bfcc64685f_BB', 'System PHP', 'nubuilder', '//', NULL, NULL, '1', '0', 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) VALUES ( '622f3bfcc64685f_BE', '622f3bfcc64685f_BE', 'System PHP', 'nubuilder', '//$hash = nuHash();\n//nuDebug($hash); \n', NULL, NULL, '1', '0', 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) VALUES ( '622f3bfcc64685f_BS', '622f3bfcc64685f_BS', 'System PHP', 'nubuilder', '// Check en cas d\'ajout d\'un contac... Error Code: 1054. Unknown column 'sfo_browse_autoresize_columns' in 'field list' 0.00038 sec

[kev1n]

You need to remove all unknown columns

[BDemeuse]

Sorry, I have understood only now. I did for the 2 tables zzzzsys_form and zzzz_tab that did not work but unfortunately, the problem is still there: browse stops at the 1st page and "0 records" are mentioned in the bottom of the page.
I did not test the select but now it is hard-coded and priority is lower

[kev1n]

You need to remove all unknown columns

It seems to me that you are not using the latest version. Did you follow the db update instructions?

[BDemeuse]

I think you are right because I have got problems that I did not have before.
I have just downloaded the last version and installed.
What are the update instructions ? I am afraid that it escapes me
However, I was satisfied to see new functions

[kev1n]

Link is in my signature