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

Home » General » Database discussions » Mysql 5.0.12
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Mysql 5.0.12 [message #31886] Mon, 22 May 2006 10:42 Go to next message
mocara is currently offline  mocara   United Kingdom
Messages: 157
Registered: January 2004
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
Hi,
I've found that some apps I have stop working on mysql > 5.0.12 when multiple tables are after the FROM as in
FROM $sql_tbl[variants], $sql_tbl[pricing]

these need to be converted to
FROM ($sql_tbl[variants], $sql_tbl[pricing])

Are there any such problems with FUDForum and mysql > 5.0.12
Re: Mysql 5.0.12 [message #31899 is a reply to message #31886] Mon, 22 May 2006 18:39 Go to previous messageGo to next message
mocara is currently offline  mocara   United Kingdom
Messages: 157
Registered: January 2004
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
Well a quick test shows that FUD forum is bombing out too Sad

Mocara.
Re: Mysql 5.0.12 [message #31906 is a reply to message #31899] Tue, 23 May 2006 16:46 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
FUDforum does not use this syntax for joins, it uses and expliciting INNER JOIN or a LEFT JOIN syntax.

FUDforum Core Developer
Re: Mysql 5.0.12 [message #31915 is a reply to message #31906] Tue, 23 May 2006 20:11 Go to previous messageGo to next message
mocara is currently offline  mocara   United Kingdom
Messages: 157
Registered: January 2004
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
That is strange because it was complaining when I upgraded to Mysql 5. I shall do it again and take carefull notes on the errors.

Error example:
064: 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 'reads FROM fud26_fc_view v INNER JOIN fud26_forum f ON f.id=v.f INNER J' at line 1
Query: SELECT f.id, f.name, c.name, c.id, CASE WHEN 1080519799 < m.post_stamp AND (fr.last_view IS NULL OR m.post_stamp > fr.last_view) THEN 1 ELSE 0 END AS reads FROM fud26_fc_view v INNER JOIN fud26_forum f ON f.id=v.f INNER JOIN fud26_cat c ON c.id=v.c LEFT JOIN fud26_msg m ON m.id=f.last_post_id LEFT JOIN fud26_mod mm ON mm.user_id=14181 AND mm.forum_id=f.id INNER JOIN fud26_group_cache g1 ON g1.resource_id=f.id AND g1.user_id=2147483647 LEFT JOIN fud26_group_cache g2 ON g2.resource_id=f.id AND g2.user_id=14181 LEFT JOIN fud26_forum_read fr ON fr.forum_id=f.id AND fr.user_id=14181 WHERE mm.id IS NOT NULL OR ((CASE WHEN g2.id IS NULL THEN g1.group_cache_opt ELSE g2.group_cache_opt END) & 1) > 0 ORDER BY v.id

Is this a case of my dump and import not working?

Mocara.

[Updated on: Tue, 23 May 2006 20:16]

Report message to a moderator

Re: Mysql 5.0.12 [message #31933 is a reply to message #31915] Wed, 24 May 2006 18:21 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Does the query work if you put
CASE WHEN 1080519799 < m.post_stamp AND (fr.last_view IS NULL OR m.post_stamp > fr.last_view) THEN 1 ELSE 0 EN


in braces?


FUDforum Core Developer
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Is it possible to set character_set_results ... for mysql 5.0... from fudforum code?
Next Topic: Regarding Constraints
Goto Forum:
  

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

Current Time: Sun Dec 17 18:35:17 EST 2017

Total time taken to generate the page: 0.00708 seconds