Redmine

Bah, formatting fail. Here's the output from "ruby script/about" again:

About your application's environment
Ruby version              1.8.7 (x86_64-linux)
RubyGems version          1.2.0
Rails version             2.1.2
Active Record version     2.1.2
Action Pack version       2.1.2
Active Resource version   2.1.2
Action Mailer version     2.1.2
Active Support version    2.1.2
Edge Rails revision       unknown
Application root          /opt/redmine-0.8.5
Environment               production
Database adapter          mysql
Database schema version   101

About your Redmine plugins
Mylyn Connector plugin      2.5.0.trunk
Scrumdashboard plugin       1.2
Charts Plugin               0.0.14
Redmine Burndown plugin     1.1.3
Redmine Task Board plugin   1.0.0
Redmine Hudson plugin       0.1.0

The conclusion I draw from this, is that db_migrate either thinks it doesn't need to do anything, or fails silently when re-run on an installation where it's been run before but the database has been re-imported from a not-updated one. Given that the implementation scenario I've used is not that unreasonable or uncommon, this may be worth looking into, I think.

That's a really common scenario. I do it all the time and believe me, it works.
To see what is going wrong, I need your error stack trace.

What error stack trace ? The upgrade script gave no output. I can get you the logfile traces from before I added the database fields, but I don't see how those would help debugging what went wrong with the database upgrade ?

However, we then started seeing internal server errors on some (but not all) repositories and Wiki pages.

These ones.

Have you (or someone else) ever added a file in db/migrate ? Eg. for a plugin or a patch (like this one: #1154 or #443).
Even if this file is no longer present, please mention it.

No, never. Funnily enough, both the issues you reference just gave me an internal error when I clicked them right now, loaded fine on refresh :-)

As I said, it's a fresh VM, with a fresh OS and Redmine install on it.

• redminy Mylin plugin from http://sourceforge.net/projects/redmin-mylyncon/
• Simple CI from http://www.redmine.org/wiki/redmine/PluginSimpleCI (later removed in favour of hudson)
• hudson from http://www.redmine.org/boards/3/topics/6650
• OpenFlashChart from http://github.com/pullmonkey/open_flash_chart (this did require some code editing in RAILS_ROOT/app/controllers/test_it_controller.rb)
• Scrumdashboard from http://www.redmine.org/boards/3/topics/5808
• Charts from http://github.com/mszczytowski/redmine_charts
• Redmine Task Board from http://github.com/scrumalliance/redmine_task_board
• Redmine Burndown from http://github.com/scrumalliance/redmine_burndown

Are you able to post the dump (structure+data) of the table named schema_migrations that you reimported in your fresh redmine install (before you ran db:migrate) ?

There is no such table, apparently. It was a Redmine 0.7, updated via SVN to revision 1518, dixit svn info.

Then it must be schema_info instead of schema_migrations.
It's a Rails core table that was renamed in Rails 2.

This seems to be OK.
Honestly, I have no idea about what went wrong and I can't go further except trying the upgrade from your full database dump.

Not really an option at this point, I'm afraid :-) I'm gonna try the whole procedure again with a blank codebase and see where I end up. I'll keep you informed.

You wouldn't have a clue about http://www.redmine.org/boards/2/topics/2512 , would you ? :-)