nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JIRA offline after changing custom field key VERY URGENT!

Adriana Stancu

Hello,

I needed to change a custom field type and updated the customfield table with a new type:

UPDATE customfield SET CUSTOMFIELDTYPEKEY = 'com.atlassian.jira.plugin.sysme', CUSTOMFIELDSEARCHERKEY = 'com.atlassian.jira.plugin.system.customfieldtypes:multiselectsearcher' WHERE cfname = '%SOMENAME%'

Now after I log in into Jira I get 500 Invalid module key specified.

It is very urgent as this is a production Jira and I don t have any database backups.

Accepted answers

All comments

Nic Brough -Adaptavist-

Stop Jira, change the keys back to what they were before, restart it and run a full locking re-index.

This SQL only works when the field types hold data that are 100% compatible, and I suspect

They are not
sysme is not a valid custom field type

Adriana Stancu

I tried but I got this

Adriana Stancu

Where can I find the logs file that reports this error?

Nic Brough -Adaptavist-

Start with the logs under <jira home>/log - look for "atlassian-jira.log".

Adriana Stancu

Nic Brough -Adaptavist-

That's because you set it to that. It is wrong.

Even if it weren't misspelt, it's being truncated down to a module that definitely does not exist.

You need to set back ALL of the custom fields customfieldtypekey to what they were before. The searchers are less important because they can be fixed in the UI, and wouldn't cause massive crashing like this, just piles of wrong-type warnings.

Adriana Stancu

Thanks a lot for that hint, but the update query only modified one row, the others have the same key. What is the default key value for Jira 3.15.3 ?

Adriana Stancu

It was a drop down list, I think the right type would be com.atlassian.jira.plugin.system.customfieldtypes:select right?

Adriana Stancu

If someone has the same problem, here is what I did to restore Jira:

Check if JIRA has exported automated backups in the $JIRA_HOME/export location. Then I have followed the procedure below:

Stop JIRA;
Place the exported XML Backup file into $JIRA_HOME/import directory;
Create an empty database by strictly following Connecting JIRA to a Databasedocumentation.
Edit the $JIRA_HOME/dbconfig.xml file to point JIRA to use the empty database;
Rename the caches folder in $JIRA_HOME and create an empty folder named indexes inside.
Start JIRA - Since JIRA will detect an empty database it will bring the setup wizard dialog, select to import the data on the first configuration screen and type the filename placed on $JIRA_HOME/import directory.

Nic Brough -Adaptavist-

So, going back to the backup you said you didn't have is the solution.

Adriana Stancu

I didn't have a backup of my database, but I found out that Jira was saving backups in JIRA_HOME/export folder.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-service-desk