Fast forms not working after update

Questions related to using nuBuilder Forte.

Fast forms not working after update

Postby tovidiu » Sat Mar 03, 2018 8:18 pm

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
tovidiu
 
Posts: 16
Joined: Sun Jan 07, 2018 2:15 am

Re: Fast forms not working after update

Postby toms » Sat Mar 03, 2018 8:20 pm

Hi,

Check out this recent thread:

viewtopic.php?f=19&t=9366
toms
toms
 
Posts: 411
Joined: Wed Nov 08, 2017 8:57 pm

Re: Fast forms not working after update

Postby tovidiu » Sat Mar 03, 2018 8:35 pm

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
tovidiu
 
Posts: 16
Joined: Sun Jan 07, 2018 2:15 am

Re: Fast forms not working after update

Postby toms » Sat Mar 03, 2018 8:55 pm

Does the view zzzzsys_run_list exist as well?
toms
toms
 
Posts: 411
Joined: Wed Nov 08, 2017 8:57 pm

Re: Fast forms not working after update

Postby tovidiu » Sat Mar 03, 2018 9:00 pm

Yes, zzzzsys_report_data and zzzzsys_run_list exists.
tovidiu
 
Posts: 16
Joined: Sun Jan 07, 2018 2:15 am

Re: Fast forms not working after update

Postby admin » Sun Mar 04, 2018 8:10 am

tovidiu,

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

Steven
admin
Site Admin
 
Posts: 2483
Joined: Mon Jun 15, 2009 9:53 am

Re: Fast forms not working after update

Postby toms » Sun Mar 04, 2018 3:26 pm

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'
toms
toms
 
Posts: 411
Joined: Wed Nov 08, 2017 8:57 pm

Re: Fast forms not working after update

Postby admin » Sun Mar 18, 2018 2:20 am

.
admin
Site Admin
 
Posts: 2483
Joined: Mon Jun 15, 2009 9:53 am


Return to General