150 "Foreign key constraint is incorrectly formed"
Nobody has claimed this yet.
Assessment
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Newbie friendliness
- 28/100
Research direction
This is a user support report: installing or reinstalling the plugin fails with MySQL errno 150 when creating werkl_blog_category, so start from the migration that creates that table and compare its foreign-key column definition with the referenced blog table (type, length, charset must match). Reproduce against Shopware 6.7.9.0 with the affected OpenBlogware version to confirm whether the schema drifted between 5.0.1 and 5.2.1. Done means the migration creates the table without errno 150 and the plugin installs cleanly; note the report gives no version of the failing migration, so ask the reporter first.
Written by the indexing model from the issue text.
Description
Ich hatte das Plugin Version 5.0.1 installiert. Nachdem ich aber Probleme mit dem Erstellen von Blogbeiträgen hatte, hatte ich die Version auf 5.2.1 aktualisiert. Doch dann stellt ich fest. das meine Plugins nicht mehr zu sehen waren. Dann habe ich es deinstalliert und wollte danna uf die darunterliegende Version wieder installieren, aber ich erhalte die Fehlermeldung "Internal Server Error An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1005 Can't create table K10804_shopname.werkl_blog_category (errno: 150 "Foreign key constraint is incorrectly formed"). Egal was ich nun mache, die Meldung bleibt bestehen. Ich setze Shopware 6.7.9.0 ein. Wie kann ich das Problem beheben bzw beseitigen.
- Dominant language
- PHP
- Stars
- 43
- Forks
- 21
- Avg merge
- 12d 20h
- Merged PRs (30d)
- 1
Getting set up
- Ships a Dockerfile or Docker Compose file
- No pull request template
- No contributing guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from Werkstattl/OpenBlogware
-
Difficulty 2/5 1-3 hours Newbie friendliness 70/100
Werkstattl/OpenBlogware#92 ·
-
Auflistung im Element eingrenzenPossibly taken @7underlines claimed this 1 day ago. Openbug
Werkstattl/OpenBlogware#70 · 2 comments · 1 assignee ·
All issues in Werkstattl/OpenBlogware
Similar issues
-
Difficulty 2/5 1-3 hours Newbie friendliness 62/100
TYPO3BestPractices/tea#2409 ·
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
api-platform/core#8690 ·
Maintainers usually reply within 1 day
-
No Code Attached Yet
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
joomla/joomla-cms#48626 ·
Maintainers usually reply within 1 day
-
enhancement good first issue
Difficulty 2/5 1-3 hours Newbie friendliness 70/100
DorsetDigital/silverstripe-schema-manager#26 ·
Maintainers usually reply within 1 day
-
sync-en
Difficulty 1/5 1-3 hours Newbie friendliness 68/100
Maintainers usually reply within 4 days