Welcome to the nuBuilder Forums!

Register and log in to access exclusive forums and content available only to registered users.

There are no bookmarks on the main form (ubuntu)

Questions related to customising nuBuilder Forte with JavaScript or PHP.
Post Reply
kknm
Posts: 366
Joined: Sat Apr 11, 2020 12:03 am
Has thanked: 3 times
Been thanked: 4 times
Contact:

There are no bookmarks on the main form (ubuntu)

Unread post by kknm »

There were no problems installing nubuider4 on windows.
When installing on ubuntu16 there is no 'SETUP' tab on the main form. LAMP is installed.
I tried different browsers

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/report/nuform.php - line 737 (nuRunQuery)

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

/var/www/report/nuapi.php - line 42 (nuGetFormObject)
kev1n
nuBuilder Team
Posts: 4416
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 74 times
Been thanked: 472 times
Contact:

Re: There are no bookmarks on the main form (ubuntu)

Unread post by kev1n »

You need to modify my.cnf as described here:
https://forums.nubuilder.cloud/viewtopic. ... ntu#p18405
kknm
Posts: 366
Joined: Sat Apr 11, 2020 12:03 am
Has thanked: 3 times
Been thanked: 4 times
Contact:

Re: There are no bookmarks on the main form (ubuntu)

Unread post by kknm »

kev1n wrote:You need to modify my.cnf as described here:
https://forums.nubuilder.cloud/viewtopic. ... ntu#p18405
It's nice to deal with you - everything worked out! Thanks!
kknm
Posts: 366
Joined: Sat Apr 11, 2020 12:03 am
Has thanked: 3 times
Been thanked: 4 times
Contact:

Re: There are no bookmarks on the main form (ubuntu)

Unread post by kknm »

kev1n wrote:You need to modify my.cnf as described here:
https://forums.nubuilder.cloud/viewtopic. ... ntu#p18405
In my case, I did this (Ubuntu-Mate 16), because it was not possible to update mysql-server:

Code: Select all

[mysqld]
sql-mode=NO_ENGINE_SUBSTITUTION

[mysqldump]
quick
Post Reply