There are no bookmarks on the main form (ubuntu)

Questions related to customising nuBuilder Forte with Javascript or PHP.

There are no bookmarks on the main form (ubuntu)

Postby kknm » Thu Apr 16, 2020 8:45 am

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)
kknm
 
Posts: 101
Joined: Sat Apr 11, 2020 7:33 am

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

Postby kev1n » Thu Apr 16, 2020 9:32 am

You need to modify my.cnf as described here:
viewtopic.php?f=19&t=9751&p=18406&hilit=Ubuntu#p18405
kev1n
 
Posts: 728
Joined: Mon Oct 15, 2018 2:13 am

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

Postby kknm » Thu Apr 16, 2020 8:18 pm

kev1n wrote:You need to modify my.cnf as described here:
viewtopic.php?f=19&t=9751&p=18406&hilit=Ubuntu#p18405

It's nice to deal with you - everything worked out! Thanks!
kknm
 
Posts: 101
Joined: Sat Apr 11, 2020 7:33 am

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

Postby kknm » Fri May 22, 2020 10:17 pm

kev1n wrote:You need to modify my.cnf as described here:
viewtopic.php?f=19&t=9751&p=18406&hilit=Ubuntu#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
kknm
 
Posts: 101
Joined: Sat Apr 11, 2020 7:33 am


Return to Custom Code