Time : 18:13:36 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ': 10485, customer_name: Pallavi S, email_addr: sp530660@gmail.com, phone_number:' at line 1 Raw SQL : SELECT * FROM rt_bookings_pt_ft WHERE booking_status='Advance Paid' and user_id={id: 10485, customer_name: Pallavi S, email_addr: sp530660@gmail.com, phone_number: 8148387800, new_user: 0, pswd: , customer_address: 36, customer_area: , landmark: null, city: 32, 2nd Main Rd, Gopalappa Layout, Lakkasandra, Rangaswamy Layout, Wilson Garden, Bengaluru, Karnata, state: 0, zip_code: null, latitude: 12.9420665, longitude: 77.6016653, status: 1, android_device_id: fOBWA7ZISRGOvpIODPRJ1J:APA91bFdz5wz6EXGqLZQ1SDN-3Bu55Y4wpETOJzgU5h7BPY1Jp4lxqH19UjX0l5CE1O71kjqz3AJxycWmPDFlftqJZ8SdIVy9LnbEo7moP28NoMmJ_1tiBfvZLAIEqEVgIfDBUc2WRTG, ios_device_id: fOBWA7ZISRGOvpIODPRJ1J:APA91bFdz5wz6EXGqLZQ1SDN-3Bu55Y4wpETOJzgU5h7BPY1Jp4lxqH19UjX0l5CE1O71kjqz3AJxycWmPDFlftqJZ8SdIVy9LnbEo7moP28NoMmJ_1tiBfvZLAIEqEVgIfDBUc2WRTG, created_at: 2024-01-12 04:05:25, updated_at: 2024-01-12 04:05:25} Time : 15:19:31 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'entered email already exist.' at line 1 Raw SQL : SELECT * FROM rt_bookings_pt_ft WHERE booking_status='Advance Paid' and user_id=User with entered email already exist. Time : 13:20:49 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'provider_id' in 'where clause' Raw SQL : UPDATE rt_service_providers SET latitude=?,longitude=?,provider_area=?,city=? WHERE provider_id = ? Time : 13:20:33 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'provider_id' in 'where clause' Raw SQL : UPDATE rt_service_providers SET latitude=?,longitude=?,provider_area=?,city=? WHERE provider_id = ? Time : 13:20:32 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'provider_id' in 'where clause' Raw SQL : UPDATE rt_service_providers SET latitude=?,longitude=?,provider_area=?,city=? WHERE provider_id = ? Time : 13:20:25 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'provider_id' in 'where clause' Raw SQL : UPDATE rt_service_providers SET latitude=?,longitude=?,provider_area=?,city=? WHERE provider_id = ? Time : 13:20:25 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'provider_id' in 'where clause' Raw SQL : UPDATE rt_service_providers SET latitude=?,longitude=?,provider_area=?,city=? WHERE provider_id = ? Time : 13:19:50 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'provider_id' in 'where clause' Raw SQL : UPDATE rt_service_providers SET latitude=?,longitude=?,provider_area=?,city=? WHERE provider_id = ? Time : 13:19:33 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'provider_id' in 'where clause' Raw SQL : UPDATE rt_service_providers SET latitude=?,longitude=?,provider_area=?,city=? WHERE provider_id = ? Time : 12:51:57 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Raw SQL : SELECT * from category where id= Time : 12:50:56 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Raw SQL : SELECT * from category where id= Time : 12:49:08 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Raw SQL : SELECT * from category where id= Time : 12:48:57 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Raw SQL : SELECT * from category where id= Time : 12:48:30 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Raw SQL : SELECT * from category where id= Time : 12:48:10 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Raw SQL : SELECT * from rt_sub_category where id= Time : 12:47:38 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'int)7' at line 1 Raw SQL : SELECT * from rt_sub_category where id=(int)7 Time : 12:46:44 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Raw SQL : SELECT * from rt_sub_category where id= Time : 12:44:04 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 Raw SQL : SELECT * from rt_sub_category where id IN () Time : 12:43:36 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Raw SQL : SELECT * from category where id= Time : 12:43:06 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Raw SQL : SELECT * from category where id= Time : 12:42:29 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 Raw SQL : SELECT * from rt_sub_category where id IN () Time : 12:42:19 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 Raw SQL : SELECT * from rt_sub_category where id IN () Time : 12:41:28 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Raw SQL : SELECT * from category where id= Time : 12:40:51 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 Raw SQL : SELECT * from rt_sub_category where id IN () Time : 12:40:15 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 Raw SQL : SELECT * from rt_sub_category where id IN () Time : 12:40:15 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 Raw SQL : SELECT * from rt_sub_category where id IN () Time : 12:39:33 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 Raw SQL : SELECT * from rt_sub_category where id IN () Time : 11:22:02 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 Raw SQL : SELECT * from rt_sub_category where id IN () Time : 11:21:49 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 Raw SQL : SELECT * from rt_sub_category where id IN () Time : 09:50:08 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'entered email already exist.' at line 1 Raw SQL : SELECT * FROM rt_bookings_pt_ft WHERE booking_status='Advance Paid' and user_id=User with entered email already exist. Time : 09:49:49 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'entered email already exist.' at line 1 Raw SQL : SELECT * FROM rt_bookings_pt_ft WHERE booking_status='Advance Paid' and user_id=User with entered email already exist. Time : 09:49:39 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'entered email already exist.' at line 1 Raw SQL : SELECT * FROM rt_bookings_pt_ft WHERE booking_status='Advance Paid' and user_id=User with entered email already exist. Time : 09:49:36 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'entered email already exist.' at line 1 Raw SQL : SELECT * FROM rt_bookings_pt_ft WHERE booking_status='Advance Paid' and user_id=User with entered email already exist. Time : 09:49:36 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'entered email already exist.' at line 1 Raw SQL : SELECT * FROM rt_bookings_pt_ft WHERE booking_status='Advance Paid' and user_id=User with entered email already exist. Time : 09:49:35 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'entered email already exist.' at line 1 Raw SQL : SELECT * FROM rt_bookings_pt_ft WHERE booking_status='Advance Paid' and user_id=User with entered email already exist. Time : 09:49:35 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'entered email already exist.' at line 1 Raw SQL : SELECT * FROM rt_bookings_pt_ft WHERE booking_status='Advance Paid' and user_id=User with entered email already exist. Time : 09:49:34 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'entered email already exist.' at line 1 Raw SQL : SELECT * FROM rt_bookings_pt_ft WHERE booking_status='Advance Paid' and user_id=User with entered email already exist. Time : 09:49:31 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'entered email already exist.' at line 1 Raw SQL : SELECT * FROM rt_bookings_pt_ft WHERE booking_status='Advance Paid' and user_id=User with entered email already exist. Time : 09:48:57 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'entered email already exist.' at line 1 Raw SQL : SELECT * FROM rt_bookings_pt_ft WHERE booking_status='Advance Paid' and user_id=User with entered email already exist. Time : 07:55:07 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Raw SQL : SELECT * from rt_customers where id = Time : 07:53:10 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Raw SQL : SELECT * from rt_customers where id = Time : 07:50:24 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Raw SQL : SELECT * from rt_customers where id = Time : 07:49:52 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Raw SQL : SELECT * from rt_customers where id = Time : 07:47:50 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Raw SQL : SELECT * from rt_customers where id = Time : 07:45:22 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Raw SQL : SELECT * from rt_customers where id = Time : 07:39:57 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Raw SQL : SELECT * from rt_customers where id = Time : 07:39:02 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Raw SQL : SELECT * from rt_customers where id = Time : 07:33:19 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Raw SQL : UPDATE rt_booking_on_the_go SET cancellation_time=NOW(), cancelled_by='customer', booking_status='Cancelled' WHERE user_id= Time : 07:29:28 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Raw SQL : UPDATE rt_booking_on_the_go SET cancellation_time=NOW(), cancelled_by='customer', booking_status='Cancelled' WHERE user_id= Time : 12:24:33 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'N)) * cos(radians(latitude)) * cos(radians(long' at line 1 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(30.7333° N)) * cos(radians(latitude)) * cos(radians(longitude) - radians(76.7794° E)) + sin (radians(30.7333° N)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' HAVING distance <= 50000 Time : 12:14:33 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'N)) * cos(radians(latitude)) * cos(radians(long' at line 1 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(30.7333° N)) * cos(radians(latitude)) * cos(radians(longitude) - radians(76.7794° E)) + sin (radians(30.7333° N)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' HAVING distance <= 50000 Time : 12:13:44 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'N)) * cos(radians(latitude)) * cos(radians(long' at line 1 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(30.7333° N)) * cos(radians(latitude)) * cos(radians(longitude) - radians(76.7794° E)) + sin (radians(30.7333° N)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' HAVING distance <= 50000 Time : 06:42:22 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Raw SQL : UPDATE rt_booking_on_the_go SET cancellation_time=NOW(), cancelled_by='customer', booking_status='Cancelled' WHERE user_id= Time : 06:33:40 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '06:33:40 WHERE id=40972' at line 1 Raw SQL : UPDATE rt_booking_on_the_go SET booking_status='Started', start_time=14-02-2024 06:33:40 WHERE id=40972 Time : 06:33:40 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '06:33:40 WHERE id=40972' at line 1 Raw SQL : UPDATE rt_booking_on_the_go SET booking_status='Started', start_time=14-02-2024 06:33:40 WHERE id=40972 Time : 06:33:35 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '06:33:35 WHERE id=40972' at line 1 Raw SQL : UPDATE rt_booking_on_the_go SET booking_status='Started', start_time=14-02-2024 06:33:35 WHERE id=40972 Time : 06:33:35 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '06:33:35 WHERE id=40972' at line 1 Raw SQL : UPDATE rt_booking_on_the_go SET booking_status='Started', start_time=14-02-2024 06:33:35 WHERE id=40972 Time : 06:32:53 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '06:32:53 WHERE id=40972' at line 1 Raw SQL : UPDATE rt_booking_on_the_go SET booking_status='Started', start_time=14-02-2024 06:32:53 WHERE id=40972 Time : 06:32:47 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '06:32:47 WHERE id=40972' at line 1 Raw SQL : UPDATE rt_booking_on_the_go SET booking_status='Started', start_time=14-02-2024 06:32:47 WHERE id=40972 Time : 05:22:30 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Raw SQL : SELECT * from rt_customers where id = Time : 04:37:54 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 Raw SQL : SELECT * from rt_sub_category where id IN () Time : 04:37:50 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 Raw SQL : SELECT * from rt_sub_category where id IN () Time : 01:04:29 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND booking_status='Accepted'' at line 1 Raw SQL : SELECT * FROM rt_booking_on_the_go WHERE user_id= AND booking_status='Accepted'