nuBuilder Forum

Posted: **Fri Dec 15, 2017 6:27 am**

HI,

I followed the installation instructions as described in this wiki article: http://wiki.nubuilder.net/nubuilderfort ... .php/Setup

The step "Import nubuilder4.sql into the new database." resulted in a query error:

Code: Select all

#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation

The statement causing the issue:

Code: Select all

--
-- Structure for view `zzzzsys_report_data`
--
DROP TABLE IF EXISTS `zzzzsys_report_data`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `zzzzsys_report_data

For those experiencing the same issue as myself, remove the extra clause "ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER" in the query and run
just this statement again. I'm not sure about possible issues when skipping the ALGORITHM clause and if this clause is required, though.

The query then looks like this:

Code: Select all

CREATE VIEW `zzzzsys_run_list`  AS  select [...]

toms

Posted: **Fri Dec 15, 2017 6:03 pm**

Code: Select all

 
-- Structure for view `zzzzsys_report_data`
--
DROP TABLE IF EXISTS `zzzzsys_report_data`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `zzzzsys_report_data

Try to change "root" with your user in database and make sure you have all the privileges for it.
You can see the current user of the database in phpmyadmin.

Posted: **Fri Dec 15, 2017 6:14 pm**

Code: Select all

 
-- Structure for view `zzzzsys_report_data`
--
DROP TABLE IF EXISTS `zzzzsys_report_data`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `zzzzsys_report_data

Try to change "root" with your user in database (nubuilder4.sql) and upload to server (import)... make sure you have all the privileges for it.
You can see the current user of the database in phpmyadmin.

Posted: **Fri Dec 15, 2017 10:24 pm**

After last update I've noticed that when creating button for launching Browse Form, the Run list with Forms was empty.
In Debugger there were errors with missing 'zzzzsys_run_list' table.

Running full SQL code from default nuBuilder database login gave me the same error.
Running full SQL code from root database login was a success.

Posted: **Sat Dec 16, 2017 8:58 am**

pierrot wrote: the Run list with Forms was empty

You are right, I noticed that too. That's why I made a fresh install because at that time I had no idea what caused it. Having no root access in my DB, it would be best to have this "ALGORITHM=UNDEFINED.." removed.

Posted: **Wed Jan 03, 2018 5:28 pm**

nuBuilder Forum

Installation hint / query error

Installation hint / query error

Re: Installation hint / query error

Re: Installation hint / query error

Re: Installation hint / query error

Re: Installation hint / query error

Re: Installation hint / query error