Jump to content


Click here to lend your support to: Traq and make a donation at pledgie.com !
Photo

Upgrading error: default_ticket_type_id is not added


  • Please log in to reply
4 replies to this topic

#1 Oire

Oire

    Newbie

  • Members
  • Pip
  • 7 posts

Posted 15 May 2013 - 08:19 PM

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!

#2 arturo182

arturo182

    Advanced Member

  • Contributor
  • PipPipPip
  • 151 posts

Posted 15 May 2013 - 08:33 PM

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!

#3 Oire

Oire

    Newbie

  • Members
  • Pip
  • 7 posts

Posted 15 May 2013 - 08:53 PM

Thanks, will do it manually then)

#4 arturo182

arturo182

    Advanced Member

  • Contributor
  • PipPipPip
  • 151 posts

Posted 15 May 2013 - 09:03 PM

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!

#5 Jack

Jack

    Project Founder

  • Administrators
  • 673 posts
  • LocationAustralia

Posted 15 May 2013 - 09:35 PM

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


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users