About › Support › Installing Church Admin › wp_church_admin_comments doesn’t exist
- This topic is empty.
-
AuthorPosts
-
7th September 2016 at 8:54 pm #2670kosie99Member
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 DESCAm I doing something wrong here?
Regards
7th September 2016 at 9:17 pm #3607Andy MoyleKeymasterNo, there was a bug, which is fixed for 1.069
Thanks
7th September 2016 at 9:35 pm #3608kosie99Member@andymoyle said:
No, there was a bug, which is fixed for 1.069Thanks
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
7th September 2016 at 9:45 pm #3609Andy MoyleKeymasterCould you post the url where you get the broken link so I can work out where the problem is
7th September 2016 at 9:56 pm #3610kosie99Member@andymoyle said:
Could you post the url where you get the broken link so I can work out where the problem isThe 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,
Kosie7th September 2016 at 10:14 pm #3611Andy MoyleKeymasterYou 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 linkOn 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 household7th September 2016 at 10:25 pm #3612kosie99MemberHi 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:
8th September 2016 at 6:59 am #3613Andy MoyleKeymasterI’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.
8th September 2016 at 3:19 pm #3614kosie99MemberThanks!
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
24th January 2017 at 2:45 pm #3652AllenMember@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 -
AuthorPosts
- You must be logged in to reply to this topic.