Setup Screen Problem

Questions related to using nuBuilder Forte.

Setup Screen Problem

Unread postby archerdata » Tue Nov 24, 2020 1:13 am

I finally got the planets to line up and succeeded in getting nuBuilder4 login page and logged in. But ... the Setup page is wonky.
Image
If anyone has experienced this, I would appreciate your insight.
____________________
Don Bledsoe
Archer Data
archerdata
 
Posts: 6
Joined: Sat Nov 21, 2020 11:11 pm
Location: Cherryvale, KS, USA

Re: Setup Screen Problem

Unread postby kev1n » Tue Nov 24, 2020 1:17 am

Hi,

That looks really, really strange. Could you upload a dump of your db here?
If you like nuBuilder, please leave a review on SourceForge

nuBuilder Code Library (85)
Installation Guides
Updating nuBuilder

Join Discord to talk about nuBuilder!
kev1n
nuBuilder Team
 
Posts: 1365
Joined: Mon Oct 15, 2018 2:13 am
nuBuilder Version: 4.5

Re: Setup Screen Problem

Unread postby archerdata » Tue Nov 24, 2020 2:06 am

____________________
Don Bledsoe
Archer Data
archerdata
 
Posts: 6
Joined: Sat Nov 21, 2020 11:11 pm
Location: Cherryvale, KS, USA

Re: Setup Screen Problem

Unread postby kev1n » Tue Nov 24, 2020 2:34 am

I would do a fresh installation. It looks like the sql has been imported several times into the db.

And do not import the sql file manually (Although it says so in the Wiki) This can lead to the result that the DB Views are not created!
If you like nuBuilder, please leave a review on SourceForge

nuBuilder Code Library (85)
Installation Guides
Updating nuBuilder

Join Discord to talk about nuBuilder!
kev1n
nuBuilder Team
 
Posts: 1365
Joined: Mon Oct 15, 2018 2:13 am
nuBuilder Version: 4.5

Re: Setup Screen Problem

Unread postby archerdata » Tue Nov 24, 2020 5:17 am

Hi.

What is the preferred import method? The instructions simply say to import it, so I used phpMy Admin, and it reported:

SQL query: Documentation

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `zzzzsys_report_data` AS select concat('PROCEDURE:',`zzzzsys_php`.`zzzzsys_php_id`) AS `id`,`zzzzsys_php`.`sph_code` AS `code`,`zzzzsys_php`.`sph_description` AS `description` from `zzzzsys_php` where `zzzzsys_php`.`sph_system` <> '1' and locate('#TABLE_ID#',`zzzzsys_php`.`sph_php`) > '0' union select concat('SQL:',`zzzzsys_select`.`zzzzsys_select_id`) AS `id`,'nuSQL' AS `code`,`zzzzsys_select`.`sse_description` AS `description` from `zzzzsys_select` where `zzzzsys_select`.`sse_system` is null or `zzzzsys_select`.`sse_system` = '' union select concat('TABLE:',`zzzzsys_table`.`zzzzsys_table_id`) AS `id`,'nuTABLE' AS `code`,`zzzzsys_table`.`zzzzsys_table_id` AS `description` from `zzzzsys_table`
MySQL said: Documentation

#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation
____________________
Don Bledsoe
Archer Data
archerdata
 
Posts: 6
Joined: Sat Nov 21, 2020 11:11 pm
Location: Cherryvale, KS, USA

Re: Setup Screen Problem

Unread postby kev1n » Tue Nov 24, 2020 5:20 am

Just log in after modifying nuconfig.php. nuBuilder will import the SQL file automatically when you first log in.
If you like nuBuilder, please leave a review on SourceForge

nuBuilder Code Library (85)
Installation Guides
Updating nuBuilder

Join Discord to talk about nuBuilder!
kev1n
nuBuilder Team
 
Posts: 1365
Joined: Mon Oct 15, 2018 2:13 am
nuBuilder Version: 4.5

Re: Setup Screen Problem

Unread postby archerdata » Tue Nov 24, 2020 5:30 am

OK, I'll drop the tables ... and then login.
____________________
Don Bledsoe
Archer Data
archerdata
 
Posts: 6
Joined: Sat Nov 21, 2020 11:11 pm
Location: Cherryvale, KS, USA

Re: Setup Screen Problem

Unread postby archerdata » Tue Nov 24, 2020 11:20 am

That worked perfectly!

When you're new to nuBuilder, it would be more reassuring if something appeared on the screen to indicate that the import completed successfully.

Thank you for the guidance.
____________________
Don Bledsoe
Archer Data
archerdata
 
Posts: 6
Joined: Sat Nov 21, 2020 11:11 pm
Location: Cherryvale, KS, USA

Re: Setup Screen Problem

Unread postby kev1n » Tue Nov 24, 2020 12:22 pm

It would probably be best if the wiki was modified (remove the sql import part). The problem has been reported again and again and will occur again as long as it is in the wiki.
If you like nuBuilder, please leave a review on SourceForge

nuBuilder Code Library (85)
Installation Guides
Updating nuBuilder

Join Discord to talk about nuBuilder!
kev1n
nuBuilder Team
 
Posts: 1365
Joined: Mon Oct 15, 2018 2:13 am
nuBuilder Version: 4.5

Re: Setup Screen Problem

Unread postby admin » Wed Nov 25, 2020 4:31 am

kev1n,

I'll try using mysqldump from now on if it works (to stop this ongoing problem).

Here is the result I'm getting...

Can you test it on a database not owned by root please?

To see if it will work.

nubuilder4.zip
(114.81 KiB) Downloaded 21 times


Thanks.


Steven
admin
Site Admin
 
Posts: 3406
Joined: Mon Jun 15, 2009 9:53 am
nuBuilder Version: 4.5

Next

Return to General

Who is online

Users browsing this forum: No registered users and 5 guests