Setup Screen Problem

[archerdata]

I finally got the planets to line up and succeeded in getting nuBuilder4 login page and logged in. But ... the Setup page is wonky.

If anyone has experienced this, I would appreciate your insight.

[kev1n]

Hi,

That looks really, really strange. Could you upload a dump of your db here?

[archerdata]

https://archerdata.com/images/scsynew_nubuilder4.sql

[kev1n]

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!

[archerdata]

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

[kev1n]

Just log in after modifying nuconfig.php. nuBuilder will import the SQL file automatically when you first log in.

[archerdata]

OK, I'll drop the tables ... and then login.

[archerdata]

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.

[kev1n]

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.

[admin]

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

Thanks.


Steven