Copied! Copy Stacktrace Search Stackoverflow Search Google Exception

Database Exceptionyii\db\Exception

SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
The SQL being executed was: INSERT INTO `ACCESS_TOKEN` (`CREATE_USER`, `CREATE_DATE`, `UPDATE_USER`, `UPDATE_DATE`, `SHOP_ID`, `ACCESS_TOKEN`, `REMOTE_IP`) VALUES (0, 1711635068, 0, 1711635068, 29046, 'P_Z6XczkLo5ZerM0iIKoUcNhayZ-o6LC', '52.54.111.228')

Error Info: Array
(
    [0] => HY000
    [1] => 1205
    [2] => Lock wait timeout exceeded; try restarting transaction
)
$_GET = [
    'suffix' => 'zh/catalog/product_compare/add/product/634/uenc/aHR0cHM6Ly93d3cuZml0Ym94eC5jb20vemgvcmVlYm9rLWdiNDAtb25lLXNlcmllcy1leGVyY2lzZS1iaWtlLmh0bWw,/form_key/jieYA1ClCOXvukF0/',
];

$_SESSION = [
    '__flash' => [],
    'currentOnlineShopId' => 3,
    'currentOnlineShop' => unserialize('O:23:"common\\models\\Warehouse":10:{s:36:"' . "\0" . 'yii\\db\\BaseActiveRecord' . "\0" . '_attributes";a:56:{s:2:"ID";i:3;s:11:"CREATE_USER";i:0;s:11:"CREATE_DATE";i:1691998466;s:11:"UPDATE_USER";i:57905;s:11:"UPDATE_DATE";i:1701308384;s:7:"SHOP_ID";i:29046;s:7:"TYPE_ID";i:9;s:4:"CODE";s:6:"HQ-WEB";s:3:"TEL";s:0:"";s:3:"FAX";N;s:5:"EMAIL";s:0:"";s:7:"WEBSITE";s:0:"";s:10:"COUNTRY_ID";i:1;s:9:"REGION_ID";N;s:11:"DISTRICT_ID";N;s:7:"AREA_ID";N;s:11:"DESCRIPTION";N;s:13:"SHOW_PRIORITY";N;s:7:"DEFAULT";N;s:11:"TABLE_TOTAL";i:50;s:10:"ENABLE_POS";N;s:18:"ENABLE_ONLINE_SHOP";i:1;s:5:"SEATS";s:0:"";s:7:"DELETED";N;s:8:"CURRENCY";s:3:"HKD";s:13:"BUSINESS_HOUR";s:11:"00:00-00:00";s:3:"LAT";s:11:"22.31930390";s:3:"LNG";s:12:"114.16936110";s:14:"MASTER_USER_ID";N;s:8:"DISABLED";N;s:15:"CORPORATE_OWNED";N;s:10:"TABLE_INFO";N;s:22:"REF_AGENT_WAREHOUSE_ID";N;s:17:"GOOGLE_MAP_SEARCH";s:0:"";s:8:"GROUP_ID";N;s:16:"PRD_WAREHOUSE_ID";N;s:19:"DEFAULT_ONLINE_SHOP";i:1;s:15:"APP_THEME_COLOR";s:5:"green";s:12:"APP_THEME_UI";s:20:"becup-accessories-01";s:12:"HEADER_THEME";s:5:"magic";s:19:"WEBSITE_TITLE_EN_US";s:0:"";s:19:"WEBSITE_TITLE_ZH_HK";s:0:"";s:19:"WEBSITE_TITLE_ZH_CN";N;s:4:"TAGS";N;s:17:"UFL_LOCATION_CODE";N;s:13:"FB_TABLE_INFO";N;s:13:"FRANCHISER_ID";N;s:9:"SOURCE_ID";i:3950;s:18:"ENABLE_RETURN_AREA";i:0;s:6:"REF_NO";N;s:13:"MAX_ORDER_QTY";N;s:18:"NUMBER_FORMAT_CODE";s:0:"";s:28:"SETTLEMENT_APPROVE_SYSTEM_ID";N;s:12:"BUSINESS_DAY";N;s:9:"PARENT_ID";N;s:28:"STOCK_OUT_SHIPPING_METHOD_ID";i:0;}s:39:"' . "\0" . 'yii\\db\\BaseActiveRecord' . "\0" . '_oldAttributes";a:56:{s:2:"ID";i:3;s:11:"CREATE_USER";i:0;s:11:"CREATE_DATE";i:1691998466;s:11:"UPDATE_USER";i:57905;s:11:"UPDATE_DATE";i:1701308384;s:7:"SHOP_ID";i:29046;s:7:"TYPE_ID";i:9;s:4:"CODE";s:6:"HQ-WEB";s:3:"TEL";s:0:"";s:3:"FAX";N;s:5:"EMAIL";s:0:"";s:7:"WEBSITE";s:0:"";s:10:"COUNTRY_ID";i:1;s:9:"REGION_ID";N;s:11:"DISTRICT_ID";N;s:7:"AREA_ID";N;s:11:"DESCRIPTION";N;s:13:"SHOW_PRIORITY";N;s:7:"DEFAULT";N;s:11:"TABLE_TOTAL";i:50;s:10:"ENABLE_POS";N;s:18:"ENABLE_ONLINE_SHOP";i:1;s:5:"SEATS";s:0:"";s:7:"DELETED";N;s:8:"CURRENCY";s:3:"HKD";s:13:"BUSINESS_HOUR";s:11:"00:00-00:00";s:3:"LAT";s:11:"22.31930390";s:3:"LNG";s:12:"114.16936110";s:14:"MASTER_USER_ID";N;s:8:"DISABLED";N;s:15:"CORPORATE_OWNED";N;s:10:"TABLE_INFO";N;s:22:"REF_AGENT_WAREHOUSE_ID";N;s:17:"GOOGLE_MAP_SEARCH";s:0:"";s:8:"GROUP_ID";N;s:16:"PRD_WAREHOUSE_ID";N;s:19:"DEFAULT_ONLINE_SHOP";i:1;s:15:"APP_THEME_COLOR";s:5:"green";s:12:"APP_THEME_UI";s:20:"becup-accessories-01";s:12:"HEADER_THEME";s:5:"magic";s:19:"WEBSITE_TITLE_EN_US";s:0:"";s:19:"WEBSITE_TITLE_ZH_HK";s:0:"";s:19:"WEBSITE_TITLE_ZH_CN";N;s:4:"TAGS";N;s:17:"UFL_LOCATION_CODE";N;s:13:"FB_TABLE_INFO";N;s:13:"FRANCHISER_ID";N;s:9:"SOURCE_ID";i:3950;s:18:"ENABLE_RETURN_AREA";i:0;s:6:"REF_NO";N;s:13:"MAX_ORDER_QTY";N;s:18:"NUMBER_FORMAT_CODE";s:0:"";s:28:"SETTLEMENT_APPROVE_SYSTEM_ID";N;s:12:"BUSINESS_DAY";N;s:9:"PARENT_ID";N;s:28:"STOCK_OUT_SHIPPING_METHOD_ID";i:0;}s:33:"' . "\0" . 'yii\\db\\BaseActiveRecord' . "\0" . '_related";a:0:{}s:47:"' . "\0" . 'yii\\db\\BaseActiveRecord' . "\0" . '_relationsDependencies";a:0:{}s:23:"' . "\0" . 'yii\\base\\Model' . "\0" . '_errors";N;s:27:"' . "\0" . 'yii\\base\\Model' . "\0" . '_validators";C:11:"ArrayObject":3702:{x:i:0;a:5:{i:0;O:30:"yii\\validators\\NumberValidator":20:{s:11:"integerOnly";b:1;s:3:"max";N;s:3:"min";N;s:6:"tooBig";N;s:8:"tooSmall";N;s:14:"integerPattern";s:18:"/^\\s*[+-]?\\d+\\s*$/";s:13:"numberPattern";s:48:"/^\\s*[-+]?[0-9]*\\.?[0-9]+([eE][-+]?[0-9]+)?\\s*$/";s:10:"attributes";a:19:{i:0;s:11:"CREATE_USER";i:1;s:11:"CREATE_DATE";i:2;s:11:"UPDATE_USER";i:3;s:11:"UPDATE_DATE";i:4;s:7:"SHOP_ID";i:5;s:7:"TYPE_ID";i:6;s:10:"COUNTRY_ID";i:7;s:9:"REGION_ID";i:8;s:11:"DISTRICT_ID";i:9;s:7:"AREA_ID";i:10;s:13:"SHOW_PRIORITY";i:11;s:7:"DEFAULT";i:12;s:11:"TABLE_TOTAL";i:13;s:10:"ENABLE_POS";i:14;s:18:"ENABLE_ONLINE_SHOP";i:15;s:7:"DELETED";i:16;s:14:"MASTER_USER_ID";i:17;s:8:"DISABLED";i:18;s:15:"CORPORATE_OWNED";}s:7:"message";s:31:"{attribute} must be an integer.";s:2:"on";a:0:{}s:6:"except";a:0:{}s:11:"skipOnError";b:1;s:11:"skipOnEmpty";b:1;s:22:"enableClientValidation";b:1;s:7:"isEmpty";N;s:4:"when";N;s:10:"whenClient";N;s:27:"' . "\0" . 'yii\\base\\Component' . "\0" . '_events";a:0:{}s:35:"' . "\0" . 'yii\\base\\Component' . "\0" . '_eventWildcards";a:0:{}s:30:"' . "\0" . 'yii\\base\\Component' . "\0" . '_behaviors";N;}i:1;O:30:"yii\\validators\\StringValidator":20:{s:6:"length";N;s:3:"max";N;s:3:"min";N;s:7:"message";s:29:"{attribute} must be a string.";s:8:"tooShort";N;s:7:"tooLong";N;s:8:"notEqual";N;s:8:"encoding";s:5:"utf-8";s:10:"attributes";a:3:{i:0;s:11:"DESCRIPTION";i:1;s:5:"SEATS";i:2;s:17:"GOOGLE_MAP_SEARCH";}s:2:"on";a:0:{}s:6:"except";a:0:{}s:11:"skipOnError";b:1;s:11:"skipOnEmpty";b:1;s:22:"enableClientValidation";b:1;s:7:"isEmpty";N;s:4:"when";N;s:10:"whenClient";N;s:27:"' . "\0" . 'yii\\base\\Component' . "\0" . '_events";a:0:{}s:35:"' . "\0" . 'yii\\base\\Component' . "\0" . '_eventWildcards";a:0:{}s:30:"' . "\0" . 'yii\\base\\Component' . "\0" . '_behaviors";N;}i:2;O:30:"yii\\validators\\StringValidator":20:{s:6:"length";N;s:3:"max";i:150;s:3:"min";N;s:7:"message";s:29:"{attribute} must be a string.";s:8:"tooShort";N;s:7:"tooLong";s:97:"{attribute} should contain at most {max, number} {max, plural, one{character} other{characters}}.";s:8:"notEqual";N;s:8:"encoding";s:5:"utf-8";s:10:"attributes";a:5:{i:0;s:4:"CODE";i:1;s:3:"TEL";i:2;s:3:"FAX";i:3;s:5:"EMAIL";i:4;s:7:"WEBSITE";}s:2:"on";a:0:{}s:6:"except";a:0:{}s:11:"skipOnError";b:1;s:11:"skipOnEmpty";b:1;s:22:"enableClientValidation";b:1;s:7:"isEmpty";N;s:4:"when";N;s:10:"whenClient";N;s:27:"' . "\0" . 'yii\\base\\Component' . "\0" . '_events";a:0:{}s:35:"' . "\0" . 'yii\\base\\Component' . "\0" . '_eventWildcards";a:0:{}s:30:"' . "\0" . 'yii\\base\\Component' . "\0" . '_behaviors";N;}i:3;O:30:"yii\\validators\\StringValidator":20:{s:6:"length";N;s:3:"max";i:3;s:3:"min";N;s:7:"message";s:29:"{attribute} must be a string.";s:8:"tooShort";N;s:7:"tooLong";s:97:"{attribute} should contain at most {max, number} {max, plural, one{character} other{characters}}.";s:8:"notEqual";N;s:8:"encoding";s:5:"utf-8";s:10:"attributes";a:1:{i:0;s:8:"CURRENCY";}s:2:"on";a:0:{}s:6:"except";a:0:{}s:11:"skipOnError";b:1;s:11:"skipOnEmpty";b:1;s:22:"enableClientValidation";b:1;s:7:"isEmpty";N;s:4:"when";N;s:10:"whenClient";N;s:27:"' . "\0" . 'yii\\base\\Component' . "\0" . '_events";a:0:{}s:35:"' . "\0" . 'yii\\base\\Component' . "\0" . '_eventWildcards";a:0:{}s:30:"' . "\0" . 'yii\\base\\Component' . "\0" . '_behaviors";N;}i:4;O:30:"yii\\validators\\StringValidator":20:{s:6:"length";N;s:3:"max";i:11;s:3:"min";N;s:7:"message";s:29:"{attribute} must be a string.";s:8:"tooShort";N;s:7:"tooLong";s:97:"{attribute} should contain at most {max, number} {max, plural, one{character} other{characters}}.";s:8:"notEqual";N;s:8:"encoding";s:5:"utf-8";s:10:"attributes";a:1:{i:0;s:13:"BUSINESS_HOUR";}s:2:"on";a:0:{}s:6:"except";a:0:{}s:11:"skipOnError";b:1;s:11:"skipOnEmpty";b:1;s:22:"enableClientValidation";b:1;s:7:"isEmpty";N;s:4:"when";N;s:10:"whenClient";N;s:27:"' . "\0" . 'yii\\base\\Component' . "\0" . '_events";a:0:{}s:35:"' . "\0" . 'yii\\base\\Component' . "\0" . '_eventWildcards";a:0:{}s:30:"' . "\0" . 'yii\\base\\Component' . "\0" . '_behaviors";N;}};m:a:0:{}}s:25:"' . "\0" . 'yii\\base\\Model' . "\0" . '_scenario";s:7:"default";s:27:"' . "\0" . 'yii\\base\\Component' . "\0" . '_events";a:5:{s:9:"afterFind";a:1:{i:0;a:2:{i:0;a:2:{i:0;O:40:"omgdef\\multilingual\\MultilingualBehavior":21:{s:10:"attributes";a:5:{i:0;s:4:"NAME";i:1;s:9:"ADDRESS_1";i:2;s:9:"ADDRESS_2";i:3;s:9:"ADDRESS_3";i:4;s:9:"ADDRESS_4";}s:9:"languages";a:2:{i:0;s:2:"EN";i:1;s:2:"ZH";}s:15:"defaultLanguage";s:2:"EN";s:9:"tableName";s:24:"{{%WAREHOUSE_TRANSLATE}}";s:13:"langClassName";s:27:"common\\models\\WarehouseLang";s:15:"langClassSuffix";s:4:"Lang";s:14:"langForeignKey";s:10:"FOREIGN_ID";s:15:"localizedPrefix";s:0:"";s:13:"languageField";s:8:"LANGUAGE";s:19:"requireTranslations";b:0;s:11:"forceDelete";b:1;s:16:"dynamicLangClass";b:1;s:7:"abridge";b:1;s:15:"currentLanguage";s:2:"ZH";s:56:"' . "\0" . 'omgdef\\multilingual\\MultilingualBehavior' . "\0" . 'ownerClassName";s:23:"common\\models\\Warehouse";s:57:"' . "\0" . 'omgdef\\multilingual\\MultilingualBehavior' . "\0" . 'ownerPrimaryKey";s:2:"ID";s:60:"' . "\0" . 'omgdef\\multilingual\\MultilingualBehavior' . "\0" . 'langClassShortName";s:13:"WarehouseLang";s:61:"' . "\0" . 'omgdef\\multilingual\\MultilingualBehavior' . "\0" . 'ownerClassShortName";s:9:"Warehouse";s:56:"' . "\0" . 'omgdef\\multilingual\\MultilingualBehavior' . "\0" . 'langAttributes";a:15:{s:7:"NAME_EN";N;s:4:"NAME";N;s:12:"ADDRESS_1_EN";N;s:9:"ADDRESS_1";N;s:12:"ADDRESS_2_EN";N;s:9:"ADDRESS_2";N;s:12:"ADDRESS_3_EN";N;s:9:"ADDRESS_3";N;s:12:"ADDRESS_4_EN";N;s:9:"ADDRESS_4";N;s:7:"NAME_ZH";N;s:12:"ADDRESS_1_ZH";N;s:12:"ADDRESS_2_ZH";N;s:12:"ADDRESS_3_ZH";N;s:12:"ADDRESS_4_ZH";N;}s:60:"' . "\0" . 'omgdef\\multilingual\\MultilingualBehavior' . "\0" . 'excludedValidators";a:1:{i:0;s:6:"unique";}s:5:"owner";r:1;}i:1;s:9:"afterFind";}i:1;N;}}s:11:"afterUpdate";a:1:{i:0;a:2:{i:0;a:2:{i:0;r:262;i:1;s:11:"afterUpdate";}i:1;N;}}s:11:"afterInsert";a:1:{i:0;a:2:{i:0;a:2:{i:0;r:262;i:1;s:11:"afterInsert";}i:1;N;}}s:11:"afterDelete";a:1:{i:0;a:2:{i:0;a:2:{i:0;r:262;i:1;s:11:"afterDelete";}i:1;N;}}s:14:"beforeValidate";a:1:{i:0;a:2:{i:0;a:2:{i:0;r:262;i:1;s:14:"beforeValidate";}i:1;N;}}}s:35:"' . "\0" . 'yii\\base\\Component' . "\0" . '_eventWildcards";a:0:{}s:30:"' . "\0" . 'yii\\base\\Component' . "\0" . '_behaviors";a:1:{s:2:"ml";r:262;}}'),
    'lang' => 'ZH_HK',
    'currency' => 'HKD',
    'currencies' => [
        'HKD',
        'CNY',
        'USD',
        'SGD',
        'EUR',
    ],
    'currencySymbol' => 'HK$',
    'p' => [],
    't' => 1711635068.4832,
    'beforeActioned' => true,
    'gLinked' => 1711635068,
];