Time : 12:17:21 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 ':APA91bFRA0MIktjO8Br5OhUUGsFz33cUjkIZFKvOmiNume7DV6RJoZrQ1rHe5HW4Ec3JILNVqKclx3k' at line 1 Raw SQL : SELECT * FROM rt_service_providers WHERE android_device_id=du_bFT2RRZ6t58Fw-NKAZR:APA91bFRA0MIktjO8Br5OhUUGsFz33cUjkIZFKvOmiNume7DV6RJoZrQ1rHe5HW4Ec3JILNVqKclx3k9pxML038enbrI4e3O5_UQkr76KtpOv9KK7Du0NtKlhwjV_f7SG8DE6SypUtdG Time : 12:16: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 ':APA91bFRA0MIktjO8Br5OhUUGsFz33cUjkIZFKvOmiNume7DV6RJoZrQ1rHe5HW4Ec3JILNVqKclx3k' at line 1 Raw SQL : SELECT * FROM rt_service_providers WHERE android_device_id=du_bFT2RRZ6t58Fw-NKAZR:APA91bFRA0MIktjO8Br5OhUUGsFz33cUjkIZFKvOmiNume7DV6RJoZrQ1rHe5HW4Ec3JILNVqKclx3k9pxML038enbrI4e3O5_UQkr76KtpOv9KK7Du0NtKlhwjV_f7SG8DE6SypUtdG Time : 12:16:14 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 ':APA91bFRA0MIktjO8Br5OhUUGsFz33cUjkIZFKvOmiNume7DV6RJoZrQ1rHe5HW4Ec3JILNVqKclx3k' at line 1 Raw SQL : SELECT * FROM rt_service_providers WHERE android_device_id=du_bFT2RRZ6t58Fw-NKAZR:APA91bFRA0MIktjO8Br5OhUUGsFz33cUjkIZFKvOmiNume7DV6RJoZrQ1rHe5HW4Ec3JILNVqKclx3k9pxML038enbrI4e3O5_UQkr76KtpOv9KK7Du0NtKlhwjV_f7SG8DE6SypUtdG Time : 12:10:44 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Array' in 'where clause' Raw SQL : SELECT * FROM rt_service_providers WHERE android_device_id IN (Array) Time : 12:10:40 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Array' in 'where clause' Raw SQL : SELECT * FROM rt_service_providers WHERE android_device_id IN (Array) Time : 12:09:14 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Array' in 'where clause' Raw SQL : SELECT * FROM rt_service_providers WHERE android_device_id=Array Time : 11:58:09 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Array' in 'where clause' Raw SQL : SELECT * FROM rt_service_providers WHERE android_device_id=Array Time : 11:56:11 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Array' in 'where clause' Raw SQL : SELECT * FROM rt_service_providers WHERE android_device_id=Array Time : 11:55:14 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Array' in 'where clause' Raw SQL : SELECT * FROM rt_service_providers WHERE android_device_id=Array Time : 17:14:13 SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'gender' at row 1 Raw SQL : INSERT INTO rt_booking_on_the_go (user_id, provider_id,booking_app_id,booking_address,latitude,longitude,booking_status, gender, service_type, sub_category_id,hours_per_day, job_types, food_type, house_size, members, user_cost, provider_salary, user_rating,provider_rating,start_date, interview_time, end_date, customer_address,record_time,customer_token_id, customer_device_os, temp_provider_id,date_time,booking_date) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Time : 16:45:22 SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect date value: '' for column 'start_date' at row 1 Raw SQL : INSERT INTO rt_booking_on_the_go (user_id, provider_id,booking_app_id,booking_address,latitude,longitude,booking_status, gender, service_type, sub_category_id,hours_per_day, job_types, food_type, house_size, members, user_cost, provider_salary, user_rating,provider_rating,start_date, interview_time, end_date, customer_address,record_time,customer_token_id, customer_device_os, temp_provider_id,date_time,booking_date) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Time : 16:45:18 SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect date value: '' for column 'start_date' at row 1 Raw SQL : INSERT INTO rt_booking_on_the_go (user_id, provider_id,booking_app_id,booking_address,latitude,longitude,booking_status, gender, service_type, sub_category_id,hours_per_day, job_types, food_type, house_size, members, user_cost, provider_salary, user_rating,provider_rating,start_date, interview_time, end_date, customer_address,record_time,customer_token_id, customer_device_os, temp_provider_id,date_time,booking_date) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Time : 16:45:15 SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect date value: '' for column 'start_date' at row 1 Raw SQL : INSERT INTO rt_booking_on_the_go (user_id, provider_id,booking_app_id,booking_address,latitude,longitude,booking_status, gender, service_type, sub_category_id,hours_per_day, job_types, food_type, house_size, members, user_cost, provider_salary, user_rating,provider_rating,start_date, interview_time, end_date, customer_address,record_time,customer_token_id, customer_device_os, temp_provider_id,date_time,booking_date) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Time : 10:21:20 SQLSTATE[HY000]: General error: 3988 Conversion from collation utf8mb3_general_ci into latin1_swedish_ci impossible for parameter Raw SQL : UPDATE rt_service_providers SET gender=?, religion=?, service_lists=?, job_lists=?, alternate_phone=?, married=?, kids=?, work_permission=?, permission_info=?, family_members=?,staying_currently=?, worked_24_hour=?, hours_worked=?, work_todo=?, total_experience=?, left_job_reason=?, relocation=?, preferred_cities=?,hours_24_work=?, hours_2_12=?, working_hours=?, pet_friendly = ?, current_city=?, education_level=?, rw_english=?, rw_hindi=?, sign_contract=?, last_salary=?,profile_image=?,identity_image=?,covid=?,dose=?,s_english=?,s_hindi=?,registration_date=?, category_id=?, sub_category_id=?,food_type_id=?, read_write_english=?,speak_english=?, provider_name=?, new_hours_worked=?, language=?, status=? WHERE id=? Time : 10:20:27 SQLSTATE[HY000]: General error: 3988 Conversion from collation utf8mb3_general_ci into latin1_swedish_ci impossible for parameter Raw SQL : UPDATE rt_service_providers SET gender=?, religion=?, service_lists=?, job_lists=?, alternate_phone=?, married=?, kids=?, work_permission=?, permission_info=?, family_members=?,staying_currently=?, worked_24_hour=?, hours_worked=?, work_todo=?, total_experience=?, left_job_reason=?, relocation=?, preferred_cities=?,hours_24_work=?, hours_2_12=?, working_hours=?, pet_friendly = ?, current_city=?, education_level=?, rw_english=?, rw_hindi=?, sign_contract=?, last_salary=?,profile_image=?,identity_image=?,covid=?,dose=?,s_english=?,s_hindi=?,registration_date=?, category_id=?, sub_category_id=?,food_type_id=?, read_write_english=?,speak_english=?, provider_name=?, new_hours_worked=?, language=?, status=? WHERE id=? Time : 10:12:49 SQLSTATE[HY000]: General error: 3988 Conversion from collation utf8mb3_general_ci into latin1_swedish_ci impossible for parameter Raw SQL : UPDATE rt_service_providers SET gender=?, religion=?, service_lists=?, job_lists=?, alternate_phone=?, married=?, kids=?, work_permission=?, permission_info=?, family_members=?,staying_currently=?, worked_24_hour=?, hours_worked=?, work_todo=?, total_experience=?, left_job_reason=?, relocation=?, preferred_cities=?,hours_24_work=?, hours_2_12=?, working_hours=?, pet_friendly = ?, current_city=?, education_level=?, rw_english=?, rw_hindi=?, sign_contract=?, last_salary=?,profile_image=?,identity_image=?,covid=?,dose=?,s_english=?,s_hindi=?,registration_date=?, category_id=?, sub_category_id=?,food_type_id=?, read_write_english=?,speak_english=?, provider_name=?, new_hours_worked=?, language=?, status=? WHERE id=? Time : 10:12:40 SQLSTATE[HY000]: General error: 3988 Conversion from collation utf8mb3_general_ci into latin1_swedish_ci impossible for parameter Raw SQL : UPDATE rt_service_providers SET gender=?, religion=?, service_lists=?, job_lists=?, alternate_phone=?, married=?, kids=?, work_permission=?, permission_info=?, family_members=?,staying_currently=?, worked_24_hour=?, hours_worked=?, work_todo=?, total_experience=?, left_job_reason=?, relocation=?, preferred_cities=?,hours_24_work=?, hours_2_12=?, working_hours=?, pet_friendly = ?, current_city=?, education_level=?, rw_english=?, rw_hindi=?, sign_contract=?, last_salary=?,profile_image=?,identity_image=?,covid=?,dose=?,s_english=?,s_hindi=?,registration_date=?, category_id=?, sub_category_id=?,food_type_id=?, read_write_english=?,speak_english=?, provider_name=?, new_hours_worked=?, language=?, status=? WHERE id=? Time : 10:12:18 SQLSTATE[HY000]: General error: 3988 Conversion from collation utf8mb3_general_ci into latin1_swedish_ci impossible for parameter Raw SQL : UPDATE rt_service_providers SET gender=?, religion=?, service_lists=?, job_lists=?, alternate_phone=?, married=?, kids=?, work_permission=?, permission_info=?, family_members=?,staying_currently=?, worked_24_hour=?, hours_worked=?, work_todo=?, total_experience=?, left_job_reason=?, relocation=?, preferred_cities=?,hours_24_work=?, hours_2_12=?, working_hours=?, pet_friendly = ?, current_city=?, education_level=?, rw_english=?, rw_hindi=?, sign_contract=?, last_salary=?,profile_image=?,identity_image=?,covid=?,dose=?,s_english=?,s_hindi=?,registration_date=?, category_id=?, sub_category_id=?,food_type_id=?, read_write_english=?,speak_english=?, provider_name=?, new_hours_worked=?, language=?, status=? WHERE id=? Time : 10:12:01 SQLSTATE[HY000]: General error: 3988 Conversion from collation utf8mb3_general_ci into latin1_swedish_ci impossible for parameter Raw SQL : UPDATE rt_service_providers SET gender=?, religion=?, service_lists=?, job_lists=?, alternate_phone=?, married=?, kids=?, work_permission=?, permission_info=?, family_members=?,staying_currently=?, worked_24_hour=?, hours_worked=?, work_todo=?, total_experience=?, left_job_reason=?, relocation=?, preferred_cities=?,hours_24_work=?, hours_2_12=?, working_hours=?, pet_friendly = ?, current_city=?, education_level=?, rw_english=?, rw_hindi=?, sign_contract=?, last_salary=?,profile_image=?,identity_image=?,covid=?,dose=?,s_english=?,s_hindi=?,registration_date=?, category_id=?, sub_category_id=?,food_type_id=?, read_write_english=?,speak_english=?, provider_name=?, new_hours_worked=?, language=?, status=? WHERE id=? Time : 10:10:06 SQLSTATE[HY000]: General error: 3988 Conversion from collation utf8mb3_general_ci into latin1_swedish_ci impossible for parameter Raw SQL : UPDATE rt_service_providers SET gender=?, religion=?, service_lists=?, job_lists=?, alternate_phone=?, married=?, kids=?, work_permission=?, permission_info=?, family_members=?,staying_currently=?, worked_24_hour=?, hours_worked=?, work_todo=?, total_experience=?, left_job_reason=?, relocation=?, preferred_cities=?,hours_24_work=?, hours_2_12=?, working_hours=?, pet_friendly = ?, current_city=?, education_level=?, rw_english=?, rw_hindi=?, sign_contract=?, last_salary=?,profile_image=?,identity_image=?,covid=?,dose=?,s_english=?,s_hindi=?,registration_date=?, category_id=?, sub_category_id=?,food_type_id=?, read_write_english=?,speak_english=?, provider_name=?, new_hours_worked=?, language=?, status=? WHERE id=? Time : 10:09:27 SQLSTATE[HY000]: General error: 3988 Conversion from collation utf8mb3_general_ci into latin1_swedish_ci impossible for parameter Raw SQL : UPDATE rt_service_providers SET gender=?, religion=?, service_lists=?, job_lists=?, alternate_phone=?, married=?, kids=?, work_permission=?, permission_info=?, family_members=?,staying_currently=?, worked_24_hour=?, hours_worked=?, work_todo=?, total_experience=?, left_job_reason=?, relocation=?, preferred_cities=?,hours_24_work=?, hours_2_12=?, working_hours=?, pet_friendly = ?, current_city=?, education_level=?, rw_english=?, rw_hindi=?, sign_contract=?, last_salary=?,profile_image=?,identity_image=?,covid=?,dose=?,s_english=?,s_hindi=?,registration_date=?, category_id=?, sub_category_id=?,food_type_id=?, read_write_english=?,speak_english=?, provider_name=?, new_hours_worked=?, language=?, status=? WHERE id=? Time : 10:09:21 SQLSTATE[HY000]: General error: 3988 Conversion from collation utf8mb3_general_ci into latin1_swedish_ci impossible for parameter Raw SQL : UPDATE rt_service_providers SET gender=?, religion=?, service_lists=?, job_lists=?, alternate_phone=?, married=?, kids=?, work_permission=?, permission_info=?, family_members=?,staying_currently=?, worked_24_hour=?, hours_worked=?, work_todo=?, total_experience=?, left_job_reason=?, relocation=?, preferred_cities=?,hours_24_work=?, hours_2_12=?, working_hours=?, pet_friendly = ?, current_city=?, education_level=?, rw_english=?, rw_hindi=?, sign_contract=?, last_salary=?,profile_image=?,identity_image=?,covid=?,dose=?,s_english=?,s_hindi=?,registration_date=?, category_id=?, sub_category_id=?,food_type_id=?, read_write_english=?,speak_english=?, provider_name=?, new_hours_worked=?, language=?, status=? WHERE id=? Time : 09:20:06 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'en' in 'field list' Raw SQL : UPDATE rt_service_providers SET language=en WHERE id=16469 Time : 09:20:05 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'en' in 'field list' Raw SQL : UPDATE rt_service_providers SET language=en WHERE id=16469 Time : 09:20:00 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'en' in 'field list' Raw SQL : UPDATE rt_service_providers SET language=en WHERE id=16469 Time : 09:19:59 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'en' in 'field list' Raw SQL : UPDATE rt_service_providers SET language=en WHERE id=16469 Time : 09:18:34 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'en' in 'field list' Raw SQL : UPDATE rt_service_providers SET language=en WHERE id=16469 Time : 09:17:10 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'en' in 'field list' Raw SQL : UPDATE rt_service_providers SET language=en WHERE id=12761 Time : 09:16:51 SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'language' cannot be null Raw SQL : UPDATE rt_service_providers SET gender=?, religion=?, service_lists=?, job_lists=?, alternate_phone=?, married=?, kids=?, work_permission=?, permission_info=?, family_members=?,staying_currently=?, worked_24_hour=?, hours_worked=?, work_todo=?, total_experience=?, left_job_reason=?, relocation=?, preferred_cities=?,hours_24_work=?, hours_2_12=?, working_hours=?, pet_friendly = ?, current_city=?, education_level=?, rw_english=?, rw_hindi=?, sign_contract=?, last_salary=?,profile_image=?,identity_image=?,covid=?,dose=?,s_english=?,s_hindi=?,registration_date=?, category_id=?, sub_category_id=?,food_type_id=?, read_write_english=?,speak_english=?, provider_name=?, new_hours_worked=?, language=? WHERE id=? Time : 09:16:10 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'en' in 'field list' Raw SQL : UPDATE rt_service_providers SET language=en WHERE id=16469 Time : 09:05:37 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'en' in 'field list' Raw SQL : UPDATE rt_service_providers SET language=en WHERE id=16469