WHD 12.8 mysql upgrade from 5.7 to 8.0 X error when forwarding from email to WHD helpdesk We're sorry, an error occurred while attempting to process your support request:

sprintership

com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression failed: <com.macsdesign.util.MDSMySQLPlugIn$MDSMySQLExpression: "INSERT INTO webhelpdesk.JOB_TICKET(BCC_ADDRESSES, BILLING_TERM_ID, REPORT_DATE, ORIGINAL_TECH_ID, SHIPPING, HAS_BEEN_REASSIGNED, SEND_GROUP_MGR_EMAIL, TRAVEL_COST, SEND_TO_CLIENT_CC_LIST, DEPARTMENT_ID, STATUS_YELLOW_NOTIFICATION_DT, TASK_ELEMENT_COMPLETE, SEND_CARBON_COPY, TRAVEL_TIME, USE_DUE_DATE_OVERRIDE_INTEGER, STATUS_RED_NOTIFICATION_DT, DELETED, LAST_EMAIL_SEND_DATE, TICKET_TIME_AS_OF_LAST_UPDATE, ASSIGNED_TECH_ID, ORION_ALERT_ATTACH_DATA_ID, ORION_ALERT_IDENTIFIER, DUE_HOURS_MANUAL, HIDDEN_SUBJECT, SUBSCRIBER_ID, JOB_TICKET_ID, PO_NUMBER, JOB_TIME, SUBJECT, IS_TAX_FREE, DUE_DATE_OVERRIDE, LOCATION_ID, QUESTION_TEXT, UPDATED_BY_TECH_FLAG, DISABLE_EMAIL_TO_ALL_CLIENTS, PRIORITY_TYPE_ID, SERVICE_TIME_ENABLED, SHOW_DUE_DATE_ON_CALENDAR, INITIALIZED_CUSTOM_FIELDS, LAST_CLIENT_UPDATE, DISCOUNT, IS_HOT, SEND_BCC_EMAIL, LAST_UPDATED, CLOSE_DATE, DISABLE_EMAIL_TO_CLIENT_AND_CC, ROOM, ROOM_ID, STATUS_TYPE_ID, WORK_START_DATE, IP_ADDRESS, SEND_CLIENT_EMAIL, CUSTOM_2, SEND_LEVEL_TECH_EMAIL, CUSTOM_3, JOB_COST, WORK_END_DATE, DISABLE_EMAIL_TO_CLIENT, LABOR_TAX_RATE, CLIENT_CREATOR_ID, FIRST_RESPONSE_DATE, CUSTOM_1, LAST_CLIENT_REMINDER_DATE, IS_ELIGIBLE_FOR_SURVEY, CUSTOM_4, PROBLEM_TYPE_ID, CLIENT_ID, PHONE, ESCALATION_LEVEL, UPDATED_FLAG, TECH_GROUP_LEVEL_ID, CC_ADDRESS_FOR_CLIENT, LOGGED_BY_ID, LAST_REMINDER_DATE, IS_PRIVATE, SEND_TECH_EMAIL, MAIL_CC_ADDRESS, LAST_STATUS_UPDATE_TIME) VALUES (NULL, NULL, ?, ?, NULL, NULL, ?, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ?, NULL, ?, NULL, NULL, ?, NULL, NULL, NULL, NULL, ?, ?, NULL, ?, ?, NULL, NULL, ?, ?, NULL, NULL, ?, ?, NULL, NULL, NULL, NULL, NULL, NULL, ?, NULL, NULL, ?, ?, ?, NULL, NULL, ?, NULL, ?, NULL, ?, NULL, NULL, NULL, ?, NULL, NULL, NULL, NULL, NULL, ?, ?, NULL, NULL, ?, ?, NULL, NULL, ?, NULL, ?, NULL, ?)" withBindings: 1:2023-11-23 10:38:18.415(reportDate), 2:25(originalTechId), 3:0(sendGroupMgrEmail), 4:0(useDueDateOverrideInteger), 5:0(deleted), 6:25(assignedTechId), 7:1(subscriberId), 8:36802(jobTicketId), 9:0(jobTime), 10:"Fwd: Cannot Block Yo...tube Shorts in Relay"(subject), 11:398(locationId), 12:"---------- Forwarded...dway | Chicago 60613"(questionText), 13:3(priorityTypeId), 14:0(serviceTimeEnabled), 15:2023-11-23 10:38:19.057(lastUpdated), 16:"223-B"(room), 17:521(assignedRoom), 18:1(statusTypeId), 19:1(sendClientEmail), 20:0(sendLevelTechEmail), 21:0.00(jobCost), 22:3541(clientCreatorId), 23:48(problemTypeId), 24:3541(clientId), 25:1(updatedFlag), 26:5(techGroupLevelId), 27:2023-11-23 10:38:18.957(lastReminderDate), 28:0(sendTechEmail), 29:2023-11-23 10:38:18.906(lastStatusUpdateTime)>:
Next exception:SQL State:HY000 -- error code: 1366 -- msg: Incorrect string value: '\xE2\x80\xAFAM\x0D...' for column 'QUESTION_TEXT' at row 1
at com.webobjects.eoaccess.EODatabaseContext._exceptionWithDatabaseContextInformationAdded(EODatabaseContext.java:4504)
at com.webobjects.eoaccess.EODatabaseContext.performChanges(EODatabaseContext.java:6216)
at com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditingContext(EOObjectStoreCoordinator.java:376)
at com.webobjects.eocontrol.EOEditingContext.saveChanges(EOEditingContext.java:3192)
at er.extensions.eof.ERXEC._saveChanges(ERXEC.java:1177)
at er.extensions.eof.ERXEC.saveChanges(ERXEC.java:1100)
at com.macsdesign.whd.daemon.WHDEmailTicketDaemon$WHDEmailAccountReader._createSupportRequest(WHDEmailTicketDaemon.java:3443)
at com.macsdesign.whd.daemon.WHDEmailTicketDaemon$WHDEmailAccountReader.processMessage(WHDEmailTicketDaemon.java:1604)
at com.macsdesign.whd.daemon.WHDEmailTicketDaemon$WHDEmailAccountReader.checkInbox(WHDEmailTicketDaemon.java:907)
at com.macsdesign.whd.daemon.WHDEmailTicketDaemon.retrieveNewTickets(WHDEmailTicketDaemon.java:311)
at com.macsdesign.whd.daemon.WHDEmailTicketDaemon.startDaemonTask(WHDEmailTicketDaemon.java:207)
at com.macsdesign.whd.daemon.DaemonTask$1.executeWithEditingContext(DaemonTask.java:99)
at com.macsdesign.util.TemporaryEditingContext.executeWithDedicatedOSC(TemporaryEditingContext.java:50)
at com.macsdesign.whd.daemon.DaemonTask.runWithSeparateOSC(DaemonTask.java:94)
at com.macsdesign.whd.daemon.DaemonTask.run(DaemonTask.java:48)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:829)

pabely

The important part is SQL State:HY000 -- error code: 1366 -- msg: Incorrect string value:  This is a MySQL error. What Collation and character set did you use for the new MySQL8 Database? The database appears to want to store a 4 byte character ( like emoji) but the Database cannot handle this, It will not be just the database that might need a collation change but the table and column within that table.