Magento 2.3.1 errors in logSQL Syntax Error near 'cat_index.is_parent=1'My magento database keeps crashing and doesn't log any errorsMagento 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 bellowMagento 2.3.1 Error on checkout getAdditionalInformation()apache2.4; php7.2.16 @debian9 squeeze + Magento CE 2.3.1Data migration from 1.9.2.4 to 2.3.1 - FailureCategory page not working Magento 2 with more than 13 million productsCustom feed get only hidden image Magento 2.3.1
Why are thrust reversers not used down to taxi speeds?
Align a table column at a specific symbol
My Sixteen Friendly Students
What dice to use in a game that revolves around triangles?
Company stopped paying my salary. What are my options?
The unknown and unexplained in science fiction
Where do 5 or more U.S. counties meet in a single point?
Can I bring back Planetary Romance as a genre?
Program for finding longest run of zeros from a list of 100 random integers which are either 0 or 1
What should I use to get rid of some kind of weed in my onions
Steganography in Latex
How long can fsck take on a 30 TB volume?
Can radiation block all wireless communications?
Crime rates in a post-scarcity economy
How do I politely tell my players to shut up about their backstory?
How to append code verbatim to .bashrc?
Do these creatures from the Tomb of Annihilation campaign speak Common?
What is the oldest instrument ever?
Why is the episode called "The Last of the Starks"?
Magical Modulo Squares
Is it safe to keep the GPU on 100% utilization for a very long time?
History: Per Leviticus 19:27 would the apostles have had corner locks ala Hassidim today?
Names of the Six Tastes
Why is it wrong to *implement* myself a known, published, widely believed to be secure crypto algorithm?
Magento 2.3.1 errors in log
SQL Syntax Error near 'cat_index.is_parent=1'My magento database keeps crashing and doesn't log any errorsMagento 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 bellowMagento 2.3.1 Error on checkout getAdditionalInformation()apache2.4; php7.2.16 @debian9 squeeze + Magento CE 2.3.1Data migration from 1.9.2.4 to 2.3.1 - FailureCategory page not working Magento 2 with more than 13 million productsCustom feed get only hidden image Magento 2.3.1
.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:
exception.log
every 5 mins I have
report.CRITICAL: Unable to send mail. "exception":"[object] (Zend_Mail_Transport_Exception(code: 0): Unable to send mail. at /home/wpaper/public_html/vendor/magento/zendframework1/library/Zend/Mail/Transport/Sendmail.php:111)" []
But it doesn't seem that mails aren't working. All transactions mails working. I use smtp.
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 can't understand if exception and system errors are related. 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 to solve these?
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:
exception.log
every 5 mins I have
report.CRITICAL: Unable to send mail. "exception":"[object] (Zend_Mail_Transport_Exception(code: 0): Unable to send mail. at /home/wpaper/public_html/vendor/magento/zendframework1/library/Zend/Mail/Transport/Sendmail.php:111)" []
But it doesn't seem that mails aren't working. All transactions mails working. I use smtp.
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 can't understand if exception and system errors are related. 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 to solve these?
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:
exception.log
every 5 mins I have
report.CRITICAL: Unable to send mail. "exception":"[object] (Zend_Mail_Transport_Exception(code: 0): Unable to send mail. at /home/wpaper/public_html/vendor/magento/zendframework1/library/Zend/Mail/Transport/Sendmail.php:111)" []
But it doesn't seem that mails aren't working. All transactions mails working. I use smtp.
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 can't understand if exception and system errors are related. 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 to solve these?
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:
exception.log
every 5 mins I have
report.CRITICAL: Unable to send mail. "exception":"[object] (Zend_Mail_Transport_Exception(code: 0): Unable to send mail. at /home/wpaper/public_html/vendor/magento/zendframework1/library/Zend/Mail/Transport/Sendmail.php:111)" []
But it doesn't seem that mails aren't working. All transactions mails working. I use smtp.
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 can't understand if exception and system errors are related. 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 to solve these?
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
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 |
0
active
oldest
votes
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-errors-in-log%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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-errors-in-log%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
