FUDforum: Bug Reports » INNER JOIN on mysql 3.22.32 broken?

Home » FUDforum Development » Bug Reports » INNER JOIN on mysql 3.22.32 broken?

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

INNER JOIN on mysql 3.22.32 broken? [message #2844]

Sat, 01 June 2002 19:55

jdibbelt

Messages: 2
Registered: June 2002

Karma:

Junior Member

Hi!

When FUDforum2 tries to do sth. like:

select user_id from fud2_mod INNER JOIN fud2_users ON fud2_users.id=fud2_mod.user_id WHERE fud2_users.is_mod!='A' GROUP BY user_id;

this happens on mysql 3.22.32:

ERROR 1064: You have an error in your SQL syntax near 'ON fud2_users.id=fud2_mod.user_id WHERE fud2_users.is_mod!='A' GROUP BY user_id' at line 1

I've tried the equivalent syntax for INNER JOIN's which is working:

mysql> select user_id from fud2_mod, fud2_users WHERE fud2_users.id=fud2_mod.user_id AND fud2_users.is_mod!='A' GROUP BY user_id;
Empty set (0.00 sec)

So, what I'm to do? Recode most of the mysql queries?

btw: the mysql server is hosted by an isp so I can't just update.

Tsch��,
Julian D.

Report message to a moderator

[Message index]

		INNER JOIN on mysql 3.22.32 broken? By: jdibbelt on Sat, 01 June 2002 19:55
		Re: INNER JOIN on mysql 3.22.32 broken? By: jdibbelt on Sat, 01 June 2002 20:34
		Re: INNER JOIN on mysql 3.22.32 broken? By: hackie on Mon, 03 June 2002 23:33

Previous Topic:	SQL error when editing post (RC3)
Next Topic:	moderation error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 09 16:26:58 GMT 2024

Total time taken to generate the page: 0.04681 seconds