| Error with getfile.php [message #31246] |
Tue, 11 April 2006 15:39  |
idofud
Messages: 7
Registered: March 2006
Karma: 0
|
Junior Member |
|
|
When trying to access a file attachement in a message i got this error reported by the error log viewer :
(*****fudforum\3208225109\index.php:131
******fudforum\3208225109\index.php:197
******fudforum\3208225109\theme\default\getfile.php:115
******fudforum\3208225109\index.php:413
) 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=2 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=2 LEFT JOIN phpgw_fud_mime mm ON mm.id=a.mime_type LEFT JOIN phpgw_fud_group_cache g2 ON g2.user_id=2 AND g2.resource_id=t.forum_id WHERE a.id=1
Server Version: 4.1.10
[Referring Page] http://******fudforum/3208225109/index.php?t=msg&goto=64&
this is the 2.6 fudforum version, with egroupware.
by the way, is there a way to upgrade the forum within egroupware?
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]