Error:
The MariaDB database returned an error while processing your request.
The SQL statement was: SELECT book.book_id, book.boat, details.berths, location.hirebase, grade.newgrade, details.d2009, location.map, details.type, details.berths, details.doublebeds, details.singlebeds, details.toilets, details.showers, details.240v, details.pets, book.startdate, calendar.day, book.enddate, endday.endday, book.price, specialoffer.specialoffer FROM book LEFT OUTER JOIN boatphone ON book.company = boatphone.company LEFT OUTER JOIN specialoffer ON book.offer = specialoffer.offer LEFT OUTER JOIN endday ON book.enddate = endday.enddate LEFT OUTER JOIN grade ON book.class = grade.class LEFT OUTER JOIN calendar ON book.startdate = calendar.startdate LEFT OUTER JOIN details ON book.class = details.class LEFT OUTER JOIN location ON book.location = location.location WHERE book.nights = 7 AND book.startdate = '2012-10-27' AND ((UPPER(book.location) LIKE UPPER('%Norbury%'))) AND ((UPPER(specialoffer.specialoffer) LIKE UPPER('%special%'))) AND ((UPPER(book.available) LIKE UPPER('%yes%'))) ORDER BY book.startdate ASC, details.berths ASC, boatphone.ranking ASC;
The database returned this: Unknown column 'details.d2009' in 'field list'
Other info: Resource temporarily unavailable
$user_data{book.nights}=7
$user_data{_cgifunction}=search
$user_data{book.startdate}=27/10/12
$user_data{specialoffer.specialoffer}=special
$user_data{book.location}=Norbury
$user_data{_layout}=waterways2009
$user_data{book.available}=yes