Just beginning to use church_admin as part of the remodeling of our church web site. The calendar widget is showing an error as below. It reads as though the problem is with the hosting company’s setup. (I’m using 1and1).
Can you confirm?
Thanks,
David
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 5]
SELECT ztrq22j723wp_church_admin_calendar_date.start_date, TIME_FORMAT(ztrq22j723wp_church_admin_calendar_date.start_time,’%h:%i%p’)AS start_time, ztrq22j723wp_church_admin_calendar_date.end_time, ztrq22j723wp_church_admin_calendar_event.title, ztrq22j723wp_church_admin_calendar_event.description,ztrq22j723wp_church_admin_calendar_category.category FROM ztrq22j723wp_church_admin_calendar_date, ztrq22j723wp_church_admin_calendar_event,ztrq22j723wp_church_admin_calendar_category WHERE ztrq22j723wp_church_admin_calendar_date.start_date=’2012-03-28′ AND ztrq22j723wp_church_admin_calendar_date.event_id = ztrq22j723wp_church_admin_calendar_event.event_id AND ztrq22j723wp_church_admin_calendar_event.cat_id=ztrq22j723wp_church_admin_calendar_category.cat_id ORDER BY ztrq22j723wp_church_admin_calendar_date.start_date,ztrq22j723wp_church_admin_calendar_date.start_time LIMIT 0 ,