nuBuilder Forum

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)

Code: Select all

[mysqld]
sql-mode=NO_ENGINE_SUBSTITUTION

[mysqldump]
quick