FOREIGN KEY EXCEPTION when running plugin on local machine with SQLite #11
Description
When installing the latest version of wagtail, the latest version of the wagtailbakerydemo and the latest version of the plugin on a local environment, using the default SQLite database setup, a "FOREIGN KEY constraint failed" exception is appearing.
To replicate the issue:
- Install wagtail as per the wagtail site in venv and test (works OK),
- Install bakerydemo and test (works OK)
- install the review plugin (installs OK)
- run wagtail on localhost and access Admin
- Go to the About Us page (page id=76), make a change and Save As Draft
- Select "Submit for review" from the dropdown
- In the modal, select a review type and a user that needs to review the content
- Press the Submit button.
With debugging disabled, an internal server error is shown.
Debug tracelog info attached.