Hi, it seems that you have run your update script twice. normally nothing to worry about I think. Regards Florian Sorry for fullquote, but the error message is needed completely I think On Wed, Jun 12, 2013 at 10:00:16AM +0200, Fabio.Grasso@itatis.net wrote:
Hello all, I'm new on this list and I ask sorry in advice if this is an already taken question.
I've updated my OTRS from 3.1 to 3.2, all the upgrade task works fine except for the DB update that give me this errors: ERROR 1091 (42000) at line 7: Can't DROP 'group_read'; check that column/key exists ERROR 1091 (42000) at line 11: Can't DROP 'group_write'; check that column/key exists ERROR 1091 (42000) at line 15: Can't DROP 'other_read'; check that column/key exists ERROR 1091 (42000) at line 19: Can't DROP 'other_write'; check that column/key exists ERROR 1091 (42000) at line 20: Can't DROP 'ticket_answered'; check that column/key exists ERROR 1091 (42000) at line 24: Can't DROP 'ticket_answered'; check that column/key exists ERROR 1091 (42000) at line 29: Can't DROP 'group_id'; check that column/key exists ERROR 1050 (42S01) at line 34: Table 'pm_process' already exists ERROR 1050 (42S01) at line 51: Table 'pm_activity' already exists ERROR 1050 (42S01) at line 66: Table 'pm_activity_dialog' already exists ERROR 1050 (42S01) at line 81: Table 'pm_transition' already exists ERROR 1050 (42S01) at line 96: Table 'pm_transition_action' already exists ERROR 1050 (42S01) at line 111: Table 'pm_entity' already exists ERROR 1050 (42S01) at line 118: Table 'pm_entity_sync' already exists ERROR 1060 (42S21) at line 129: Duplicate column name 'internal_field' ERROR 1062 (23000) at line 135: Duplicate entry 'ProcessManagementProcessID' for key 'dynamic_field_name' ERROR 1062 (23000) at line 141: Duplicate entry 'ProcessManagementActivityID' for key 'dynamic_field_name' ERROR 1005 (HY000) at line 158: Can't create table 'otrs.#sql-38f_f1' (errno: 121) ERROR 1005 (HY000) at line 159: Can't create table 'otrs.#sql-38f_f1' (errno: 121) ERROR 1005 (HY000) at line 160: Can't create table 'otrs.#sql-38f_f1' (errno: 121) ERROR 1005 (HY000) at line 161: Can't create table 'otrs.#sql-38f_f1' (errno: 121) ERROR 1005 (HY000) at line 162: Can't create table 'otrs.#sql-38f_f1' (errno: 121) ERROR 1005 (HY000) at line 163: Can't create table 'otrs.#sql-38f_f1' (errno: 121) ERROR 1005 (HY000) at line 164: Can't create table 'otrs.#sql-38f_f1' (errno: 121) ERROR 1005 (HY000) at line 165: Can't create table 'otrs.#sql-38f_f1' (errno: 121) ERROR 1005 (HY000) at line 166: Can't create table 'otrs.#sql-38f_f1' (errno: 121) ERROR 1005 (HY000) at line 167: Can't create table 'otrs.#sql-38f_f1' (errno: 121)
At the actual state I can login to my OTRS, I can see the old ticket and close them and also open a new ticket manually. But all the ticket received by mail are deleted from my POP3 account but not appears in the OTRS queues.
Have you any idea on how I can fix it?
Thanks a lot Fabio
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs