Troubleshooting the "SQLSTATE[01000]: Warning: 1265 Data truncated for column 'pub_log_code' at row 1" Error in Channel Publishing: The Yii 2.0 Framework Returns a "42S22" Code Instead of a Numeric Value

1. During channel publishing, an error occurred: SQLSTATE[01000]: Warning: 1265 Data truncated for column ‘pub_log_code’ at row 1. As shown in Figure 1

JSON

{
    "name": "Database Exception",
    "message": "SQLSTATE[01000]: Warning: 1265 Data truncated for column 'pub_log_code' at row 1\nThe SQL being executed was: INSERT INTO `cpa_pre_pub_log` (`group_id`, `task_group_id`, `task_group_uuid`, `channel_id`, `channel_code`, `type`, `run_model`, `article_type_id`, `article_type_code`, `article_type_name`, `article_category_id`, `article_category_name`, `article_title`, `article_author`, `source`, `source_uuid`, `source_pub_user_id`, `source_callback_url`, `source_article_id`, `pub_log_code`, `pub_log_message`, `pub_log_body`, `status`, `is_deleted`, `created_at`, `updated_at`, `deleted_at`, `uuid`, `channel_type_id`, `channel_type_code`, `channel_app_source_id`, `channel_app_source_uuid`) VALUES ('59b8833e28c267350c8c0fa5d890c4a4', 0, '', 7, 'douyin', 'pub', 'yii2_queue', 3, 'video', '视频', 0, '', '', '', 'spider', '825e6d5e36468cc4bf536799ce3565c1', 1, 'https://api.dev.chinamcloud.cn/scms/api/thirdPush/callBack', 1, '42S22', 'SQLSTATE[42S22]: Column not found: 1054 Unknown column \\'channel_app_source_uuid\\' in \\'where clause\\'\\nThe SQL being executed was: SELECT * FROM `cpa_douyin_web_app_user_access_token` WHERE (`channel_app_source_uuid`=\\'8957c4e204c111ec97ac54ee75d2ebc1\\') AND (`is_deleted`=0)', 'a:13:{s:24:\\\"channel_app_source_uuids\\\";a:1:{i:0;s:32:\\\"8957c4e204c111ec97ac54ee75d2ebc1\\\";}s:6:\\\"source\\\";s:6:\\\"spider\\\";s:17:\\\"source_article_id\\\";i:1;s:19:\\\"source_callback_url\\\";s:58:\\\"https://api.dev.chinamcloud.cn/scms/api/thirdPush/callBack\\\";s:18:\\\"source_pub_user_id\\\";s:1:\\\"1\\\";s:11:\\\"source_uuid\\\";s:32:\\\"825e6d5e36468cc4bf536799ce3565c1\\\";s:18:\\\"video_absolute_url\\\";s:90:\\\"https://media.shuijingwanwq.com/2021/07/318公路上的进藏人.divx.avi\\\";s:4:\\\"text\\\";s:23:\\\"交契税了0.avchd.mts\\\";s:9:\\\"cover_tsp\\\";i:0;s:12:\\\"micro_app_id\\\";s:0:\\\"\\\";s:15:\\\"micro_app_title\\\";s:0:\\\"\\\";s:13:\\\"micro_app_url\\\";s:0:\\\"\\\";s:8:\\\"at_users\\\";a:0:{}}', 3, 0, 1629802670, 1629802670, 0, '1ff2c90804ca11ecafc554ee75d2ebc1', 17, 'douyin_web', 80, '8957c4e204c111ec97ac54ee75d2ebc1')",
    "code": "01000",
    "type": "yii\\db\\Exception",
    "file": "E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\Schema.php",
    "line": 678,
    "stack-trace": [
        "#0 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\Command.php(1304): yii\\db\\Schema->convertException(Object(PDOException), 'INSERT INTO `cp...')",
        "#1 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\Command.php(1099): yii\\db\\Command->internalExecute('INSERT INTO `cp...')",
        "#2 E:\\wwwroot\\ccp_api_dev_new\\common\\services\\PrePubLogService.php(166): yii\\db\\Command->execute()",
        "#3 E:\\wwwroot\\ccp_api_dev_new\\douyin\\filters\\PrePubLogFilter.php(50): common\\services\\PrePubLogService->createMultiple('59b8833e28c2673...', '42S22', 'SQLSTATE[42S22]...', 'douyin', 'pub', 'video', Array, 'yii2_queue')",
        "#4 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\ActionFilter.php(92): douyin\\filters\\PrePubLogFilter->afterAction(Object(douyin\\rests\\article\\VideoCreateAction), Array)",
        "#5 [internal function]: yii\\base\\ActionFilter->afterFilter(Object(yii\\base\\ActionEvent))",
        "#6 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Component.php(628): call_user_func(Array, Object(yii\\base\\ActionEvent))",
        "#7 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Controller.php(329): yii\\base\\Component->trigger('afterAction', Object(yii\\base\\ActionEvent))",
        "#8 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\rest\\Controller.php(76): yii\\base\\Controller->afterAction(Object(douyin\\rests\\article\\VideoCreateAction), Array)",
        "#9 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Controller.php(183): yii\\rest\\Controller->afterAction(Object(douyin\\rests\\article\\VideoCreateAction), Array)",
        "#10 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Module.php(534): yii\\base\\Controller->runAction('video-create', Array)",
        "#11 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\web\\Application.php(104): yii\\base\\Module->runAction('v1/article/vide...', Array)",
        "#12 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Application.php(392): yii\\web\\Application->handleRequest(Object(yii\\web\\Request))",
        "#13 E:\\wwwroot\\ccp_api_dev_new\\douyin\\web\\index.php(17): yii\\base\\Application->run()",
        "#14 {main}"
    ],
    "error-info": [
        "01000",
        1265,
        "Data truncated for column 'pub_log_code' at row 1"
    ],
    "previous": {
        "name": "Exception",
        "message": "SQLSTATE[01000]: Warning: 1265 Data truncated for column 'pub_log_code' at row 1",
        "code": "01000",
        "type": "PDOException",
        "file": "E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\Command.php",
        "line": 1299,
        "stack-trace": [
            "#0 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\Command.php(1299): PDOStatement->execute()",
            "#1 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\Command.php(1099): yii\\db\\Command->internalExecute('INSERT INTO `cp...')",
            "#2 E:\\wwwroot\\ccp_api_dev_new\\common\\services\\PrePubLogService.php(166): yii\\db\\Command->execute()",
            "#3 E:\\wwwroot\\ccp_api_dev_new\\douyin\\filters\\PrePubLogFilter.php(50): common\\services\\PrePubLogService->createMultiple('59b8833e28c2673...', '42S22', 'SQLSTATE[42S22]...', 'douyin', 'pub', 'video', Array, 'yii2_queue')",
            "#4 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\ActionFilter.php(92): douyin\\filters\\PrePubLogFilter->afterAction(Object(douyin\\rests\\article\\VideoCreateAction), Array)",
            "#5 [internal function]: yii\\base\\ActionFilter->afterFilter(Object(yii\\base\\ActionEvent))",
            "#6 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Component.php(628): call_user_func(Array, Object(yii\\base\\ActionEvent))",
            "#7 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Controller.php(329): yii\\base\\Component->trigger('afterAction', Object(yii\\base\\ActionEvent))",
            "#8 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\rest\\Controller.php(76): yii\\base\\Controller->afterAction(Object(douyin\\rests\\article\\VideoCreateAction), Array)",
            "#9 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Controller.php(183): yii\\rest\\Controller->afterAction(Object(douyin\\rests\\article\\VideoCreateAction), Array)",
            "#10 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Module.php(534): yii\\base\\Controller->runAction('video-create', Array)",
            "#11 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\web\\Application.php(104): yii\\base\\Module->runAction('v1/article/vide...', Array)",
            "#12 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Application.php(392): yii\\web\\Application->handleRequest(Object(yii\\web\\Request))",
            "#13 E:\\wwwroot\\ccp_api_dev_new\\douyin\\web\\index.php(17): yii\\base\\Application->run()",
            "#14 {main}"
        ]
    }
}


{
    "name": "Database Exception",
    "message": "SQLSTATE[01000]: Warning: 1265 Data truncated for column 'pub_log_code' at row 1\nThe SQL being executed was: INSERT INTO `cpa_pre_pub_log` (`group_id`, `task_group_id`, `task_group_uuid`, `channel_id`, `channel_code`, `type`, `run_model`, `article_type_id`, `article_type_code`, `article_type_name`, `article_category_id`, `article_category_name`, `article_title`, `article_author`, `source`, `source_uuid`, `source_pub_user_id`, `source_callback_url`, `source_article_id`, `pub_log_code`, `pub_log_message`, `pub_log_body`, `status`, `is_deleted`, `created_at`, `updated_at`, `deleted_at`, `uuid`, `channel_type_id`, `channel_type_code`, `channel_app_source_id`, `channel_app_source_uuid`) VALUES ('59b8833e28c267350c8c0fa5d890c4a4', 0, '', 7, 'douyin', 'pub', 'yii2_queue', 3, 'video', '视频', 0, '', '', '', 'spider', '825e6d5e36468cc4bf536799ce3565c1', 1, 'https://api.dev.chinamcloud.cn/scms/api/thirdPush/callBack', 1, '42S22', 'SQLSTATE[42S22]: Column not found: 1054 Unknown column \\'channel_app_source_uuid\\' in \\'where clause\\'\\nThe SQL being executed was: SELECT * FROM `cpa_douyin_web_app_user_access_token` WHERE (`channel_app_source_uuid`=\\'8957c4e204c111ec97ac54ee75d2ebc1\\') AND (`is_deleted`=0)', 'a:13:{s:24:\\\"channel_app_source_uuids\\\";a:1:{i:0;s:32:\\\"8957c4e204c111ec97ac54ee75d2ebc1\\\";}s:6:\\\"source\\\";s:6:\\\"spider\\\";s:17:\\\"source_article_id\\\";i:1;s:19:\\\"source_callback_url\\\";s:58:\\\"https://api.dev.chinamcloud.cn/scms/api/thirdPush/callBack\\\";s:18:\\\"source_pub_user_id\\\";s:1:\\\"1\\\";s:11:\\\"source_uuid\\\";s:32:\\\"825e6d5e36468cc4bf536799ce3565c1\\\";s:18:\\\"video_absolute_url\\\";s:90:\\\"https://media.shuijingwanwq.com/2021/07/318公路上的进藏人.divx.avi\\\";s:4:\\\"text\\\";s:23:\\\"交契税了0.avchd.mts\\\";s:9:\\\"cover_tsp\\\";i:0;s:12:\\\"micro_app_id\\\";s:0:\\\"\\\";s:15:\\\"micro_app_title\\\";s:0:\\\"\\\";s:13:\\\"micro_app_url\\\";s:0:\\\"\\\";s:8:\\\"at_users\\\";a:0:{}}', 3, 0, 1629802670, 1629802670, 0, '1ff2c90804ca11ecafc554ee75d2ebc1', 17, 'douyin_web', 80, '8957c4e204c111ec97ac54ee75d2ebc1')",
    "code": "01000",
    "type": "yii\\db\\Exception",
    "file": "E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\Schema.php",
    "line": 678,
    "stack-trace": [
        "#0 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\Command.php(1304): yii\\db\\Schema->convertException(Object(PDOException), 'INSERT INTO `cp...')",
        "#1 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\Command.php(1099): yii\\db\\Command->internalExecute('INSERT INTO `cp...')",
        "#2 E:\\wwwroot\\ccp_api_dev_new\\common\\services\\PrePubLogService.php(166): yii\\db\\Command->execute()",
        "#3 E:\\wwwroot\\ccp_api_dev_new\\douyin\\filters\\PrePubLogFilter.php(50): common\\services\\PrePubLogService->createMultiple('59b8833e28c2673...', '42S22', 'SQLSTATE[42S22]...', 'douyin', 'pub', 'video', Array, 'yii2_queue')",
        "#4 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\ActionFilter.php(92): douyin\\filters\\PrePubLogFilter->afterAction(Object(douyin\\rests\\article\\VideoCreateAction), Array)",
        "#5 [internal function]: yii\\base\\ActionFilter->afterFilter(Object(yii\\base\\ActionEvent))",
        "#6 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Component.php(628): call_user_func(Array, Object(yii\\base\\ActionEvent))",
        "#7 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Controller.php(329): yii\\base\\Component->trigger('afterAction', Object(yii\\base\\ActionEvent))",
        "#8 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\rest\\Controller.php(76): yii\\base\\Controller->afterAction(Object(douyin\\rests\\article\\VideoCreateAction), Array)",
        "#9 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Controller.php(183): yii\\rest\\Controller->afterAction(Object(douyin\\rests\\article\\VideoCreateAction), Array)",
        "#10 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Module.php(534): yii\\base\\Controller->runAction('video-create', Array)",
        "#11 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\web\\Application.php(104): yii\\base\\Module->runAction('v1/article/vide...', Array)",
        "#12 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Application.php(392): yii\\web\\Application->handleRequest(Object(yii\\web\\Request))",
        "#13 E:\\wwwroot\\ccp_api_dev_new\\douyin\\web\\index.php(17): yii\\base\\Application->run()",
        "#14 {main}"
    ],
    "error-info": [
        "01000",
        1265,
        "Data truncated for column 'pub_log_code' at row 1"
    ],
    "previous": {
        "name": "Exception",
        "message": "SQLSTATE[01000]: Warning: 1265 Data truncated for column 'pub_log_code' at row 1",
        "code": "01000",
        "type": "PDOException",
        "file": "E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\Command.php",
        "line": 1299,
        "stack-trace": [
            "#0 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\Command.php(1299): PDOStatement->execute()",
            "#1 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\Command.php(1099): yii\\db\\Command->internalExecute('INSERT INTO `cp...')",
            "#2 E:\\wwwroot\\ccp_api_dev_new\\common\\services\\PrePubLogService.php(166): yii\\db\\Command->execute()",
            "#3 E:\\wwwroot\\ccp_api_dev_new\\douyin\\filters\\PrePubLogFilter.php(50): common\\services\\PrePubLogService->createMultiple('59b8833e28c2673...', '42S22', 'SQLSTATE[42S22]...', 'douyin', 'pub', 'video', Array, 'yii2_queue')",
            "#4 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\ActionFilter.php(92): douyin\\filters\\PrePubLogFilter->afterAction(Object(douyin\\rests\\article\\VideoCreateAction), Array)",
            "#5 [internal function]: yii\\base\\ActionFilter->afterFilter(Object(yii\\base\\ActionEvent))",
            "#6 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Component.php(628): call_user_func(Array, Object(yii\\base\\ActionEvent))",
            "#7 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Controller.php(329): yii\\base\\Component->trigger('afterAction', Object(yii\\base\\ActionEvent))",
            "#8 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\rest\\Controller.php(76): yii\\base\\Controller->afterAction(Object(douyin\\rests\\article\\VideoCreateAction), Array)",
            "#9 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Controller.php(183): yii\\rest\\Controller->afterAction(Object(douyin\\rests\\article\\VideoCreateAction), Array)",
            "#10 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Module.php(534): yii\\base\\Controller->runAction('video-create', Array)",
            "#11 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\web\\Application.php(104): yii\\base\\Module->runAction('v1/article/vide...', Array)",
            "#12 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Application.php(392): yii\\web\\Application->handleRequest(Object(yii\\web\\Request))",
            "#13 E:\\wwwroot\\ccp_api_dev_new\\douyin\\web\\index.php(17): yii\\base\\Application->run()",
            "#14 {main}"
        ]
    }
}

2. The SQL error occurs because the type of the field: pub_log_code in the table: cpa_pre_pub_log is: int(11), but the inserted value is the string: 42S22. As shown in Figure 2

3. The value: 42S22 is obtained from: $e->getCode(). As shown in Figure 3

PHP

try {
} catch(\Throwable $e) {
    echo $e->getCode();
    exit;
    Yii::$app->response->statusCode = $e->statusCode ?? 200;
    return ['code' => $e->getCode(), 'message' => $e->getMessage()];
}


try {
} catch(\Throwable $e) {
    echo $e->getCode();
    exit;
    Yii::$app->response->statusCode = $e->statusCode ?? 200;
    return ['code' => $e->getCode(), 'message' => $e->getMessage()];
}

4. Comment out the exception-catching code. It is confirmed that the code value responded by the Yii 2.0 framework equals: 42S22. Prior to this, I always thought the response value type was only numeric. As shown in Figure 4

Comment out the exception-catching code. It is confirmed that the code value responded by the Yii 2.0 framework equals: 42S22. Prior to this, I always thought the response value type was only numeric. — Figure 4

PHP

// try {
// } catch(\Throwable $e) {
//     echo $e->getCode();
//     exit;
//     Yii::$app->response->statusCode = $e->statusCode ?? 200;
//     return ['code' => $e->getCode(), 'message' => $e->getMessage()];
// }


// try {
// } catch(\Throwable $e) {
//     echo $e->getCode();
//     exit;
//     Yii::$app->response->statusCode = $e->statusCode ?? 200;
//     return ['code' => $e->getCode(), 'message' => $e->getMessage()];
// }

JSON

{
    "name": "Database Exception",
    "message": "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'channel_app_source_uuid' in 'where clause'\nThe SQL being executed was: SELECT * FROM `cpa_douyin_web_app_user_access_token` WHERE (`channel_app_source_uuid`='8957c4e204c111ec97ac54ee75d2ebc1') AND (`is_deleted`=0)",
    "code": "42S22",
    "type": "yii\\db\\Exception",
    "file": "E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\Schema.php",
    "line": 678,
    "stack-trace": [
        "#0 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\Command.php(1304): yii\\db\\Schema->convertException(Object(PDOException), 'SELECT * FROM `...')",
        "#1 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\Command.php(1165): yii\\db\\Command->internalExecute('SELECT * FROM `...')",
        "#2 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\Command.php(407): yii\\db\\Command->queryInternal('fetchAll', NULL)",
        "#3 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\Query.php(249): yii\\db\\Command->queryAll()",
        "#4 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\ActiveQuery.php(133): yii\\db\\Query->all(NULL)",
        "#5 E:\\wwwroot\\ccp_api_dev_new\\common\\models\\DouyinWebAppUserAccessTokenQuery.php(23): yii\\db\\ActiveQuery->all(NULL)",
        "#6 E:\\wwwroot\\ccp_api_dev_new\\common\\logics\\DouyinWebAppUserAccessToken.php(107): common\\models\\DouyinWebAppUserAccessTokenQuery->all()",
        "#7 E:\\wwwroot\\ccp_api_dev_new\\common\\services\\DouyinWebAppAccessTokenService.php(101): common\\logics\\DouyinWebAppUserAccessToken::findAllByChannelAppSourceUuids(Array)",
        "#8 E:\\wwwroot\\ccp_api_dev_new\\douyin\\rests\\article\\VideoCreateAction.php(235): common\\services\\DouyinWebAppAccessTokenService::findModelsValidByChannelAppSourceUuids(Array)",
        "#9 [internal function]: douyin\\rests\\article\\VideoCreateAction->run()",
        "#10 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Action.php(94): call_user_func_array(Array, Array)",
        "#11 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Controller.php(181): yii\\base\\Action->runWithParams(Array)",
        "#12 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Module.php(534): yii\\base\\Controller->runAction('video-create', Array)",
        "#13 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\web\\Application.php(104): yii\\base\\Module->runAction('v1/article/vide...', Array)",
        "#14 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Application.php(392): yii\\web\\Application->handleRequest(Object(yii\\web\\Request))",
        "#15 E:\\wwwroot\\ccp_api_dev_new\\douyin\\web\\index.php(17): yii\\base\\Application->run()",
        "#16 {main}"
    ],
    "error-info": [
        "42S22",
        1054,
        "Unknown column 'channel_app_source_uuid' in 'where clause'"
    ],
    "previous": {
        "name": "Exception",
        "message": "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'channel_app_source_uuid' in 'where clause'",
        "code": "42S22",
        "type": "PDOException",
        "file": "E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\Command.php",
        "line": 1299,
        "stack-trace": [
            "#0 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\Command.php(1299): PDOStatement->execute()",
            "#1 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\Command.php(1165): yii\\db\\Command->internalExecute('SELECT * FROM `...')",
            "#2 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\Command.php(407): yii\\db\\Command->queryInternal('fetchAll', NULL)",
            "#3 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\Query.php(249): yii\\db\\Command->queryAll()",
            "#4 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\ActiveQuery.php(133): yii\\db\\Query->all(NULL)",
            "#5 E:\\wwwroot\\ccp_api_dev_new\\common\\models\\DouyinWebAppUserAccessTokenQuery.php(23): yii\\db\\ActiveQuery->all(NULL)",
            "#6 E:\\wwwroot\\ccp_api_dev_new\\common\\logics\\DouyinWebAppUserAccessToken.php(107): common\\models\\DouyinWebAppUserAccessTokenQuery->all()",
            "#7 E:\\wwwroot\\ccp_api_dev_new\\common\\services\\DouyinWebAppAccessTokenService.php(101): common\\logics\\DouyinWebAppUserAccessToken::findAllByChannelAppSourceUuids(Array)",
            "#8 E:\\wwwroot\\ccp_api_dev_new\\douyin\\rests\\article\\VideoCreateAction.php(235): common\\services\\DouyinWebAppAccessTokenService::findModelsValidByChannelAppSourceUuids(Array)",
            "#9 [internal function]: douyin\\rests\\article\\VideoCreateAction->run()",
            "#10 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Action.php(94): call_user_func_array(Array, Array)",
            "#11 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Controller.php(181): yii\\base\\Action->runWithParams(Array)",
            "#12 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Module.php(534): yii\\base\\Controller->runAction('video-create', Array)",
            "#13 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\web\\Application.php(104): yii\\base\\Module->runAction('v1/article/vide...', Array)",
            "#14 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Application.php(392): yii\\web\\Application->handleRequest(Object(yii\\web\\Request))",
            "#15 E:\\wwwroot\\ccp_api_dev_new\\douyin\\web\\index.php(17): yii\\base\\Application->run()",
            "#16 {main}"
        ]
    }
}


{
    "name": "Database Exception",
    "message": "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'channel_app_source_uuid' in 'where clause'\nThe SQL being executed was: SELECT * FROM `cpa_douyin_web_app_user_access_token` WHERE (`channel_app_source_uuid`='8957c4e204c111ec97ac54ee75d2ebc1') AND (`is_deleted`=0)",
    "code": "42S22",
    "type": "yii\\db\\Exception",
    "file": "E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\Schema.php",
    "line": 678,
    "stack-trace": [
        "#0 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\Command.php(1304): yii\\db\\Schema->convertException(Object(PDOException), 'SELECT * FROM `...')",
        "#1 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\Command.php(1165): yii\\db\\Command->internalExecute('SELECT * FROM `...')",
        "#2 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\Command.php(407): yii\\db\\Command->queryInternal('fetchAll', NULL)",
        "#3 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\Query.php(249): yii\\db\\Command->queryAll()",
        "#4 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\ActiveQuery.php(133): yii\\db\\Query->all(NULL)",
        "#5 E:\\wwwroot\\ccp_api_dev_new\\common\\models\\DouyinWebAppUserAccessTokenQuery.php(23): yii\\db\\ActiveQuery->all(NULL)",
        "#6 E:\\wwwroot\\ccp_api_dev_new\\common\\logics\\DouyinWebAppUserAccessToken.php(107): common\\models\\DouyinWebAppUserAccessTokenQuery->all()",
        "#7 E:\\wwwroot\\ccp_api_dev_new\\common\\services\\DouyinWebAppAccessTokenService.php(101): common\\logics\\DouyinWebAppUserAccessToken::findAllByChannelAppSourceUuids(Array)",
        "#8 E:\\wwwroot\\ccp_api_dev_new\\douyin\\rests\\article\\VideoCreateAction.php(235): common\\services\\DouyinWebAppAccessTokenService::findModelsValidByChannelAppSourceUuids(Array)",
        "#9 [internal function]: douyin\\rests\\article\\VideoCreateAction->run()",
        "#10 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Action.php(94): call_user_func_array(Array, Array)",
        "#11 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Controller.php(181): yii\\base\\Action->runWithParams(Array)",
        "#12 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Module.php(534): yii\\base\\Controller->runAction('video-create', Array)",
        "#13 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\web\\Application.php(104): yii\\base\\Module->runAction('v1/article/vide...', Array)",
        "#14 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Application.php(392): yii\\web\\Application->handleRequest(Object(yii\\web\\Request))",
        "#15 E:\\wwwroot\\ccp_api_dev_new\\douyin\\web\\index.php(17): yii\\base\\Application->run()",
        "#16 {main}"
    ],
    "error-info": [
        "42S22",
        1054,
        "Unknown column 'channel_app_source_uuid' in 'where clause'"
    ],
    "previous": {
        "name": "Exception",
        "message": "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'channel_app_source_uuid' in 'where clause'",
        "code": "42S22",
        "type": "PDOException",
        "file": "E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\Command.php",
        "line": 1299,
        "stack-trace": [
            "#0 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\Command.php(1299): PDOStatement->execute()",
            "#1 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\Command.php(1165): yii\\db\\Command->internalExecute('SELECT * FROM `...')",
            "#2 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\Command.php(407): yii\\db\\Command->queryInternal('fetchAll', NULL)",
            "#3 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\Query.php(249): yii\\db\\Command->queryAll()",
            "#4 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\db\\ActiveQuery.php(133): yii\\db\\Query->all(NULL)",
            "#5 E:\\wwwroot\\ccp_api_dev_new\\common\\models\\DouyinWebAppUserAccessTokenQuery.php(23): yii\\db\\ActiveQuery->all(NULL)",
            "#6 E:\\wwwroot\\ccp_api_dev_new\\common\\logics\\DouyinWebAppUserAccessToken.php(107): common\\models\\DouyinWebAppUserAccessTokenQuery->all()",
            "#7 E:\\wwwroot\\ccp_api_dev_new\\common\\services\\DouyinWebAppAccessTokenService.php(101): common\\logics\\DouyinWebAppUserAccessToken::findAllByChannelAppSourceUuids(Array)",
            "#8 E:\\wwwroot\\ccp_api_dev_new\\douyin\\rests\\article\\VideoCreateAction.php(235): common\\services\\DouyinWebAppAccessTokenService::findModelsValidByChannelAppSourceUuids(Array)",
            "#9 [internal function]: douyin\\rests\\article\\VideoCreateAction->run()",
            "#10 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Action.php(94): call_user_func_array(Array, Array)",
            "#11 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Controller.php(181): yii\\base\\Action->runWithParams(Array)",
            "#12 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Module.php(534): yii\\base\\Controller->runAction('video-create', Array)",
            "#13 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\web\\Application.php(104): yii\\base\\Module->runAction('v1/article/vide...', Array)",
            "#14 E:\\wwwroot\\ccp_api_dev_new\\vendor\\yiisoft\\yii2\\base\\Application.php(392): yii\\web\\Application->handleRequest(Object(yii\\web\\Request))",
            "#15 E:\\wwwroot\\ccp_api_dev_new\\douyin\\web\\index.php(17): yii\\base\\Application->run()",
            "#16 {main}"
        ]
    }
}

5. The solution at this stage is either to change the type of the field: pub_log_code in the table: cpa_pre_pub_log to: varchar(16), or to convert the value type of $e->getCode() to a numeric type. I have temporarily decided to adopt the latter approach, since the probability of the response code value type being a string is extremely low. As shown in Figure 5

The solution at this stage is either to change the type of the field: pub_log_code in the table: cpa_pre_pub_log to: varchar(16), or to convert the value type of $e->getCode() to a numeric type. I have temporarily decided to adopt the latter approach, since the probability of the response code value type being a string is extremely low. — Figure 5

PHP

try {
} catch(\Throwable $e) {
    Yii::$app->response->statusCode = $e->statusCode ?? 200;
    return ['code' => (int) $e->getCode(), 'message' => $e->getMessage()];
}


try {
} catch(\Throwable $e) {
    Yii::$app->response->statusCode = $e->statusCode ?? 200;
    return ['code' => (int) $e->getCode(), 'message' => $e->getMessage()];
}

6. I decided to first fundamentally resolve the issue of throwing the exception, so that it no longer throws an exception. This is a program bug. SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘channel_app_source_uuid’ in ‘where clause’. The field: channel_app_source_uuid no longer exists in the table: cpa_douyin_web_app_user_access_token.

关于作者 · 持续学习与技术实践

我是一名拥有 15 年以上开发经验的技术从业者，自 2013 年起持续运营个人技术博客，记录工作与个人项目中遇到的真实问题，以及解决问题过程中的探索、实践和思考。

除了技术写作，我也在持续开发和维护自己的独立项目，探索新技术和新工具在实际场景中的应用。我始终相信，没有不值得去解决的问题，也没有不值得去学习的技术。

如果这篇文章对你有所帮助，欢迎浏览博客中的其他文章，也欢迎交流技术经验与想法。

关于我 · GitHub · 邮件联系

Troubleshooting the “SQLSTATE[01000]: Warning: 1265 Data truncated for column ‘pub_log_code’ at row 1” Error in Channel Publishing: The Yii 2.0 Framework Returns a “42S22” Code Instead of a Numeric Value

更多文章

保护机制也会保护错东西：为什么一个 Documentation 能阻塞整页修订？

页面明明是我自己的，为什么不能直接重写？从 /translation/ 改版看 immutable source 与 replacement successor

为什么修完 Reviewer 指出的所有例子，下一轮还是会失败？从 B→revision→B 看同类问题完整性

为下一次 PHP 8.5 升级做准备：从两次验证失败到自动回滚工具完成