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:
while this is from Percona:
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
Welcome to the nuBuilder forums!
Please register and login to view forums and other content only available to registered users.
Please register and login to view forums and other content only available to registered users.
Issue with Percona server
-
- Posts: 64
- Joined: Sun Jan 22, 2023 7:03 pm
- nuBuilder Version: 4.5
-
- nuBuilder Team
- Posts: 3909
- Joined: Sun Oct 14, 2018 6:43 pm
- nuBuilder Version: 4.5
- Has thanked: 2 times
- Been thanked: 9 times
- Contact:
Re: Issue with Percona server
Hi,
Run this SQL and try again:
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` ;
-
- Posts: 64
- Joined: Sun Jan 22, 2023 7:03 pm
- nuBuilder Version: 4.5
Re: Issue with Percona server
It modified DROP TABLE into DROP VIEW, and it works.
Now, you should explain me why...
Now, you should explain me why...
-
- nuBuilder Team
- Posts: 3909
- Joined: Sun Oct 14, 2018 6:43 pm
- nuBuilder Version: 4.5
- Has thanked: 2 times
- Been thanked: 9 times
- Contact:
Re: Issue with Percona server
That view could not be created automatically. There might be hints in the server error logs.