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.
Upgrade attempt to 3.3 results in Error with unknown Column
Moderator: crythias
Upgrade attempt to 3.3 results in Error with unknown Column
--------------------------------------------------------------
Running OTRS 3.3.3 on Ubuntu 12.04 With MySQL
Running OTRS 3.3.3 on Ubuntu 12.04 With MySQL
-
- 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
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
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
Re: Upgrade attempt to 3.3 results in Error with unknown Col
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.
Thanks for setting me straight.
--------------------------------------------------------------
Running OTRS 3.3.3 on Ubuntu 12.04 With MySQL
Running OTRS 3.3.3 on Ubuntu 12.04 With MySQL