wp_church_admin_comments doesn’t exist

About Support Installing Church Admin wp_church_admin_comments doesn’t exist

  • This topic is empty.
Viewing 10 posts - 1 through 10 (of 10 total)
  • Author
    Posts
  • #2670
    Avatar for kosie99kosie99
    Member

    I have done a brand new fresh install of the plugin and when I edit a person, I see this at the bottom of the screen:

    Notes

    WordPress database error: [Table ‘db.wp_church_admin_comments’ doesn’t exist]
    SELECT a.*, CONCAT_WS(” “,b.first_name,b.prefix,b.last_name) AS name FROM wp_church_admin_comments a, wp_church_admin_people b WHERE a.ID=”2″ AND a.comment_type=”people” AND a.parent_id=0 AND a.author_id=b.user_id ORDER BY timestamp DESC

    Am I doing something wrong here?

    Regards

    #3607
    Avatar for Andy MoyleAndy Moyle
    Keymaster

    No, there was a bug, which is fixed for 1.069

    Thanks

    #3608
    Avatar for kosie99kosie99
    Member

    @andymoyle said:
    No, there was a bug, which is fixed for 1.069

    Thanks  

    I see now that when I edit a person, that the google map link at the bottom shows a broken link:

    When I click on “edit address”, the map displays correctly.

    Regards

    #3609
    Avatar for Andy MoyleAndy Moyle
    Keymaster

    Could you post the url where you get the broken link so I can work out where the problem is

    #3610
    Avatar for kosie99kosie99
    Member

    @andymoyle said:
    Could you post the url where you get the broken link so I can work out where the problem is  

    The site is not public yet, so I cannot link a url. I see the broken link when I click on an address of a household. The broken image is just below the “edit address” link.

    I see the same type of broken map link on a page where I use this shortcode:

    [church_admin type=address-list member_type_id=# photo=1 map=1 site_id=0]

    Regards,
    Kosie

    #3611
    Avatar for Andy MoyleAndy Moyle
    Keymaster

    You need to set a google api key on the settings page in the general settings area for a map to show on an edit household/smallgroup/site page on the backend.
    You need to set it up for the domain you are woking with – i.e localhost ;-)
    The google api link is https://console.developers.google.com/apis/ and then click Google Maps Geocoding API link

    On the shortcode – what do you mean by broken map link? If the map is not showing – right click the broken image and click open image in a new tab – then google will tell you what is wrong!
    The little links at the bottom left of an address entry
    One is edit (which links to the back end edit page or the page with [church_admin_register] if set)
    The other downloads a vcf file of that household

    #3612
    Avatar for kosie99kosie99
    Member

    Hi Andy,

    I do have an API key. Pity I cannot post you a screenshot :)

    When using the shortcode, the page lists all members and way to the right, I see a broken image and the word “Map”. When right-click the broken link image and open in a new tab, it does load the map properly:

    I used 10 Downing Street as the address of a fake member and google opens this page for me when I right-click as you suggested:

    https://goo.gl/maps/6rFBMn1vcA12

    #3613
    Avatar for Andy MoyleAndy Moyle
    Keymaster

    I’ve not had the api key in on the static map requests for the address list shortcodes and it’s been working fine for me. But I’ve added it in for the next update, so it should come good for you too.

    #3614
    Avatar for kosie99kosie99
    Member

    Thanks!

    One last thing for me, hopefully :):

    The page using the address list shortcode has a link at the top that says:
    “PDF version”

    When I click on that, I get:

    “You can only download if coming from a valid link”

    Regards

    #3652
    Avatar for AllenAllen
    Member

    @kosie99 said:
    Thanks!

    One last thing for me, hopefully :):

    The page using the address list shortcode has a link at the top that says:
    “PDF version”

    When I click on that, I get:

    “You can only download if coming from a valid link”

    Regards  

    If you still have this problem.
    I noticed this problem on mine and found I had the “#” in the shortcode
    {church_admin type=address-list member_type_id=# photo=1 map=1 site_id=0}
    I changed it to “all”
    {church_admin type=address-list member_type_id=all photo=1 map=1 site_id=0}
    and it produced a nice pdf version

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