Time : 21:01: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 's Hostel, Near Mizo Modern High School ,Nongrim Hill, Meghalaya, India','Full ti' at line 1 Raw SQL : INSERT INTO `user_searches`( `user_id`, `type`, `work_type`, `house_size`, `members`, `gender`, `date_time`,`address`,`hours`) VALUES ('8575911624','1','Cooking,Cleaning','5','','Female','2024-03-13 21:01:30','C/B 016, Rymbai Villa, Carmel Girl's Hostel, Near Mizo Modern High School ,Nongrim Hill, Meghalaya, India','Full time') Time : 21:00: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 's Hostel, Near Mizo Modern High School ,Nongrim Hill, Meghalaya, India','Full ti' at line 1 Raw SQL : INSERT INTO `user_searches`( `user_id`, `type`, `work_type`, `house_size`, `members`, `gender`, `date_time`,`address`,`hours`) VALUES ('8575911624','1','Cooking,Cleaning','5','','Female','2024-03-13 21:00:35','C/B 016, Rymbai Villa, Carmel Girl's Hostel, Near Mizo Modern High School ,Nongrim Hill, Meghalaya, India','Full time') Time : 13: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 'istance <= 50000' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(30.6862324)) * cos(radians(latitude)) * cos(radians(longitude) - radians(76.8449194)) + sin (radians(30.6862324)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where hours_worked <= 12 and category_id LIKE '%2%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' HAVING d istance <= 50000 Time : 13:39:57 SQLSTATE[42000]: Syntax error or access violation: 1582 Incorrect parameter count in the call to native function 'find_in_set' Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(30.6862324)) * cos(radians(latitude)) * cos(radians(longitude) - radians(76.8449194)) + sin (radians(30.6862324)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where hours_worked <= 12 and find_in_set(5,6,8, sub_category_id) OR find_in_set(5,6,8, sub_category_id) OR find_in_set(5,6,8, sub_category_id) and category_id LIKE '%2%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' HAVING distance <= 50000 Time : 12:43:23 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 'FIND_IN_SET(sub_category_id, '6,5,8') and category_id LIKE '%2%' and status = 1 ' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(30.6862324)) * cos(radians(latitude)) * cos(radians(longitude) - radians(76.8449194)) + sin (radians(30.6862324)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where hours_worked <= 12 FIND_IN_SET(sub_category_id, '6,5,8') and category_id LIKE '%2%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' HAVING distance <= 50000 Time : 12:33:12 SQLSTATE[42000]: Syntax error or access violation: 1582 Incorrect parameter count in the call to native function 'FIND_IN_SET' Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(18.99480262115614)) * cos(radians(latitude)) * cos(radians(longitude) - radians(72.83087850010962)) + sin (radians(18.99480262115614)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where hours_worked <= 10 and FIND_IN_SET(5,6,sub_category_id) and category_id LIKE '%2%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' HAVING distance <= 50000 Time : 12:31:27 SQLSTATE[42000]: Syntax error or access violation: 1582 Incorrect parameter count in the call to native function 'FIND_IN_SET' Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(30.6862324)) * cos(radians(latitude)) * cos(radians(longitude) - radians(76.8449194)) + sin (radians(30.6862324)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where hours_worked <= 12 and FIND_IN_SET(5,6,sub_category_id) and category_id LIKE '%2%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' HAVING distance <= 50000 Time : 12:30:32 SQLSTATE[42000]: Syntax error or access violation: 1582 Incorrect parameter count in the call to native function 'FIND_IN_SET' Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(30.6862324)) * cos(radians(latitude)) * cos(radians(longitude) - radians(76.8449194)) + sin (radians(30.6862324)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where hours_worked <= 12 and FIND_IN_SET(6,5,8,sub_category_id) and category_id LIKE '%2%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' HAVING distance <= 50000 Time : 12:29:59 SQLSTATE[42000]: Syntax error or access violation: 1582 Incorrect parameter count in the call to native function 'find_in_set' Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(30.6862324)) * cos(radians(latitude)) * cos(radians(longitude) - radians(76.8449194)) + sin (radians(30.6862324)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where hours_worked <= 12 and find_in_set(6,5,8,sub_category_id) <>0 and category_id LIKE '%2%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' HAVING distance <= 50000 Time : 12:29:42 SQLSTATE[42000]: Syntax error or access violation: 1582 Incorrect parameter count in the call to native function 'find_in_set' Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(30.6862324)) * cos(radians(latitude)) * cos(radians(longitude) - radians(76.8449194)) + sin (radians(30.6862324)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where hours_worked <= 12 and find_in_set(6,5,8,sub_category_id) and category_id LIKE '%2%' and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' HAVING distance <= 50000 Time : 09:46:44 SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' Raw SQL : SELECT count(id) num_rows from rt_customers where email_addr = 'हरिहंकर @Gmail com' and phone_number='8319536032' Time : 09:46:44 SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' Raw SQL : SELECT count(id) num_rows from rt_customers where email_addr = 'हरिहंकर @Gmail com' and phone_number='8319536032' Time : 09:46:43 SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' Raw SQL : SELECT count(id) num_rows from rt_customers where email_addr = 'हरिहंकर @Gmail com' and phone_number='8319536032' Time : 09:46:43 SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' Raw SQL : SELECT count(id) num_rows from rt_customers where email_addr = 'हरिहंकर @Gmail com' and phone_number='8319536032' Time : 09:46:43 SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' Raw SQL : SELECT count(id) num_rows from rt_customers where email_addr = 'हरिहंकर @Gmail com' and phone_number='8319536032' Time : 09:46:42 SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' Raw SQL : SELECT count(id) num_rows from rt_customers where email_addr = 'हरिहंकर @Gmail com' and phone_number='8319536032' Time : 09:46:42 SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' Raw SQL : SELECT count(id) num_rows from rt_customers where email_addr = 'हरिहंकर @Gmail com' and phone_number='8319536032' Time : 09:46:41 SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' Raw SQL : SELECT count(id) num_rows from rt_customers where email_addr = 'हरिहंकर @Gmail com' and phone_number='8319536032' Time : 09:46:41 SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' Raw SQL : SELECT count(id) num_rows from rt_customers where email_addr = 'हरिहंकर @Gmail com' and phone_number='8319536032' Time : 09:46:34 SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' Raw SQL : SELECT count(id) num_rows from rt_customers where email_addr = 'हरिहंकर @Gmail com' and phone_number='8319536032' Time : 06:22: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 'AND provider_id=' at line 1 Raw SQL : SELECT * FROM rt_booking_on_the_go WHERE DATE(booking_date) = DATE(NOW()) and (booking_status='Accepted' || booking_status='Started' || booking_status='Finish') AND user_id= AND provider_id= Time : 06:22:48 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 provider_id=' at line 1 Raw SQL : SELECT * FROM rt_booking_on_the_go WHERE DATE(booking_date) = DATE(NOW()) and (booking_status='Accepted' || booking_status='Started' || booking_status='Finish') AND user_id= AND provider_id= Time : 06:17:43 SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' Raw SQL : SELECT count(id) num_rows from rt_customers where email_addr = '“To climb the heights, one has to fall and get up again and aा हैं |"' and phone_number='9628982473' Time : 06:17:40 SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' Raw SQL : SELECT count(id) num_rows from rt_customers where email_addr = '“To climb the heights, one has to fall and get up again and aा हैं |"' and phone_number='9628982473' Time : 06:17:14 SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' Raw SQL : SELECT count(id) num_rows from rt_customers where email_addr = '“To climb the heights, one has to fall and get up again and again.”“ऊँचाइयों के पायदान पर चढ़ने के लिए बार बार गिरकर उठना पड़ता हैं |"' and phone_number='9628982473' Time : 06:17:05 SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' Raw SQL : SELECT count(id) num_rows from rt_customers where email_addr = '“To climb the heights, one has to fall and get up again and again.”“ऊँचाइयों के पायदान पर चढ़ने के लिए बार बार गिरकर उठना पड़ता हैं |"' and phone_number='9628982473' Time : 06:17:01 SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' Raw SQL : SELECT count(id) num_rows from rt_customers where email_addr = '“To climb the heights, one has to fall and get up again and again.”“ऊँचाइयों के पायदान पर चढ़ने के लिए बार बार गिरकर उठना पड़ता हैं |"' and phone_number='9628982473'