Page 1 of 1
Fast forms not working after update
Posted: Sat Mar 03, 2018 11:48 am
by tovidiu
After updating nuBuilder forte today it seems that fast forms is not working properly.
It say`s that everything is ok and the subform is created with code FF* but in the forms list it`s missing.
Ovidiu
Re: Fast forms not working after update
Posted: Sat Mar 03, 2018 11:50 am
by toms
Re: Fast forms not working after update
Posted: Sat Mar 03, 2018 12:05 pm
by tovidiu
Hi toms,
Thanks for your help but it is not working.
I followed those steps
1) Removed "ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER" from sql before updating . Not working still not showing the new form created.
2) Running the queries
Code: Select all
CREATE VIEW `zzzzsys_report_data` AS select concat('PROCEDURE:',`zzzzsys_php`.`zzzzsys_php_id`) AS `id`,`zzzzsys_php`.`sph_code` AS `code`,`zzzzsys_php`.`sph_description` AS `description` from `zzzzsys_php` where ((`zzzzsys_php`.`sph_system` <> '1') and (locate('#TABLE_ID#',`zzzzsys_php`.`sph_php`) > '0')) union select concat('SQL:',`zzzzsys_select`.`zzzzsys_select_id`) AS `id`,'nuSQL' AS `code`,`zzzzsys_select`.`sse_description` AS `description` from `zzzzsys_select` where (`zzzzsys_select`.`sse_system` <> '1') union select concat('TABLE:',`zzzzsys_table`.`zzzzsys_table_id`) AS `id`,'nuTABLE' AS `code`,`zzzzsys_table`.`zzzzsys_table_id` AS `description` from `zzzzsys_table` ;
CREATE VIEW `zzzzsys_run_list` AS select `zzzzsys_form`.`zzzzsys_form_id` AS `id`,'Form' AS `run`,`zzzzsys_form`.`sfo_code` AS `code`,`zzzzsys_form`.`sfo_description` AS `description` from `zzzzsys_form` union select `zzzzsys_report`.`zzzzsys_report_id` AS `id`,'Report' AS `run`,`zzzzsys_report`.`sre_code` AS `code`,`zzzzsys_report`.`sre_description` AS `description` from `zzzzsys_report` union select `zzzzsys_php`.`zzzzsys_php_id` AS `id`,'Procedure' AS `run`,`zzzzsys_php`.`sph_code` AS `code`,`zzzzsys_php`.`sph_description` AS `description` from `zzzzsys_php` where (`zzzzsys_php`.`sph_system` <> 1) order by `code` ;
gives me error
"#1050 - Table 'zzzzsys_report_data' already exists"
Ovidiu
Re: Fast forms not working after update
Posted: Sat Mar 03, 2018 12:25 pm
by toms
Does the view zzzzsys_run_list exist as well?
Re: Fast forms not working after update
Posted: Sat Mar 03, 2018 12:30 pm
by tovidiu
Yes, zzzzsys_report_data and zzzzsys_run_list exists.
Re: Fast forms not working after update
Posted: Sat Mar 03, 2018 11:40 pm
by admin
tovidiu,
You may have to restore from a backup and then try again using toms instructions.
Steven
Re: Fast forms not working after update
Posted: Sun Mar 04, 2018 6:56 am
by toms
I would first check if the subform has been saved in the database.
Run these two queries to find it out:
Code: Select all
SELECT * FROM `zzzzsys_object` WHERE `sob_all_type` = 'subform'
Code: Select all
SELECT * FROM `zzzzsys_form` WHERE `sfo_type` = 'subform'
Re: Fast forms not working after update
Posted: Sat Mar 17, 2018 5:50 pm
by admin
.