A PHP Error was encountered
Severity: Warning
Message: Cannot modify header information - headers already sent by (output started at /home/tradexl/public_html/system/core/Exceptions.php:271)
Filename: core/Common.php
Line Number: 570
Backtrace:
File: /home/tradexl/public_html/application/models/Common_model.php
Line: 235
Function: get
File: /home/tradexl/public_html/application/helpers/portal_helper.php
Line: 250
Function: assignProduct
File: /home/tradexl/public_html/application/views/sub_category_view.php
Line: 59
Function: getAssignProduct
File: /home/tradexl/public_html/application/controllers/Sub_category.php
Line: 23
Function: view
File: /home/tradexl/public_html/index.php
Line: 587
Function: require_once
A Database Error Occurred
Error Number: 1055
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'tradexl_sitev1jan15.product_tbl.p_Id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT `product_tbl`.*, `product_by_user`.*, `user_registration`.*, `city`.`city_id`, `city`.`city_name` FROM `product_tbl` JOIN `product_by_user` ON `product_by_user`.`product_By_User_Id`=`product_tbl`.`p_user_Id` JOIN `user_registration` ON `user_registration`.`user_Id`=`product_by_user`.`user_Id` JOIN `city` ON `city`.`city_id`=`user_registration`.`user_City` WHERE `p_cat_Id` = '2' AND `p_subcat_Id` = '18' AND `user_registration`.`live_status` = 1 AND `product_by_user`.`catalog_status` = 0 AND `product_by_user`.`status_Flag` = 'Accepted' GROUP BY `product_by_user`.`product_By_User_url` ORDER BY `p_user_Id` ASC
Filename: models/Common_model.php
Line Number: 235