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

Home » General » FUDforum in eGroupWare » Attachment problems! Can somebody help?
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
Attachment problems! Can somebody help? [message #21396] Mon, 29 November 2004 09:15 Go to next message
kennylam is currently offline  kennylam   Hong Kong
Messages: 4
Registered: November 2004
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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!
Re: Attachment problems! Can somebody help? [message #21401 is a reply to message #21396] Mon, 29 November 2004 11:14 Go to previous messageGo to next 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
Here is the fix:
http://bb.prohost.org/egw.txt


FUDforum Core Developer
Re: Attachment problems! Can somebody help? [message #22944 is a reply to message #21396] Tue, 22 February 2005 06:11 Go to previous messageGo to next message
stormuk is currently offline  stormuk   United Kingdom
Messages: 6
Registered: February 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
How does one apply the patch?

Or does someone have the contents I could just paste in?

Cheers

Tony
Re: Attachment problems! Can somebody help? [message #22948 is a reply to message #22944] Tue, 22 February 2005 09:11 Go to previous messageGo to next 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 apply patches using the "patch" command line utility.

FUDforum Core Developer
Re: Attachment problems! Can somebody help? [message #22950 is a reply to message #21396] Tue, 22 February 2005 09:51 Go to previous messageGo to next message
stormuk is currently offline  stormuk   United Kingdom
Messages: 6
Registered: February 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Ahh sorry my mistake - Im not using Unix its a windowz server!

How can I apply it using windows?
Re: Attachment problems! Can somebody help? [message #22951 is a reply to message #22950] Tue, 22 February 2005 09:56 Go to previous messageGo to next 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
The change is very simple in this case, simply replace the - lines with the + lines.

FUDforum Core Developer
icon9.gif  Re: Attachment problems! Can somebody help? [message #22952 is a reply to message #21396] Tue, 22 February 2005 11:33 Go to previous messageGo to next message
stormuk is currently offline  stormuk   United Kingdom
Messages: 6
Registered: February 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
what do I do with

@@ -17,13 +17,13 @@
invl_inp_err();
}
if (!isset($_GET['private'])) { /* non-private upload */

Anyone got the complete file?
Re: Attachment problems! Can somebody help? [message #22953 is a reply to message #22952] Tue, 22 February 2005 11:46 Go to previous messageGo to next 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 only need to consider the +/- lines... the rest you can ignore.

FUDforum Core Developer
Re: Attachment problems! Can somebody help? [message #22954 is a reply to message #22953] Tue, 22 February 2005 12:21 Go to previous messageGo to next message
stormuk is currently offline  stormuk   United Kingdom
Messages: 6
Registered: February 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Okay well done that and the errors have gone!

but uploaded images are just showing as

/egroupware/fudforum/3814588639/index.php?t=getfile&id=7

and if I click the link Im getting a blank page!

?

Tony
Re: Attachment problems! Can somebody help? [message #22957 is a reply to message #22954] Tue, 22 February 2005 16:21 Go to previous messageGo to next 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 syncronized fudforum sources & then rebuild the theme.

FUDforum Core Developer
Re: Attachment problems! Can somebody help? [message #22964 is a reply to message #21396] Wed, 23 February 2005 05:48 Go to previous messageGo to next message
stormuk is currently offline  stormuk   United Kingdom
Messages: 6
Registered: February 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Hia

Done

Slight change to the problem now - same link text on images in the forum itself

But now clicking on an, image gives you -

'The image “http://***/fudforum/3814588639/index.php?t=getfile&id=14&”; cannot be displayed, because it contains errors.'

In IE I just get the red cross image!

[Updated on: Wed, 23 February 2005 05:49]

Report message to a moderator

Re: Attachment problems! Can somebody help? [message #22973 is a reply to message #22964] Wed, 23 February 2005 10:43 Go to previous messageGo to next 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
Can you try that with a newly uploaded file?

FUDforum Core Developer
Re: Attachment problems! Can somebody help? [message #22981 is a reply to message #21396] Wed, 23 February 2005 13:20 Go to previous messageGo to next message
stormuk is currently offline  stormuk   United Kingdom
Messages: 6
Registered: February 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
I did try with a new one after deleting the older ones!

Just for info Ive rebuilt the install on a new PC and added the modified file pre build!

Using latest install from xampp - Tried PHP 4 & 5!

Same error

[Updated on: Wed, 23 February 2005 13:42]

Report message to a moderator

Re: Attachment problems! Can somebody help? [message #23471 is a reply to message #21396] Fri, 18 March 2005 03:37 Go to previous messageGo to next message
sanju is currently offline  sanju   India
Messages: 11
Registered: March 2005
Location: Linux World
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
but i dont have the
LEFT JOIN {SQL_TABLE_PREFIX}mod md portion at all?

what shud i do?

Re: Attachment problems! Can somebody help? [message #23483 is a reply to message #23471] Fri, 18 March 2005 10:18 Go to previous messageGo to next 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
Then you need to add it.

FUDforum Core Developer
Re: Attachment problems! Can somebody help? [message #23533 is a reply to message #21396] Mon, 21 March 2005 00:53 Go to previous message
sanju is currently offline  sanju   India
Messages: 11
Registered: March 2005
Location: Linux World
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Nope, still no luck

Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: SQL-Error
Next Topic: Application Title Change
Goto Forum:
  

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

Current Time: Mon Dec 18 09:54:47 EST 2017

Total time taken to generate the page: 0.00894 seconds