Nothing in "PHP or Select or Table"

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

[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`  ;

[nathan]

the view did exist...so I deleted it and ran SQL and now I can see the sqls
Thank you !!!!