Warning: session_start(): open(/var/lib/php/session/sess_jhc4d52qgu6in78n46ntq33o17, O_RDWR) failed: No space left on device (28) in /var/www/_shared/codebase.php on line 228

Warning: session_start(): Failed to read session data: files (path: /var/lib/php/session) in /var/www/_shared/codebase.php on line 228

Warning: fopen(./logs/error_2018-11-22.txt): failed to open stream: No space left on device in /var/www/_shared/codebase.php on line 1098

Warning: fwrite() expects parameter 1 to be resource, boolean given in /var/www/_shared/codebase.php on line 1099

Warning: fclose() expects parameter 1 to be resource, boolean given in /var/www/_shared/codebase.php on line 1100
The file ./logs/error_2018-11-22.txt is not writable

SQL Statement Debugger

Record::getRecordsForSql()

SELECT
  (SELECT
      `system`.`textEnglish`
  FROM
      `system`
  WHERE
      `system`.`ID` = `community_member`.`systemID`
  ) `systemTitle`,
  CONCAT(
      TRIM(TRAILING '/' FROM `community`.`URL`),
      '/',
      `community_member`.`name`
  ) AS `member_URL`,
  (
      LENGTH(`partner_csv`) -
      LENGTH(replace(`partner_csv`, ',', '')) +
      if(LENGTH(`partner_csv`), 1, 0) >= `partner_min`
  ) as `compliance`,
  (
      LENGTH(`partner_csv`) -
      LENGTH(replace(`partner_csv`,',','')) +
      if(LENGTH(`partner_csv`),1,0)
  ) `partners`,
  COALESCE(
      (SELECT
          `shortform_name`
      FROM
          `community_member` `cm2`
      WHERE
          `cm2`.`ID` = `community_member`.`primary_ministerialID`
      ),
      ''
  ) `ministerial_title`,
  `community_member`.*
FROM
  `community`
INNER JOIN `community_membership` ON
  `community_membership`.`communityID` = `community`.`ID`
INNER JOIN `community_member` ON
  `community_member`.`ID` = `community_membership`.`memberID`
WHERE
  `community`.`ID` = 635117601
ORDER BY
  `name`,`service_addr_city`

Error:

Can't create/write to file '/tmp/#sql_534_0.MYI' (Errcode: 28)

Call stack trace:

# Called by File Line
13 Record::getRecordsForSql() /var/www/_shared/classes/class.record.php 2569
12 Record::get_records_for_sql() /var/www/_shared/classes/class.community.php 195
11 Community::get_members() /var/www/_shared/classes/class.community_display.php 2458
10 Community_Display::setupListingsLoadRecords() /var/www/_shared/classes/class.community_display.php 2350
09 Community_Display::setupListings() /var/www/_shared/classes/class.community_display.php 888
08 Community_Display::draw() /var/www/_shared/codebase.php(1006) : eval()'d code 3
07 eval() /var/www/_shared/codebase.php 1006
06 convert_ecl_tags() /var/www/_shared/codebase.php 966
05 convert_safe_to_php() /var/www/_shared/codebase.php 1006
04 convert_ecl_tags() /var/www/_shared/codebase.php 966
03 convert_safe_to_php() /var/www/_shared/classes/class.layout.php 177
02 Layout::prepare() /var/www/_shared/system.php 224
01 main() /var/www/_shared/functions.php 176
00 include() /var/www/clients/client1/web1/web/index.php 3

Warning: Invalid argument supplied for foreach() in /var/www/_shared/classes/class.community_display.php on line 2363

Warning: Invalid argument supplied for foreach() in /var/www/_shared/classes/map/googlemap.php on line 627

Warning: Invalid argument supplied for foreach() in /var/www/_shared/classes/class.community_display.php on line 1510
Community of King

Members

Click on any photo for details.
Help:
Premium Listing - all features availablePremium Listing
Fully VerifiedFully Verified
Ministerial MemberMinisterial Member
View ProfileView Profile
View MapView map
View WebsiteView website

 

Members Map

Click on any name to find on map.
 

Regular Meeting Times

Showing regular public meetings. See Events for other events.

Sunday

(No scheduled meetings)

Monday

(No scheduled meetings)

Tuesday

(No scheduled meetings)

Wednesday

(No scheduled meetings)

Thursday

(No scheduled meetings)

Friday

(No scheduled meetings)

Saturday

(No scheduled meetings)
Disclaimer:   The values or activities represented here do not necessarily reflect those of all other members, or of Ecclesiact and its ministry partners.

Featured Articles

Featured articles from all members.
There are no Articles at this time.
Disclaimer:   The values or activities represented here do not necessarily reflect those of all other members, or of Ecclesiact and its ministry partners.

Featured Events

Featured events from all members. See Calendar for monthly calendar view.
There are no Events at this time.
Disclaimer:   The values or activities represented here do not necessarily reflect those of all other members, or of Ecclesiact and its ministry partners.

Monthly Calendar

Monthly Calendar for all members.
  November 2018
Print this calendar 
<< Prev Year < Prev Month Today > Next Month >> Next Year
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
28
29
30
31
01
02
03
04
05
06
07
08
09
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
01
02
03
04
05
06
07
08
Disclaimer:   The values or activities represented here do not necessarily reflect those of all other members, or of Ecclesiact and its ministry partners.

Featured News

Featured news from all members.
There are no News Items at this time.
Disclaimer:   The values or activities represented here do not necessarily reflect those of all other members, or of Ecclesiact and its ministry partners.

Latest Audio

Latest Sermon from each member - click here to access all sermons for this community.
There are no Podcasts at this time.
Disclaimer:   The values or activities represented here do not necessarily reflect those of all other members, or of Ecclesiact and its ministry partners.

About This Website

[ Our Partners | Ways You Can Help | Learn More... ]

Churches In King is part of the ChurchesInYourTown.ca initiative, a network of community websites operated by Ecclesiact© which has been specifically designed to help local churches work together and cooperate more effectively, to better serve their local communities and to bring Glory to the great name of Jesus Christ, the author and perfecter of our faith.


National Site Partners

We gratefully acknowledge our National Partners for their faithful support - without their help this website would not even have been possible.
Please click on their logos to visit each of their websites, and mention us whenever you contact them.
 

Ways you can help

We've laboured hard to establish this resource without having to resort to the usual barrage of inappropriate or irrelevant internet adverts.
If you believe in what we're doing and you feel called to support the work of this ministry, there are several practical ways you can help:

  1. Remember us in your prayers!
  2. Ask your webmaster to place a button on your church website homepage, and link it to http://www.ChurchesInKing.ca
    Contact us if you'd like this logo in a different size to suit your website.
    Churches In King website button (300px wide) Churches In King website button (250px wide) Churches In King website button (200px wide) Churches In King website button (150px wide)
  3. If you have a local church ministerial, tell them about this community website and invite them to contact us to discuss formally adopting it.
  4. Contact us if you'd like to be involved as an administrator or programmer - plenty of training will be given!
  5. If you know of anyone who would like to sponsor this site, please ask them to contact us. Click here to learn more about partnership.
  6. If you feel so moved, please prayerfully consider making a one-time donation toward the costs of running and maintaining this website.

Learn More...