成功添加GitLab应用之后，无法关联GitLab的代码库。已解决 悬赏15积分

# 环境信息：

OS:  Ubuntu 22.04.3 LTS (GNU/Linux 5.15.0-107-generic x86_64)

客户端浏览器：Google Chrome，Microsoft Edge

禅道版本：禅道开源版：20.0

# 问题描述：

# 错误提示信息：

Webhook创建失败，请查看日志

# 错误信息截图

# DevOps > 应用 > 添加应用 

- 保存GitLab成功

日志目录：/opt/zentao/data/zentao/tmp/log

相关日志如下：

david@app-svr7:/opt/zentao/data/zentao/tmp/log$ tail -f saas.20240603.log.php

data:   Array

(

    [enable_ssl_verification] => false

    [url] => http://192.168.0.77:8003/api.php/v1/gitlab/webhook?repoID=9

    [push_events] => 1

    [merge_requests_events] => 1

    [token] => 665d400e2cf02

)

results:{"error":"Invalid url given"}

david@app-svr7:/opt/zentao/data/zentao/tmp/log$ tail -f php_cli.20240603.log.php

08:02:19 Uncaught PDOException: SQLSTATE[HY000] [2002] Connection refused in /apps/zentao/lib/dbh/dbh.class.php:76

Stack trace:

#0 /apps/zentao/lib/dbh/dbh.class.php(76): PDO->__construct('mysql:host=127....', 'root', '123456')

#1 /apps/zentao/framework/base/router.class.php(3041): dbh->__construct(Object(stdClass), true, 'MASTER')

#2 /apps/zentao/framework/base/router.class.php(2981): baseRouter->connectByPDO(Object(stdClass), 'MASTER')

#3 /apps/zentao/framework/base/router.class.php(463): baseRouter->connectDB()

#4 /apps/zentao/framework/base/router.class.php(513): baseRouter->__construct('pms', '/apps/zentao', 'running')

#5 /apps/zentao/roadrunner/scheduler.php(27): baseRouter::createApp('pms', '/apps/zentao', 'router')

#6 {main}

  thrown in /apps/zentao/lib/dbh/dbh.class.php on line 76 when visiting

david@app-svr7:/opt/zentao/data/zentao/tmp/log$ tail -f php.20240603.log.php

#4 framework/base/control.class.php(904): metric->updateMetricLib()

#5 framework/control.class.php(415): baseControl->fetch('metric', 'updateMetricLib', Array, '')

#6 module/cron/control.php(402): control->fetch('metric', 'updateMetricLib')

#7 module/cron/control.php(358): cron->consumeTask(1895963848, Object(stdClass))

#8 module/cron/control.php(156): cron->consumeTasks(1895963848)

#9 framework/base/router.class.php(2451): cron->ajaxExec(false)

#10 framework/router.class.php(743): baseRouter->loadModule()

#11 www/index.php(77): router->loadModule()

#12 {main}ERROR: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '`` AS `t1_`date``,`t1`.`consumed` AS `t1_consumed` FROM `zt_effort` AS t1  LE...' at line 1 ,the sql is: 'SELECT `t1`.`project` AS `t1_project`,`t1`.``date`` AS `t1_`date``,`t1`.`consumed` AS `t1_consumed` FROM `zt_effort` AS t1  LEFT JOIN `zt_project` AS t2  ON t1.project = t2.id  wHeRe t1.deleted  = '0' AND  t2.deleted  = '0' AND  t2.model  = 'waterfall' AND  t2.type  = 'project' AND ( t2.vision LIKE '%rnd%'  OR t2.vision IS NULL )' The sql is: SELECT `t1`.`project` AS `t1_project`,`t1`.``date`` AS `t1_`date``,`t1`.`consumed` AS `t1_consumed` FROM `zt_effort` AS t1  LEFT JOIN `zt_project` AS t2  ON t1.project = t2.id  wHeRe t1.deleted  = '0' AND  t2.deleted  = '0' AND  t2.model  = 'waterfall' AND  t2.type  = 'project' AND ( t2.vision LIKE '%rnd%'  OR t2.vision IS NULL ) in lib/base/dao/dao.class.php on line 1537, last called by lib/base/dao/dao.class.php on line 800 through function sqlError.

in /apps/zentao/framework/base/router.class.php on line 3170 when visiting /index.php?m=cron&f=ajaxExec&restart=0&t=html