FUDforum - خوراک RDF
http://fudforum.org/forum/index.php
Cannot download attachments in fudforum after mysql upgrade
http://fudforum.org/forum/index.phpindex.php?t=rview&goto=29120&th=5910#msg_29120
(/var/www/localhost/htdocs/egroupware/fudforum/2456323713/in dex.php:131
/var/www/localhost/htdocs/egroupware/fudforum/2456323713/ind ex.php:197
/var/www/localhost/htdocs/egroupware/fudforum/2456323713/the me/default/getfile.php:115
/var/www/localhost/htdocs/egroupware/fudforum/2456323713/ind ex.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=3 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=3 LEFT JOIN phpgw_fud_mime mm ON mm.id=a.mime_type LEFT JOIN phpgw_fud_group_cache g2 ON g2.user_id=3 AND g2.resource_id=t.forum_id WHERE a.id=2
Server Version: 4.1.14
[Referring Page] https://xxx.xxx.xxx.xxx/egroupware/fudforum/2456323713/index .php?t=msg&th=13&start=0&
I have verified that a reference to the file exists in mysql, and also that the uploaded file exists in the file system. It seems that the problem is that egroupware is not doing the query in a syntax that mysql likes. Unfortunately, I am short on mysql syntax. Please help!
Also, I'm running egroupware version 1.0.0.009
Thanks so much if you can help!
-Trent]]>Crib2005-11-30T20:09:01-00:00Re: Cannot download attachments in fudforum after mysql upgrade
http://fudforum.org/forum/index.phpindex.php?t=rview&goto=29141&th=5910#msg_29141
Ilia2005-12-01T15:49:28-00:00Re: Cannot download attachments in fudforum after mysql upgrade
http://fudforum.org/forum/index.phpindex.php?t=rview&goto=29151&th=5910#msg_29151
egroupware/fudforum/xxxxxxxxx/theme/default/getfile.php