I've written a book!

friendsfoodgospelcoverI'm excited to announce that I have written a book - Friends, Food and the Gospel.
I lead a multi-cultural church and we have learnt how to reach people from different nations with the gospel through friendship and food! In the book, I teach on how to apply Jesus's words "Come follow me and I will make you fishers of men" as a team, how to make strong friendships, what hospitality really is and how to share the gospel effectively to people from different cultural settings. It's available in print and as an ebook in all countries... Buy on Lulu.com worldwide Buy on amazon.co.uk Buy on amazon.com


Support Forum

Avatar

Please consider registering
guest

sp_LogInOut Log In sp_Registration Register sp_MemberList Members

Register | Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed Topic RSS sp_TopicIcon
wp_church_admin_comments doesn't exist
7th September 2016
8:54 pm
Avatar
Member
Members
Forum Posts: 7
Member Since:
7th September 2016
sp_UserOfflineSmall Offline

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

7th September 2016
9:17 pm
Avatar
Admin
Forum Posts: 398
Member Since:
4th March 2015
sp_UserOfflineSmall Offline

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

Thanks

If you find the plugin useful, please buy me a coffee for all the late nights working on it!

7th September 2016
9:35 pm
Avatar
Member
Members
Forum Posts: 7
Member Since:
7th September 2016
sp_UserOfflineSmall Offline

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

7th September 2016
9:45 pm
Avatar
Admin
Forum Posts: 398
Member Since:
4th March 2015
sp_UserOfflineSmall Offline

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

If you find the plugin useful, please buy me a coffee for all the late nights working on it!

7th September 2016
9:56 pm
Avatar
Member
Members
Forum Posts: 7
Member Since:
7th September 2016
sp_UserOfflineSmall Offline

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:

Regards,
Kosie

7th September 2016
10:14 pm
Avatar
Admin
Forum Posts: 398
Member Since:
4th March 2015
sp_UserOfflineSmall Offline

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 if set)
The other downloads a vcf file of that household

If you find the plugin useful, please buy me a coffee for all the late nights working on it!

7th September 2016
10:25 pm
Avatar
Member
Members
Forum Posts: 7
Member Since:
7th September 2016
sp_UserOfflineSmall Offline

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

8th September 2016
6:59 am
Avatar
Admin
Forum Posts: 398
Member Since:
4th March 2015
sp_UserOfflineSmall Offline

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.

If you find the plugin useful, please buy me a coffee for all the late nights working on it!

8th September 2016
3:19 pm
Avatar
Member
Members
Forum Posts: 7
Member Since:
7th September 2016
sp_UserOfflineSmall Offline

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

24th January 2017
2:45 pm
Avatar
Wirksworth, Derbyshire, UK
Member
Members
Forum Posts: 30
Member Since:
19th January 2017
sp_UserOfflineSmall Offline

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

Forum Timezone: Europe/London

Most Users Ever Online: 19

Currently Online:
3 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Member Stats:

Guest Posters: 16

Members: 262

Moderators: 0

Admins: 1

Forum Stats:

Groups: 4

Forums: 12

Topics: 255

Posts: 930

Administrators: andymoyle: 398