FUDforum: Bug Reports » File attachments attach, but cannot be downloaded

Home » FUDforum Development » Bug Reports » File attachments attach, but cannot be downloaded

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

File attachments attach, but cannot be downloaded [message #17705]

Tue, 13 April 2004 08:22

miknight

Messages: 5
Registered: April 2004
Location: Sydney, Australia

Karma: 0

Junior Member

I found this problem in version 2.6.0, and have upgraded to 2.6.2rc1 but am having the same problem, so I'm thinking there's something wrong with my own setup.

When anyone attaches files to a post, the files attach and they do upload properly (I checked the /files dir), but when someone clicks on the attachment they just get a blank screen. I've tried this in several browsers with the same result.

Does anyone have a suggestion to fix this? I'm using PHP 4.3.5 and MySQL 4.1.1.

Thanks for any help!

Report message to a moderator

Re: File attachments attach, but cannot be downloaded [message #17706 is a reply to message #17705]

Tue, 13 April 2004 13:50

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Could you please give me a URL to one of these attachments?

FUDforum Core Developer

Report message to a moderator

Re: File attachments attach, but cannot be downloaded [message #17727 is a reply to message #17705]

Wed, 14 April 2004 00:42

miknight

Messages: 5
Registered: April 2004
Location: Sydney, Australia

Karma: 0

Junior Member

Here we go:

http://biotrack.nerdforce.net/index.php?t=msg&th=5&start=0&rid= 3

Report message to a moderator

Re: File attachments attach, but cannot be downloaded [message #17728 is a reply to message #17727]

Wed, 14 April 2004 14:17

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

For some unknown reason the forum thinks that the files are 0 bytes. I can tell that because the webserver sends Content-Type header with a value of 0.

Would it be possible to get admin access to the forum, that would permit me to analyze the problem further.

Report message to a moderator

Re: File attachments attach, but cannot be downloaded [message #17739 is a reply to message #17728]

Thu, 15 April 2004 02:43

miknight

Messages: 5
Registered: April 2004
Location: Sydney, Australia

Karma: 0

Junior Member

No worries, I'll PM you with the details.

Report message to a moderator

Re: File attachments attach, but cannot be downloaded [message #17741 is a reply to message #17739]

Thu, 15 April 2004 03:39

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Fixed in CVS. Apply the patch in the URL below and recompile the theme, after that the problem should be gone.

http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=2619

In MySQL 4.1 keyword "mod" has a special meaning and I was using as table alias, hence the problem.

FUDforum Core Developer

Report message to a moderator

Re: File attachments attach, but cannot be downloaded [message #17742 is a reply to message #17705]

Thu, 15 April 2004 04:40

miknight

Messages: 5
Registered: April 2004
Location: Sydney, Australia

Karma: 0

Junior Member

Great, thanks for the speedy support and letting us know what the prob was Wink

Report message to a moderator

Re: File attachments attach, but cannot be downloaded [message #21391 is a reply to message #17705]

Mon, 29 November 2004 02:19

kennylam

Messages: 4
Registered: November 2004

Karma: 0

Junior Member

I've found similar problems when downloding the attachment. The following errors occurred :

(/www/htdocs/egroupware/fudforum/3814588639/index.php:131
/www/htdocs/egroupware/fudforum/3814588639/index.php:197
/www/htdocs/egroupware/fudforum/3814588639/theme/default/getfile.php:115
/www/htdocs/egroupware/fudforum/3814588639/index.php:412
) 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mod ON mod.forum_id=t.forum_id AND mod.user_id=5 LEFT JOIN phpgw_fud_mime mm ' at line 7
Query: SELECT mm.mime_hdr, a.original_name, a.location, m.id, mod.id, ((CASE WHEN g2.id IS NOT NULL THEN g2.group_cache_opt ELSE g1.group_cache_opt END) & 2) > 0 FROM phpgw_fud_attach a INNER JOIN phpgw_fud_msg m ON a.message_id=m.id AND a.attach_opt=0 INNER JOIN phpgw_fud_thread t ON m.thread_id=t.id INNER JOIN phpgw_fud_group_cache g1 ON g1.user_id=2147483647 AND g1.resource_id=t.forum_id LEFT JOIN phpgw_fud_mod mod ON mod.forum_id=t.forum_id AND mod.user_id=5 LEFT JOIN phpgw_fud_mime mm ON mm.id=a.mime_type LEFT JOIN phpgw_fud_group_cache g2 ON g2.user_id=5 AND g2.resource_id=t.forum_id WHERE a.id=2
Server Version: 4.1.7-log
[Referring Page] http://202.83.221.116:8080/egroupware/fudforum/3814588639/index.php?t=msg&a mp;th=2&start=0&

I've already cvs up the fudforum and still cannot solve the problem. Can anyone help me with this? Thanks a lot!

Report message to a moderator

Re: File attachments attach, but cannot be downloaded [message #21399 is a reply to message #21391]

Mon, 29 November 2004 16:12

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

The EgroupWare fix was just applied to CVS.
The patch to fix the problem can be found here:
http://bb.prohost.org/egw.txt

FUDforum Core Developer

Report message to a moderator

Re: File attachments attach, but cannot be downloaded [message #21431 is a reply to message #21399]

Tue, 30 November 2004 03:20

kennylam

Messages: 4
Registered: November 2004

Karma: 0

Junior Member

Thanks a lot for your prompt reply! It works perfectly now! Really appreciate for your effort! Surprised

Report message to a moderator

Re: File attachments attach, but cannot be downloaded [message #21635 is a reply to message #17705]

Tue, 07 December 2004 19:18

malik

Messages: 21
Registered: October 2004
Location: houston,tx

Karma: 0

Junior Member

Could somebody help me with that?
The error occured while downloading delating file:->

1064: You have an error in your SQL syntax near 'AND id NOT IN(5))' at line 1
Query: DELETE FROM fud26_attach WHERE message_id=199 AND id NOT IN( AND id NOT IN(5))
Server Version: 3.23.54-log

Report message to a moderator

Re: File attachments attach, but cannot be downloaded [message #21638 is a reply to message #21635]

Tue, 07 December 2004 19:32

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

This bug was fixed in later released, upgrade your forum.

FUDforum Core Developer

Report message to a moderator

Previous Topic:	Bulbs doesn't snuff out
Next Topic:	Small HTML bug in 2.6.9RC2

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 29 00:55:04 GMT 2024

Total time taken to generate the page: 0.03124 seconds