Hi, This ist he procedure I took form y upgrade: I'v done a complete new installation of OTRS 2.1.1 on a new hardware (SUSE 9.3) Afterwards I copied back the database from 2.0.4 with cat ../../backup/master/DatabaseBackup.sql | mysql -uotrs -phot -hlocalhost otrs I upgraded the DB with cat /opt/otrs/scripts/DBUpdate-to-2.1.mysql.sql | mysql -p -f -u root otrs After that I started rcotrs start I loaded up zzzauto.pm And then installed the FAQ 1.0.6 Paket with AdminPackageManager My Result: I'v got all my config (pop, user, customer, groups, queues, etc...) BUT although I have a running FAQ package I have NO FAQ's !!! Help where are my FAQ's gone , that's the asset of our support !!! Regards Reinhard Travnicek mailto: reinhard.travnicek@x-tech.at
Hi, Yes, I have already upgraded, and it is my problem too... Reinhard: check your Syslog in Admin backend. My Syslog it says: Mon Oct 9 15:30:04 2006 error OTRS-CGI-10 ERROR: column i.change_time does not exist So, please tell me, what is it... Thanks. -- Valkai Jozsef +36 70 36 28 147 valkaij@externet.hu jvalkai@gmail.com lat:N 47° lon:E 19°
Reinhard: check your Syslog in Admin backend. My Syslog it says:
Mon Oct 9 15:30:04 2006 error OTRS-CGI-10 ERROR: column i.change_time does not exist
So, please tell me, what is it...
Sounds like you didn't upgrade the database schema.
But yes! I have ran the DBupdate...postgreesql script. There was not error. -- Valkai Jozsef +36 70 36 28 147 valkaij@externet.hu jvalkai@gmail.com lat:N 47° lon:E 19°
Reinhard: I had the same issue and after several attempts I modified this procedure Adding the FAQ** parts: These instructions are for people upgrading OTRS from "2.0" to "2.1". **) FAQ Module: If you intend to install the FAQ module after update: a) log into your system as root@localhost (or equiv) b) goto Admin --> Groups and rename FAQ to something else maybe XX c) check to make sure that no one belongs to this group. *) Stop all your services (e. g. rcotrs stop-force) *) Backup everything (database, Kernel/Config.pm, Kernel/Config/GenericAgent.pm, var/*) (Remember: 80% of all config settings are renamed in OTRS 2.0, so most of the Kernel/Config.pm settings will not be compatible) *) Make sure that you have backed up everything ,-) *) If possible try this install on a separate machine, although I had always only production machines to upgrade *) Install the new release (tar or RPM) **IGNORE DATABASE UPGRADE ERROR MESSAGES DURRING THE UPGRADE !! **YOU JUST UNLOADED IT WITH rcotrs stop-force! - ITS OK ! *) If you use the tar: a) the otrs themes between 2.0 and 2.1 may are _not_ compatible (don't us the old theme)! *) Run 'SuSEconfig' *) Update the MySQL database: *) restart MySQL with 'rcmysql start' then execute: cat /opt/otrs/scripts/DBUpdate-to-2.1.mysql.sql | mysql -p -f -u root otrs *) Execute /opt/otrs/bin/SetPermissions.sh /opt/otrs otrs wwwrun root www (or equiv for your system) **) run a 'chmod 767 /opt/otrs' or you will not be able to install additional online packages *) Restart your services (e. g. rcotrs restart-force or each service manually) **) FAQ Module: a) log into your system as root@localhost (or equiv) b) download/install FAQ module via Admin --> packages c) do a 'rcotrs restart-force' d) re-login as root@localhost (or equiv) e) a new 'faq' group will now exist, add your users to that group f) make the old group XX invalid. EOF Enjoy your day! Gregory. *------------------------------
Reinhard.Travnicek@x-tech.at 10/9/2006 7:18:21 am >>>
Hi, This ist he procedure I took form y upgrade: I'v done a complete new installation of OTRS 2.1.1 on a new hardware (SUSE 9.3) <snip> Reinhard Travnicek mailto: reinhard.travnicek@x-tech.at
It seems like, its a bug, because some table name in the database has been renamed and in the code has not been renamed... When I make a category In the FAQ module (backend), I get some error message, for example: Message: ERROR: column "create_time" of relation "faq_category" does not exist , SQL: 'INSERT INTO faq_category (name, comments, create_time, create_by, change_time, change_by) VALUES ('a', '', current_timestamp, 5, current_timestamp, 5)' ..and in the Syslog: Wed Oct 11 10:39:54 2006 error OTRS-CGI-10 ERROR: column "create_time" of relation "faq_category" does not exist Wed Oct 11 10:39:48 2006 error OTRS-CGI-10 ERROR: column i.change_time does not exist -- Valkai Jozsef +36 70 36 28 147 valkaij@externet.hu jvalkai@gmail.com lat:N 47° lon:E 19°
participants (4)
-
Jozsef Valkai -
Nils Breunese (Lemonbit Internet) -
nocadmin -
Reinhard Travnicek