FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » FUDforum 3.0+ » Error with getfile.php
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Error with getfile.php [message #31246] Tue, 11 April 2006 11:39 Go to next message
idofud is currently offline  idofud   France
Messages: 7
Registered: March 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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?
Re: Error with getfile.php [message #31284 is a reply to message #31246] Fri, 14 April 2006 16:49 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
You need to change the alias name from "mod" to "md"

FUDforum Core Developer
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: PDF generation
Next Topic: fudforum2.6 + index.php was not found on this server
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Oct 17 09:16:56 EDT 2017

Total time taken to generate the page: 0.00698 seconds