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

Home » FUDforum Development » Bug Reports » INNER JOIN on mysql 3.22.32 broken?
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
INNER JOIN on mysql 3.22.32 broken? [message #2844] Sat, 01 June 2002 19:55 Go to next message
jdibbelt   Germany
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 #2845 is a reply to message #2844] Sat, 01 June 2002 20:34 Go to previous messageGo to next message
jdibbelt   Germany
Messages: 2
Registered: June 2002
Karma: 0
Junior Member
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.
Re: INNER JOIN on mysql 3.22.32 broken? [message #2870 is a reply to message #2845] Mon, 03 June 2002 23:33 Go to previous message
hackie is currently offline  hackie   Canada
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
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: SQL error when editing post (RC3)
Next Topic: moderation error
Goto Forum:
  

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

Current Time: Sun Nov 10 00:02:37 GMT 2024

Total time taken to generate the page: 0.02080 seconds