Hi Volker, On Sat, Oct 26, 2002 at 04:23:57PM +0200, Volker Vo?k?mper wrote:
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 vk-main:/opt/OpenTRS/Kernel # ) [...] Did some tests. OK. everything looks good... ... but don't know about the dbscript errors ?!?
Don't worry about the error messages, you can update all previous version with this script and in the most cases your database has already the most changes! I put this to the UPGRADING file.
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.
Volker, can you try this with an other browser (e. g. Mozilla)!? I need to know if this is not working with IE. Or with any browser.
- 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.
Oh ja. A Bug, I fixed it. Update Kernel/System/EmailSend.pm and restart the webserver. (http://otrs.org/cgi-bin/cvsweb.cgi/~checkout~/otrs/Kernel/System/EmailSend.p...) In this cases a bugzilla entry would be fine! :)
OK, that's all for now. (I have some truble with euro sign. But later...)
Really? You need to use iso-8859-15 for the euro sign. There is also a test email with euro sign. shell> cat /usr/share/doc/packages/otrs/test-email-7-euro-iso-8859-15.box | /opt/OpenTRS/bin/PostMaster.pl
Volker
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "There are two major products that come out of Berkeley: LSD and Unix. We don't believe this to be a coincidence." -- Jeremy S. Anderson