
Server: SuSE 8.0 Client: W2K de SP3, MS IExplorer 5.0 First a short description what I did: - rcotrs stop-force - Backup otrs Database - Install RPM with -U Option - Edit new version of following files: - /etc/sysconfig/otrs - /opt/OpenTRS/.fetchmail - /opt/OpenTRS/Kernel/Config.pm - /opt/OpenTRS/var/cron/fetchmail - copy and delete of rpm backup files - running permissions-script (you forgot the s in your anounce mail /opt/OpenTRS/bin/SetPermission.sh) - running updateDB script (this returns the following errors: vk-main:/opt/OpenTRS/Kernel # cat /opt/OpenTRS/scripts/DBUpdate.mysql.sql | mysql -f -u root otrs ERROR 1050 at line 52: Table 'ticket_index' already exists ERROR 1050 at line 64: Table 'time_accounting' already exists ERROR 1062 at line 79: Duplicate entry 'TimeAccounting' for key 2 ERROR 1062 at line 85: Duplicate entry 'email-notification-ext' for key 2 ERROR 1062 at line 89: Duplicate entry 'email-notification-int' for key 2 ERROR 1062 at line 95: Duplicate entry 'Forward' for key 2 ERROR 1062 at line 99: Duplicate entry 'Bounce' for key 2 ERROR 1060 at line 106: Duplicate column name 'a_content_type' ERROR 1061 at line 112: Duplicate key name 'index_user_preferences_user_id' ERROR 1060 at line 118: Duplicate column name 'ticket_answered' ERROR 1062 at line 121: Duplicate entry 'SendAgentNotification' for key 2 ERROR 1062 at line 127: Duplicate entry 'French' for key 2 ERROR 1062 at line 133: Duplicate entry 'email-external' for key 2 ERROR 1062 at line 137: Duplicate entry 'email-internal' for key 2 ERROR 1050 at line 143: Table 'user_preferences' already exists ERROR 1050 at line 152: Table 'session' already exists vk-main:/opt/OpenTRS/Kernel # ) - rcotrs start-force Did some tests. OK. everything looks good... ... but don't know about the dbscript errors ?!? OK. Now some attachment tests. - making new telephone call (windows client) - make answer with attachment of: E:\Daten\Test.zip - the recipient got the mail but the name of the attachement is: EDatenTest.zip (but the file is ok) - in the ticket the file ist shown by E:\Daten\Test.zip - I try to download this file from the ticket - file dialog shows: Filename: index Type: -document after saving this a message apperars in explorer: action aborted the URL is: http://myhost/otrs/index.pl?Action=AgentAttachment&ArticleID=190&File=E:\Dat en\Test.zip the filename in server filesystem is: EDATE~2L.ZIP but the file was allready downloaded as index after renaming the file on my client to index.zip I can open it - the file is OK. - now I try a second answer with attachement a message appears:page cannot be shown http 500 internal error the URL is: http://myhost/otrs/index.pl no message is send I can't write any more answer with attachment on this ticket !!! normal answer is OK answer with attachment on other ticket is same as described before. OK, that's all for now. (I have some truble with euro sign. But later...) regards Volker