Hi,
Take a look at the answer written by Peter Brawley to Jason Chan at Oct
10, 2006, ~04:34 PM. Answer included below:
Jason
following statement works in 4 but not 5
SELECT f.*, c.id as cat_id, c.position as cat_position, c.state as
cat_state, c.name as cat_name, c.description as cat_desc,
c.image, c.url, m.member_name as mod_name, m.member_id as
mod_id, m.is_group, m.group_id, m.group_name, m.mid
FROM ibf_forums f, ibf_categories c
LEFT JOIN ibf_moderators m ON (f.id=m.forum_id)
WHERE c.id=f.category
ORDER BY c.position, f.position
Look up joins in the 5.0 or 5.1 manual. As of 5.0.12, MySQL implemented
ANSI/ISO compliance, breaking comma joins of the sort you use above. You need
explicit JOIN ... ON | USING syntax to remove referential ambiguities.
PB
-----
Jason Chan wrote:
I am going to upgrade my database from version 4 to 5.
However I found some of my web application doesn't work on MySQL5
e.g following statement works in 4 but not 5
SELECT f.*, c.id as cat_id, c.position as cat_position, c.state as
cat_state, c.name as cat_name, c.description as cat_desc,
c.image, c.url, m.member_name as mod_name, m.member_id as
mod_id, m.is_group, m.group_id, m.group_name, m.mid
FROM ibf_forums f, ibf_categories c
LEFT JOIN ibf_moderators m ON (f.id=m.forum_id)
WHERE c.id=f.category
ORDER BY c.position, f.position
Error:
Unknown column 'f.id' in 'on clause'
The alias seem not working?
What should I do, I dont want to rewrite all my sql statement....
Thanks.
Jason
--
Anders Lundgren
Master Software Engineer
Viba IT Handelsbolag
Web: http://www.vibait.se
[EMAIL PROTECTED] wrote:
hi,
currently using mysql 4.0.18. want to move to 5.0 (latest stable version
for commercil use). is there anytihng I have to be considered DB will not
work?
thanks.
-afan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
