Magento 2.3.1 Base table or view not foundMagento 2.3 introduced a view table which causes issue with import of mysql dump. What's it for?SQL Syntax Error near 'cat_index.is_parent=1'Troubleshooting “Base table or view not found”SQLSTATE[42S02]: Base table or view not found in extensionBase table or view not found: 1146Base table or view not found errorBase table or view not found: 1146 TableMagento more than 61 product attribute database tables in join queryProblem with SQLSTATE[42S22]: Column not foundMagento 2.1.6 website is working fine but suddenly in one subcategory I'm getting the error bellowCategory page not working Magento 2 with more than 13 million products
First Program Tic-Tac-Toe
3 prong range outlet
What did the 'turbo' button actually do?
Does French have the English "short i" vowel?
Is superuser the same as root?
Why is the Eisenstein ideal paper so great?
Why is 'additive' EQ more difficult to use than 'subtractive'?
On San Andreas Speedruns, why do players blow up the Picador in the mission Ryder?
Time complexity of an algorithm: Is it important to state the base of the logarithm?
Final exams: What is the most common protocol for scheduling?
Would Buddhists help non-Buddhists continuing their attachments?
Why does the hash of infinity have the digits of π?
Of strange atmospheres - the survivable but unbreathable
Are runways booked by airlines to land their planes?
Where is Jon going?
One word for 'the thing that attracts me'?
How to melt snow without fire or using body heat?
Navigating a quick return to previous employer
Using too much dialogue?
What weight should be given to writers groups critiques?
Expected maximum number of unpaired socks
Shorten or merge multiple lines of `&> /dev/null &`
Python program for fibonacci sequence using a recursive function
Can you still travel to America on the ESTA waiver program if you have been to Iran in transit?
Magento 2.3.1 Base table or view not found
Magento 2.3 introduced a view table which causes issue with import of mysql dump. What's it for?SQL Syntax Error near 'cat_index.is_parent=1'Troubleshooting “Base table or view not found”SQLSTATE[42S02]: Base table or view not found in extensionBase table or view not found: 1146Base table or view not found errorBase table or view not found: 1146 TableMagento more than 61 product attribute database tables in join queryProblem with SQLSTATE[42S22]: Column not foundMagento 2.1.6 website is working fine but suddenly in one subcategory I'm getting the error bellowCategory page not working Magento 2 with more than 13 million products
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
Magento 2.3.1 keep filling logs with these errors:
system.log
[2019-05-04 23:30:12] report.INFO: SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index_store0` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=0 AND cat_index.visibility IN(3, 2, 4) AND cat_index.category_id=0
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '0' AND price_index.customer_group_id = 0 WHERE ((`e`.`entity_id` IN(23262))) AND (e.created_in <= '1556754420') AND (e.updated_in > '1556754420') [] []
[2019-05-04 23:30:12] report.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento231.catalog_category_product_index_store0' doesn't exist, query was: SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index_store0` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=0 AND cat_index.visibility IN(3, 2, 4) AND cat_index.category_id=0
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '0' AND price_index.customer_group_id = 0 WHERE ((`e`.`entity_id` IN(23262))) AND (e.created_in <= '1556754420') AND (e.updated_in > '1556754420') [] []
system.log is filled with these two errors.
I don't see a problem somewhere or maybe I didn't notice.
I use a two language store. In the times I see in log only crons are running but in their log I don't have issue.All crons successful finished.
Can anyone help me where to check please?
database magento2.3 exception
asked May 4 at 23:48
G. G.G. G.
11519
add a comment |
Magento 2.3.1 keep filling logs with these errors:
system.log
[2019-05-04 23:30:12] report.INFO: SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index_store0` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=0 AND cat_index.visibility IN(3, 2, 4) AND cat_index.category_id=0
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '0' AND price_index.customer_group_id = 0 WHERE ((`e`.`entity_id` IN(23262))) AND (e.created_in <= '1556754420') AND (e.updated_in > '1556754420') [] []
[2019-05-04 23:30:12] report.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento231.catalog_category_product_index_store0' doesn't exist, query was: SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index_store0` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=0 AND cat_index.visibility IN(3, 2, 4) AND cat_index.category_id=0
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '0' AND price_index.customer_group_id = 0 WHERE ((`e`.`entity_id` IN(23262))) AND (e.created_in <= '1556754420') AND (e.updated_in > '1556754420') [] []
system.log is filled with these two errors.
I don't see a problem somewhere or maybe I didn't notice.
I use a two language store. In the times I see in log only crons are running but in their log I don't have issue.All crons successful finished.
Can anyone help me where to check please?
database magento2.3 exception
asked May 4 at 23:48
G. G.G. G.
11519
add a comment |
Magento 2.3.1 keep filling logs with these errors:
system.log
[2019-05-04 23:30:12] report.INFO: SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index_store0` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=0 AND cat_index.visibility IN(3, 2, 4) AND cat_index.category_id=0
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '0' AND price_index.customer_group_id = 0 WHERE ((`e`.`entity_id` IN(23262))) AND (e.created_in <= '1556754420') AND (e.updated_in > '1556754420') [] []
[2019-05-04 23:30:12] report.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento231.catalog_category_product_index_store0' doesn't exist, query was: SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index_store0` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=0 AND cat_index.visibility IN(3, 2, 4) AND cat_index.category_id=0
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '0' AND price_index.customer_group_id = 0 WHERE ((`e`.`entity_id` IN(23262))) AND (e.created_in <= '1556754420') AND (e.updated_in > '1556754420') [] []
system.log is filled with these two errors.
I don't see a problem somewhere or maybe I didn't notice.
I use a two language store. In the times I see in log only crons are running but in their log I don't have issue.All crons successful finished.
Can anyone help me where to check please?
database magento2.3 exception
asked May 4 at 23:48
G. G.G. G.
11519
Magento 2.3.1 keep filling logs with these errors:
system.log
[2019-05-04 23:30:12] report.INFO: SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index_store0` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=0 AND cat_index.visibility IN(3, 2, 4) AND cat_index.category_id=0
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '0' AND price_index.customer_group_id = 0 WHERE ((`e`.`entity_id` IN(23262))) AND (e.created_in <= '1556754420') AND (e.updated_in > '1556754420') [] []
[2019-05-04 23:30:12] report.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento231.catalog_category_product_index_store0' doesn't exist, query was: SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index_store0` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=0 AND cat_index.visibility IN(3, 2, 4) AND cat_index.category_id=0
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '0' AND price_index.customer_group_id = 0 WHERE ((`e`.`entity_id` IN(23262))) AND (e.created_in <= '1556754420') AND (e.updated_in > '1556754420') [] []
system.log is filled with these two errors.
I don't see a problem somewhere or maybe I didn't notice.
I use a two language store. In the times I see in log only crons are running but in their log I don't have issue.All crons successful finished.
Can anyone help me where to check please?
database magento2.3 exception
database magento2.3 exception
asked May 4 at 23:48
G. G.G. G.
11519
asked May 4 at 23:48
G. G.G. G.
11519
edited May 16 at 18:18
G. G.
asked May 4 at 23:48
G. G.G. G.
11519
asked May 4 at 23:48
G. G.G. G.
11519
asked May 4 at 23:48
G. G.G. G.
11519
11519
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
How did you create your database? Did you migrate from another server using mysql dump?
If so the answer is the view part of the question I asked.
Magento 2.3 introduced a view table which causes issue with import of mysql dump. What's it for?
think maybe either you are missing the view or the query requiring elevated access in the import interrupted inserting foreign keys into your database
answered May 16 at 18:35
Dominic XigenDominic Xigen
39810
Yes....it is migrated from magento 1.9.3.8. I checked your post. Is this the fix??
– G. G.
May 16 at 18:35
As how to fix. I think the only thing you can do is install 2.3.1 on separate dev box as fresh install - no migration and try and compare keys to work out what's missing
– Dominic Xigen
May 16 at 18:39
Really?? Install new instance? I have 3gb database....what to compare there....So if you dump you can't import again?
– G. G.
May 16 at 18:41
1
You don't have to start again. I say do a mysql dump on problem install and fresh vanilla install of 2.3.1 and compare foreign keys. See what's missing. Hopefully you can manually add missing to problem install.
– Dominic Xigen
May 16 at 18:44
Understood.I will do that and post here! Thank you
– G. G.
May 16 at 18:46
|
show 3 more comments
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f273441%2fmagento-2-3-1-base-table-or-view-not-found%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
How did you create your database? Did you migrate from another server using mysql dump?
If so the answer is the view part of the question I asked.
Magento 2.3 introduced a view table which causes issue with import of mysql dump. What's it for?
think maybe either you are missing the view or the query requiring elevated access in the import interrupted inserting foreign keys into your database
answered May 16 at 18:35
Dominic XigenDominic Xigen
39810
Yes....it is migrated from magento 1.9.3.8. I checked your post. Is this the fix??
– G. G.
May 16 at 18:35
As how to fix. I think the only thing you can do is install 2.3.1 on separate dev box as fresh install - no migration and try and compare keys to work out what's missing
– Dominic Xigen
May 16 at 18:39
Really?? Install new instance? I have 3gb database....what to compare there....So if you dump you can't import again?
– G. G.
May 16 at 18:41
1
You don't have to start again. I say do a mysql dump on problem install and fresh vanilla install of 2.3.1 and compare foreign keys. See what's missing. Hopefully you can manually add missing to problem install.
– Dominic Xigen
May 16 at 18:44
Understood.I will do that and post here! Thank you
– G. G.
May 16 at 18:46
|
show 3 more comments
How did you create your database? Did you migrate from another server using mysql dump?
If so the answer is the view part of the question I asked.
Magento 2.3 introduced a view table which causes issue with import of mysql dump. What's it for?
think maybe either you are missing the view or the query requiring elevated access in the import interrupted inserting foreign keys into your database
answered May 16 at 18:35
Dominic XigenDominic Xigen
39810
Yes....it is migrated from magento 1.9.3.8. I checked your post. Is this the fix??
– G. G.
May 16 at 18:35
As how to fix. I think the only thing you can do is install 2.3.1 on separate dev box as fresh install - no migration and try and compare keys to work out what's missing
– Dominic Xigen
May 16 at 18:39
Really?? Install new instance? I have 3gb database....what to compare there....So if you dump you can't import again?
– G. G.
May 16 at 18:41
1
You don't have to start again. I say do a mysql dump on problem install and fresh vanilla install of 2.3.1 and compare foreign keys. See what's missing. Hopefully you can manually add missing to problem install.
– Dominic Xigen
May 16 at 18:44
Understood.I will do that and post here! Thank you
– G. G.
May 16 at 18:46
|
show 3 more comments
How did you create your database? Did you migrate from another server using mysql dump?
If so the answer is the view part of the question I asked.
Magento 2.3 introduced a view table which causes issue with import of mysql dump. What's it for?
think maybe either you are missing the view or the query requiring elevated access in the import interrupted inserting foreign keys into your database
answered May 16 at 18:35
Dominic XigenDominic Xigen
39810
How did you create your database? Did you migrate from another server using mysql dump?
If so the answer is the view part of the question I asked.
Magento 2.3 introduced a view table which causes issue with import of mysql dump. What's it for?
think maybe either you are missing the view or the query requiring elevated access in the import interrupted inserting foreign keys into your database
answered May 16 at 18:35
Dominic XigenDominic Xigen
39810
edited May 16 at 18:37
answered May 16 at 18:35
Dominic XigenDominic Xigen
39810
answered May 16 at 18:35
Dominic XigenDominic Xigen
39810
answered May 16 at 18:35
Dominic XigenDominic Xigen
39810
39810
Yes....it is migrated from magento 1.9.3.8. I checked your post. Is this the fix??
– G. G.
May 16 at 18:35
As how to fix. I think the only thing you can do is install 2.3.1 on separate dev box as fresh install - no migration and try and compare keys to work out what's missing
– Dominic Xigen
May 16 at 18:39
Really?? Install new instance? I have 3gb database....what to compare there....So if you dump you can't import again?
– G. G.
May 16 at 18:41
1
You don't have to start again. I say do a mysql dump on problem install and fresh vanilla install of 2.3.1 and compare foreign keys. See what's missing. Hopefully you can manually add missing to problem install.
– Dominic Xigen
May 16 at 18:44
Understood.I will do that and post here! Thank you
– G. G.
May 16 at 18:46
|
show 3 more comments
Yes....it is migrated from magento 1.9.3.8. I checked your post. Is this the fix??
– G. G.
May 16 at 18:35
As how to fix. I think the only thing you can do is install 2.3.1 on separate dev box as fresh install - no migration and try and compare keys to work out what's missing
– Dominic Xigen
May 16 at 18:39
Really?? Install new instance? I have 3gb database....what to compare there....So if you dump you can't import again?
– G. G.
May 16 at 18:41
1
You don't have to start again. I say do a mysql dump on problem install and fresh vanilla install of 2.3.1 and compare foreign keys. See what's missing. Hopefully you can manually add missing to problem install.
– Dominic Xigen
May 16 at 18:44
Understood.I will do that and post here! Thank you
– G. G.
May 16 at 18:46
Yes....it is migrated from magento 1.9.3.8. I checked your post. Is this the fix??
– G. G.
May 16 at 18:35
Yes....it is migrated from magento 1.9.3.8. I checked your post. Is this the fix??
– G. G.
May 16 at 18:35
As how to fix. I think the only thing you can do is install 2.3.1 on separate dev box as fresh install - no migration and try and compare keys to work out what's missing
– Dominic Xigen
May 16 at 18:39
As how to fix. I think the only thing you can do is install 2.3.1 on separate dev box as fresh install - no migration and try and compare keys to work out what's missing
– Dominic Xigen
May 16 at 18:39
Really?? Install new instance? I have 3gb database....what to compare there....So if you dump you can't import again?
– G. G.
May 16 at 18:41
Really?? Install new instance? I have 3gb database....what to compare there....So if you dump you can't import again?
– G. G.
May 16 at 18:41
1
1
You don't have to start again. I say do a mysql dump on problem install and fresh vanilla install of 2.3.1 and compare foreign keys. See what's missing. Hopefully you can manually add missing to problem install.
– Dominic Xigen
May 16 at 18:44
You don't have to start again. I say do a mysql dump on problem install and fresh vanilla install of 2.3.1 and compare foreign keys. See what's missing. Hopefully you can manually add missing to problem install.
– Dominic Xigen
May 16 at 18:44
Understood.I will do that and post here! Thank you
– G. G.
May 16 at 18:46
Understood.I will do that and post here! Thank you
– G. G.
May 16 at 18:46
|
show 3 more comments
Thanks for contributing an answer to Magento Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f273441%2fmagento-2-3-1-base-table-or-view-not-found%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
