Upgrade attempt to 3.3 results in Error with unknown Column

Moderator: crythias

Locked
MKOP
Znuny newbie
Posts: 4
Joined: 19 Feb 2013, 19:43
Znuny Version: 3.2.1

Upgrade attempt to 3.3 results in Error with unknown Column

Post by MKOP »

From a working 3.2.12, I am attempting an upgrade to 3.3.3.

Stop services, backup, new ln link, run sql script, etc... DB check shows no errors.

I get the following error in the webGUI
Unknown column 'template_type' in 'field list', SQL: ' INSERT INTO standard_template (name, valid_id, comments, text, content_type, create_time, create_by, change_time, change_by, template_type) VALUES (?, ?, ?, ?, ?, '2013-12-10 17:02:40' , ?, '2013-12-10 17:02:40' , ?, ?)'

Obviously, there's a column missing from the table. I checked the table desc in Mysql and there is no column for 'template_type' in that table.

I revert back to 3.2.12 and check the original table before the 3.3.3 sql script renames it with '
ALTER TABLE standard_response RENAME standard_template;'

So on 3.2.12, I look a the table 'standard_response' and there is no column for 'template_type'.

I searched the sql script that is run when upgrading to 3.3.3 from 3.2, and there is no mention of an additional column called 'template_type'.

I can only assume that this column may have been part of an earlier upgrade script that didn't run properly...

Can someone with more intimate knowledge verify that the 3.3.x MySQL table called 'standard_template' does include a column called 'template_type'?
Can someone point out when/where/what version did the column get added to the table?

Or am I doing something so wrong I'm embarrassing myself.
--------------------------------------------------------------
Running OTRS 3.3.3 on Ubuntu 12.04 With MySQL
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Upgrade attempt to 3.3 results in Error with unknown Col

Post by crythias »

Did you run DBUpdate-to-3.3.pl after DBUpdate-to-3.3.[db].sql per UPGRADING.md?
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
MKOP
Znuny newbie
Posts: 4
Joined: 19 Feb 2013, 19:43
Znuny Version: 3.2.1

Re: Upgrade attempt to 3.3 results in Error with unknown Col

Post by MKOP »

That's it, I just misinterpreted the README. Somehow I read that as a 3 part CASE... mysql, postgre, or other. And I Ignored the update.pl as part of 'other'.


Thanks for setting me straight.
--------------------------------------------------------------
Running OTRS 3.3.3 on Ubuntu 12.04 With MySQL
Locked