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

Tell us how you've implemented Change Management

Hello Community 👋, I'm a product manager at Atlassian, looking at improving change management capabilities across our products. In particular, we're looking at bridging the gap between Dev & ...

336 views 0 7
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