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

ERROR - 2025-03-27 10:41: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(24.8566943,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(74.6126292,2)) ) + sin( radians(round(24.8566943,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-03-27 11:35: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.*,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(24.8566993,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(74.6126393,2)) ) + sin( radians(round(24.8566993,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-03-27 11:36: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(24.8567073,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(74.6126317,2)) ) + sin( radians(round(24.8567073,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-03-27 11:37: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,vt.name as vehicle_name,
                    tbc.selecteddate,tbc.selectedtime,tu.f_name,tu.mobile_no,tu.email_id
                    FROM tbl_booking b
                    INNER JOIN tbl_vehicletype vt ON vt.id=b.type_id 
                    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 b.user_id='User-00841432'  AND b.ride_status='2' GROUP BY b.book_id ORDER BY b.id DESC LIMIT 0,10
ERROR - 2025-03-27 11:37:48 --> 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,vt.name as vehicle_name,
                    tbc.selecteddate,tbc.selectedtime,tu.f_name,tu.mobile_no,tu.email_id
                    FROM tbl_booking b
                    INNER JOIN tbl_vehicletype vt ON vt.id=b.type_id 
                    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 b.user_id='User-00841432'  AND b.ride_status='2' GROUP BY b.book_id ORDER BY b.id DESC LIMIT 0,10
ERROR - 2025-03-27 11:45:47 --> 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(24.8570443,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(74.6126224,2)) ) + sin( radians(round(24.8570443,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-03-27 13:20:47 --> Severity: Notice --> Undefined variable: name /home/akshay/public_html/cab/application/controllers/Api/DriverApi/DriverController.php 64
ERROR - 2025-03-27 13:27: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(24.8567799,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(74.6122013,2)) ) + sin( radians(round(24.8567799,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-03-27 13:28: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(24.8568468,2)) ) * cos( radians(curr_lat) ) *
            cos( radians(curr_long) - radians(round(74.6122508,2)) ) + sin( radians(round(24.8568468,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-03-27 13:54:04 --> 404 Page Not Found: Admin/index
ERROR - 2025-03-27 13:54:44 --> Query error: Expression #46 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'akshay_cab_db.tv.number' 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.* FROM ( SELECT v.*,d.driver_name, tv.number,d.driver_id AS driverid,GROUP_CONCAT(t.name) AS type
          FROM tbl_booking v
          INNER JOIN tbl_driver d ON d.id=v.driver_id
          INNER JOIN tbl_vehicle tv ON tv.driver_id = v.driver_id
          INNER JOIN tbl_vehicletype t ON t.id=v.type_id
          WHERE v.ride_status LIKE '%'  GROUP BY v.id ) AS tmp  ORDER BY tmp.id DESC
ERROR - 2025-03-27 17:06:31 --> 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, vt.seat, f.per_km 
				FROM (
					SELECT driver_id,
						ROUND((6371 * ACOS(
							COS(RADIANS(ROUND(21.2340229,2))) * COS(RADIANS(curr_lat)) *
							COS(RADIANS(curr_long) - RADIANS(ROUND(72.8168875,2))) + 
							SIN(RADIANS(ROUND(21.2340229,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
