Strange. I'm curious, what is it about this query that trips up mysql 5? I use:
- Server version: 5.0.91-community
I notice there were bugs in earlier versions. Maybe my host just for this test server needs to update mysql 5?
SELECT [B]music_albums.*[/B],users.username,inventory.stock,inventory.upc_code, DATE_FORMAT(release_date,'%M %d, %Y') AS rel FROM music_albums,users LEFT JOIN inventory ON ([B]inventory.album_id=music_albums.id[/B]) WHERE users.uid=music_albums.artist_id AND music_albums.id='8'
This has worked perfectly on mysql 4. Now, with mysql 5+, it gives this error:
#1054 - Unknown column 'music_albums.id' in 'on clause'
How does it not recognize the column music_albums.id ? What do I have to do differently, from now on, for mysql 5? I am testing our site on php 5/mysql 5 to make sure our site won't break before we update our servers.
PS. Edit: I see it was a feature change and am reading the mysql docs but I think I need coffee to understand it...but for those going through the same thing, look at this page: