Fast forms not working after update

[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

[toms]

Hi,

Check out this recent thread:

https://forums.nubuilder.cloud/viewtopic.php?f=19&t=9366

[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

[toms]

Does the view zzzzsys_run_list exist as well?

[tovidiu]

Yes, zzzzsys_report_data and zzzzsys_run_list exists.

[admin]

tovidiu,

You may have to restore from a backup and then try again using toms instructions.

Steven

[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'

[admin]

.