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.

Sign up for GitHub

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

Jump to bottom

30000Date20240417075404 - You can't specify target table 'oc_preferences' for update in FROM clause #2592

Closed
nickvergessen opened this issue Aug 12, 2024 · 3 comments · Fixed by #2593
Closed

30000Date20240417075404 - You can't specify target table 'oc_preferences' for update in FROM clause #2592

nickvergessen opened this issue Aug 12, 2024 · 3 comments · Fixed by #2593
Assignees
@nickvergessen
Labels
0. Needs triage Pending approval or rejection. This issue is pending approval. bug Something isn't working

Comments

@nickvergessen
Copy link
Member 

Exception: Database error when running migration 30000Date20240417075404 for app photos An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1093 You can't specify target table 'oc_preferences' for update in FROM clause
@nickvergessen nickvergessen added bug Something isn't working 0. Needs triage Pending approval or rejection. This issue is pending approval. labels Aug 12, 2024
@nickvergessen
Copy link
Member Author

Regression from #2571

@nickvergessen
Copy link
Member Author

Should split the select and the delete (don't get confused by the word update and read it as row-modification instead).
On inserting we then also need to make sure to not have an IN with more than 1k elements (oracle)

@sorbaugh
Copy link

@yemkareems, could you please take a look 🙏

@nickvergessen nickvergessen self-assigned this Aug 13, 2024
@nickvergessen nickvergessen mentioned this issue Aug 13, 2024
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@nickvergessen nickvergessen

Labels
0. Needs triage Pending approval or rejection. This issue is pending approval. bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

fix(migration): Fix migration for MySQL which does not allow joining nextcloud/photos
3 participants
@nickvergessen @yemkareems @sorbaugh