Error on directory pages

About Support Installing Church Admin Error on directory pages

  • This topic is empty.
Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #2492

    This is the first thing I’ve tried since installing this program. Here is the error I get. The url is http://www.fbcwayne.com/directory

    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 1]
    SELECT household_id FROM wp_church_admin_people WHERE (member_type_id=#) GROUP BY household_id ORDER BY last_name ASC

    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 1]
    SELECT household_id FROM wp_church_admin_people WHERE (member_type_id=#) GROUP BY household_id ORDER BY last_name ASC LIMIT 10, 10

    #3126
    Avatar for Andy MoyleAndy Moyle
    Keymaster

    Hi there,

    Sorry for leaving error reporting live – that makes it pretty ugly!

    You need to adjust your shortcode at the moment you have something like
    [church_admin type="address-list" member_type_id=# map=1]

    The # needs to be replaced with the member_type_id’s you have setup/defaults
    On the main menu page there are listed in the shortcodes section all the member types you currently are using

    http://www.themoyles.co.uk/wp-content/uploads/2013/05/member_type_id.PNG

    [church_admin type="address-list" member_type_id=1,3 map=1] is what I have on my site – map=1 shows a small google map for geo-located people

    #3127
    Avatar for Andy MoyleAndy Moyle
    Keymaster

    v0.554 will display all address records for all member types if # is used!

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