We have just moved our system from 1.7.8 (windows/IIS) to 2.0.0.3(Debian Linux/Docker) via 1.8.
We seem to have some database issues, the current show stopper is we can’t add a new schedule, we get a “Unexpected Error, please contact support” message.
As per screen shot.
How can we fix this?
Could you please provide Status Screenshots and Logs screenshots ? Thanks.
Unable to upload the troubleshooting file here so shared it via one drive.
Many thanks.
Rob Keeling
Is there any other trouble shooting info I can provide?
Thank you for providing those informations.
I can see two errors from your Logs : one with the display profile and one with the schedule.
Regarding the Cannot get display profile, please make sure that you have the default profile set on each display
Regarding the schedule error : you will need to connect to MySQL in Docker and run the command describe schedule then post the result of that command p[lease.
To see how to run a SQL command when running a Docked install please consult : How can I run a SQL command when using a Docker Install?
describe schedule gives the following
MySQL [cms]> describe schedule;
±---------------------------±--------------------------------------------------±-----±----±--------±---------------+
| Field | Type | Null | Key | Default | Extra |
±---------------------------±--------------------------------------------------±-----±----±--------±---------------+
| eventID | int(11) | NO | PRI | NULL | auto_increment |
| eventTypeId | tinyint(4) | NO | | 1 | |
| campaignId | int(11) | YES | MUL | NULL | |
| commandId | int(11) | NO | | NULL | |
| recurrence_type | enum(‘Minute’,‘Hour’,‘Day’,‘Week’,‘Month’,‘Year’) | YES | | NULL | |
| recurrence_detail | varchar(100) | YES | | NULL | |
| userID | int(11) | NO | | NULL | |
| is_priority | int(11) | NO | | NULL | |
| fromDt | bigint(20) | YES | | NULL | |
| toDt | bigint(20) | YES | | NULL | |
| recurrence_range | bigint(20) | YES | | NULL | |
| DisplayOrder | int(11) | NO | | 0 | |
| dayPartId | int(11) | NO | | NULL | |
| recurrenceRepeatsOn | varchar(255) | YES | | NULL | |
| lastRecurrenceWatermark | bigint(20) | YES | | NULL | |
| syncTimezone | tinyint(4) | NO | | NULL | |
| syncEvent | int(11) | NO | | 0 | |
| recurrenceMonthlyRepeatsOn | tinyint(4) | NO | | 0 | |
±---------------------------±--------------------------------------------------±-----±----±--------±---------------+
18 rows in set (0.00 sec)
I have manually set a display profile for all the screens, though this does not appear to have changed anything. Not sure if I need to leave a time interval for the screens to catch up before trying again though?
