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
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
