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

ERROR - 2026-02-24 10:16:50 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cabdb.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,tmp.curr_lat,tmp.curr_long,
		    f.per_km FROM (SELECT driver_id,curr_lat, curr_long,
    	    round(( 6371 * acos( cos( radians(round(28.5292833,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(77.4709402,2)) ) + sin( radians(round(28.5292833,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 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 <= d.pickup_radius GROUP BY vt.id ORDER BY tmp.distance,f.per_km ASC
ERROR - 2026-02-24 10:17:07 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cabdb.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, vt.seat, f.per_km 
				FROM (
					SELECT driver_id,
						ROUND((6371 * ACOS(
							COS(RADIANS(ROUND(28.529283254223,2))) * COS(RADIANS(curr_lat)) *
							COS(RADIANS(curr_long) - RADIANS(ROUND(77.470940351486,2))) + 
							SIN(RADIANS(ROUND(28.529283254223,2))) * SIN(RADIANS(curr_lat))
						)), 2) 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 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 <= d.pickup_radius 
				GROUP BY vt.id 
				ORDER BY tmp.distance, f.per_km ASC
ERROR - 2026-02-24 10:17:26 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cabdb.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,tmp.curr_lat,tmp.curr_long,
		    f.per_km FROM (SELECT driver_id,curr_lat, curr_long,
    	    round(( 6371 * acos( cos( radians(round(28.5292775,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(77.4709366,2)) ) + sin( radians(round(28.5292775,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 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 <= d.pickup_radius GROUP BY vt.id ORDER BY tmp.distance,f.per_km ASC
ERROR - 2026-02-24 10:17:44 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cabdb.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, vt.seat, f.per_km 
				FROM (
					SELECT driver_id,
						ROUND((6371 * ACOS(
							COS(RADIANS(ROUND(28.529277362931,2))) * COS(RADIANS(curr_lat)) *
							COS(RADIANS(curr_long) - RADIANS(ROUND(77.470936663449,2))) + 
							SIN(RADIANS(ROUND(28.529277362931,2))) * SIN(RADIANS(curr_lat))
						)), 2) 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 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 <= d.pickup_radius 
				GROUP BY vt.id 
				ORDER BY tmp.distance, f.per_km ASC
ERROR - 2026-02-24 10:19:10 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cabdb.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, vt.seat, f.per_km 
				FROM (
					SELECT driver_id,
						ROUND((6371 * ACOS(
							COS(RADIANS(ROUND(28.529277362931,2))) * COS(RADIANS(curr_lat)) *
							COS(RADIANS(curr_long) - RADIANS(ROUND(77.470936663449,2))) + 
							SIN(RADIANS(ROUND(28.529277362931,2))) * SIN(RADIANS(curr_lat))
						)), 2) 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 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 <= d.pickup_radius 
				GROUP BY vt.id 
				ORDER BY tmp.distance, f.per_km ASC
ERROR - 2026-02-24 10:19:24 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cabdb.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,tmp.curr_lat,tmp.curr_long,
		    f.per_km FROM (SELECT driver_id,curr_lat, curr_long,
    	    round(( 6371 * acos( cos( radians(round(28.5292838,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(77.4709253,2)) ) + sin( radians(round(28.5292838,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 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 <= d.pickup_radius GROUP BY vt.id ORDER BY tmp.distance,f.per_km ASC
ERROR - 2026-02-24 10:19:36 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cabdb.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, vt.seat, f.per_km 
				FROM (
					SELECT driver_id,
						ROUND((6371 * ACOS(
							COS(RADIANS(ROUND(28.529283843352,2))) * COS(RADIANS(curr_lat)) *
							COS(RADIANS(curr_long) - RADIANS(ROUND(77.47092526406,2))) + 
							SIN(RADIANS(ROUND(28.529283843352,2))) * SIN(RADIANS(curr_lat))
						)), 2) 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 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 <= d.pickup_radius 
				GROUP BY vt.id 
				ORDER BY tmp.distance, f.per_km ASC
ERROR - 2026-02-24 10:19:41 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cabdb.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, vt.seat, f.per_km 
				FROM (
					SELECT driver_id,
						ROUND((6371 * ACOS(
							COS(RADIANS(ROUND(28.529283843352,2))) * COS(RADIANS(curr_lat)) *
							COS(RADIANS(curr_long) - RADIANS(ROUND(77.47092526406,2))) + 
							SIN(RADIANS(ROUND(28.529283843352,2))) * SIN(RADIANS(curr_lat))
						)), 2) 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 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 <= d.pickup_radius 
				GROUP BY vt.id 
				ORDER BY tmp.distance, f.per_km ASC
ERROR - 2026-02-24 10:19:44 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cabdb.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, vt.seat, f.per_km 
				FROM (
					SELECT driver_id,
						ROUND((6371 * ACOS(
							COS(RADIANS(ROUND(28.529283843352,2))) * COS(RADIANS(curr_lat)) *
							COS(RADIANS(curr_long) - RADIANS(ROUND(77.47092526406,2))) + 
							SIN(RADIANS(ROUND(28.529283843352,2))) * SIN(RADIANS(curr_lat))
						)), 2) 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 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 <= d.pickup_radius 
				GROUP BY vt.id 
				ORDER BY tmp.distance, f.per_km ASC
ERROR - 2026-02-24 10:19:59 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cabdb.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,tmp.curr_lat,tmp.curr_long,
		    f.per_km FROM (SELECT driver_id,curr_lat, curr_long,
    	    round(( 6371 * acos( cos( radians(round(28.5292764,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(77.4709161,2)) ) + sin( radians(round(28.5292764,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 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 <= d.pickup_radius GROUP BY vt.id ORDER BY tmp.distance,f.per_km ASC
ERROR - 2026-02-24 10:20:11 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cabdb.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, vt.seat, f.per_km 
				FROM (
					SELECT driver_id,
						ROUND((6371 * ACOS(
							COS(RADIANS(ROUND(28.5284465,2))) * COS(RADIANS(curr_lat)) *
							COS(RADIANS(curr_long) - RADIANS(ROUND(77.470392,2))) + 
							SIN(RADIANS(ROUND(28.5284465,2))) * SIN(RADIANS(curr_lat))
						)), 2) 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 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 <= d.pickup_radius 
				GROUP BY vt.id 
				ORDER BY tmp.distance, f.per_km ASC
ERROR - 2026-02-24 10:21:26 --> Query error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cabdb.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, vt.seat, f.per_km 
				FROM (
					SELECT driver_id,
						ROUND((6371 * ACOS(
							COS(RADIANS(ROUND(28.5284465,2))) * COS(RADIANS(curr_lat)) *
							COS(RADIANS(curr_long) - RADIANS(ROUND(77.470392,2))) + 
							SIN(RADIANS(ROUND(28.5284465,2))) * SIN(RADIANS(curr_lat))
						)), 2) 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 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 <= d.pickup_radius 
				GROUP BY vt.id 
				ORDER BY tmp.distance, f.per_km ASC
