Permission Error upgrading from 3.2.10 to 3.3.1

[otrscrasher]

Same Problem

Code: Select all

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
[Thu Mar 20 14:48:19 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: Thu Mar 20 14:48:19 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 (7524):
   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: Thu Mar 20 14:48:19 2014

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

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

[Thu Mar 20 14:48:19 2014] DBUpdate-to-3.3.pl: Died at scripts/DBUpdate-to-3.3.pl line 126.

[crythias]

you have the same problem, then the same solution should apply.

[otrscrasher]

you have the same problem, then the same solution should apply.

Unfortunately not.


First i start the script:

Code: Select all

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

then

Run the migration script (as user `otrs`, NOT as `root`):

shell> scripts/DBUpdate-to-3.3.pl


and i get this error ...

[crythias]

You didn't get the same error as the topic you hijacked.

ALTER command denied to user 'otrs'@'localhost' for table 'standard_template'

you should have done a search engine search for this to determine ... you don't have permission to do this with the otrs@localhost user.