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
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 [...]