Welcome to WebmasterWorld Guest from 23.20.245.192
Forum Moderators: open
WARNING [1024] Error while executing query:
select event_type, EventId, VenueId, Price, Schedule, ev.startDate, ev.endDate, events.name eventname, movies.name moviename from `eventvenue` ev, `events` left join (movies) on (movies.ID = ev.EventId) where events.ID = ev.EventId and VenueId = '493' and ((ev.startDate >= '2010-04-25' or ev.endDate >= '2010-04-25') or event_type = 'movies') order by moviename asc, ev.startDate asc
1054:Unknown column 'ev.EventId' in 'on clause'
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
SELECT * FROM locations WHERE MATCH (Name, StreetAddress1, StreetAddress2, Area, City, Pin, Reviewer, CategoryKeywords, ProfileText, UserNames, UserComments) AGAINST ("+isb*" IN BOOLEAN MODE) limit 1
this query worked:....
AND ((ev.startDate >= '2010-04-26' OR ev.endDate >= '2010-04-26') OR ev.event_type = 'movies')
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
The argument to AGAINST() must be a constant string
The search string must be a literal string, not a variable or a column name.
Full-text indexes can be used only with MyISAM tables, and can be created only for CHAR, VARCHAR, or TEXT columns.