Page 1 of 1
Admin Can Log in but no settings
Posted: Sat Aug 29, 2020 12:31 am
by 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?)
Re: Admin Can Log in but no settings
Posted: Sat Aug 29, 2020 2:52 am
by 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.
Re: Admin Can Log in but no settings
Posted: Sat Aug 29, 2020 3:05 am
by kev1n
formmanokay wrote:(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.
Re: Admin Can Log in but no settings
Posted: Sat Aug 29, 2020 7:44 am
by 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.
Re: Admin Can Log in but no settings
Posted: Sat Aug 29, 2020 8:04 am
by 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
Re: Admin Can Log in but no settings
Posted: Sat Aug 29, 2020 8:12 am
by formmanokay
Yes, I read your guide before posting and added those lines in my.cnf
Re: Admin Can Log in but no settings
Posted: Sat Aug 29, 2020 8:21 am
by 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
Re: Admin Can Log in but no settings
Posted: Sat Aug 29, 2020 8:27 am
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
Re: Admin Can Log in but no settings
Posted: Sat Aug 29, 2020 8:47 am
by 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.
Re: Admin Can Log in but no settings
Posted: Sat Aug 29, 2020 9:19 am
by kev1n
formmanokay wrote:I'm guessing if the server restarts I'll have the error again.
Please let us know.