[SOLVED] ITSM broken, upgrade not available

[netjess]

I upgraded OTRS from 3.0.11 to 3.1.10 and now ITSM reports incompatability and after selecting "update repository information" in the Admin Panel Package Manager, I still do not have an option to upgrade to ITSM 3.1.6.

I don't know if it is related but I am alos getting a db error on otrs startup.
Starting OTRS..
Checking httpd ... done.
Checking database connection... Trying to connect to database
DSN: DBI:mysql:database=otrs;host=localhost;
DatabaseUser: otrs

It looks Ok! done.
Checking OTRS Scheduler Service... DBD::mysql::st execute failed: Unknown column 'process_change' in 'field list' at /opt/otrs/Kernel/System/DB.pm line 618.
ERROR: OTRS-otrs.Scheduler-10 Perl: 5.8.8 OS: linux Time: Thu Sep 6 16:48:03 2012

Message: Unknown column 'process_change' in 'field list', SQL: 'SELECT process_name, process_id, process_host, process_create, process_change FROM process_id WHERE process_name = ? LIMIT 1'

Traceback (20737):
Module: Kernel::System::PID::PIDGet (v1.28) Line: 184
Module: /opt/otrs/bin/otrs.Scheduler.pl (v1.37) Line: 127

0
done.
Enable /opt/otrs/bin/otrs.PostMaster.pl ... done.
Checking otrs spool dir... done.
Creating cronjobs (source /opt/otrs/var/cron/*) ...
done.

-->> http://stats.grunt.dom/otrs/index.pl <<--
Final start of OTRS.. done

Thanks for assist.

[jojo]

your upgrade failed and you need to change the ITSM repository to http://ftp.otrs.org/pub/otrs/itsm/packages31/

[netjess]

When you say my upgrade failed, are you talking about my OTRS upgrade?

When I ran the upgrade, as per instructions at http://doc.otrs.org/3.1/en/html/upgrading.html, at the end it displayed the following:
-----------------------------------------------------
Next steps:
[httpd services]
Restart httpd 'service httpd restart'

[install the OTRS database]
Make sure your database server is running.
Use a web browser and open this link:
http://servername/otrs/installer.pl

[OTRS services]
Start OTRS 'service otrs start' (service otrs {start|stop|status|restart).

((enjoy))
Your OTRS Team
-------------------------------------------------------------------------------------------

The upgrade instructions did not mention runing the http://servername/otrs/installer.pl and it looked like what you would run on a fresh install. Did I need to go ahead and disable SecureMode and run the installer.pl?

[netjess]

Also in case it helps someone else updating repository to http://ftp.otrs.org/pub/otrs/itsm/bundle31/ rather than package was a better option for me.
Also to save someone a bit of searching repository is updatedor added in Agent console > Admin > SysConfig > Framework:Package.