search

avstudnitz / AvS_FastSimpleImport

Wrapper for Magento ImportExport functionality, which imports products and customers from arrays
306 stars 146 forks source link

SQLSTATE[42000] and rollback #441

Closed FTEyurchenko closed 5 years ago

FTEyurchenko commented 5 years ago

Sometimes the import ends up failing with the following messages:

2019-08-13 09:30:07 \e[93m\033[1mPROCESSING\033[0m\e[39m [~~~~~~> ] 52% : 1314 processed / 21855 queries
2019-08-13 09:30:07 \e[93m\033[1mPROCESSING\033[0m\e[39m [~~~~~~~> ] 54% : 1533 processed / 21855 queries
2019-08-13 09:30:07 \e[93m\033[1mPROCESSING\033[0m\e[39m [~~~~~~~> ] 54% : 1752 processed / 21855 queries
2019-08-13 09:30:07 \e[91m\033[1mFAILED\033[0m\e[39m : SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax
2019-08-13 09:30:07 \e[91m\033[1mFAILED\033[0m\e[39m : Error while processing, rollback has been performed.
Error while processing, rollback has been performed.

It's hadly an access violation as nothing had been changed in auth stuff for a long time. I can't figure out the reason of this error as it doesn't happen constantly and there are success imports as well. F.e.:

2019-07-26 12:19:30 \e[93m\033[1mPROCESSING\033[0m\e[39m [~~~~~~~~~~>] 100% : 21939 processed / 21939 queries
2019-07-26 12:19:30 \e[93m\033[1mPROCESSING\033[0m\e[39m [~~~~~~~~~~>] 100% : 21940 processed / 21939 queries
2019-07-26 12:19:31 \e[93m\033[1mPROCESSING\033[0m\e[39m [~~~~~~~~~~>] 100% : >> Cataloginventory Stock re-indexed
2019-07-26 12:19:31 \e[93m\033[1mPROCESSING\033[0m\e[39m [~~~~~~~~~~>] 100% : >> Execute after process for stock
2019-07-26 12:19:31 \e[93m\033[1mPROCESSING\033[0m\e[39m [~~~~~~~~~~>] 100% : >> Execute after process for advancedinventory
2019-07-26 12:19:31 \e[92mSUCCEEDED\e[39m [~~~~~~~~~~>] 100% : 95 products ignored:sku, 4456, 7894, 9343, 9534, 10779, 10783, 11291, 11292, 11634, 12245, 12531, 12988, 13445, 13464, 13528, 14808, 15235, 15282, 15385..., 1828 products updated.

Could you help me, please? Thank you.