Admin Can Log in but no settings

[formmanokay]

Hi folks - I got nuBuilder up and running on my site, but when I go to log-in using the admin credentials from nuconfig.php, I don't see any options mentioned in the documentation. All I see is the attache image. (Is it because I didn't call the user globeadmin?)

[kev1n]

Hi,

Check the developer console (F12) for errors.
Also check the nuDebug Results, Apache log files.


Depending on the platform/web server, other settings are required.
Also see my Installation Guides.

[kev1n]

(Is it because I didn't call the user globeadmin?)

You can easily test that by naming it globeadmin. But normally you can rename it to whatever you want.

[formmanokay]

Found this error in developer console

Code: Select all

Uncaught TypeError: Cannot read property 'title' of undefined
    at nuResponseForm.setStartPosition (nuformclass.js?ts=20200828223315:61)
    at nuResponseForm.getStartPositions (nuformclass.js?ts=20200828223315:17)
    at nuBuildForm (nuform.js?ts=20200828223315:159)
    at Object.success ((index):79)
    at c (jquery.js?ts=20200828223315:2)
    at Object.fireWith [as resolveWith] (jquery.js?ts=20200828223315:2)
    at l (jquery.js?ts=20200828223315:2)
    at XMLHttpRequest.<anonymous> (jquery.js?ts=20200828223315:2)

And found this in nuDebug

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 'nubuilder.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====

/var/www/nubuilder/html/nuform.php - line 737 (nuRunQuery)

/var/www/nubuilder/html/nuform.php - line 86 (nuBuildTabList)

/var/www/nubuilder/html/nuapi.php - line 41 (nuGetFormObject)

My admin user defined as admin, not globeadmin
Also, for what it's helpful, I'm running Ubuntu 18.04 with Php7.

[kev1n]

Have you done these changes?

Edit the file /etc/alternatives/my.cnf and this at the bottom:

[client]
port=3306
socket=/tmp/mysql.sock

[mysqld]
port=3306
socket=/tmp/mysql.sock
key_buffer_size=16M
max_allowed_packet=8M
sql-mode=NO_ENGINE_SUBSTITUTION

[mysqldump]
quick

Also read: https://forums.nubuilder.cloud/viewtopic. ... ntu#p18405

[formmanokay]

Yes, I read your guide before posting and added those lines in my.cnf

[kev1n]

Search your webserver files for only_full_group_by and disable it (probably by removing it)

Also check out: https://stackoverflow.com/questions/239 ... l-group-by

[kev1n]

Sometimes there's a my.ini file (depending on the distribution). For UniServerZ, e.g. I had to set the sql-mode there because I encountered the same issue ("...this is incompatible with sql_mode=only_full_group_by"...) as you

[mysqld]
sql-mode=NO_ENGINE_SUBSTITUTION

[formmanokay]

Interesting. I'm not sure where that mode is set (running a DigitalOcean LAMP server). I was able to do SET GLOBAL sql_mode = 'NO_ENGINE_SUBSTITUTION'; in mysql and that fixed things. I'm guessing if the server restarts I'll have the error again.

[kev1n]

I'm guessing if the server restarts I'll have the error again.

Please let us know.