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

ERROR - 2025-04-11 10:50:14 --> Severity: Notice --> Undefined variable: name /home/akshay/public_html/cab/application/controllers/Api/DriverApi/DriverController.php 64
ERROR - 2025-04-11 12:29: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.*,d.id as driver_id,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(18.516916,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(73.8471036,2)) ) + sin( radians(round(18.516916,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 - 2025-04-11 12:29:57 --> 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.*,d.id as driver_id,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(18.516916129879,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(73.847103640437,2)) ) + sin( radians(round(18.516916129879,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 - 2025-04-11 12:35: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.*,d.id as driver_id,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(18.5169068,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(73.8471079,2)) ) + sin( radians(round(18.5169068,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 - 2025-04-11 12:35: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.*,d.id as driver_id,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(18.516906910232,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(73.847107999027,2)) ) + sin( radians(round(18.516906910232,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 - 2025-04-11 12:44:09 --> Severity: Notice --> Undefined variable: name /home/akshay/public_html/cab/application/controllers/Api/DriverApi/DriverController.php 64
ERROR - 2025-04-11 15:21: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.*,d.id as driver_id,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(25.8884683,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(83.1496562,2)) ) + sin( radians(round(25.8884683,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 - 2025-04-11 15:22:25 --> 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.*,d.id as driver_id,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(25.8884683,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(83.1496562,2)) ) + sin( radians(round(25.8884683,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 - 2025-04-11 15:22:26 --> 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.*,d.id as driver_id,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(25.888468366425,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(83.149656280875,2)) ) + sin( radians(round(25.888468366425,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 - 2025-04-11 15:26:12 --> 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.*,d.id as driver_id,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(25.8879353,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(83.1476559,2)) ) + sin( radians(round(25.8879353,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 - 2025-04-11 15:26:13 --> 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.*,d.id as driver_id,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(25.887935385512,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(83.147656023502,2)) ) + sin( radians(round(25.887935385512,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 - 2025-04-11 15:38:32 --> 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.*,d.id as driver_id,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(25.8879349,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(83.1476543,2)) ) + sin( radians(round(25.8879349,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 - 2025-04-11 15:38: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.*,d.id as driver_id,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(25.887934782249,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(83.147654347122,2)) ) + sin( radians(round(25.887934782249,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 - 2025-04-11 16:08: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.*,d.id as driver_id,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(25.8878382,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(83.1477554,2)) ) + sin( radians(round(25.8878382,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 - 2025-04-11 16:08:59 --> 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.*,d.id as driver_id,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(25.887838260264,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(83.147755265236,2)) ) + sin( radians(round(25.887838260264,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 - 2025-04-11 16:24:35 --> 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.*,d.id as driver_id,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(25.8879919,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(83.1477193,2)) ) + sin( radians(round(25.8879919,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 - 2025-04-11 16:24: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.*,d.id as driver_id,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(25.88799179051,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(83.14771939069,2)) ) + sin( radians(round(25.88799179051,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 - 2025-04-11 16:30:52 --> 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.*,d.id as driver_id,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(25.8879739,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(83.1476547,2)) ) + sin( radians(round(25.8879739,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 - 2025-04-11 16:31:17 --> 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.*,d.id as driver_id,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(25.8878942,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(83.1476039,2)) ) + sin( radians(round(25.8878942,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 - 2025-04-11 16:31: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.*,d.id as driver_id,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(25.887894062047,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(83.147604055703,2)) ) + sin( radians(round(25.887894062047,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 - 2025-04-11 17:34: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.*,d.id as driver_id,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(25.8880936,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(83.1475572,2)) ) + sin( radians(round(25.8880936,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 - 2025-04-11 17:34:11 --> 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.*,d.id as driver_id,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(25.888093741722,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(83.147557117045,2)) ) + sin( radians(round(25.888093741722,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 - 2025-04-11 17:50:24 --> 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.*,d.id as driver_id,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(25.8884683,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(83.1496562,2)) ) + sin( radians(round(25.8884683,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 - 2025-04-11 17:50:25 --> 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.*,d.id as driver_id,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(25.888468366425,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(83.149656280875,2)) ) + sin( radians(round(25.888468366425,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 - 2025-04-11 18:36: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.*,d.id as driver_id,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(25.8878751,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(83.1474222,2)) ) + sin( radians(round(25.8878751,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
