Attachment problems! Can somebody help? [message #21396] |
Mon, 29 November 2004 14:15 |
kennylam
Messages: 4 Registered: November 2004
Karma:
|
Junior Member |
|
|
I'm using the lastest 1.00006 egroupware. All the user can upload attachment without any problems. But when I try to downlode 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;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!
|
|
|