FUDforum: FUDforum in eGroupWare » Attachment problems! Can somebody help?

Home » General » FUDforum in eGroupWare » Attachment problems! Can somebody help?

Show: Today's Messages :: Polls :: Message Navigator

Attachment problems! Can somebody help? [message #21396]

Mon, 29 November 2004 14:15

kennylam

Messages: 4
Registered: November 2004

Karma: 0

Junior Member

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!

Report message to a moderator

Re: Attachment problems! Can somebody help? [message #21401 is a reply to message #21396]

Mon, 29 November 2004 16:14

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Here is the fix:
http://bb.prohost.org/egw.txt

FUDforum Core Developer

Report message to a moderator

Re: Attachment problems! Can somebody help? [message #22944 is a reply to message #21396]

Tue, 22 February 2005 11:11

stormuk

Messages: 6
Registered: February 2005

Karma: 0

Junior Member

How does one apply the patch?

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

Cheers

Tony

Report message to a moderator

Re: Attachment problems! Can somebody help? [message #22948 is a reply to message #22944]

Tue, 22 February 2005 14:11

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

You apply patches using the "patch" command line utility.

FUDforum Core Developer

Report message to a moderator

Re: Attachment problems! Can somebody help? [message #22950 is a reply to message #21396]

Tue, 22 February 2005 14:51

stormuk

Messages: 6
Registered: February 2005

Karma: 0

Junior Member

Ahh sorry my mistake - Im not using Unix its a windowz server!

How can I apply it using windows?

Report message to a moderator

Re: Attachment problems! Can somebody help? [message #22951 is a reply to message #22950]

Tue, 22 February 2005 14:56

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

The change is very simple in this case, simply replace the - lines with the + lines.

FUDforum Core Developer

Report message to a moderator

Re: Attachment problems! Can somebody help? [message #22952 is a reply to message #21396]

Tue, 22 February 2005 16:33

stormuk

Messages: 6
Registered: February 2005

Karma: 0

Junior Member

what do I do with

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

Anyone got the complete file?

Report message to a moderator

Re: Attachment problems! Can somebody help? [message #22953 is a reply to message #22952]

Tue, 22 February 2005 16:46

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

You only need to consider the +/- lines... the rest you can ignore.

FUDforum Core Developer

Report message to a moderator

Re: Attachment problems! Can somebody help? [message #22954 is a reply to message #22953]

Tue, 22 February 2005 17:21

stormuk

Messages: 6
Registered: February 2005

Karma: 0

Junior Member

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

Report message to a moderator

Re: Attachment problems! Can somebody help? [message #22957 is a reply to message #22954]

Tue, 22 February 2005 21:21

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

you need to syncronized fudforum sources & then rebuild the theme.

FUDforum Core Developer

Report message to a moderator

Re: Attachment problems! Can somebody help? [message #22964 is a reply to message #21396]

Wed, 23 February 2005 10:48

stormuk

Messages: 6
Registered: February 2005

Karma: 0

Junior Member

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 10:49]

Report message to a moderator

Re: Attachment problems! Can somebody help? [message #22973 is a reply to message #22964]

Wed, 23 February 2005 15:43

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Can you try that with a newly uploaded file?

FUDforum Core Developer

Report message to a moderator

Re: Attachment problems! Can somebody help? [message #22981 is a reply to message #21396]

Wed, 23 February 2005 18:20

stormuk

Messages: 6
Registered: February 2005

Karma: 0

Junior Member

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 18:42]

Report message to a moderator

Re: Attachment problems! Can somebody help? [message #23471 is a reply to message #21396]

Fri, 18 March 2005 08:37

sanju

Messages: 11
Registered: March 2005
Location: Linux World

Karma: 0

Junior Member

but i dont have the
LEFT JOIN {SQL_TABLE_PREFIX}mod md portion at all?

what shud i do?

Report message to a moderator

Re: Attachment problems! Can somebody help? [message #23483 is a reply to message #23471]

Fri, 18 March 2005 15:18

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Then you need to add it.

FUDforum Core Developer

Report message to a moderator

Re: Attachment problems! Can somebody help? [message #23533 is a reply to message #21396]

Mon, 21 March 2005 05:53

sanju

Messages: 11
Registered: March 2005
Location: Linux World

Karma: 0

Junior Member

Nope, still no luck

Report message to a moderator

Previous Topic:	SQL-Error
Next Topic:	Application Title Change

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 02:37:58 GMT 2024

Total time taken to generate the page: 0.02346 seconds