Hi Tyler, On Mon, Aug 30, 2004 at 01:21:42PM -0600, Tyler Hepworth wrote:
I upgraded from 1.3 beta 1 to 1.3 beta 3. This got rid of the 'unknown column system_id' error, but now my log is filled with 'unknown column queue_id' errors whenever I get new tickets from email.
Mon Aug 30 13:09:34 2004 error OTRS-PM3-10 Unknown column 'queue_id' in 'field list', SQL: 'INSERT INTO ticket_history (name, [...]
Sorry, I forgot the database info: [scripts/DBUpdate-to-1.3.mysql.sql] -- -- ticket_history -- ALTER TABLE ticket_history ADD queue_id INTEGER NOT NULL; ALTER TABLE ticket_history ADD owner_id INTEGER NOT NULL; ALTER TABLE ticket_history ADD priority_id SMALLINT NOT NULL; ALTER TABLE ticket_history ADD state_id SMALLINT NOT NULL; [...] The queue_id in now new with 1.3 beta3. PS: No other database changes. Martin Edenhofer -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Manage your communication!