[RESOLU] 1ère installation - SquashTM 5.0.1

Nico
Messages : 3
Inscription : mar. avr. 25, 2023 2:43 pm

[RESOLU] 1ère installation - SquashTM 5.0.1

Message par Nico »

Bonjour à tous,

Je viens d'installer SquashTM et je suis confronté à une erreur lorsque je veux me rendre sur les pages de l'administration. Les logs indiquent ceci :

Code : Tout sélectionner

SquashTM - 968 ERROR [http-nio-8080-exec-6] [ServletWebRequest: uri=/squash/backend/users;client=IP;session=15367A7E33E9C4A9E580F04F7CC509D9;user=admin] --- org.squashtest.tm.web.backend.exceptionresolver.HandlerExceptionLogger: An exception occured while processing request  : http://squashtm:8080/squash/backend/users
org.jooq.exception.DataAccessException: SQL [select `CORE_USER`.`PARTY_ID`, `CORE_USER`.`ACTIVE`, `CORE_USER`.`LOGIN`, `CORE_GROUP`.`QUALIFIED_NAME` as `USER_GROUP`, `CORE_USER`.`FIRST_NAME`, `CORE_USER`.`LAST_NAME`, `CORE_USER`.`EMAIL`, `CORE_USER`.`CREATED_ON`, `CORE_USER`.`CREATED_BY`, IFNULL(HABILITATION_COUNT, ?) as `HABILITATION_COUNT`, IFNULL(TEAM_COUNT, ?) as `TEAM_COUNT`, `CORE_USER`.`LAST_CONNECTED_ON` from `CORE_USER` left outer join `CORE_GROUP_MEMBER` on `CORE_GROUP_MEMBER`.`PARTY_ID` = `CORE_USER`.`PARTY_ID` left outer join `CORE_GROUP` on `CORE_GROUP_MEMBER`.`GROUP_ID` = `CORE_GROUP`.`ID` left outer join (select `CORE_USER`.`PARTY_ID` as `TEAM_MEMBER_ID`, COUNT(`CORE_TEAM_MEMBER`.`TEAM_ID`) as `TEAM_COUNT` from `CORE_USER` left outer join `CORE_TEAM_MEMBER` on `CORE_TEAM_MEMBER`.`USER_ID` = `CORE_USER`.`PARTY_ID` group by `CORE_USER`.`PARTY_ID`) as `ALIAS_9928152` on `ALIAS_9928152`.`TEAM_MEMBER_ID` = `CORE_USER`.`PARTY_ID` left outer join (select `CORE_USER`.`PARTY_ID` as `USER_ID`, COUNT(`ACL_RESPONSIBILITY_SCOPE_ENTRY`.`ID`) as `HABILITATION_COUNT` from `CORE_USER` left outer join `ACL_RESPONSIBILITY_SCOPE_ENTRY` on `ACL_RESPONSIBILITY_SCOPE_ENTRY`.`PARTY_ID` = `CORE_USER`.`PARTY_ID` left outer join `ACL_OBJECT_IDENTITY` on `ACL_OBJECT_IDENTITY`.`ID` = `ACL_RESPONSIBILITY_SCOPE_ENTRY`.`OBJECT_IDENTITY_ID` where `ACL_OBJECT_IDENTITY`.`CLASS_ID` = ? group by `CORE_USER`.`PARTY_ID`) as `ALIAS_31927684` on `ALIAS_31927684`.`USER_ID` = `CORE_USER`.`PARTY_ID` where (? = ? and ? = ?) order by UPPER(`CORE_USER`.`LOGIN`) asc offset ? rows fetch next ? rows only]; (conn=930) 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 'offset 0 rows fetch next 25 rows only' at line 1

at org.jooq_3.16.11.MARIADB.debug(Unknown Source) ~[?:?]



Code : Tout sélectionner

org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: 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 'offset 0 rows fetch next 25 rows only' at line 1

J'en ai plein d'autre du même genre.

Ma config :

Debian 11.6
MariaDB 10.5
JRE 11
SquasTM 5.0.1

Code : Tout sélectionner

AR_NAME="squash-tm.war"  # Java main library
HTTP_PORT=8080              
TMP_DIR=../tmp
BUNDLES_DIR=../bundles
CONF_DIR=../conf
LOG_DIR=../logs
TOMCAT_HOME=../tomcat-home
PLUGINS_DIR=../plugins
DB_TYPE=mariadb
DB_URL="jdbc:mariadb://localhost:3306/squashtm"
D'avance merci pour votre aide.
Nico
Messages : 3
Inscription : mar. avr. 25, 2023 2:43 pm

Re: [RESOLU] 1ère installation - SquashTM 5.0.1

Message par Nico »

Problème résolu : upgrade mariadb 10.5 vers 10.6
Répondre

Revenir à « Installation & Base de données / Installation & Database »