Installation hint / query error

[toms]

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

[danpadro]

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.

[danpadro]

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.

[pierrot]

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.

[toms]

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.

[admin]

.