Left Join query not working in mysql 5.1

Try prepending the fields with the table name. Also looks like you're missing two commas, one after events.name and one after movies.name. I'd also remove the parentheses in the join (the extra one in the where is okay, but not needed) but it shouldn't be a problem.

select ev.event_type, ev.EventId, ev.VenueId, ev.Price, ev.Schedule, ev.startDate, ev.endDate, ev.events.name, ev.eventname, movies.name, movies.moviename from `eventvenue` ev, `events` left join movies on movies.ID = ev.EventId where events.ID = ev.EventId and events.VenueId = '493' and (ev.startDate >= '2010-04-25' or ev.endDate >= '2010-04-25' or ev.event_type = 'movies') order by ev.moviename asc, ev.startDate asc

Thanks, rocknbil. So this query worked:

SELECT ev.event_type
  , ev.EventId
  , ev.VenueId
  , ev.Price
  , ev.Schedule
  , ev.startDate
  , ev.endDate
  , e.name eventname
  , m.name moviename 
 FROM eventvenue ev
 JOIN events e
 ON e.ID = ev.EventId
 LEFT 
 JOIN movies m 
 ON m.ID = ev.EventId 
 WHERE ev.VenueId = 493 
 AND ((ev.startDate >= '2010-04-26' OR ev.endDate >= '2010-04-26') OR ev.event_type = 'movies') 
 ORDER 
 BY moviename ASC
  , ev.startDate ASC

However, I'm having a problem with another query now, that was working in4.1 but is not working in 5.1:

SELECT * FROM locations WHERE MATCH (Name, StreetAddress1, StreetAddress2, Area, City, Pin, Reviewer, CategoryKeywords, ProfileText, UserNames, UserComments) AGAINST ("+isb*" IN BOOLEAN MODE) limit 1 

Will greatly appreciate any pointers!

Just a note,

this query worked:....

AND ((ev.startDate >= '2010-04-26' OR ev.endDate >= '2010-04-26') OR ev.event_type = 'movies')

The way or works is additive, that is, the inner ()'s are not needed "as is." But it's no big deal.

However, I'm having a problem with another query now, that was working in4.1 but is not working in 5.1:

SELECT * FROM locations WHERE MATCH (Name, StreetAddress1, StreetAddress2, Area, City, Pin, Reviewer, CategoryKeywords, ProfileText, UserNames, UserComments) AGAINST ("+isb*" IN BOOLEAN MODE) limit 1

I rarely use match, so the foll0wing statement may be false. From what I can gather from the documentation here [dev.mysql.com],

The argument to AGAINST() must be a constant string

and here [dev.mysql.com],

The search string must be a literal string, not a variable or a column name.

it looks to me like you are attempting a regular expression match, "+isb*", and I don't know that it will work. I'd probably change this to use the like operator or regexps.

Another bit of info I found in the second document link:

Full-text indexes can be used only with MyISAM tables, and can be created only for CHAR, VARCHAR, or TEXT columns.

You can check that it's using MyISAM tables.

Does the query return an error?

My problem was actually that I'd set ft_min_word_len to 3 earlier, and when I migrated, it became the default 4. I reset it to 3 and recreated the indexes (indices?) and the query started working normally (throwing up results, as opposed to 0 results earlier).

Thanks, rocknbil!