Page 1 of 1
Issue with Percona server
Posted: Tue Apr 25, 2023 8:20 am
by luca.ongaro
Hi,
I moved my nuBuilder application from my test server, running MySQL 8.0, to a production server running Percona 5.7.
Everything seems ok, but I cannot modify reports. This is a screenshot from MySQL:
- MySQL.png (21.05 KiB) Viewed 3392 times
while this is from Percona:
- Percona.png (19.02 KiB) Viewed 3392 times
The "Table" field is blank, anything I type there is erased, the browse list of available tables pops up empty.
Is this a known issue? Any hint?
Thank you
Re: Issue with Percona server
Posted: Tue Apr 25, 2023 8:58 am
by kev1n
Hi,
Run this SQL and try again:
Code: Select all
DROP TABLE IF EXISTS `zzzzsys_report_data`;
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: Issue with Percona server
Posted: Tue Apr 25, 2023 10:54 am
by luca.ongaro
It modified DROP TABLE into DROP VIEW, and it works.
Now, you should explain me why...
Re: Issue with Percona server
Posted: Tue Apr 25, 2023 3:50 pm
by kev1n
That view could not be created automatically. There might be hints in the server error logs.