Time : 08:00:01 SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'city' at row 1 Raw SQL : UPDATE rt_service_providers SET latitude=?,longitude=?,provider_area=?,city=?,zip_code=? WHERE id = ? Time : 07:33:39 SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'city' at row 1 Raw SQL : INSERT INTO rt_service_providers (provider_name, email_addr, phone_number, pswd, provider_address, provider_area, landmark, city, state, zip_code,latitude,longitude,android_device_id,ios_device_id,covid,dose) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Time : 07:27:34 SQLSTATE[HY000]: General error: 3988 Conversion from collation utf8mb3_general_ci into latin1_swedish_ci impossible for parameter Raw SQL : INSERT INTO rt_service_providers (provider_name, email_addr, phone_number, pswd, provider_address, provider_area, landmark, city, state, zip_code,latitude,longitude,android_device_id,ios_device_id,covid,dose) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Time : 06:06: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 'ORDER BY last_seen DESC, ORDER BY not_answer ASC LIMIT 0, 15' at line 3 Raw SQL : SELECT *, (111.111 * DEGREES(acos(cos(radians(31.1068797)) * cos(radians(latitude)) * cos(radians(longitude) - radians(77.1960654)) + sin (radians(31.1068797)) * sin(radians(latitude)) ))) AS distance from rt_service_providers where android_device_id IS NOT NULL and status != 3 and id NOT IN (123) and FIND_IN_SET(5, sub_category_id) and FIND_IN_SET(2, category_id) and status = 1 and deactivate_account = 0 and latitude <> '' and longitude <> '' and category_id <> '' and sub_category_id <> '' HAVING distance <= 20 ORDER BY id DESC, ORDER BY last_seen DESC, ORDER BY not_answer ASC LIMIT 0, 15