Hi Luca,
On Wed, Dec 7, 2011 at 14:26, Luca Domenella
i spoke too early ! the script dont fail... but never end and looking from mysql perspective the script don’t perform any action L
mysql> show processlist; +----+------+-----------+-------+---------+------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+------+-----------+-------+---------+------+-------+------------------+ | 12 | root | localhost | NULL | Query | 0 | NULL | show processlist | | 13 | otrs | localhost | otrs2 | Sleep | 0 | | NULL | +----+------+-----------+-------+---------+------+-------+------------------+
2 rows in set (0.00 sec)
Do you have any suggestion on how to process ?
Would be correct for example to do an alter table add column archive_flag before to run the perl script ?
No, adding the column might help, but it should really not be needed when you first upgrade to 2.3. I'm also not sure what other issues this might cause. I know at least you'd have to then remove the add column statement from the DBUpdate-to-3.0 sql script. I've done a ton of upgrades, also from really old versions, such as 2.0.4 > 3.0.x and typically the upgrade process is flawless. If you can reproduce the issue, or find where you got stuck, maybe I can offer some more targeted advice. Otherwise I'd like to offer you assistance from OTRS Group on a commercial basis - let us do the upgrade for you. Michiel Beijen Senior Consultant OTRS BV Schipholweg 103 2316 XC Leiden The Netherlands T: +31 71 8200 255 F: +31 71 8200 254 I: http://www.otrs.com Making OTRS even better! Exclusive Feature Add-Ons improve usability of OTRS and extend its functionality: http://j.mp/ndQvZj