Hi Crythias,
Thank you for the prompt response.
I will reply the points suggested and then explain what has been done since.
1. Indexes
I don't know how to do this.
2. queue_standard_template doesn't exist on 3.2.13. This only gets created when migrating to 3.3.0. The current 3.2.13 is still operational. Hence I doubt that it has been removed.
3. delete cache. rebuild config
I have been following
http://doc.otrs.org/3.3/en/html/upgrading.html. Hence I have performed these steps.
Since this issue was posing an issue, I performed few attempts and collected some information.
1. At the start of the update I can see the following message.
$rpm -Uvh xxxx
backup old (maybe not compatible) templates (of 3.2.13)
mv: target `/opt/otrs/Kernel/Output/HTML/Standard/*.backup_maybe_not_compat_to.3.2.13' is not a directory
mv: target `/opt/otrs/Kernel/Output/HTML/Standard/Warning.dtl' is not a directory
otrs.RebuildConfig.pl - OTRS rebuild default config
2.First DB part
$cat scripts/DBUpdate-to-3.3.mysql.sql | mysql -p -f -u root otrs
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
3. The DB Update Produces the following output.
Migration started...
ERROR: Permission denied: /opt/otrs/Kernel/Config/Files/ZZZAAuto.pm
ERROR: Permission denied: /opt/otrs/Kernel/Config/Files/ZZZAAuto.pm
Step 1 of 13: Refresh configuration cache...
If you see warnings about 'Subroutine Load redefined', that's fine, no need to worry!
Subroutine Load redefined at /opt/otrs/Kernel/Config/Files/ZZZAuto.pm line 7.
done.
Step 2 of 13: Check framework version... done.
Step 3 of 13: Generate MessageID md5sums... done.
Step 4 of 13: Migrate old settings... done.
Step 5 of 13: Migrate OTRSExternalTicketNumberRecognition... done.
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
UPDATE standard_template SET template_type = 'Answer' WHERE template_type IS NULL
ALTER TABLE standard_template CHANGE template_type template_type VARCHAR (100) DEFAULT 'Answer' NOT NULL
done.
Step 7 of 13: Updating Queue Standard Template relations table...
Cleaning queue_standard_template table
Creating new Foreign Keys for queue_standard_template table
--- Note: ---
If you have already run this script before then the Foreign Keys are already set and you might see errors regarding 'duplicate key' or 'constrain already exists', that's fine, no need to worry!
---
ALTER TABLE queue_standard_template ADD CONSTRAINT FK_queue_standard_template_standard_template_id_id FOREIGN KEY (standard_template_id) REFERENCES standard_template (id)
ALTER TABLE queue_standard_template ADD CONSTRAINT FK_queue_standard_template_queue_id_id FOREIGN KEY (queue_id) REFERENCES queue (id)
DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`finhd`.<result 2 when explaining filename '#sql-7af_1b'>, CONSTRAINT `FK_queue_standard_template_queue_id_id` FOREIGN KEY (`queue_id`) REFERENCES `queue` (`id`)) at /opt/otrs/Kernel/System/DB.pm line 499.
ERROR: OTRS-DBUpdate-to-3.3-3 Perl: 5.10.1 OS: linux Time: Sat Jan 11 23:46:18 2014
Message: Cannot add or update a child row: a foreign key constraint fails (`finhd`.<result 2 when explaining filename '#sql-7af_1b'>, CONSTRAINT `FK_queue_standard_template_queue_id_id` FOREIGN KEY (`queue_id`) REFERENCES `queue` (`id`)), SQL: 'ALTER TABLE queue_standard_template ADD CONSTRAINT FK_queue_standard_template_queue_id_id FOREIGN KEY (queue_id) REFERENCES queue (id)'
Traceback (2477):
Module: main::_AddQueueStandardTemplateForeignKeys (unknown version) Line: 563
Module: ./DBUpdate-to-3.3.pl (unknown version) Line: 130
ERROR: OTRS-DBUpdate-to-3.3-3 Perl: 5.10.1 OS: linux Time: Sat Jan 11 23:46:18 2014
Message: Error during execution of 'ALTER TABLE queue_standard_template ADD CONSTRAINT FK_queue_standard_template_queue_id_id FOREIGN KEY (queue_id) REFERENCES queue (id)'!
Traceback (2477):
Module: main::_AddQueueStandardTemplateForeignKeys (unknown version) Line: 565
Module: ./DBUpdate-to-3.3.pl (unknown version) Line: 130
done.
Step 8 of 13: Migrate OTRSGenericStandardTemplates... done.
Step 9 of 13: Checking if ACL tables already exist... Check if ACL table exists.
ACL tables not found, create it.
CREATE TABLE acl (
id INTEGER NOT NULL AUTO_INCREMENT,
name VARCHAR (200) NOT NULL,
comments VARCHAR (250) NULL,
description VARCHAR (250) NULL,
valid_id SMALLINT NOT NULL,
stop_after_match SMALLINT NULL,
config_match LONGBLOB NULL,
config_change LONGBLOB NULL,
create_time DATETIME NOT NULL,
create_by INTEGER NOT NULL,
change_time DATETIME NOT NULL,
change_by INTEGER NOT NULL,
PRIMARY KEY(id),
UNIQUE INDEX acl_name (name)
)
CREATE TABLE acl_sync (
acl_id VARCHAR (200) NOT NULL,
sync_state VARCHAR (30) NOT NULL,
create_time DATETIME NOT NULL,
change_time DATETIME NOT NULL
)
ALTER TABLE acl ADD CONSTRAINT FK_acl_create_by_id FOREIGN KEY (create_by) REFERENCES users (id)
ALTER TABLE acl ADD CONSTRAINT FK_acl_change_by_id FOREIGN KEY (change_by) REFERENCES users (id)
ALTER TABLE acl ADD CONSTRAINT FK_acl_valid_id_id FOREIGN KEY (valid_id) REFERENCES valid (id)
done.
Step 10 of 13: Uninstall Merged Feature Add-Ons... done.
Step 11 of 13: Delete the files that are not longer needed... done.
Step 12 of 13: Clean up the cache... done.
Step 13 of 13: Refresh configuration cache another time...
If you see warnings about 'Subroutine Load redefined', that's fine, no need to worry!
Subroutine Load redefined at /opt/otrs/Kernel/Config/Files/ZZZAAuto.pm line 7.
Subroutine Load redefined at /opt/otrs/Kernel/Config/Files/ZZZAuto.pm line 7.
done.
The interesting fact is that the OTRS works after the update (i.e creating tickets), but I can't only access status and queue views. I get the messages attached before. On the status view, after selecting "ok", there will be a transparent "cannot read article()" message behind each ticket number.
The following error message gets logged on the httpd error logs when I access status view.
[Sun Jan 12 10:32:13 2014] -e: Use of uninitialized value in numeric comparison (<=>) at /opt/otrs//Kernel/Output/HTML/LayoutTicket.pm line 903.
[Sun Jan 12 10:32:13 2014] -e: Use of uninitialized value in numeric comparison (<=>) at /opt/otrs//Kernel/Output/HTML/LayoutTicket.pm line 903.
My personal opinion is that the installation will work but there is something failing with the graphical components (Java script). I might be wrong here. Please let me know if you need additional information.
Thank you in advance.
Note:finhd is the database name.
SK