phpdump( Db.class : line [ 701 ] )
stack: » bootstrap.inc » Web.class » SingletonClasses.class » SingletonClasses.class » Configuration.class » Configuration.class » Db.class » Db.class
trace: » instance() » __construct() » configuration() » classinstance() » instance() » __construct() » load() » query() » execute()
select c.name as category
      ,lower(l.name) as setting
      ,l.description
	  
      ,if(x.domain_id is null,d.name
       ,if(p.name = 'user defined' and x.custom_value is not null,x.custom_value,p.name)) as value

      ,if(p.name = 'user defined',x.custom_value,d.name) as default_value
	  
      ,if(p.name is not null
       ,if(p.name = d.name,'y','n')
       ,'y') as is_default
      ,group_concat(j.name) as all_options

from edu_property_categories c
    ,edu_property_options    d
    ,edu_property_options    j
    ,edu_property_lists      l

left join (edu_property_options  p
          ,edu_domain_properties x
          ,edu_domains           w)
	   on (l.id = p.list_id
	   and p.id = x.property_id
	   and w.id = x.domain_id
	   and w.name = 'uvu.edu')

where c.id = l.category_id
and   c.name like '% configuration'
and   j.list_id = l.id
and   d.list_id = l.id
and   d.is_default = 'y'

group by l.name

union

select 'system configuration'
       ,sys.name as setting
       ,sys.description
	  
       ,if(dss.value is not null and sys.read_only = 'n'
        ,dss.value
        ,sys.value) as value

       ,sys.value as default_value
       ,'y'
       ,null as all_options
	   
from edu_system_settings sys
left join edu_domain_settings dss on sys.id = dss.setting_id

order by setting

database: uvu_core
error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'uvu_core.c.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
record count: 0
affected rows: 0
Application Error
An error occurred while executing the sql statement.