INNER JOIN on mysql 3.22.32 broken? [message #2844] |
Sat, 01 June 2002 19:55 |
jdibbelt
Messages: 2 Registered: June 2002
Karma: 0
|
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.
|
|
|
|
Re: INNER JOIN on mysql 3.22.32 broken? [message #2870 is a reply to message #2845] |
Mon, 03 June 2002 23:33 |
hackie
Messages: 177 Registered: January 2002
Karma: 0
|
Senior Member Core Developer |
|
|
jdibbelt wrote on Sat, 01 June 2002 16:34 | Oh, stupid me.
That's probably at least one reason why mysql 3.23 or higher is needed by FUDforum.
So i've to bother my isp.
Thanks,
Julian D.
|
Yep, MySQL 3.22 is a tad bit old, we considered supporting it, but dropped the idea as to much PITA, supporting it would require making our relatively clean looking (but complex) queries a rather nasty mess.
cc intelligence.c -o intelligence
$ ./intelligence
Segmentation fault
|
|
|