3.2.1 upgrade ERROR 1091 Can't DROP 'ticket_answered'; - otrs - OTRS mailing lists

newer
YAML error message after upgrade...

3.2.1 upgrade ERROR 1091 Can't DROP 'ticket_answered';

older
Showing Dynamic Fields in print...

Marco Vannini

29 Jan 2013 29 Jan '13

11:39 a.m.

Did anyone got this during ]# cat scripts/DBUpdate-to-3.2.mysql.sql | mysql otrs ERROR 1091 (42000) at line 20: Can't DROP 'ticket_answered'; check that column/key exists Can I go on ? I'm "upping" from a 3.1.6. thank you in advance. MV

Attachments:

attachment.html (text/html — 492 bytes)

Reply

Sign in to reply online Use email software

Show replies by date

Michiel Beijen

29 Jan 29 Jan

12:11 p.m.

Did you run the upgrade script twice? The ticket_answered column really should have been available in the Ticket table, although it was no longer used. -- Mike On Tue, Jan 29, 2013 at 12:39 PM, Marco Vannini wrote:

Did anyone got this during

]# cat scripts/DBUpdate-to-3.2.mysql.sql | mysql otrs ERROR 1091 (42000) at line 20: Can't DROP 'ticket_answered'; check that column/key exists

Can I go on ?

I'm "upping" from a 3.1.6.

thank you in advance.

MV

--------------------------------------------------------------------- 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

Reply

Sign in to reply online Use email software

Marco Vannini

12:22 p.m.

Hi Michiel, Yes, I tryed and obviously I had to comment out some row before the one failed but than I encountered the same on other indexes ...really strange, but than, the .pl has gone without problems. [root@HMCVR0004 otrs]# cat scripts/DBUpdate-to-3.2.mysql.sql | mysql otrs ERROR 1091 (42000) at line 7: Can't DROP 'group_read'; check that column/key exists [root@HMCVR0004 otrs]# cat scripts/DBUpdate-to-3.2.mysql.sql | mysql otrs ERROR 1091 (42000) at line 19: Can't DROP 'other_write'; check that column/key exists [root@HMCVR0004 otrs]# cat scripts/DBUpdate-to-3.2.mysql.sql | mysql otrs ERROR 1091 (42000) at line 20: Can't DROP 'ticket_answered'; check that column/key exists [root@HMCVR0004 otrs]# cat scripts/DBUpdate-to-3.2.mysql.sql | mysql otrs ERROR 1091 (42000) at line 25: Can't DROP 'article_flag_create_by'; check that column/key exists [root@HMCVR0004 otrs]# cat scripts/DBUpdate-to-3.2.mysql.sql | mysql otrs ERROR 1091 (42000) at line 27: Can't DROP 'ticket_queue_view'; check that column/key exists [root@HMCVR0004 otrs]# cat scripts/DBUpdate-to-3.2.mysql.sql | mysql otrs [root@HMCVR0004 otrs]# scripts/DBUpdate-to-3.2.pl Migration started... Step 1 of 9: Refresh configuration cache... If you see warnings about 'Subroutine Load redefined', that's fine, no need to worry! done. Step 2 of 9: Check framework version... done. Step 3 of 9: Cleanup UserPreferences... done. Step 4 of 9: Updating toolbar configuration... done. Step 5 of 9: Updating AgentTicketZoom window configuration... done. Step 6 of 9: Dropping obsolete columns from article_search... Check if columns exist. Columns found, drop them. ALTER TABLE article_search DROP a_freetext1 ALTER TABLE article_search DROP a_freetext2 ALTER TABLE article_search DROP a_freetext3 ALTER TABLE article_search DROP a_freekey1 ALTER TABLE article_search DROP a_freekey2 ALTER TABLE article_search DROP a_freekey3 done. Step 7 of 9: Migration cache backend configuration... done. Step 8 of 9: Clean up the cache... done. Step 9 of 9: Refresh configuration cache another time... If you see warnings about 'Subroutine Load redefined', that's fine, no need to worry! done. Migration completed! On Tue, Jan 29, 2013 at 1:11 PM, Michiel Beijen wrote:

Did you run the upgrade script twice? The ticket_answered column really should have been available in the Ticket table, although it was no longer used. -- Mike On Tue, Jan 29, 2013 at 12:39 PM, Marco Vannini wrote:

...
Did anyone got this during

]# cat scripts/DBUpdate-to-3.2.mysql.sql | mysql otrs ERROR 1091 (42000) at line 20: Can't DROP 'ticket_answered'; check that column/key exists

Can I go on ?

I'm "upping" from a 3.1.6.

thank you in advance.

MV

--------------------------------------------------------------------- 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

--------------------------------------------------------------------- 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

Reply

Sign in to reply online Use email software

Michiel Beijen

12:28 p.m.

Marco: "I had to comment out some row before the one failed " -- I'm not sure what you mean here. Glad it worked for you... I think? -- Michiel On Tue, Jan 29, 2013 at 1:22 PM, Marco Vannini wrote:

Hi Michiel,

Yes, I tryed and obviously I had to comment out some row before the one failed but than I encountered the same on other indexes ...really strange, but than, the .pl has gone without problems.

[root@HMCVR0004 otrs]# cat scripts/DBUpdate-to-3.2.mysql.sql | mysql otrs ERROR 1091 (42000) at line 7: Can't DROP 'group_read'; check that column/key exists [root@HMCVR0004 otrs]# cat scripts/DBUpdate-to-3.2.mysql.sql | mysql otrs ERROR 1091 (42000) at line 19: Can't DROP 'other_write'; check that column/key exists [root@HMCVR0004 otrs]# cat scripts/DBUpdate-to-3.2.mysql.sql | mysql otrs ERROR 1091 (42000) at line 20: Can't DROP 'ticket_answered'; check that column/key exists [root@HMCVR0004 otrs]# cat scripts/DBUpdate-to-3.2.mysql.sql | mysql otrs ERROR 1091 (42000) at line 25: Can't DROP 'article_flag_create_by'; check that column/key exists [root@HMCVR0004 otrs]# cat scripts/DBUpdate-to-3.2.mysql.sql | mysql otrs ERROR 1091 (42000) at line 27: Can't DROP 'ticket_queue_view'; check that column/key exists [root@HMCVR0004 otrs]# cat scripts/DBUpdate-to-3.2.mysql.sql | mysql otrs

[root@HMCVR0004 otrs]# scripts/DBUpdate-to-3.2.pl

Migration started...

Step 1 of 9: Refresh configuration cache... If you see warnings about 'Subroutine Load redefined', that's fine, no need to worry! done.

Step 2 of 9: Check framework version... done.

Step 3 of 9: Cleanup UserPreferences... done.

Step 4 of 9: Updating toolbar configuration... done.

Step 5 of 9: Updating AgentTicketZoom window configuration... done.

Step 6 of 9: Dropping obsolete columns from article_search... Check if columns exist. Columns found, drop them. ALTER TABLE article_search DROP a_freetext1 ALTER TABLE article_search DROP a_freetext2 ALTER TABLE article_search DROP a_freetext3 ALTER TABLE article_search DROP a_freekey1 ALTER TABLE article_search DROP a_freekey2 ALTER TABLE article_search DROP a_freekey3 done.

Step 7 of 9: Migration cache backend configuration... done.

Step 8 of 9: Clean up the cache... done.

Step 9 of 9: Refresh configuration cache another time... If you see warnings about 'Subroutine Load redefined', that's fine, no need to worry! done.

Migration completed!

On Tue, Jan 29, 2013 at 1:11 PM, Michiel Beijen wrote:

...
Did you run the upgrade script twice? The ticket_answered column really should have been available in the Ticket table, although it was no longer used. -- Mike On Tue, Jan 29, 2013 at 12:39 PM, Marco Vannini wrote:

...
Did anyone got this during

]# cat scripts/DBUpdate-to-3.2.mysql.sql | mysql otrs ERROR 1091 (42000) at line 20: Can't DROP 'ticket_answered'; check that column/key exists

Can I go on ?

I'm "upping" from a 3.1.6.

thank you in advance.

MV

--------------------------------------------------------------------- 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

--------------------------------------------------------------------- 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

--------------------------------------------------------------------- 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

Reply

Sign in to reply online Use email software

Marco Vannini

1:02 p.m.

:D yes, I mean, if I had to reexecute the script the first line "ALTER TABLE ticket DROP group_read;" would fail so I commented out all the command just executed. Seems to work ... :D On Tue, Jan 29, 2013 at 1:28 PM, Michiel Beijen wrote:

Marco: "I had to comment out some row before the one failed " -- I'm not sure what you mean here.

Glad it worked for you... I think? -- Michiel On Tue, Jan 29, 2013 at 1:22 PM, Marco Vannini wrote:

...
Hi Michiel,

Yes, I tryed and obviously I had to comment out some row before the one failed but than I encountered the same on other indexes ...really strange, but than, the .pl has gone without problems.

[root@HMCVR0004 otrs]# cat scripts/DBUpdate-to-3.2.mysql.sql | mysql otrs ERROR 1091 (42000) at line 7: Can't DROP 'group_read'; check that column/key exists [root@HMCVR0004 otrs]# cat scripts/DBUpdate-to-3.2.mysql.sql | mysql otrs ERROR 1091 (42000) at line 19: Can't DROP 'other_write'; check that column/key exists [root@HMCVR0004 otrs]# cat scripts/DBUpdate-to-3.2.mysql.sql | mysql otrs ERROR 1091 (42000) at line 20: Can't DROP 'ticket_answered'; check that column/key exists [root@HMCVR0004 otrs]# cat scripts/DBUpdate-to-3.2.mysql.sql | mysql otrs ERROR 1091 (42000) at line 25: Can't DROP 'article_flag_create_by'; check that column/key exists [root@HMCVR0004 otrs]# cat scripts/DBUpdate-to-3.2.mysql.sql | mysql otrs ERROR 1091 (42000) at line 27: Can't DROP 'ticket_queue_view'; check that column/key exists [root@HMCVR0004 otrs]# cat scripts/DBUpdate-to-3.2.mysql.sql | mysql otrs

[root@HMCVR0004 otrs]# scripts/DBUpdate-to-3.2.pl

Migration started...

Step 1 of 9: Refresh configuration cache... If you see warnings about 'Subroutine Load redefined', that's fine, no need to worry! done.

Step 2 of 9: Check framework version... done.

Step 3 of 9: Cleanup UserPreferences... done.

Step 4 of 9: Updating toolbar configuration... done.

Step 5 of 9: Updating AgentTicketZoom window configuration... done.

Step 6 of 9: Dropping obsolete columns from article_search... Check if columns exist. Columns found, drop them. ALTER TABLE article_search DROP a_freetext1 ALTER TABLE article_search DROP a_freetext2 ALTER TABLE article_search DROP a_freetext3 ALTER TABLE article_search DROP a_freekey1 ALTER TABLE article_search DROP a_freekey2 ALTER TABLE article_search DROP a_freekey3 done.

Step 7 of 9: Migration cache backend configuration... done.

Step 8 of 9: Clean up the cache... done.

Step 9 of 9: Refresh configuration cache another time... If you see warnings about 'Subroutine Load redefined', that's fine, no need to worry! done.

Migration completed!

On Tue, Jan 29, 2013 at 1:11 PM, Michiel Beijen
...
wrote:

...
Did you run the upgrade script twice? The ticket_answered column really should have been available in the Ticket table, although it was no longer used. -- Mike On Tue, Jan 29, 2013 at 12:39 PM, Marco Vannini
...
wrote:

...
Did anyone got this during

]# cat scripts/DBUpdate-to-3.2.mysql.sql | mysql otrs ERROR 1091 (42000) at line 20: Can't DROP 'ticket_answered'; check that column/key exists

Can I go on ?

I'm "upping" from a 3.1.6.

thank you in advance.

MV

--------------------------------------------------------------------- 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

--------------------------------------------------------------------- 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

--------------------------------------------------------------------- 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

--------------------------------------------------------------------- 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

Reply

Sign in to reply online Use email software

4553

Age (days ago)

4553

Last active (days ago)

Download

4 comments

2 participants

tags

participants (2)

Marco Vannini
Michiel Beijen