FUDforum: Bug Reports » Attachments doesn't display

Home » FUDforum Development » Bug Reports » Attachments doesn't display

Show: Today's Messages :: Polls :: Message Navigator

Attachments doesn't display [message #29905]

Mon, 23 January 2006 18:43

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

I've copied my forum from one server to another using a different directory structure. After that, attachments didn't display anymore.

The problem was that full paths are stored in the fud26_attch table. A simple update fixed the problem.

Now the question: Wouldn't it be better to just store relative paths? Doing so will make the forum more transportable.

Best regards.

Frank

Report message to a moderator

Re: Attachments doesn't display [message #29924 is a reply to message #29905]

Tue, 24 January 2006 18:38

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

You can fix it with a simple replace operation. Storing file paths in DB allows for reduction in real-time operations the forum needs to perform.

FUDforum Core Developer

Report message to a moderator

Re: Attachments doesn't display [message #29934 is a reply to message #29924]

Tue, 24 January 2006 19:33

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

In that case, can we make a note of this in the documentation or setup a wiki for such purposes. If this info was readily available, it would have saved me a lot of time trying to figure out what going on.

update fud26_attach set location = replace(location,
        '/home/virtual/site1/fst/var/www/html/',
        '/var/www/vhosts/mysiste.com/httpdocs/');

Report message to a moderator

Re: Attachments doesn't display [message #29938 is a reply to message #29934]

Tue, 24 January 2006 20:14

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Fair enough, I'll add this to our online docs.

FUDforum Core Developer

Report message to a moderator

Previous Topic:	Problem when in Cpanel
Next Topic:	Message bodies of PMs are blank in my installation of V 2.7.4 RC2

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 15:10:43 GMT 2024

Total time taken to generate the page: 0.05134 seconds