<?php defined('BASEPATH') OR exit('No direct script access allowed'); ?>

ERROR - 2024-12-16 11:03:42 --> Severity: Notice --> Trying to get property of non-object /home/akshay/public_html/cab/application/controllers/Api/User.php 160
ERROR - 2024-12-16 11:03:42 --> Severity: Notice --> Trying to get property of non-object /home/akshay/public_html/cab/application/controllers/Api/User.php 161
ERROR - 2024-12-16 11:17:21 --> Severity: Notice --> Undefined index: PHP_AUTH_USER /home/akshay/public_html/cab/application/controllers/Api/User.php 15
ERROR - 2024-12-16 12:28:51 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.d.curr_lat' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT tmp.*,vt.id,vt.image,vt.name,vt.description,vt.type,
		    prmo.promo_code_discount,prmo.status as promo_status,tmp.curr_lat,tmp.curr_long,
		    f.per_km FROM (SELECT driver_id,curr_lat, curr_long,
    	    round(( 6371 * acos( cos( radians(round(24.854975080601,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(74.612969195319,2)) ) + sin( radians(round(24.854975080601,2)) ) * sin( radians(curr_lat) ) ) )) AS distance
    	    FROM tbl_driver_currentLocation d GROUP BY driver_id) AS tmp
    	    INNER JOIN tbl_driver d ON d.id=tmp.driver_id
    	    INNER JOIN tbl_vehicle tv ON tv.driver_id=d.id
     	    INNER JOIN tbl_map_vehicletype dmt ON dmt.vehicle_id=tv.id
     	    INNER JOIN tbl_vehicletype vt ON vt.id=dmt.type_id
     	    INNER JOIN promocode prmo ON prmo.vehicletype_id=vt.id
     	    INNER JOIN tbl_fare f ON f.vehicle_type=vt.id WHERE vt.status=1 AND d.is_online=1 AND d.status=1
     	    
     	    AND tmp.distance <= '5' GROUP BY vt.id ORDER BY tmp.distance,f.per_km ASC
ERROR - 2024-12-16 12:28:51 --> Query error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.b.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT b.*,DATE_FORMAT(b.entry_date,'%d/%m/%Y %H:%i %p') AS entrydate,
            tbc.selecteddate,tbc.selectedtime,tu.f_name,tu.mobile_no,tu.email_id
            FROM tbl_booking b
            INNER JOIN tbl_userwise_cabrequest tbc ON tbc.user_id=b.user_id 
            INNER JOIN tbl_user tu ON tu.id=b.user_id 
            WHERE tbc.status=0 AND b.user_id='15' GROUP BY b.book_id ORDER BY b.id DESC
ERROR - 2024-12-16 12:29:46 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.d.curr_lat' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT tmp.*,vt.id,vt.image,vt.name,vt.description,vt.type,
		    prmo.promo_code_discount,prmo.status as promo_status,tmp.curr_lat,tmp.curr_long,
		    f.per_km FROM (SELECT driver_id,curr_lat, curr_long,
    	    round(( 6371 * acos( cos( radians(round(24.854975080601,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(74.612969195319,2)) ) + sin( radians(round(24.854975080601,2)) ) * sin( radians(curr_lat) ) ) )) AS distance
    	    FROM tbl_driver_currentLocation d GROUP BY driver_id) AS tmp
    	    INNER JOIN tbl_driver d ON d.id=tmp.driver_id
    	    INNER JOIN tbl_vehicle tv ON tv.driver_id=d.id
     	    INNER JOIN tbl_map_vehicletype dmt ON dmt.vehicle_id=tv.id
     	    INNER JOIN tbl_vehicletype vt ON vt.id=dmt.type_id
     	    INNER JOIN promocode prmo ON prmo.vehicletype_id=vt.id
     	    INNER JOIN tbl_fare f ON f.vehicle_type=vt.id WHERE vt.status=1 AND d.is_online=1 AND d.status=1
     	    
     	    AND tmp.distance <= '5' GROUP BY vt.id ORDER BY tmp.distance,f.per_km ASC
ERROR - 2024-12-16 12:29:46 --> Query error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.b.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT b.*,DATE_FORMAT(b.entry_date,'%d/%m/%Y %H:%i %p') AS entrydate,
            tbc.selecteddate,tbc.selectedtime,tu.f_name,tu.mobile_no,tu.email_id
            FROM tbl_booking b
            INNER JOIN tbl_userwise_cabrequest tbc ON tbc.user_id=b.user_id 
            INNER JOIN tbl_user tu ON tu.id=b.user_id 
            WHERE tbc.status=0 AND b.user_id='15' GROUP BY b.book_id ORDER BY b.id DESC
ERROR - 2024-12-16 12:31:08 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.d.curr_lat' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT tmp.*,vt.id,vt.image,vt.name,vt.description,vt.type,
		    prmo.promo_code_discount,prmo.status as promo_status,tmp.curr_lat,tmp.curr_long,
		    f.per_km FROM (SELECT driver_id,curr_lat, curr_long,
    	    round(( 6371 * acos( cos( radians(round(30.368341,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(78.0516939,2)) ) + sin( radians(round(30.368341,2)) ) * sin( radians(curr_lat) ) ) )) AS distance
    	    FROM tbl_driver_currentLocation d GROUP BY driver_id) AS tmp
    	    INNER JOIN tbl_driver d ON d.id=tmp.driver_id
    	    INNER JOIN tbl_vehicle tv ON tv.driver_id=d.id
     	    INNER JOIN tbl_map_vehicletype dmt ON dmt.vehicle_id=tv.id
     	    INNER JOIN tbl_vehicletype vt ON vt.id=dmt.type_id
     	    INNER JOIN promocode prmo ON prmo.vehicletype_id=vt.id
     	    INNER JOIN tbl_fare f ON f.vehicle_type=vt.id WHERE vt.status=1 AND d.is_online=1 AND d.status=1
     	    
     	    AND tmp.distance <= '5' GROUP BY vt.id ORDER BY tmp.distance,f.per_km ASC
ERROR - 2024-12-16 12:31:45 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.d.curr_lat' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT tmp.*,vt.id,vt.image,vt.name,vt.description,vt.type,
		    prmo.promo_code_discount,prmo.status as promo_status,tmp.curr_lat,tmp.curr_long,
		    f.per_km FROM (SELECT driver_id,curr_lat, curr_long,
    	    round(( 6371 * acos( cos( radians(round(30.368341,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(78.0516939,2)) ) + sin( radians(round(30.368341,2)) ) * sin( radians(curr_lat) ) ) )) AS distance
    	    FROM tbl_driver_currentLocation d GROUP BY driver_id) AS tmp
    	    INNER JOIN tbl_driver d ON d.id=tmp.driver_id
    	    INNER JOIN tbl_vehicle tv ON tv.driver_id=d.id
     	    INNER JOIN tbl_map_vehicletype dmt ON dmt.vehicle_id=tv.id
     	    INNER JOIN tbl_vehicletype vt ON vt.id=dmt.type_id
     	    INNER JOIN promocode prmo ON prmo.vehicletype_id=vt.id
     	    INNER JOIN tbl_fare f ON f.vehicle_type=vt.id WHERE vt.status=1 AND d.is_online=1 AND d.status=1
     	    
     	    AND tmp.distance <= '5' GROUP BY vt.id ORDER BY tmp.distance,f.per_km ASC
ERROR - 2024-12-16 12:33:39 --> Query error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.b.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT b.*,DATE_FORMAT(b.entry_date,'%d/%m/%Y %H:%i %p') AS entrydate,
            tbc.selecteddate,tbc.selectedtime,tu.f_name,tu.mobile_no,tu.email_id
            FROM tbl_booking b
            INNER JOIN tbl_userwise_cabrequest tbc ON tbc.user_id=b.user_id 
            INNER JOIN tbl_user tu ON tu.id=b.user_id 
            WHERE tbc.status=0 AND b.user_id='15' GROUP BY b.book_id ORDER BY b.id DESC
ERROR - 2024-12-16 12:33:39 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.d.curr_lat' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT tmp.*,vt.id,vt.image,vt.name,vt.description,vt.type,
		    prmo.promo_code_discount,prmo.status as promo_status,tmp.curr_lat,tmp.curr_long,
		    f.per_km FROM (SELECT driver_id,curr_lat, curr_long,
    	    round(( 6371 * acos( cos( radians(round(24.854975080601,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(74.612969195319,2)) ) + sin( radians(round(24.854975080601,2)) ) * sin( radians(curr_lat) ) ) )) AS distance
    	    FROM tbl_driver_currentLocation d GROUP BY driver_id) AS tmp
    	    INNER JOIN tbl_driver d ON d.id=tmp.driver_id
    	    INNER JOIN tbl_vehicle tv ON tv.driver_id=d.id
     	    INNER JOIN tbl_map_vehicletype dmt ON dmt.vehicle_id=tv.id
     	    INNER JOIN tbl_vehicletype vt ON vt.id=dmt.type_id
     	    INNER JOIN promocode prmo ON prmo.vehicletype_id=vt.id
     	    INNER JOIN tbl_fare f ON f.vehicle_type=vt.id WHERE vt.status=1 AND d.is_online=1 AND d.status=1
     	    
     	    AND tmp.distance <= '5' GROUP BY vt.id ORDER BY tmp.distance,f.per_km ASC
ERROR - 2024-12-16 12:35:58 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.d.curr_lat' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT tmp.*,vt.id,vt.image,vt.name,vt.description,vt.type,
		    prmo.promo_code_discount,prmo.status as promo_status,tmp.curr_lat,tmp.curr_long,
		    f.per_km FROM (SELECT driver_id,curr_lat, curr_long,
    	    round(( 6371 * acos( cos( radians(round(30.368341,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(78.0516939,2)) ) + sin( radians(round(30.368341,2)) ) * sin( radians(curr_lat) ) ) )) AS distance
    	    FROM tbl_driver_currentLocation d GROUP BY driver_id) AS tmp
    	    INNER JOIN tbl_driver d ON d.id=tmp.driver_id
    	    INNER JOIN tbl_vehicle tv ON tv.driver_id=d.id
     	    INNER JOIN tbl_map_vehicletype dmt ON dmt.vehicle_id=tv.id
     	    INNER JOIN tbl_vehicletype vt ON vt.id=dmt.type_id
     	    INNER JOIN promocode prmo ON prmo.vehicletype_id=vt.id
     	    INNER JOIN tbl_fare f ON f.vehicle_type=vt.id WHERE vt.status=1 AND d.is_online=1 AND d.status=1
     	    
     	    AND tmp.distance <= '5' GROUP BY vt.id ORDER BY tmp.distance,f.per_km ASC
ERROR - 2024-12-16 12:38:32 --> Query error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.b.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT b.*,DATE_FORMAT(b.entry_date,'%d/%m/%Y %H:%i %p') AS entrydate,
            tbc.selecteddate,tbc.selectedtime,tu.f_name,tu.mobile_no,tu.email_id
            FROM tbl_booking b
            INNER JOIN tbl_userwise_cabrequest tbc ON tbc.user_id=b.user_id 
            INNER JOIN tbl_user tu ON tu.id=b.user_id 
            WHERE tbc.status=0 AND b.user_id='15' GROUP BY b.book_id ORDER BY b.id DESC
ERROR - 2024-12-16 12:39:14 --> Query error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.b.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT b.*,DATE_FORMAT(b.entry_date,'%d/%m/%Y %H:%i %p') AS entrydate,
            tbc.selecteddate,tbc.selectedtime,tu.f_name,tu.mobile_no,tu.email_id
            FROM tbl_booking b
            INNER JOIN tbl_userwise_cabrequest tbc ON tbc.user_id=b.user_id 
            INNER JOIN tbl_user tu ON tu.id=b.user_id 
            WHERE tbc.status=0 AND b.user_id='15' GROUP BY b.book_id ORDER BY b.id DESC
ERROR - 2024-12-16 14:13:17 --> Query error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.b.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT b.*,DATE_FORMAT(b.entry_date,'%d/%m/%Y %H:%i %p') AS entrydate,
            tbc.selecteddate,tbc.selectedtime,tu.f_name,tu.mobile_no,tu.email_id
            FROM tbl_booking b
            INNER JOIN tbl_userwise_cabrequest tbc ON tbc.user_id=b.user_id 
            INNER JOIN tbl_user tu ON tu.id=b.user_id 
            WHERE tbc.status=0 AND b.user_id='15' GROUP BY b.book_id ORDER BY b.id DESC
ERROR - 2024-12-16 14:17:45 --> Query error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.b.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT b.*,DATE_FORMAT(b.entry_date,'%d/%m/%Y %H:%i %p') AS entrydate,
            tbc.selecteddate,tbc.selectedtime,tu.f_name,tu.mobile_no,tu.email_id
            FROM tbl_booking b
            INNER JOIN tbl_userwise_cabrequest tbc ON tbc.user_id=b.user_id 
            INNER JOIN tbl_user tu ON tu.id=b.user_id 
            WHERE tbc.status=0 AND b.user_id='15' GROUP BY b.book_id ORDER BY b.id DESC
ERROR - 2024-12-16 14:29:36 --> Query error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.b.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT b.*,DATE_FORMAT(b.entry_date,'%d/%m/%Y %H:%i %p') AS entrydate,
            tbc.selecteddate,tbc.selectedtime,tu.f_name,tu.mobile_no,tu.email_id
            FROM tbl_booking b
            INNER JOIN tbl_userwise_cabrequest tbc ON tbc.user_id=b.user_id 
            INNER JOIN tbl_user tu ON tu.id=b.user_id 
            WHERE tbc.status=0 AND b.user_id='15' GROUP BY b.book_id ORDER BY b.id DESC
ERROR - 2024-12-16 14:29:36 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.d.curr_lat' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT tmp.*,vt.id,vt.image,vt.name,vt.description,vt.type,
		    prmo.promo_code_discount,prmo.status as promo_status,tmp.curr_lat,tmp.curr_long,
		    f.per_km FROM (SELECT driver_id,curr_lat, curr_long,
    	    round(( 6371 * acos( cos( radians(round(24.854975080601,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(74.612969195319,2)) ) + sin( radians(round(24.854975080601,2)) ) * sin( radians(curr_lat) ) ) )) AS distance
    	    FROM tbl_driver_currentLocation d GROUP BY driver_id) AS tmp
    	    INNER JOIN tbl_driver d ON d.id=tmp.driver_id
    	    INNER JOIN tbl_vehicle tv ON tv.driver_id=d.id
     	    INNER JOIN tbl_map_vehicletype dmt ON dmt.vehicle_id=tv.id
     	    INNER JOIN tbl_vehicletype vt ON vt.id=dmt.type_id
     	    INNER JOIN promocode prmo ON prmo.vehicletype_id=vt.id
     	    INNER JOIN tbl_fare f ON f.vehicle_type=vt.id WHERE vt.status=1 AND d.is_online=1 AND d.status=1
     	    
     	    AND tmp.distance <= '5' GROUP BY vt.id ORDER BY tmp.distance,f.per_km ASC
ERROR - 2024-12-16 14:31:33 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.d.curr_lat' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT tmp.*,vt.id,vt.image,vt.name,vt.description,vt.type,
		    prmo.promo_code_discount,prmo.status as promo_status,tmp.curr_lat,tmp.curr_long,
		    f.per_km FROM (SELECT driver_id,curr_lat, curr_long,
    	    round(( 6371 * acos( cos( radians(round(24.854975080601,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(74.612969195319,2)) ) + sin( radians(round(24.854975080601,2)) ) * sin( radians(curr_lat) ) ) )) AS distance
    	    FROM tbl_driver_currentLocation d GROUP BY driver_id) AS tmp
    	    INNER JOIN tbl_driver d ON d.id=tmp.driver_id
    	    INNER JOIN tbl_vehicle tv ON tv.driver_id=d.id
     	    INNER JOIN tbl_map_vehicletype dmt ON dmt.vehicle_id=tv.id
     	    INNER JOIN tbl_vehicletype vt ON vt.id=dmt.type_id
     	    INNER JOIN promocode prmo ON prmo.vehicletype_id=vt.id
     	    INNER JOIN tbl_fare f ON f.vehicle_type=vt.id WHERE vt.status=1 AND d.is_online=1 AND d.status=1
     	    
     	    AND tmp.distance <= '5' GROUP BY vt.id ORDER BY tmp.distance,f.per_km ASC
ERROR - 2024-12-16 14:31:33 --> Query error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.b.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT b.*,DATE_FORMAT(b.entry_date,'%d/%m/%Y %H:%i %p') AS entrydate,
            tbc.selecteddate,tbc.selectedtime,tu.f_name,tu.mobile_no,tu.email_id
            FROM tbl_booking b
            INNER JOIN tbl_userwise_cabrequest tbc ON tbc.user_id=b.user_id 
            INNER JOIN tbl_user tu ON tu.id=b.user_id 
            WHERE tbc.status=0 AND b.user_id='15' GROUP BY b.book_id ORDER BY b.id DESC
ERROR - 2024-12-16 14:49:18 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.d.curr_lat' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT tmp.*,vt.id,vt.image,vt.name,vt.description,vt.type,
		    prmo.promo_code_discount,prmo.status as promo_status,tmp.curr_lat,tmp.curr_long,
		    f.per_km FROM (SELECT driver_id,curr_lat, curr_long,
    	    round(( 6371 * acos( cos( radians(round(24.854975080601,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(74.612969195319,2)) ) + sin( radians(round(24.854975080601,2)) ) * sin( radians(curr_lat) ) ) )) AS distance
    	    FROM tbl_driver_currentLocation d GROUP BY driver_id) AS tmp
    	    INNER JOIN tbl_driver d ON d.id=tmp.driver_id
    	    INNER JOIN tbl_vehicle tv ON tv.driver_id=d.id
     	    INNER JOIN tbl_map_vehicletype dmt ON dmt.vehicle_id=tv.id
     	    INNER JOIN tbl_vehicletype vt ON vt.id=dmt.type_id
     	    INNER JOIN promocode prmo ON prmo.vehicletype_id=vt.id
     	    INNER JOIN tbl_fare f ON f.vehicle_type=vt.id WHERE vt.status=1 AND d.is_online=1 AND d.status=1
     	    
     	    AND tmp.distance <= '5' GROUP BY vt.id ORDER BY tmp.distance,f.per_km ASC
ERROR - 2024-12-16 14:49:18 --> Query error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.b.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT b.*,DATE_FORMAT(b.entry_date,'%d/%m/%Y %H:%i %p') AS entrydate,
            tbc.selecteddate,tbc.selectedtime,tu.f_name,tu.mobile_no,tu.email_id
            FROM tbl_booking b
            INNER JOIN tbl_userwise_cabrequest tbc ON tbc.user_id=b.user_id 
            INNER JOIN tbl_user tu ON tu.id=b.user_id 
            WHERE tbc.status=0 AND b.user_id='15' GROUP BY b.book_id ORDER BY b.id DESC
ERROR - 2024-12-16 14:52:29 --> Query error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.b.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT b.*,DATE_FORMAT(b.entry_date,'%d/%m/%Y %H:%i %p') AS entrydate,
            tbc.selecteddate,tbc.selectedtime,tu.f_name,tu.mobile_no,tu.email_id
            FROM tbl_booking b
            INNER JOIN tbl_userwise_cabrequest tbc ON tbc.user_id=b.user_id 
            INNER JOIN tbl_user tu ON tu.id=b.user_id 
            WHERE tbc.status=0 AND b.user_id='15' GROUP BY b.book_id ORDER BY b.id DESC
ERROR - 2024-12-16 14:52:29 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.d.curr_lat' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT tmp.*,vt.id,vt.image,vt.name,vt.description,vt.type,
		    prmo.promo_code_discount,prmo.status as promo_status,tmp.curr_lat,tmp.curr_long,
		    f.per_km FROM (SELECT driver_id,curr_lat, curr_long,
    	    round(( 6371 * acos( cos( radians(round(24.854975080601,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(74.612969195319,2)) ) + sin( radians(round(24.854975080601,2)) ) * sin( radians(curr_lat) ) ) )) AS distance
    	    FROM tbl_driver_currentLocation d GROUP BY driver_id) AS tmp
    	    INNER JOIN tbl_driver d ON d.id=tmp.driver_id
    	    INNER JOIN tbl_vehicle tv ON tv.driver_id=d.id
     	    INNER JOIN tbl_map_vehicletype dmt ON dmt.vehicle_id=tv.id
     	    INNER JOIN tbl_vehicletype vt ON vt.id=dmt.type_id
     	    INNER JOIN promocode prmo ON prmo.vehicletype_id=vt.id
     	    INNER JOIN tbl_fare f ON f.vehicle_type=vt.id WHERE vt.status=1 AND d.is_online=1 AND d.status=1
     	    
     	    AND tmp.distance <= '5' GROUP BY vt.id ORDER BY tmp.distance,f.per_km ASC
ERROR - 2024-12-16 14:53:30 --> Query error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.b.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT b.*,DATE_FORMAT(b.entry_date,'%d/%m/%Y %H:%i %p') AS entrydate,
            tbc.selecteddate,tbc.selectedtime,tu.f_name,tu.mobile_no,tu.email_id
            FROM tbl_booking b
            INNER JOIN tbl_userwise_cabrequest tbc ON tbc.user_id=b.user_id 
            INNER JOIN tbl_user tu ON tu.id=b.user_id 
            WHERE tbc.status=0 AND b.user_id='15' GROUP BY b.book_id ORDER BY b.id DESC
ERROR - 2024-12-16 14:58:40 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.d.curr_lat' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT tmp.*,vt.id,vt.image,vt.name,vt.description,vt.type,
		    prmo.promo_code_discount,prmo.status as promo_status,tmp.curr_lat,tmp.curr_long,
		    f.per_km FROM (SELECT driver_id,curr_lat, curr_long,
    	    round(( 6371 * acos( cos( radians(round(30.368341,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(78.0516939,2)) ) + sin( radians(round(30.368341,2)) ) * sin( radians(curr_lat) ) ) )) AS distance
    	    FROM tbl_driver_currentLocation d GROUP BY driver_id) AS tmp
    	    INNER JOIN tbl_driver d ON d.id=tmp.driver_id
    	    INNER JOIN tbl_vehicle tv ON tv.driver_id=d.id
     	    INNER JOIN tbl_map_vehicletype dmt ON dmt.vehicle_id=tv.id
     	    INNER JOIN tbl_vehicletype vt ON vt.id=dmt.type_id
     	    INNER JOIN promocode prmo ON prmo.vehicletype_id=vt.id
     	    INNER JOIN tbl_fare f ON f.vehicle_type=vt.id WHERE vt.status=1 AND d.is_online=1 AND d.status=1
     	    
     	    AND tmp.distance <= '5' GROUP BY vt.id ORDER BY tmp.distance,f.per_km ASC
ERROR - 2024-12-16 15:44:37 --> Query error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.b.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT b.*,DATE_FORMAT(b.entry_date,'%d/%m/%Y %H:%i %p') AS entrydate,
            tbc.selecteddate,tbc.selectedtime,tu.f_name,tu.mobile_no,tu.email_id
            FROM tbl_booking b
            INNER JOIN tbl_userwise_cabrequest tbc ON tbc.user_id=b.user_id 
            INNER JOIN tbl_user tu ON tu.id=b.user_id 
            WHERE tbc.status=0 AND b.user_id='15' GROUP BY b.book_id ORDER BY b.id DESC
ERROR - 2024-12-16 15:44:37 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.d.curr_lat' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT tmp.*,vt.id,vt.image,vt.name,vt.description,vt.type,
		    prmo.promo_code_discount,prmo.status as promo_status,tmp.curr_lat,tmp.curr_long,
		    f.per_km FROM (SELECT driver_id,curr_lat, curr_long,
    	    round(( 6371 * acos( cos( radians(round(30.368341,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(78.0516939,2)) ) + sin( radians(round(30.368341,2)) ) * sin( radians(curr_lat) ) ) )) AS distance
    	    FROM tbl_driver_currentLocation d GROUP BY driver_id) AS tmp
    	    INNER JOIN tbl_driver d ON d.id=tmp.driver_id
    	    INNER JOIN tbl_vehicle tv ON tv.driver_id=d.id
     	    INNER JOIN tbl_map_vehicletype dmt ON dmt.vehicle_id=tv.id
     	    INNER JOIN tbl_vehicletype vt ON vt.id=dmt.type_id
     	    INNER JOIN promocode prmo ON prmo.vehicletype_id=vt.id
     	    INNER JOIN tbl_fare f ON f.vehicle_type=vt.id WHERE vt.status=1 AND d.is_online=1 AND d.status=1
     	    
     	    AND tmp.distance <= '5' GROUP BY vt.id ORDER BY tmp.distance,f.per_km ASC
ERROR - 2024-12-16 15:47:09 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.d.curr_lat' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT tmp.*,vt.id,vt.image,vt.name,vt.description,vt.type,
		    prmo.promo_code_discount,prmo.status as promo_status,tmp.curr_lat,tmp.curr_long,
		    f.per_km FROM (SELECT driver_id,curr_lat, curr_long,
    	    round(( 6371 * acos( cos( radians(round(30.368341,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(78.0516939,2)) ) + sin( radians(round(30.368341,2)) ) * sin( radians(curr_lat) ) ) )) AS distance
    	    FROM tbl_driver_currentLocation d GROUP BY driver_id) AS tmp
    	    INNER JOIN tbl_driver d ON d.id=tmp.driver_id
    	    INNER JOIN tbl_vehicle tv ON tv.driver_id=d.id
     	    INNER JOIN tbl_map_vehicletype dmt ON dmt.vehicle_id=tv.id
     	    INNER JOIN tbl_vehicletype vt ON vt.id=dmt.type_id
     	    INNER JOIN promocode prmo ON prmo.vehicletype_id=vt.id
     	    INNER JOIN tbl_fare f ON f.vehicle_type=vt.id WHERE vt.status=1 AND d.is_online=1 AND d.status=1
     	    
     	    AND tmp.distance <= '5' GROUP BY vt.id ORDER BY tmp.distance,f.per_km ASC
ERROR - 2024-12-16 15:47:09 --> Query error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.b.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT b.*,DATE_FORMAT(b.entry_date,'%d/%m/%Y %H:%i %p') AS entrydate,
            tbc.selecteddate,tbc.selectedtime,tu.f_name,tu.mobile_no,tu.email_id
            FROM tbl_booking b
            INNER JOIN tbl_userwise_cabrequest tbc ON tbc.user_id=b.user_id 
            INNER JOIN tbl_user tu ON tu.id=b.user_id 
            WHERE tbc.status=0 AND b.user_id='15' GROUP BY b.book_id ORDER BY b.id DESC
ERROR - 2024-12-16 16:14:20 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.d.curr_lat' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT tmp.*,vt.id,vt.image,vt.name,vt.description,vt.type,
		    prmo.promo_code_discount,prmo.status as promo_status,tmp.curr_lat,tmp.curr_long,
		    f.per_km FROM (SELECT driver_id,curr_lat, curr_long,
    	    round(( 6371 * acos( cos( radians(round(24.854975080601,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(74.612969195319,2)) ) + sin( radians(round(24.854975080601,2)) ) * sin( radians(curr_lat) ) ) )) AS distance
    	    FROM tbl_driver_currentLocation d GROUP BY driver_id) AS tmp
    	    INNER JOIN tbl_driver d ON d.id=tmp.driver_id
    	    INNER JOIN tbl_vehicle tv ON tv.driver_id=d.id
     	    INNER JOIN tbl_map_vehicletype dmt ON dmt.vehicle_id=tv.id
     	    INNER JOIN tbl_vehicletype vt ON vt.id=dmt.type_id
     	    INNER JOIN promocode prmo ON prmo.vehicletype_id=vt.id
     	    INNER JOIN tbl_fare f ON f.vehicle_type=vt.id WHERE vt.status=1 AND d.is_online=1 AND d.status=1
     	    
     	    AND tmp.distance <= '5' GROUP BY vt.id ORDER BY tmp.distance,f.per_km ASC
ERROR - 2024-12-16 16:14:20 --> Query error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.b.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT b.*,DATE_FORMAT(b.entry_date,'%d/%m/%Y %H:%i %p') AS entrydate,
            tbc.selecteddate,tbc.selectedtime,tu.f_name,tu.mobile_no,tu.email_id
            FROM tbl_booking b
            INNER JOIN tbl_userwise_cabrequest tbc ON tbc.user_id=b.user_id 
            INNER JOIN tbl_user tu ON tu.id=b.user_id 
            WHERE tbc.status=0 AND b.user_id='15' GROUP BY b.book_id ORDER BY b.id DESC
ERROR - 2024-12-16 16:23:19 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.d.curr_lat' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT tmp.*,vt.id,vt.image,vt.name,vt.description,vt.type,
		    prmo.promo_code_discount,prmo.status as promo_status,tmp.curr_lat,tmp.curr_long,
		    f.per_km FROM (SELECT driver_id,curr_lat, curr_long,
    	    round(( 6371 * acos( cos( radians(round(24.854975080601,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(74.612969195319,2)) ) + sin( radians(round(24.854975080601,2)) ) * sin( radians(curr_lat) ) ) )) AS distance
    	    FROM tbl_driver_currentLocation d GROUP BY driver_id) AS tmp
    	    INNER JOIN tbl_driver d ON d.id=tmp.driver_id
    	    INNER JOIN tbl_vehicle tv ON tv.driver_id=d.id
     	    INNER JOIN tbl_map_vehicletype dmt ON dmt.vehicle_id=tv.id
     	    INNER JOIN tbl_vehicletype vt ON vt.id=dmt.type_id
     	    INNER JOIN promocode prmo ON prmo.vehicletype_id=vt.id
     	    INNER JOIN tbl_fare f ON f.vehicle_type=vt.id WHERE vt.status=1 AND d.is_online=1 AND d.status=1
     	    
     	    AND tmp.distance <= '5' GROUP BY vt.id ORDER BY tmp.distance,f.per_km ASC
ERROR - 2024-12-16 16:23:19 --> Query error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.b.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT b.*,DATE_FORMAT(b.entry_date,'%d/%m/%Y %H:%i %p') AS entrydate,
            tbc.selecteddate,tbc.selectedtime,tu.f_name,tu.mobile_no,tu.email_id
            FROM tbl_booking b
            INNER JOIN tbl_userwise_cabrequest tbc ON tbc.user_id=b.user_id 
            INNER JOIN tbl_user tu ON tu.id=b.user_id 
            WHERE tbc.status=0 AND b.user_id='15' GROUP BY b.book_id ORDER BY b.id DESC
ERROR - 2024-12-16 16:38:05 --> Query error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.b.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT b.*,DATE_FORMAT(b.entry_date,'%d/%m/%Y %H:%i %p') AS entrydate,
            tbc.selecteddate,tbc.selectedtime,tu.f_name,tu.mobile_no,tu.email_id
            FROM tbl_booking b
            INNER JOIN tbl_userwise_cabrequest tbc ON tbc.user_id=b.user_id 
            INNER JOIN tbl_user tu ON tu.id=b.user_id 
            WHERE tbc.status=0 AND b.user_id='15' GROUP BY b.book_id ORDER BY b.id DESC
ERROR - 2024-12-16 16:38:05 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.d.curr_lat' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT tmp.*,vt.id,vt.image,vt.name,vt.description,vt.type,
		    prmo.promo_code_discount,prmo.status as promo_status,tmp.curr_lat,tmp.curr_long,
		    f.per_km FROM (SELECT driver_id,curr_lat, curr_long,
    	    round(( 6371 * acos( cos( radians(round(24.854975080601,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(74.612969195319,2)) ) + sin( radians(round(24.854975080601,2)) ) * sin( radians(curr_lat) ) ) )) AS distance
    	    FROM tbl_driver_currentLocation d GROUP BY driver_id) AS tmp
    	    INNER JOIN tbl_driver d ON d.id=tmp.driver_id
    	    INNER JOIN tbl_vehicle tv ON tv.driver_id=d.id
     	    INNER JOIN tbl_map_vehicletype dmt ON dmt.vehicle_id=tv.id
     	    INNER JOIN tbl_vehicletype vt ON vt.id=dmt.type_id
     	    INNER JOIN promocode prmo ON prmo.vehicletype_id=vt.id
     	    INNER JOIN tbl_fare f ON f.vehicle_type=vt.id WHERE vt.status=1 AND d.is_online=1 AND d.status=1
     	    
     	    AND tmp.distance <= '5' GROUP BY vt.id ORDER BY tmp.distance,f.per_km ASC
ERROR - 2024-12-16 16:58:39 --> Query error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.b.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT b.*,DATE_FORMAT(b.entry_date,'%d/%m/%Y %H:%i %p') AS entrydate,
            tbc.selecteddate,tbc.selectedtime,tu.f_name,tu.mobile_no,tu.email_id
            FROM tbl_booking b
            INNER JOIN tbl_userwise_cabrequest tbc ON tbc.user_id=b.user_id 
            INNER JOIN tbl_user tu ON tu.id=b.user_id 
            WHERE tbc.status=0 AND b.user_id='15' GROUP BY b.book_id ORDER BY b.id DESC
ERROR - 2024-12-16 16:58:40 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.d.curr_lat' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT tmp.*,vt.id,vt.image,vt.name,vt.description,vt.type,
		    prmo.promo_code_discount,prmo.status as promo_status,tmp.curr_lat,tmp.curr_long,
		    f.per_km FROM (SELECT driver_id,curr_lat, curr_long,
    	    round(( 6371 * acos( cos( radians(round(24.854975080601,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(74.612969195319,2)) ) + sin( radians(round(24.854975080601,2)) ) * sin( radians(curr_lat) ) ) )) AS distance
    	    FROM tbl_driver_currentLocation d GROUP BY driver_id) AS tmp
    	    INNER JOIN tbl_driver d ON d.id=tmp.driver_id
    	    INNER JOIN tbl_vehicle tv ON tv.driver_id=d.id
     	    INNER JOIN tbl_map_vehicletype dmt ON dmt.vehicle_id=tv.id
     	    INNER JOIN tbl_vehicletype vt ON vt.id=dmt.type_id
     	    INNER JOIN promocode prmo ON prmo.vehicletype_id=vt.id
     	    INNER JOIN tbl_fare f ON f.vehicle_type=vt.id WHERE vt.status=1 AND d.is_online=1 AND d.status=1
     	    
     	    AND tmp.distance <= '5' GROUP BY vt.id ORDER BY tmp.distance,f.per_km ASC
ERROR - 2024-12-16 17:05:48 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.d.curr_lat' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT tmp.*,vt.id,vt.image,vt.name,vt.description,vt.type,
		    prmo.promo_code_discount,prmo.status as promo_status,tmp.curr_lat,tmp.curr_long,
		    f.per_km FROM (SELECT driver_id,curr_lat, curr_long,
    	    round(( 6371 * acos( cos( radians(round(30.368341,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(78.0516939,2)) ) + sin( radians(round(30.368341,2)) ) * sin( radians(curr_lat) ) ) )) AS distance
    	    FROM tbl_driver_currentLocation d GROUP BY driver_id) AS tmp
    	    INNER JOIN tbl_driver d ON d.id=tmp.driver_id
    	    INNER JOIN tbl_vehicle tv ON tv.driver_id=d.id
     	    INNER JOIN tbl_map_vehicletype dmt ON dmt.vehicle_id=tv.id
     	    INNER JOIN tbl_vehicletype vt ON vt.id=dmt.type_id
     	    INNER JOIN promocode prmo ON prmo.vehicletype_id=vt.id
     	    INNER JOIN tbl_fare f ON f.vehicle_type=vt.id WHERE vt.status=1 AND d.is_online=1 AND d.status=1
     	    
     	    AND tmp.distance <= '5' GROUP BY vt.id ORDER BY tmp.distance,f.per_km ASC
ERROR - 2024-12-16 17:10:45 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.d.curr_lat' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT tmp.*,vt.id,vt.image,vt.name,vt.description,vt.type,
		    prmo.promo_code_discount,prmo.status as promo_status,tmp.curr_lat,tmp.curr_long,
		    f.per_km FROM (SELECT driver_id,curr_lat, curr_long,
    	    round(( 6371 * acos( cos( radians(round(24.854975080601,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(74.612969195319,2)) ) + sin( radians(round(24.854975080601,2)) ) * sin( radians(curr_lat) ) ) )) AS distance
    	    FROM tbl_driver_currentLocation d GROUP BY driver_id) AS tmp
    	    INNER JOIN tbl_driver d ON d.id=tmp.driver_id
    	    INNER JOIN tbl_vehicle tv ON tv.driver_id=d.id
     	    INNER JOIN tbl_map_vehicletype dmt ON dmt.vehicle_id=tv.id
     	    INNER JOIN tbl_vehicletype vt ON vt.id=dmt.type_id
     	    INNER JOIN promocode prmo ON prmo.vehicletype_id=vt.id
     	    INNER JOIN tbl_fare f ON f.vehicle_type=vt.id WHERE vt.status=1 AND d.is_online=1 AND d.status=1
     	    
     	    AND tmp.distance <= '5' GROUP BY vt.id ORDER BY tmp.distance,f.per_km ASC
ERROR - 2024-12-16 17:10:45 --> Query error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.b.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT b.*,DATE_FORMAT(b.entry_date,'%d/%m/%Y %H:%i %p') AS entrydate,
            tbc.selecteddate,tbc.selectedtime,tu.f_name,tu.mobile_no,tu.email_id
            FROM tbl_booking b
            INNER JOIN tbl_userwise_cabrequest tbc ON tbc.user_id=b.user_id 
            INNER JOIN tbl_user tu ON tu.id=b.user_id 
            WHERE tbc.status=0 AND b.user_id='15' GROUP BY b.book_id ORDER BY b.id DESC
ERROR - 2024-12-16 17:10:55 --> Query error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.b.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT b.*,DATE_FORMAT(b.entry_date,'%d/%m/%Y %H:%i %p') AS entrydate,
            tbc.selecteddate,tbc.selectedtime,tu.f_name,tu.mobile_no,tu.email_id
            FROM tbl_booking b
            INNER JOIN tbl_userwise_cabrequest tbc ON tbc.user_id=b.user_id 
            INNER JOIN tbl_user tu ON tu.id=b.user_id 
            WHERE tbc.status=0 AND b.user_id='15' GROUP BY b.book_id ORDER BY b.id DESC
ERROR - 2024-12-16 17:10:56 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.d.curr_lat' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT tmp.*,vt.id,vt.image,vt.name,vt.description,vt.type,
		    prmo.promo_code_discount,prmo.status as promo_status,tmp.curr_lat,tmp.curr_long,
		    f.per_km FROM (SELECT driver_id,curr_lat, curr_long,
    	    round(( 6371 * acos( cos( radians(round(24.854975080601,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(74.612969195319,2)) ) + sin( radians(round(24.854975080601,2)) ) * sin( radians(curr_lat) ) ) )) AS distance
    	    FROM tbl_driver_currentLocation d GROUP BY driver_id) AS tmp
    	    INNER JOIN tbl_driver d ON d.id=tmp.driver_id
    	    INNER JOIN tbl_vehicle tv ON tv.driver_id=d.id
     	    INNER JOIN tbl_map_vehicletype dmt ON dmt.vehicle_id=tv.id
     	    INNER JOIN tbl_vehicletype vt ON vt.id=dmt.type_id
     	    INNER JOIN promocode prmo ON prmo.vehicletype_id=vt.id
     	    INNER JOIN tbl_fare f ON f.vehicle_type=vt.id WHERE vt.status=1 AND d.is_online=1 AND d.status=1
     	    
     	    AND tmp.distance <= '5' GROUP BY vt.id ORDER BY tmp.distance,f.per_km ASC
ERROR - 2024-12-16 17:30:30 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.d.curr_lat' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT tmp.*,vt.id,vt.image,vt.name,vt.description,vt.type,
		    prmo.promo_code_discount,prmo.status as promo_status,tmp.curr_lat,tmp.curr_long,
		    f.per_km FROM (SELECT driver_id,curr_lat, curr_long,
    	    round(( 6371 * acos( cos( radians(round(24.854975080601,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(74.612969195319,2)) ) + sin( radians(round(24.854975080601,2)) ) * sin( radians(curr_lat) ) ) )) AS distance
    	    FROM tbl_driver_currentLocation d GROUP BY driver_id) AS tmp
    	    INNER JOIN tbl_driver d ON d.id=tmp.driver_id
    	    INNER JOIN tbl_vehicle tv ON tv.driver_id=d.id
     	    INNER JOIN tbl_map_vehicletype dmt ON dmt.vehicle_id=tv.id
     	    INNER JOIN tbl_vehicletype vt ON vt.id=dmt.type_id
     	    INNER JOIN promocode prmo ON prmo.vehicletype_id=vt.id
     	    INNER JOIN tbl_fare f ON f.vehicle_type=vt.id WHERE vt.status=1 AND d.is_online=1 AND d.status=1
     	    
     	    AND tmp.distance <= '5' GROUP BY vt.id ORDER BY tmp.distance,f.per_km ASC
ERROR - 2024-12-16 17:30:30 --> Query error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.b.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT b.*,DATE_FORMAT(b.entry_date,'%d/%m/%Y %H:%i %p') AS entrydate,
            tbc.selecteddate,tbc.selectedtime,tu.f_name,tu.mobile_no,tu.email_id
            FROM tbl_booking b
            INNER JOIN tbl_userwise_cabrequest tbc ON tbc.user_id=b.user_id 
            INNER JOIN tbl_user tu ON tu.id=b.user_id 
            WHERE tbc.status=0 AND b.user_id='15' GROUP BY b.book_id ORDER BY b.id DESC
ERROR - 2024-12-16 17:33:09 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.d.curr_lat' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT tmp.*,vt.id,vt.image,vt.name,vt.description,vt.type,
		    prmo.promo_code_discount,prmo.status as promo_status,tmp.curr_lat,tmp.curr_long,
		    f.per_km FROM (SELECT driver_id,curr_lat, curr_long,
    	    round(( 6371 * acos( cos( radians(round(24.854975080601,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(74.612969195319,2)) ) + sin( radians(round(24.854975080601,2)) ) * sin( radians(curr_lat) ) ) )) AS distance
    	    FROM tbl_driver_currentLocation d GROUP BY driver_id) AS tmp
    	    INNER JOIN tbl_driver d ON d.id=tmp.driver_id
    	    INNER JOIN tbl_vehicle tv ON tv.driver_id=d.id
     	    INNER JOIN tbl_map_vehicletype dmt ON dmt.vehicle_id=tv.id
     	    INNER JOIN tbl_vehicletype vt ON vt.id=dmt.type_id
     	    INNER JOIN promocode prmo ON prmo.vehicletype_id=vt.id
     	    INNER JOIN tbl_fare f ON f.vehicle_type=vt.id WHERE vt.status=1 AND d.is_online=1 AND d.status=1
     	    
     	    AND tmp.distance <= '5' GROUP BY vt.id ORDER BY tmp.distance,f.per_km ASC
ERROR - 2024-12-16 17:33:09 --> Query error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.b.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT b.*,DATE_FORMAT(b.entry_date,'%d/%m/%Y %H:%i %p') AS entrydate,
            tbc.selecteddate,tbc.selectedtime,tu.f_name,tu.mobile_no,tu.email_id
            FROM tbl_booking b
            INNER JOIN tbl_userwise_cabrequest tbc ON tbc.user_id=b.user_id 
            INNER JOIN tbl_user tu ON tu.id=b.user_id 
            WHERE tbc.status=0 AND b.user_id='15' GROUP BY b.book_id ORDER BY b.id DESC
ERROR - 2024-12-16 17:38:22 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.d.curr_lat' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT tmp.*,vt.id,vt.image,vt.name,vt.description,vt.type,
		    prmo.promo_code_discount,prmo.status as promo_status,tmp.curr_lat,tmp.curr_long,
		    f.per_km FROM (SELECT driver_id,curr_lat, curr_long,
    	    round(( 6371 * acos( cos( radians(round(24.854975080601,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(74.612969195319,2)) ) + sin( radians(round(24.854975080601,2)) ) * sin( radians(curr_lat) ) ) )) AS distance
    	    FROM tbl_driver_currentLocation d GROUP BY driver_id) AS tmp
    	    INNER JOIN tbl_driver d ON d.id=tmp.driver_id
    	    INNER JOIN tbl_vehicle tv ON tv.driver_id=d.id
     	    INNER JOIN tbl_map_vehicletype dmt ON dmt.vehicle_id=tv.id
     	    INNER JOIN tbl_vehicletype vt ON vt.id=dmt.type_id
     	    INNER JOIN promocode prmo ON prmo.vehicletype_id=vt.id
     	    INNER JOIN tbl_fare f ON f.vehicle_type=vt.id WHERE vt.status=1 AND d.is_online=1 AND d.status=1
     	    
     	    AND tmp.distance <= '5' GROUP BY vt.id ORDER BY tmp.distance,f.per_km ASC
ERROR - 2024-12-16 17:38:22 --> Query error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.b.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT b.*,DATE_FORMAT(b.entry_date,'%d/%m/%Y %H:%i %p') AS entrydate,
            tbc.selecteddate,tbc.selectedtime,tu.f_name,tu.mobile_no,tu.email_id
            FROM tbl_booking b
            INNER JOIN tbl_userwise_cabrequest tbc ON tbc.user_id=b.user_id 
            INNER JOIN tbl_user tu ON tu.id=b.user_id 
            WHERE tbc.status=0 AND b.user_id='15' GROUP BY b.book_id ORDER BY b.id DESC
ERROR - 2024-12-16 17:46:38 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.d.curr_lat' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT tmp.*,vt.id,vt.image,vt.name,vt.description,vt.type,
		    prmo.promo_code_discount,prmo.status as promo_status,tmp.curr_lat,tmp.curr_long,
		    f.per_km FROM (SELECT driver_id,curr_lat, curr_long,
    	    round(( 6371 * acos( cos( radians(round(30.368341,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(78.0516939,2)) ) + sin( radians(round(30.368341,2)) ) * sin( radians(curr_lat) ) ) )) AS distance
    	    FROM tbl_driver_currentLocation d GROUP BY driver_id) AS tmp
    	    INNER JOIN tbl_driver d ON d.id=tmp.driver_id
    	    INNER JOIN tbl_vehicle tv ON tv.driver_id=d.id
     	    INNER JOIN tbl_map_vehicletype dmt ON dmt.vehicle_id=tv.id
     	    INNER JOIN tbl_vehicletype vt ON vt.id=dmt.type_id
     	    INNER JOIN promocode prmo ON prmo.vehicletype_id=vt.id
     	    INNER JOIN tbl_fare f ON f.vehicle_type=vt.id WHERE vt.status=1 AND d.is_online=1 AND d.status=1
     	    
     	    AND tmp.distance <= '5' GROUP BY vt.id ORDER BY tmp.distance,f.per_km ASC
ERROR - 2024-12-16 17:50:08 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.d.curr_lat' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT tmp.*,vt.id,vt.image,vt.name,vt.description,vt.type,
		    prmo.promo_code_discount,prmo.status as promo_status,tmp.curr_lat,tmp.curr_long,
		    f.per_km FROM (SELECT driver_id,curr_lat, curr_long,
    	    round(( 6371 * acos( cos( radians(round(24.854975080601,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(74.612969195319,2)) ) + sin( radians(round(24.854975080601,2)) ) * sin( radians(curr_lat) ) ) )) AS distance
    	    FROM tbl_driver_currentLocation d GROUP BY driver_id) AS tmp
    	    INNER JOIN tbl_driver d ON d.id=tmp.driver_id
    	    INNER JOIN tbl_vehicle tv ON tv.driver_id=d.id
     	    INNER JOIN tbl_map_vehicletype dmt ON dmt.vehicle_id=tv.id
     	    INNER JOIN tbl_vehicletype vt ON vt.id=dmt.type_id
     	    INNER JOIN promocode prmo ON prmo.vehicletype_id=vt.id
     	    INNER JOIN tbl_fare f ON f.vehicle_type=vt.id WHERE vt.status=1 AND d.is_online=1 AND d.status=1
     	    
     	    AND tmp.distance <= '5' GROUP BY vt.id ORDER BY tmp.distance,f.per_km ASC
ERROR - 2024-12-16 17:50:08 --> Query error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.b.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT b.*,DATE_FORMAT(b.entry_date,'%d/%m/%Y %H:%i %p') AS entrydate,
            tbc.selecteddate,tbc.selectedtime,tu.f_name,tu.mobile_no,tu.email_id
            FROM tbl_booking b
            INNER JOIN tbl_userwise_cabrequest tbc ON tbc.user_id=b.user_id 
            INNER JOIN tbl_user tu ON tu.id=b.user_id 
            WHERE tbc.status=0 AND b.user_id='15' GROUP BY b.book_id ORDER BY b.id DESC
ERROR - 2024-12-16 17:52:23 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.d.curr_lat' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT tmp.*,vt.id,vt.image,vt.name,vt.description,vt.type,
		    prmo.promo_code_discount,prmo.status as promo_status,tmp.curr_lat,tmp.curr_long,
		    f.per_km FROM (SELECT driver_id,curr_lat, curr_long,
    	    round(( 6371 * acos( cos( radians(round(24.854975080601,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(74.612969195319,2)) ) + sin( radians(round(24.854975080601,2)) ) * sin( radians(curr_lat) ) ) )) AS distance
    	    FROM tbl_driver_currentLocation d GROUP BY driver_id) AS tmp
    	    INNER JOIN tbl_driver d ON d.id=tmp.driver_id
    	    INNER JOIN tbl_vehicle tv ON tv.driver_id=d.id
     	    INNER JOIN tbl_map_vehicletype dmt ON dmt.vehicle_id=tv.id
     	    INNER JOIN tbl_vehicletype vt ON vt.id=dmt.type_id
     	    INNER JOIN promocode prmo ON prmo.vehicletype_id=vt.id
     	    INNER JOIN tbl_fare f ON f.vehicle_type=vt.id WHERE vt.status=1 AND d.is_online=1 AND d.status=1
     	    
     	    AND tmp.distance <= '5' GROUP BY vt.id ORDER BY tmp.distance,f.per_km ASC
ERROR - 2024-12-16 17:52:23 --> Query error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.b.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT b.*,DATE_FORMAT(b.entry_date,'%d/%m/%Y %H:%i %p') AS entrydate,
            tbc.selecteddate,tbc.selectedtime,tu.f_name,tu.mobile_no,tu.email_id
            FROM tbl_booking b
            INNER JOIN tbl_userwise_cabrequest tbc ON tbc.user_id=b.user_id 
            INNER JOIN tbl_user tu ON tu.id=b.user_id 
            WHERE tbc.status=0 AND b.user_id='15' GROUP BY b.book_id ORDER BY b.id DESC
ERROR - 2024-12-16 18:05:10 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.d.curr_lat' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT tmp.*,vt.id,vt.image,vt.name,vt.description,vt.type,
		    prmo.promo_code_discount,prmo.status as promo_status,tmp.curr_lat,tmp.curr_long,
		    f.per_km FROM (SELECT driver_id,curr_lat, curr_long,
    	    round(( 6371 * acos( cos( radians(round(30.368341,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(78.0516939,2)) ) + sin( radians(round(30.368341,2)) ) * sin( radians(curr_lat) ) ) )) AS distance
    	    FROM tbl_driver_currentLocation d GROUP BY driver_id) AS tmp
    	    INNER JOIN tbl_driver d ON d.id=tmp.driver_id
    	    INNER JOIN tbl_vehicle tv ON tv.driver_id=d.id
     	    INNER JOIN tbl_map_vehicletype dmt ON dmt.vehicle_id=tv.id
     	    INNER JOIN tbl_vehicletype vt ON vt.id=dmt.type_id
     	    INNER JOIN promocode prmo ON prmo.vehicletype_id=vt.id
     	    INNER JOIN tbl_fare f ON f.vehicle_type=vt.id WHERE vt.status=1 AND d.is_online=1 AND d.status=1
     	    
     	    AND tmp.distance <= '5' GROUP BY vt.id ORDER BY tmp.distance,f.per_km ASC
ERROR - 2024-12-16 18:05:16 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.d.curr_lat' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT tmp.*,vt.id,vt.image,vt.name,vt.description,vt.type,
		    prmo.promo_code_discount,prmo.status as promo_status,tmp.curr_lat,tmp.curr_long,
		    f.per_km FROM (SELECT driver_id,curr_lat, curr_long,
    	    round(( 6371 * acos( cos( radians(round(24.854975080601,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(74.612969195319,2)) ) + sin( radians(round(24.854975080601,2)) ) * sin( radians(curr_lat) ) ) )) AS distance
    	    FROM tbl_driver_currentLocation d GROUP BY driver_id) AS tmp
    	    INNER JOIN tbl_driver d ON d.id=tmp.driver_id
    	    INNER JOIN tbl_vehicle tv ON tv.driver_id=d.id
     	    INNER JOIN tbl_map_vehicletype dmt ON dmt.vehicle_id=tv.id
     	    INNER JOIN tbl_vehicletype vt ON vt.id=dmt.type_id
     	    INNER JOIN promocode prmo ON prmo.vehicletype_id=vt.id
     	    INNER JOIN tbl_fare f ON f.vehicle_type=vt.id WHERE vt.status=1 AND d.is_online=1 AND d.status=1
     	    
     	    AND tmp.distance <= '5' GROUP BY vt.id ORDER BY tmp.distance,f.per_km ASC
ERROR - 2024-12-16 18:05:16 --> Query error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.b.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT b.*,DATE_FORMAT(b.entry_date,'%d/%m/%Y %H:%i %p') AS entrydate,
            tbc.selecteddate,tbc.selectedtime,tu.f_name,tu.mobile_no,tu.email_id
            FROM tbl_booking b
            INNER JOIN tbl_userwise_cabrequest tbc ON tbc.user_id=b.user_id 
            INNER JOIN tbl_user tu ON tu.id=b.user_id 
            WHERE tbc.status=0 AND b.user_id='15' GROUP BY b.book_id ORDER BY b.id DESC
ERROR - 2024-12-16 18:16:04 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.d.curr_lat' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT tmp.*,vt.id,vt.image,vt.name,vt.description,vt.type,
		    prmo.promo_code_discount,prmo.status as promo_status,tmp.curr_lat,tmp.curr_long,
		    f.per_km FROM (SELECT driver_id,curr_lat, curr_long,
    	    round(( 6371 * acos( cos( radians(round(24.854975080601,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(74.612969195319,2)) ) + sin( radians(round(24.854975080601,2)) ) * sin( radians(curr_lat) ) ) )) AS distance
    	    FROM tbl_driver_currentLocation d GROUP BY driver_id) AS tmp
    	    INNER JOIN tbl_driver d ON d.id=tmp.driver_id
    	    INNER JOIN tbl_vehicle tv ON tv.driver_id=d.id
     	    INNER JOIN tbl_map_vehicletype dmt ON dmt.vehicle_id=tv.id
     	    INNER JOIN tbl_vehicletype vt ON vt.id=dmt.type_id
     	    INNER JOIN promocode prmo ON prmo.vehicletype_id=vt.id
     	    INNER JOIN tbl_fare f ON f.vehicle_type=vt.id WHERE vt.status=1 AND d.is_online=1 AND d.status=1
     	    
     	    AND tmp.distance <= '5' GROUP BY vt.id ORDER BY tmp.distance,f.per_km ASC
ERROR - 2024-12-16 18:16:04 --> Query error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.b.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT b.*,DATE_FORMAT(b.entry_date,'%d/%m/%Y %H:%i %p') AS entrydate,
            tbc.selecteddate,tbc.selectedtime,tu.f_name,tu.mobile_no,tu.email_id
            FROM tbl_booking b
            INNER JOIN tbl_userwise_cabrequest tbc ON tbc.user_id=b.user_id 
            INNER JOIN tbl_user tu ON tu.id=b.user_id 
            WHERE tbc.status=0 AND b.user_id='15' GROUP BY b.book_id ORDER BY b.id DESC
