| Cannot download attachments in fudforum after mysql upgrade [message #29120] |
Wed, 30 November 2005 20:09  |
Crib
Messages: 2
Registered: November 2005
Location: Bloomington, Indiana
Karma:
|
Junior Member |
|
|
It appears that after upgrading mysql to version 4.1.14 (which is current for Gentoo), users are now not able to download attachments from fudforum, due to a mysql syntax error. I have verified that the files are being uploaded, and the posts reflects a link to the attachment, but when one attempts to download the attachment, the following error message is generated:
(/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
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]