Please Help: SQL Server Support error persists
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
We are using the new DAP 1.3.1 client. We perform a database initialization. The API runs fine for all tables until we get to the assignments table. Every single time we are receiving the same error regardless of what we do:
File "C:\Users\jbrandt\Desktop\NewDap\.venv\Lib\site-packages\pysqlsync\base.py", line 1173, in _generate_records
transformer = self._get_transformer(
^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\jbrandt\Desktop\NewDap\.venv\Lib\site-packages\pysqlsync\base.py", line 1210, in _get_transformer
raise ValueError(
ValueError: column "submission_types" not found in table "canvas"."assignments"
It looks like when the upserts begin, the sql generated should be using assignments.type as the column. Submission_types does not exist in the table that I can see.
There is a foreign key from assignments to the submission__types table.
Hoping someone can help:)
