Project

General

Profile

Forums » Help »

Unable to Set the Default Issue Status

Added by Cemre Mengu over 9 years ago

I am trying to migrate my mysql db from version 2.x to 3.x. (with agile plugin) Everything seems to be fine except a few columns and I got it to run.

However, I am not able to add a new issue since I keep getting no default issue status is defined (See image).

Following this I go and check Administration -> Issue statuses as suggested by the error message but the issue statuses has no option to set the status as default (as seen in the images).
I manually set the is_default column in the issue_statuses table (which I believe is responsible for this) but that does not work as well. There is simply no way to set this value..

Whatever I try I am not able to set the default status. How am I supposed to do this ? Any ideas ?

Download all files
error.PNG (8.99 KB) error.PNG Error message
status1.PNG (26.9 KB) status1.PNG Issue Statuses
status2.PNG (9.64 KB) status2.PNG Adding new issue status

Replies (9)

RE: Unable to Set the Default Issue Status - Added by Daniel Matthes over 9 years ago

I've the same Problem.

I've installed a new redmine version 3.0.4. and load my db with the following command mysql -u redmine -p redmine < backup.sql

Everything worked without problems beside these error.

I'll be grateful for a fast answer.

RE: Unable to Set the Default Issue Status - Added by Cemre Mengu over 9 years ago

Hello,

I solved the problem. You need to set default_status_id column of the trackers table to 1 and you should be good to go. I am attaching a screen shot.

Hope this works for you as well

Cheers!

fix.PNG (49 KB) fix.PNG

RE: Unable to Set the Default Issue Status - Added by Daniel Matthes over 9 years ago

Thank you very munch for your fast answer!

Where did I find this setting window?

Kind regards.

RE: Unable to Set the Default Issue Status - Added by Cemre Mengu over 9 years ago

It's the phpmyadmin panel

Go to localhost/phpmyadmin

The default user for the phpMyAdmin application is "root" and the password is the same that you set during the installation

RE: Unable to Set the Default Issue Status - Added by Daniel Matthes over 9 years ago

If I call localhost/phpmyadmin, I get the answer "page not found". Did I have to install phpmyadmin separately or is it a part of redmine?

RE: Unable to Set the Default Issue Status - Added by Cemre Mengu over 9 years ago

Yes it is a separate tool for viewing the database. I used the VM image provided by bitnami so thats how I have it.

But it is OK if you dont have it. You just need to manually execute the sql query from mysql commandline:

UPDATE TRACKERS SET DEFAULT_STATUS_ID = 1

RE: Unable to Set the Default Issue Status - Added by Daniel Matthes over 9 years ago

It works. At first I had to add the column default_status_id. Now every thing is fine.

Thanks for your help!

RE: Unable to Set the Default Issue Status - Added by Cemre Mengu over 9 years ago

I am glad that it works.

There are a few other changes such as emails are now stored in a different table (in the past they were only stored in the users table) so make sure to check that too!

    (1-9/9)