FUDforum: FUDforum in eGroupWare » SQL syntax error when trying to enter forums

Home » General » FUDforum in eGroupWare » SQL syntax error when trying to enter forums

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

Re: SQL syntax error when trying to enter forums [message #29400 is a reply to message #29395]

Sun, 18 December 2005 14:13

Ilia

Messages: 13241
Registered: January 2002

Karma:

Senior Member
Administrator
Core Developer

I ment like this:
SELECT f.id, f.name, c.name, c.id, (CASE WHEN 0 < m.post_stamp AND (fr.last_view IS NULL OR m.post_stamp > fr.last_view) THEN 1 ELSE 0 END) AS reads FROM phpgw_fud_fc_view v INNER JOIN phpgw_fud_forum f ON f.id=v.f INNER JOIN phpgw_fud_cat c ON c.id=v.c LEFT JOIN phpgw_fud_msg m ON m.id=f.last_post_id LEFT JOIN phpgw_fud_forum_read fr ON fr.forum_id=f.id AND fr.user_id=2 ORDER BY v.id

FUDforum Core Developer

Report message to a moderator

[Message index]

		SQL syntax error when trying to enter forums By: sommer on Fri, 16 December 2005 13:55
		Re: SQL syntax error when trying to enter forums By: Ilia on Fri, 16 December 2005 20:43
		Re: SQL syntax error when trying to enter forums By: sommer on Sat, 17 December 2005 16:41
		Re: SQL syntax error when trying to enter forums By: Ilia on Sun, 18 December 2005 14:13
		Re: SQL syntax error when trying to enter forums By: sommer on Sun, 18 December 2005 14:23
		Re: SQL syntax error when trying to enter forums By: Ilia on Sun, 18 December 2005 14:30
		Re: SQL syntax error when trying to enter forums By: sommer on Sun, 18 December 2005 16:17
		Re: SQL syntax error when trying to enter forums By: Ilia on Mon, 19 December 2005 16:45
		Re: SQL syntax error when trying to enter forums By: sommer on Mon, 19 December 2005 23:18
		Re: SQL syntax error when trying to enter forums By: Ilia on Wed, 21 December 2005 05:09
		Re: SQL syntax error when trying to enter forums By: paulbau on Wed, 15 February 2006 19:22
		Re: SQL syntax error when trying to enter forums By: paulbau on Sun, 12 March 2006 21:34
		Re: SQL syntax error when trying to enter forums By: paulbau on Sun, 12 March 2006 21:57
		Re: SQL syntax error when trying to enter forums By: razvu on Sat, 18 March 2006 09:25
		Re: SQL syntax error when trying to enter forums By: Sir_Brizz on Tue, 13 June 2006 21:05
		Re: SQL syntax error when trying to enter forums By: kalmarek on Sat, 20 January 2007 00:27

Previous Topic:	Error 404 in eGroupware
Next Topic:	Migrating issues

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 02:02:31 GMT 2024

Total time taken to generate the page: 0.03643 seconds