It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Service desk cant create new projet

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.

1 answer

0 votes
Scott_Theus Community Leader Mar 29, 2018

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."


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

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira Service Desk

How has Jira Service Desk increased productivity in your org?

Hi Jira Service Desk community, Atlassian is on a mission to unleash the potential of all teams, and we know that tools are just one piece of that puzzle. With Jira Service Desk, we have productiv...

178 views 0 3
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you