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
-
2Well gee thanks for posting this as a screenshot which has been removed instead of a code fragment which could stay hosted for evereddhall– eddhall2021年12月13日 23:45:18 +00:00Commented Dec 13, 2021 at 23:45
-
the image on prnt.sc was deleted so how can I fix this?huykon225– huykon2252022年01月24日 17:56:28 +00:00Commented Jan 24, 2022 at 17:56
-
-1 for screenshot was removedYohanes Pradono– Yohanes Pradono2022年06月27日 04:51:13 +00:00Commented Jun 27, 2022 at 4:51
-
add your fix in comment please, screenshot is removed!Jonas de Herdt– Jonas de Herdt2023年08月08日 08:00:33 +00:00Commented Aug 8, 2023 at 8:00
-