Error when importing nubuilder4.sql
Posted: Fri Dec 22, 2017 12:38 pm
Hello,
When I import the file nubuilder4.sql to a new mysql database in my cpanel domain (my login is not root on there, but a normal cpanel user instead) i see the following error:
I can run nuBuilder even after this error but I don't know it it will affect something later.
When I import the file nubuilder4.sql to a new mysql database in my cpanel domain (my login is not root on there, but a normal cpanel user instead) i see the following error:
Code: Select all
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` 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` <> '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` ;Code: Select all
#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation