Page 1 of 1
Nothing in "PHP or Select or Table"
Posted: Sun Nov 20, 2022 6:22 pm
by nathan
I have run into a little problem,
When I try to create a report, I cannot select a table.
The “PHP or Select or Table” window appears but is blank
I have tried to add …the SQL builder opens I create and save ..but still nothing in the “PHP or Select or Table”
Re: Nothing in "PHP or Select or Table"
Posted: Mon Nov 21, 2022 5:51 am
by kev1n
Does the VIEW zzzzsys_report_data exist? If not, please create it by running this SQL:
Code: Select all
CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER 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` is null or `zzzzsys_select`.`sse_system` = '' union select concat('TABLE:',`zzzzsys_object_list`.`zzzzsys_object_list_id`) AS `id`,'nuTABLE' AS `code`,`zzzzsys_object_list`.`zzzzsys_object_list_id` AS `description` from `zzzzsys_object_list` ;
Re: Nothing in "PHP or Select or Table"
Posted: Wed Nov 23, 2022 3:58 pm
by nathan
the view did exist...so I deleted it and ran SQL and now I can see the sqls
Thank you !!!!