Service desk cant create new projet

Benjamin Marboeuf

hi, when i create new service desk project, I'm error message : "Hmm... nous n'avons pas pu créer votre projet en raison d'une erreur inconnue. Actualisez la page et réessayez."

 

Where is service desk log, can you hep me about this error.

I'm on debian 8.

thanks for your answer.

 

Best regard Mathieu.

Scott Theus

Hi Matheiu,

I'm assuming your language settings are French? There could be something in the SQL that is causing a collation error...

"running  MySQL query SELECT table_name, character_set_name, collation_name FROM information_schema.COLUMNS WHERE table_schema = '<db_name>' AND collation_name != 'utf8_bin'; 

I then created the conversion sql to an output file 

select CONCAT('ALTER TABLE ',  table_name, ' CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;') INTO OUTFILE '/tmp/collation.sql' from information_schema.columns where table_schema='<db_name>' and collation_name !='utf8_bin' group by table_name;

I then ran the file against the database and all columns were converted."

Source: https://community.atlassian.com/t5/Jira-Service-Desk-questions/Error-creating-new-project-in-Jira-Service-Desk-Server-edition-V/qaq-p/742213

Not sure if this helps, but it's a start.