Welcome to the nuBuilder forums!

Please register and login to view forums and other content only available to registered users.

Installation hint / query error

Questions related to installing, updating, setting up and configuring
Locked
toms
Posts: 785
Joined: Sun Oct 14, 2018 11:25 am

Installation hint / query error

Unread post by 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
Posts: 8
Joined: Fri Feb 01, 2013 10:56 am

Re: Installation hint / query error

Unread post by 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.
Attachments
db.jpg
db.jpg (189.91 KiB) Viewed 3404 times
danpadro
Posts: 8
Joined: Fri Feb 01, 2013 10:56 am

Re: Installation hint / query error

Unread post by 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
Posts: 15
Joined: Thu Dec 14, 2017 11:51 am

Re: Installation hint / query error

Unread post by 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
Posts: 785
Joined: Sun Oct 14, 2018 11:25 am

Re: Installation hint / query error

Unread post by toms »

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.
admin
Site Admin
Posts: 2778
Joined: Mon Jun 15, 2009 2:23 am
nuBuilder Version: 4.5

Re: Installation hint / query error

Unread post by admin »

.
Locked