Details
-
Bug
-
Resolution: Fixed
-
None
-
Critical
-
A script to cleanup duplicated term attributes did not run successfully in some circumstances and was blocking the whole DB update procedure.
-
-
Description
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1,
query was: DELETE FROM `terms_attributes` WHERE `id` IN
(2824420,2824112,2824095,2824068,2824050,2823959,2823822,2823756,2823738,2823668,2823489,2823472,2822772,2822426,2821915
,2821898,2821869,2821852,2821689,2821672,2821511,2821494,2821318,2821293,2821150,2821133,2821104,2821087,2820845,2820230
,2819494,2819476,2819459,2819420,2819402,2819385,2819285,2819268,2818777,2818761,2818384,2818358,2817509,2817483,2817313
,2817295,2817278,2817089,2817072,2817028,2816970,2816952,2816922,2816905,2816329,2816311,2816294,2816265,2816247,2816230
,2816191,2816165,2816136,2816118,2816101,2816020,2816003,2815294,2815238,2815220,2815155,2814539,2814017,2814000,2813757
,2813739,2813691,2813674,2813476,2813459,2813242,2813224,2813207,2813012,2812994,2812977,2811709,2811692,2811636,2811618
,2811601,2811384,2811259,2811204,2811086,2811032,2810986,2810744,2810689,2810332,2810207,2810190,2809852,2809826,2809758
,2809732,2809535,2809518,2809472,2809293,2809237,2809069,2809022,2808958,2808894,2808837,2808820,2808322,2808305,2808160
,2808143,2808076,2808059,2807358,2807341,2807198,2807173,) in
/webs/instance-1014/vendor/shardj/zf1-future/library/Zend/Db/Statement/Pdo.php:235
Stack trace:
#0 /webs/instance-1014/vendor/shardj/zf1-future/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute()
#1 /webs/instance-1014/vendor/shardj/zf1-future/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute()
#2 /webs/instance-1014/vendor/shardj/zf1-future/library/Zend/Db/Adapter/Pdo/Abstract.php(238):
Zend_Db_Adapter_Abstract->query()
#3 /webs/instance-1014/application/modules/editor/database/377-TRANSLATE-3123-delete-attrs-duplicates.php(80):
Zend_Db_Adapter_Pdo_Abstract->query()
#4 /webs/instance-1014/application/modules/editor/database/377-TRANSLATE-3123-delete-attrs-duplicates.php(145):
cleanupAttrA()