Error when importing nubuilder4.sql

[Celson]

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:

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

I can run nuBuilder even after this error but I don't know it it will affect something later.

[toms]

Hi, check out this thread. I have the same issue.
http://forums.nubuilder.cloud/viewtopic.php?f=19&t=9177

[Celson]

Thank you!
I'll modify the sql file in order to use my database user instead root and see if it works.

[admin]

.