Waited to see how many (if any) responses to this 'issue' ... none ... so I'll offer 2 cents ... in a 'nutshell', if it hurts, don't do it!
Suggest using a 'true to moodle life' senario in testing backups and restores. I imagine that Testers of any Moodle release do test backups and restores but not many (venturing a guess) if any would do the steps you've described here. While in theory, the backup/restores routines/code should allow any/every combination of settings, can see that conflicting decisions could cause a state of total confusion for Moodle thus rendering mis-leading debugs.
Table missing ... got ssh/shell access? Use mysql client on server and issue the following from the mysql> prompt using DB for Moodle:
mysql> use moodle36;
mysql> show tables like '%workshop%';
You should see:
+----------------------------------+
| Tables_in_moodle36 (%workshop%) |
+----------------------------------+
| mdl_workshop |
| mdl_workshop_aggregations |
| mdl_workshop_assessments |
| mdl_workshop_grades |
| mdl_workshop_submissions |
| mdl_workshopallocation_scheduled |
| mdl_workshopeval_best_settings |
| mdl_workshopform_accumulative |
| mdl_workshopform_comments |
| mdl_workshopform_numerrors |
| mdl_workshopform_numerrors_map |
| mdl_workshopform_rubric |
| mdl_workshopform_rubric_config |
| mdl_workshopform_rubric_levels |
+----------------------------------+
14 rows in set (0.01 sec)
Check the specific table mentioned:
mysql> explain mdl_workshop_submissions;
should see:
+----------------------+---------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+---------------+------+-----+---------+----------------+
| id | bigint(10) | NO | PRI | NULL | auto_increment |
| workshopid | bigint(10) | NO | MUL | NULL | |
| example | tinyint(2) | YES | | 0 | |
| authorid | bigint(10) | NO | MUL | NULL | |
| timecreated | bigint(10) | NO | | NULL | |
| timemodified | bigint(10) | NO | | NULL | |
| title | varchar(255) | NO | | | |
| content | longtext | YES | | NULL | |
| contentformat | smallint(3) | NO | | 0 | |
| contenttrust | smallint(3) | NO | | 0 | |
| attachment | tinyint(2) | YES | | 0 | |
| grade | decimal(10,5) | YES | | NULL | |
| gradeover | decimal(10,5) | YES | | NULL | |
| gradeoverby | bigint(10) | YES | MUL | NULL | |
| feedbackauthor | longtext | YES | | NULL | |
| feedbackauthorformat | smallint(3) | YES | | 0 | |
| timegraded | bigint(10) | YES | | NULL | |
| published | tinyint(2) | YES | | 0 | |
| late | tinyint(2) | NO | | 0 | |
+----------------------+---------------+------+-----+---------+----------------+
19 rows in set (0.00 sec)
'SoS', Ken