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

Re-installing myparcelnl/magento results in setup/upgrade db failure #770

Open
bamboekeizer opened this issue Jul 16, 2023 · 0 comments
Open
Labels
bug Something isn't working

Comments

@bamboekeizer
Copy link

Plugin version

4.91

Magento version

2.4.6-p1

PHP version

8.1

What went wrong?

Upgrade magento to 2.4.6-p1
Removed myparcelnl/magento module
Installed myparcelnl/magento module
But setup/upgrade failes with db error related to myparcel:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mg3.catalog_product_entity' doesn't exist, query was: SELECT catalog_product_entity_varchar.entity_id, catalog_product_entity_varchar.value_id, catalog_product_entity_varchar.value, eav_attribute.attribute_id FROM catalog_product_entity AS product LEFT JOIN catalog_product_entity_varchar ON product.entity_id = catalog_product_entity_varchar.entity_id LEFT JOIN eav_attribute ON 'myparcel_fit_in_mailbox' = eav_attribute.attribute_code WHERE catalog_product_entity_varchar.attribute_id = eav_attribute.attribute_id

Reproduction steps

Magento installation previously contained myparcelnl/magento

Remove myparcelnl/magento (because product edit with myparcel is not possible anymore)

Run setup/upgrade - fails with db error

Relevant log output

-bash-4.1$ composer remove myparcelnl/magento
./composer.json has been updated
Running composer update myparcelnl/magento
Loading composer repositories with package information
Updating dependencies
Lock file operations: 0 installs, 0 updates, 2 removals
  - Removing myparcelnl/magento (4.9.1)
  - Removing myparcelnl/sdk (7.7.6)
Writing lock file
Installing dependencies from lock file (including require-dev)
Package operations: 0 installs, 0 updates, 2 removals
  - Removing myparcelnl/sdk (7.7.6)
  - Removing myparcelnl/magento (4.9.1)
Removing Myparcelnl/Sdk
Removing Myparcelnl/Magento
Package sebastian/phpcpd is abandoned, you should avoid using it. No replacement was suggested.
Generating autoload files
131 packages you are using are looking for funding.
Use the `composer fund` command to find out more!
-bash-4.1$ rm -rf var/cache/*; rm -rf var/page_cache/*; rm -rf generated/code/*; php bin/magento setup:upgrade && php bin/magento cache:clean



-bash-4.1$ composer require myparcelnl/magento
Using version ^4.9 for myparcelnl/magento
./composer.json has been updated
Running composer update myparcelnl/magento
Loading composer repositories with package information
Updating dependencies
Lock file operations: 2 installs, 0 updates, 0 removals
  - Locking myparcelnl/magento (4.9.1)
  - Locking myparcelnl/sdk (7.7.6)
Writing lock file
Installing dependencies from lock file (including require-dev)
Package operations: 2 installs, 0 updates, 0 removals
  - Downloading myparcelnl/sdk (7.7.6)
  - Installing myparcelnl/sdk (7.7.6): Extracting archive
  - Installing myparcelnl/magento (4.9.1): Extracting archive
Package sebastian/phpcpd is abandoned, you should avoid using it. No replacement was suggested.
Generating autoload files
131 packages you are using are looking for funding.
Use the `composer fund` command to find out more!
-bash-4.1$ rm -rf var/cache/*; rm -rf var/page_cache/*; rm -rf generated/code/*; php bin/magento setup:upgrade && php bin/magento cache:clean


SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mg3.catalog_product_entity' doesn't exist, query was: SELECT catalog_product_entity_varchar.entity_id, catalog_product_entity_varchar.value_id, catalog_product_entity_varchar.value, eav_attribute.attribute_id FROM catalog_product_entity AS product LEFT JOIN catalog_product_entity_varchar ON product.entity_id = catalog_product_entity_varchar.entity_id LEFT JOIN eav_attribute ON 'myparcel_fit_in_mailbox' = eav_attribute.attribute_code WHERE catalog_product_entity_varchar.attribute_id = eav_attribute.attribute_id

Additional context

No response

@bamboekeizer bamboekeizer added the bug Something isn't working label Jul 16, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Development

No branches or pull requests

1 participant