Error when importing nubuilder4.sql

Error when importing nubuilder4.sql

Postby Celson » Fri Dec 22, 2017 9:08 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:

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.
Celson
 
Posts: 18
Joined: Wed Jan 27, 2016 9:05 pm

Re: Error when importing nubuilder4.sql

Postby toms » Fri Dec 22, 2017 9:55 pm

Hi, check out this thread. I have the same issue.
viewtopic.php?f=19&t=9177
toms
 
Posts: 143
Joined: Wed Nov 08, 2017 8:57 pm

Re: Error when importing nubuilder4.sql

Postby Celson » Sat Dec 23, 2017 1:18 am

Thank you!
I'll modify the sql file in order to use my database user instead root and see if it works.
Celson
 
Posts: 18
Joined: Wed Jan 27, 2016 9:05 pm

Re: Error when importing nubuilder4.sql

Postby admin » Mon Jan 08, 2018 5:38 am

.
admin
Site Admin
 
Posts: 2061
Joined: Mon Jun 15, 2009 9:53 am


Return to General