: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 <[email protected]>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 <[email protected]>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 <[email protected] >> > 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 <[email protected] >>> > 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 >
--------------------------------------------------------------------- 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
