Upgrade from 3.1.12 to 3.2

Moderator: crythias

Locked
bgone
Znuny newbie
Posts: 32
Joined: 26 Oct 2010, 10:19
Znuny Version: 6.0.19

Upgrade from 3.1.12 to 3.2

Post by bgone »

Hi All,

When I upgrade mysql database as guide, received the error "#1061 - Can't DROP 'group_read': check that column/key exists".
The others error like as below:
command: ALTER TABLE pm_process ADD CONSTRAINT FK_pm_process_create_by_id FOREIGN KEY (create_by) REFERENCES users (id); <--error: #1005 - Can't create table 'otrs.#sql-df5_65' (errno: 150) (Details...Supports transactions, row-level locking, and foreign keys )
Please help
Wolfgangf
Znuny ninja
Posts: 1029
Joined: 13 Apr 2009, 12:26
Znuny Version: 6.0.13
Real Name: Wolfgang Fürtbauer
Company: PBS Logitek GmbH
Location: Pinsdorf

Re: Upgrade from 3.1.12 to 3.2

Post by Wolfgangf »

did you check the UPGRADING document - what's the default database storage module of your MySQL database?
Produktiv:
OTRS 6.0.13/ ITSM 6.0.13
OS: SUSE Linux (SLES 12, Leap), MySql 5.5.x, 5.6.x
Windows 2012 AD Integration (agents and customers), Nagios integration (incidents, CMDB), Survey, TimeAccounting
Locked