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

Can't DROP INDEX CAT_PRD_ENTT_MDA_GLR_VAL_ENTT_ID_VAL_ID_STORE_ID; check that it exists #12

Closed
raulsinapsis opened this issue Dec 18, 2024 · 3 comments
Closed

Can't DROP INDEX CAT_PRD_ENTT_MDA_GLR_VAL_ENTT_ID_VAL_ID_STORE_ID; check that it exists #12

raulsinapsis opened this issue Dec 18, 2024 · 3 comments

Comments

@raulsinapsis
Copy link
Contributor

In product.sql script it fails in "Gallery value" section, giving this error:

Can't DROP INDEX CAT_PRD_ENTT_MDA_GLR_VAL_ENTT_ID_VAL_ID_STORE_ID; check that it exists
@raulsinapsis
Copy link
Contributor Author

The right value would be

ALTER TABLE catalog_product_entity_media_gallery_value DROP INDEX CAT_PRD_ENTT_MDA_GLR_VAL_ROW_ID_VAL_ID_STORE_ID;

@thomas-kl1
Copy link
Member

Hello ! Could you open a PR with the related change? It would be greatly appreciated by others 😄

raulsinapsis added a commit to raulsinapsis/magento2-downgrade-ee-ce that referenced this issue Jan 7, 2025
@raulsinapsis
Fix Can't DROP INDEX CAT_PRD_ENTT_MDA_GLR_VAL_ENTT_ID_VAL_ID_STORE_ID…
9a889a6 
…; check that it exists

opengento#12
@raulsinapsis raulsinapsis mentioned this issue Jan 7, 2025
Merged
@raulsinapsis
Copy link
Contributor Author

Can't DROP INDEX CAT_PRD_ENTT_MDA_GLR_VAL_ENTT_ID_VAL_ID_STORE_ID; check that it exists

Sure
#13

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@raulsinapsis @thomas-kl1