New lower pricing for Subscriptions

50%off old price

Widget – SQL error

About Support Calendar Widget – SQL error

  • This topic is empty.
Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #2579
    Avatar for DavidNDavidN
    Member

    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 ,

    #3420
    Avatar for Andy MoyleAndy Moyle
    Keymaster

    The only problem I can see is that the second number after the comma is missing, so I’ve hopefully fixed that in v0.33.4.5 – but I’ve never had a problem with it before

    #3421
    Avatar for DavidNDavidN
    Member

    Thanks for looking at this. Unfortunately, it’s still the same, but it’s not a major problem. Now I’ve found more about the calendar, I may use a list view instead. There’s plenty to go in the widget area anyway ;)

Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.