FUDforum: Bug Reports » PostgreSQL and attachments

Home » FUDforum Development » Bug Reports » PostgreSQL and attachments

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

PostgreSQL and attachments [message #164124]

Wed, 05 January 2011 13:00

mguillaume

Messages: 13
Registered: December 2010

Karma:

Junior Member

When attaching a file to a post, the following request is generated for PostgreSQL:
UPDATE fud30_attach SET location='/opt/forum/data/files/'||id||'.atch', message_id=13754 WHERE id IN(6) AND attach_opt=0
This triggers an error as apparently is doesn't like double-concatenations with different types.

I think a possible fix would be, in attach.inc.t line 59 and ppost.inc.t line 304:
$cc = q_concat(_esc($GLOBALS['FILE_STORE']), 'cast(id as text)', _esc('.atch'));

Report message to a moderator

[Message index]

		PostgreSQL and attachments By: mguillaume on Wed, 05 January 2011 13:00
		Re: PostgreSQL and attachments By: naudefj on Wed, 05 January 2011 13:20
		Re: PostgreSQL and attachments By: mguillaume on Wed, 05 January 2011 13:24
		Re: PostgreSQL and attachments By: naudefj on Wed, 05 January 2011 13:28
		Re: PostgreSQL and attachments By: mguillaume on Wed, 05 January 2011 13:36
		Re: PostgreSQL and attachments By: naudefj on Wed, 05 January 2011 14:27
		Re: PostgreSQL and attachments By: mguillaume on Thu, 06 January 2011 06:32
		Re: PostgreSQL and attachments By: naudefj on Thu, 06 January 2011 13:04
		Re: PostgreSQL and attachments By: mguillaume on Thu, 06 January 2011 13:16
		Re: PostgreSQL and attachments By: naudefj on Thu, 06 January 2011 14:41

Previous Topic:	text error on Mailing List Manager
Next Topic:	Backslashes after editing file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 22:30:48 GMT 2024

Total time taken to generate the page: 0.05035 seconds