Attachments path in Windows environment

ern

Hi all,

After clicking on attachment in ticket I've got info:

No such file

in the web browser.

File uploaded successfuly and exists in upload directory with name:

c:\xampplite\htdocs\upload\E00430875A3720_logo.jpg

The php request to open this file is as below

http://localhost/helpdesk/scp/attachment.php?id=1&ref=3c570fa9bd59aa69f983796085913949

Follow this instruction (http://www.openscriptsolution.com/2009/08/31/how-to-setup-attachment-directory-in-osticket-system(http://www.openscriptsolution.com/2009/08/31/how-to-setup-attachment-directory-in-osticket-system))

I set up right path in attachments settings:

C:/xampplite/htdocs/upload

where the root directory is:

C:/xampplite/htdocs

Do You have any idea how to fix this?

Best Regards,

Lucas

masino_sinaga

Hi Lucas:

Did it happen at the client-side or staff side, or both of them?

Sincerely,

Masino Sinaga

ern

Well,

I am using only staff site.

I have this problem in my both OsTicket installations:

in testing environment and in corporate use.

In thoses cases I based on xammp in M$ Windows.

Please, give me some tips how to solve that.

Thanks!

Lucas

masino_sinaga

Lucas,

Please follow this:

Open your \include\class.ticket.php, and find this code:

$sql ='SELECT attach_id,file_size,file_name FROM '.TICKET_ATTACHMENT_TABLE.

then replace with this:

$sql ='SELECT attach_id,file_size,file_name,file_key FROM '.TICKET_ATTACHMENT_TABLE.

Find again this code:

while(list($id,$size,$name)=db_fetch_row($res)){

then replace with this code:

while(list($id,$size,$name,$key)=db_fetch_row($res)){

Find again this code:

$attachstr.= "<a class='Icon file' href='attachment.php?id=$id&ref=$hash' target='_blank'>$name</a> ($size)  ";

after that line, please add this following code:

global $cfg;

$attachstr.= " Attachment Directory: ".$cfg->getUploadDir().'/'.$key.'_'.$name;

After that, please go to your viewticket page belongs to a ticket which has the attachment file in it.

You should see such string like this:

Attachment Directory: blablabla

Let us know what is the value of that blablabla.

Sincerely,

Masino Sinaga

ern

Solution

Hi friends,

Thanks for Your reply Masino, I asked friend of mine,

to look into php code in:

c:\xampplite\htdocs\helpdesk\scp\attachment.php

He found that when You use M$ Windows environment

You should change slash "/" to double backslash "\\" which means in php "\" in this line:

original code:

$file= rtrim($cfg->getUploadDir(),'/').'/'.$key.'_'.$filename;

should be changed to:

$file= rtrim($cfg->getUploadDir(),'\\').'\\'.$key.'_'.$filename;

BTW, my Upload dir is right now like this:

c:/xampplite/htdocs/uplod

Another important thing is to carefully fill in path form,

Spacebar on the end of path will bring the same problem as above (no such file)

All the best,

Lucas

masino_sinaga

Hi Lucas,

Thanks for the info. It is very helpful for us, indeed.

Sincerely,

Masino Sinaga