Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Upgrade from version 3.5.0 with PostgreSQL fails #628

Open
HirotoKagotani opened this issue Mar 15, 2025 · 0 comments
Open

Upgrade from version 3.5.0 with PostgreSQL fails #628

HirotoKagotani opened this issue Mar 15, 2025 · 0 comments

Comments

@HirotoKagotani
Copy link

Commit e20310e causes a syntax error when upgrading Questionnaire from 3.5.0 or earlier with PostgreSQL.
With PostgreSQL, the UPDATE statement should be:

UPDATE mdl_questionnaire_response qr
SET questionnaireid = qa.qid
FROM mdl_questionnaire_attempts qa
WHERE qr.id = qa.rid;

instead of using INNER JOIN.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant