SQL Statement Debugger

Record::get_records_for_sql()

SELECT
  COALESCE(MIN(DATE(`history_created_date`)),'0000-00-00') `min`,
  COALESCE(MAX(DATE(`history_created_date`)),'0000-00-00') `max`
FROM
  `pages`
WHERE
  `history_created_date`>'1000-00-00' AND
  `systemID` IN()

Error:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 8

Call stack trace:
[12] Record::get_record_for_sql() via /var/www/2380/classes/class.system.php line 769
[11] System::get_global_date_range() via /var/www/2380/classes/class.search.php line 101
[10] Search::_draw_controls() via /var/www/2380/classes/class.search.php line 297
[09] Search::_draw_results() via /var/www/2380/classes/class.search.php line 90
[08] Search::draw() via /var/www/2380/codebase.php(982) : eval()'d code line 3
[07] eval() via /var/www/2380/codebase.php line 982
[06] convert_ecl_tags() via /var/www/2380/codebase.php line 942
[05] convert_safe_to_php() via /var/www/2380/codebase.php line 982
[04] convert_ecl_tags() via /var/www/2380/codebase.php line 942
[03] convert_safe_to_php() via /var/www/2380/classes/class.layout.php line 133
[02] Layout::prepare() via /var/www/2380/system.php line 189
[01] main() via /var/www/2380/functions.php line 151
[00] include() via /var/www/clients/client5/web76/web/index.php line 4

SQL Statement Debugger

Record::get_records_for_sql()

SELECT
  COALESCE(MIN(DATE(IF(`type`='event',`effective_date_start`,`date`))),'0000-00-00') `min`,
  COALESCE(MAX(DATE(IF(`type`='event',`effective_date_start`,`date`))),'0000-00-00') `max`
FROM
  `postings`
WHERE
  IF(`type`='event',`effective_date_start`,`date`)>'1000-00-00' AND
  `systemID` IN()

Error:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 8

Call stack trace:
[12] Record::get_record_for_sql() via /var/www/2380/classes/class.system.php line 779
[11] System::get_global_date_range() via /var/www/2380/classes/class.search.php line 101
[10] Search::_draw_controls() via /var/www/2380/classes/class.search.php line 297
[09] Search::_draw_results() via /var/www/2380/classes/class.search.php line 90
[08] Search::draw() via /var/www/2380/codebase.php(982) : eval()'d code line 3
[07] eval() via /var/www/2380/codebase.php line 982
[06] convert_ecl_tags() via /var/www/2380/codebase.php line 942
[05] convert_safe_to_php() via /var/www/2380/codebase.php line 982
[04] convert_ecl_tags() via /var/www/2380/codebase.php line 942
[03] convert_safe_to_php() via /var/www/2380/classes/class.layout.php line 133
[02] Layout::prepare() via /var/www/2380/system.php line 189
[01] main() via /var/www/2380/functions.php line 151
[00] include() via /var/www/clients/client5/web76/web/index.php line 4
Search Results
Skip to Content
Click to print

Search Results for tag Enrolment

Text:
Categories:
Tags:
Date Range:
- to -
Items:
Sites:

Found 22 Articles:
Title Summary Date
Charlottetown Celebrates 122nd… Highlights of the festivities included the enrolment of Stef… Tue 8th Jul 2008
2008 Soldier and Adherent Enro…   Brampton, Ontario (L-R) Boyd Cooper, Lynn Coope… Fri 2nd May 2008
God's Army Grows P.E.I. - Charlottetown Community Church recently welcomed it… Wed 4th Jul 2007
Highlights from Bells Corners Ottawa - Bells Corners Community church shares their latest … Mon 2nd Jul 2007
God's Army Grows Islandview Citadel, Musgravetown, NLE - Congratulations to 1… Thu 21st Jun 2007
A mother-daughter enrolment at… It was a mother & daughter / senior & junior soldier enrolme… Wed 23rd May 2007
God's Army grows in Newmarket Newmarket - The Salvation Army Northridge Community Church h… Fri 18th May 2007
Belleville corps celebrates ne… On May 6, 2007, one soldier and 23 adherents were enrolled a… Thu 17th May 2007
New commitments Smiths Falls, Ont. - Congratulations to the four new soldier… Fri 16th Mar 2007
New youth commitments Penticton, BC, has recently experienced another exciting wee… Fri 23rd Feb 2007
God's Army grows in St. John's St. John's Citadel, NF - Pictured from left are: Captain Jul… Wed 24th Jan 2007
An unusual enrolment Jeni Parsons and Regan Lipsett are enrolled under the colour… Tue 19th Dec 2006
Senior soldier enrolment London, Ont. - In June three new senior soldiers were enroll… Tue 10th Oct 2006
Orillia Community Church celeb… Junior Soldier enrolment - Congratulations to five young peo… Fri 6th Oct 2006
A young life puts her future i… Winnipeg, M.B. - Emily Moulton was enrolled October 1, 2006 … Thu 5th Oct 2006
New life celebrated/new soldie… Napanee, Ont. - New members of the corps, Shawn and Sandra H… Fri 11th Aug 2006
New members welcomed/Faithful … Brantford, Ont.- New junior and senior soldiers are enrolled… Wed 26th Jul 2006
God's army grows Woodroofe Community Church, Ottawa, welcomes three new soldi… Tue 4th Jul 2006
Charlottetown, Nfld., enrolmen… Pictured is Kim Tucker, newly enrolled soldier along with Cp… Tue 13th Jun 2006
St. Thomas Corps welcomes new … Both junior and senior soldiers were recently enrolled at th… Wed 7th Jun 2006
Celebrating Ninety-Five Years Congratulations to St. Anthony, Nfld. corps who recently cel… Wed 17th May 2006
Enrolments Across the Territor… "Praise God in His Sanctuary." Exciting new enrolments take … Wed 19th Apr 2006