Post-Installation, Home Page not as expected

[Hargey]

Hi Team,

I'm getting started with nuBuilder without a lot of technical experience. My goal is to convert an actively used Excel spreadsheet that tracks sales queries into a CRM system of sorts with a nuBuilder-based frontend to be accessed from a local server by the team.

To develop this, I've installed Bitnami WAMP 7.3.5-0 (Apache 2.4.39, MySQL 8.0.16, PHP 7.3.5) on my local Windows 10 machine and placed the latest version of the nubuilder4 files into C:\Bitnami\wampstack\apache2\htdocs\nubuilder4 , and edited the nuconfig.php to point towards my local MySQL instance and the nubuilder4 schema (side note, I experienced Error 500 while trying to reach http://127.0.0.1/nubuilder4/index.php in my browser until I manually imported the nubuilder4.sql schema into my database).

I was trying to follow along with the User Guide PDF, and was mostly fine until I attempted to log in to nuBuilder with globeadmin. The resulting page looked like my attached screenshot. On this page, you can see that the Builder tab is selected by default. There are no tabs listed along the top of the screen, so I cannot select Setup to continue the tutorial. Selecting Refresh from the right dropdown menu, or clicking the Home breadcrumb from any page, brings me to an empty nuBuilder page with only the Logout option available in the top left.

Additionally, the debug logs show a massive (and growing) number of errors of type:

Code: Select all

[0] : 
===USER==========

globeadmin

===PDO MESSAGE=== 

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'nubuilder4.zzzzsys_tab.zzzzsys_tab_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

===SQL=========== 


    
        SELECT * 
        FROM zzzzsys_tab 
        INNER JOIN zzzzsys_object ON sob_all_zzzzsys_form_id = syt_zzzzsys_form_id
        WHERE syt_zzzzsys_form_id = 'nudebug'
        GROUP BY syt_zzzzsys_form_id, syt_title
        ORDER BY syt_order
    
    

===BACK TRACE====

C:\Bitnami\wampstack\apache2\htdocs\nubuilder4\nuform.php - line 738 (nuRunQuery)

C:\Bitnami\wampstack\apache2\htdocs\nubuilder4\nuform.php - line 86 (nuBuildTabList)

C:\Bitnami\wampstack\apache2\htdocs\nubuilder4\nuapi.php - line 42 (nuGetFormObject)

and

Code: Select all

[0] : 
===USER==========

globeadmin

===PDO MESSAGE=== 

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

===SQL=========== 

dESCRIBE 

===BACK TRACE====

C:\Bitnami\wampstack\apache2\htdocs\nubuilder4\nudatabase.php - line 150 (nuRunQuery)

C:\Bitnami\wampstack\apache2\htdocs\nubuilder4\nucommon.php - line 1093 (db_field_types)

C:\Bitnami\wampstack\apache2\htdocs\nubuilder4\nucommon.php - line 1146 (nuBuildTableSchema)

C:\Bitnami\wampstack\apache2\htdocs\nubuilder4\nuapi.php - line 65 (nuUpdateTableSchema)

Is there anywhere I might have gone wrong with my installation? I haven't made any deviations from the default Bitnami and nuBuilder installations to my knowledge. Any help or hints are appreciated, thanks for your time.

[kev1n]

Hi,

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'nubuilder4.zzzzsys_tab.zzzzsys_tab_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Try this:

https://tableplus.io/blog/2018/08/mysql ... up-by.html

[Hargey]

Hi,

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'nubuilder4.zzzzsys_tab.zzzzsys_tab_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Try this:

https://tableplus.io/blog/2018/08/mysql ... up-by.html

Thank you for your help, I wasn't aware of these global settings. I followed the instructions, and now the error log doesn't show any more errors of that type, and the home page appears to be working correctly. I still see many errors reporting a syntax error around DESCRIBE, but this hasn't affected my activities so far. I'll continue with the guide.