Using the latest version of Magent2; 2.3.5 currently. When running the setup:upgrade query, we are hitting the below error:

Notice: Undefined index: store in /siteurl/public/vendor/magento/framework/Setup/Declaration/Schema/Db/SchemaBuilder.php on line 152

Looking at the store table, the admin ID has at somepoint changed from 0 to 2. Which is the likely issue. When restoring an old backup of this table, the id of 2 remains.

How is the above error rectified?

1 Answer 1


There is a foreign key in one table which leads to another unexisting table. To find where it is, you should access the file: siteurl/public/vendor/magento/framework/Setup/Declaration/Schema/Db.

Before the line 152, fix the code following this image: https://prnt.sc/sjjvww

  • Yes, that was it, thanks.
    – MagentoMac
    May 19, 2020 at 14:17
  • 2
    Well gee thanks for posting this as a screenshot which has been removed instead of a code fragment which could stay hosted for ever
    – eddhall
    Dec 13, 2021 at 23:45
  • the image on prnt.sc was deleted so how can I fix this?
    – huykon225
    Jan 24, 2022 at 17:56
  • -1 for screenshot was removed Jun 27, 2022 at 4:51
  • add your fix in comment please, screenshot is removed! Aug 8, 2023 at 8:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.