Message:
invalid query:- SELECT c.*,p.picture_id, p.pic_small,p.pic_medium,p.pic_main,p.pic_thumb,p.pic_bigthumb,v.video_id,v.video_path,v.pic_thumb as video_pic_thumb,v.pic_small as video_pic_small
FROM children c LEFT OUTER JOIN children_pictures p ON ( c.child_id = p.child_id AND p.status = 'enable')
LEFT OUTER JOIN children_videos v ON (c.child_id=v.child_id AND v.status = 'enable')
WHERE c.status = 'enable' AND c.isSponsored='No'
GROUP BY c.child_id
Expression #35 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'chooseto_childsponsor.p.picture_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Created in file
/home/chooseto/public_html/usol/lib/database/SqlDatabaseManager.class.php on line
148.
Stack Trace:#0 /home/chooseto/public_html/protected/appcode/datamanager/ChildrenDataManager.class.php(142): SqlDatabaseManager->executeQuery('\tSELECT c.*,p.p...')
#1 /home/chooseto/public_html/protected/classes/CommonContent.class.php(366): ChildrenDataManager->getAllChildrens('client')
#2 /home/chooseto/public_html/protected/controller/home.php(44): CommonContent->getFooter(Object(home))
#3 /home/chooseto/public_html/usol/lib/Application.class.php(66): home->initialize()
#4 /home/chooseto/public_html/index.php(15): Application::run(Object(HttpRequest))
#5 {main}- 4.
- In file /home/chooseto/public_html/protected/appcode/datamanager/ChildrenDataManager.class.php line 142.
Method: SqlDatabaseManager->executeQuery([$query FILTERED]) - 3.
- In file /home/chooseto/public_html/protected/classes/CommonContent.class.php line 366.
Method: ChildrenDataManager->getAllChildrens([$mode FILTERED]) - 2.
- In file /home/chooseto/public_html/protected/controller/home.php line 44.
Method: CommonContent->getFooter([$page FILTERED]) - 1.
- In file /home/chooseto/public_html/usol/lib/Application.class.php line 66.
Method: home->initialize() - 0.
- In file /home/chooseto/public_html/index.php line 15.
Method: Application::run([$request FILTERED])