Upgrade von 3.2.15 to 3.3.5

[otrscrasher]

System:
RedHat 6
MySql 5.1
Apache 2.2

Code: Select all

cat scripts/DBUpdate-to-3.3.mysql.sql | mysql -p -f -u root otrs

Info und Fehler:

INFO: Foreign key constraint FK_standard_response_valid_id_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_valid_id_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_create_by_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_create_by_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_change_by_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_change_by_id does not exist, skipping.
INFO: Foreign key constraint FK_queue_standard_response_standard_response_id_id does not exist, skipping.
INFO: Foreign key constraint FK_queue_standard_response_standard_response_id_id does not exist, skipping.
INFO: Foreign key constraint FK_queue_standard_response_queue_id_id does not exist, skipping.
INFO: Foreign key constraint FK_queue_standard_response_queue_id_id does not exist, skipping.
INFO: Foreign key constraint FK_queue_standard_response_create_by_id does not exist, skipping.
INFO: Foreign key constraint FK_queue_standard_response_create_by_id does not exist, skipping.
INFO: Foreign key constraint FK_queue_standard_response_change_by_id does not exist, skipping.
INFO: Foreign key constraint FK_queue_standard_response_change_by_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_attachment_standard_response_id_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_attachment_standard_response_id_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_attachment_standard_attachment_id_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_attachment_standard_attachment_id_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_attachment_create_by_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_attachment_create_by_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_attachment_change_by_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_attachment_change_by_id does not exist, skipping.
ERROR 1091 (42000) at line 109: Can't DROP 'standard_response_name'; check that column/key exists

Im nächsten Schritt:

Code: Select all

su otrs
scripts/DBUpdate-to-3.3.pl

Fehler:

Step 6 of 13: Checking Standard Template table columns...
Check if 'template_type' columns exists.
'template_type' column not found, create it.
ALTER TABLE standard_template ADD template_type VARCHAR (100) NULL
[Mon Mar 24 15:14:53 2014] DBUpdate-to-3.3.pl: DBD::mysql::db do failed: ALTER command denied to user 'otrs'@'localhost' for table 'standard_template' at /opt/otrs-3.3.5/Kernel/System/DB.pm line 499.
ERROR: OTRS-DBUpdate-to-3.3-10 Perl: 5.10.1 OS: linux Time: Mon Mar 24 15:14:53 2014

Message: ALTER command denied to user 'otrs'@'localhost' for table 'standard_template', SQL: 'ALTER TABLE standard_template ADD template_type VARCHAR (100) NULL'

Traceback (10647):
Module: main::_AddTemplateTypeColumn (unknown version) Line: 478
Module: scripts/DBUpdate-to-3.3.pl (unknown version) Line: 126

ERROR: OTRS-DBUpdate-to-3.3-10 Perl: 5.10.1 OS: linux Time: Mon Mar 24 15:14:53 2014

Message: Error during execution of 'ALTER TABLE standard_template ADD template_type VARCHAR (100) NULL'!

Traceback (10647):
Module: main::_AddTemplateTypeColumn (unknown version) Line: 480
Module: scripts/DBUpdate-to-3.3.pl (unknown version) Line: 126

[Mon Mar 24 15:14:53 2014] DBUpdate-to-3.3.pl: Died at scripts/DBUpdate-to-3.3.pl line 126.

Hat jemand eine Lösung für diesen Fehler?

[otrscrasher]

OK, hab selber. Auf dem Testsystem musste ich doch die Rechte anpassen:

GRANT
SELECT ,
INSERT ,
UPDATE ,
DELETE ,
CREATE ,
DROP ,
FILE ,
ALTER ON * . * TO 'otrs'@'localhost' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

Vor allem fehlten ALTER, CREATE, DROP ...