Calendar not showing on front end

Hi,

My client has just updated to Joomla 3.6, then updated Event Booking to 2.8.1.

Now the calendar isn't working it's giving the default error page and is showing the following error:

#1054 Unknown column 'a.featured' in 'field list' SQL=SELECT a.id,a.parent_id,a.event_capacity,a.title,a.event_date,a.event_end_date,a.thumb,a.alias,a.featured,SUM(b.number_registrants) AS total_registrants FROM #__eb_events AS a LEFT JOIN #__eb_registrants AS b ON (a.id = b.event_id ) AND b.group_id = 0 AND (b.published=1 OR (b.payment_method LIKE "os_offline%" AND b.published NOT IN (2,3))) WHERE a.published = 1 AND a.access in (1,1,5) AND ((`event_date` BETWEEN '2016-07-01 00:00:00' AND '2016-07-31 23:59:59') OR (MONTH(event_end_date) = 07 AND YEAR(event_end_date) = 2016 )) GROUP BY a.id ORDER BY a.event_date ASC, a.ordering ASC

Thanks for you help
Kylie

Hi Kylie

Seems the upgrade was not success for some reasons. Please go to Events Booking -> Events, then access to Tools -> Fix Database Schema

The system will then update the database schema to latest version and it should help solving the issue

Regards,

Tuan

Hi, thank you for your reply.

I'm logged into Joomla, I go to components > Events Booking > Events but I cannot find Tools. Could you please explain further where this is?

Thanks
Kylie

Hi

Please see this screenshot drive.google.com/file/d/0B2RoJ_24efMQVUk...W8/view?usp=drivesdk

Tuan

Thank you Tuan.

Mine doesn't show tools

dl.dropboxusercontent.com/u/2574008/Past..._07_2016_6_00_pm.jpg

Hi Kylie

So strange. Please submit a support tickets sending us super admin account of your site, we will check it directly on your site to see why it happens and get it sorted

Regards,

Tuan