[Bug][Sonarqube] data too long about incubator-devlake HOT 5 OPEN

Hey @irkhamdayat! 👋 I'm here to help you with any bugs, questions, or becoming a contributor. I'll assist you while waiting for a human maintainer.

To resolve the "data too long for column name" error in the _tool_sonarqube_scope_configs table during the data collection process for SonarQube in version v0.21.0@ac4f7fe, you can manually change the field length to varchar(255) or longer in MySQL.

Execute the following SQL command to increase the length of the name column:

ALTER TABLE _tool_sonarqube_scope_configs MODIFY COLUMN name VARCHAR(255);

This should resolve the error you're encountering ^[1].

To continue talking to Dosu, mention @dosu.

from incubator-devlake.

i was increase the lenght of the name, still get error

from incubator-devlake.

@irkhamdayat I think it's name field in table _tool_sonarqube_accounts.

Can you check the actual length of account names in your SonarQube ?

We can update this column to a proper length later.

from incubator-devlake.

my lenght of account names in _tool_sonarqube_accounts is

from incubator-devlake.

@irkhamdayat I mean the username's length in sonarqube, not in devlake's database.
We should change database's fields according to the real name's length.

from incubator-devlake.