Installation hint / query error

Questions related to using nuBuilder Forte.

Installation hint / query error

Postby toms » Fri Dec 15, 2017 2:57 pm

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
toms
toms
 
Posts: 405
Joined: Wed Nov 08, 2017 8:57 pm

Re: Installation hint / query error

Postby danpadro » Sat Dec 16, 2017 2:33 am

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.
Attachments
db.jpg
db.jpg (189.91 KiB) Viewed 289 times
danpadro
 
Posts: 8
Joined: Fri Feb 01, 2013 7:26 pm

Re: Installation hint / query error

Postby danpadro » Sat Dec 16, 2017 2:44 am

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.
danpadro
 
Posts: 8
Joined: Fri Feb 01, 2013 7:26 pm

Re: Installation hint / query error

Postby pierrot » Sat Dec 16, 2017 6:54 am

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.
pierrot
 
Posts: 15
Joined: Thu Dec 14, 2017 8:21 pm

Re: Installation hint / query error

Postby toms » Sat Dec 16, 2017 5:28 pm

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.
toms
toms
 
Posts: 405
Joined: Wed Nov 08, 2017 8:57 pm

Re: Installation hint / query error

Postby admin » Thu Jan 04, 2018 1:58 am

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


Return to General