Upgrading error: default_ticket_type_id is not added

Development related discussion.
Post Reply
User avatar
Oire
Newbie
Posts: 7
Joined: Wed May 01, 2013 10:50 pm
Contact:

Upgrading error: default_ticket_type_id is not added

Post by Oire » Thu May 16, 2013 6:19 am

Hello,

I've tried to upgrade my installation from 3.2 to latest commit.

The difference (as you obviously know) is in adding the `default_ticket_type_id` in the `projects` table.

I've checked that this change is implemented in /install/upgrade.php. but for some reason it says that it's "Already up to date". and when I navigate to the index page, it throws at me the following error:

Unknown column 'default_ticket_type_id' in 'field list'

SELECT `id`, `name`, `codename`, `slug`, `info`, `next_tid`, `enable_wiki`, `default_ticket_type_id`, `displayorder`, `private_key` FROM `projects` ORDER

BY `projects`.`displayorder` ASC

What am I missing? How to tell Traq that it needs to alter the `projects` table?

This exact case is simple: I can go to my database and update the table on my own. But I would like to get the principle for not bothering you again in future.

Thanks!

User avatar
arturo182
Advanced Member
Posts: 151
Joined: Mon Mar 22, 2010 10:28 am
Contact:

Re: Upgrading error: default_ticket_type_id is not added

Post by arturo182 » Thu May 16, 2013 6:33 am

When upgrading, upgrade.php compares your database version with the script's db version and does the upgrade only if your version is older.

The problem here is that Jack updates the version file manually and only when a release is done.



So if you want to use Traq from git, you have to track db changes and make them manually in your db.
Traq, yo!

User avatar
Oire
Newbie
Posts: 7
Joined: Wed May 01, 2013 10:50 pm
Contact:

Re: Upgrading error: default_ticket_type_id is not added

Post by Oire » Thu May 16, 2013 6:53 am

Thanks, will do it manually then)

User avatar
arturo182
Advanced Member
Posts: 151
Joined: Mon Mar 22, 2010 10:28 am
Contact:

Re: Upgrading error: default_ticket_type_id is not added

Post by arturo182 » Thu May 16, 2013 7:03 am

Alternatively you could check what the next db version will be (in the upgrade.php) and change it in your "vendor/traq/version.php" file.



After doing that you will be able to successfully run upgrade.php.
Traq, yo!

User avatar
Jack
Advanced Member
Posts: 666
Joined: Fri Mar 27, 2009 7:37 pm
Location: Australia

Re: Upgrading error: default_ticket_type_id is not added

Post by Jack » Thu May 16, 2013 7:35 am

I've updated the version file to contain the 3.2.1 database version.

Post Reply

Who is online

Users browsing this forum: No registered users and 18 guests