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 category Around the Territory

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

Found 639 Articles: showing 1 to 25
< 1 2 3 4 5 6 … 21 22 23 24 25 26 >
Title Summary Date
Call to Prayer for the Middle … Dear Fellow Salvationists, Once more those lands so famil… Mon 12th Jan 2009
Christmas with The Salvation A… Any producer will reluctantly admit that finding an audience… Sun 11th Jan 2009
Hope in the City Breakfast It’s a classic rags-to-riches story Frank O’Dea … Wed 7th Jan 2009
New Blankets for Yellowknife S… Northwest Territories Deputy Minister for the Department of … Wed 7th Jan 2009
Toy Drive Every year, more than 130,000 children receive toys from The… Fri 19th Dec 2008
How the Christmas Kettle Made … Each year, clients from The Salvation Army’s Hope Acre… Thu 18th Dec 2008
Community Support in Langley, … Langley, B.C., is getting behind the Army’s Gateway of… Wed 17th Dec 2008
Commissioner Francis Installed… Commissioner William W. Francis, Territorial Commander of Th… Tue 9th Dec 2008
The Salvation Army's 100th You… Over the past two years The Salvation Army has been busy upl… Thu 4th Dec 2008
Senior Reserved Appointments Following extensive consultation with territories, and in-de… Mon 1st Dec 2008
Lt-Colonels Copple Promoted to… Lt-Colonels Donald and Ann Copple, Chief Secretary and Terri… Fri 28th Nov 2008
Cadet Winter Assignments 2008 Cadets are on the move again. CFOT, working in consultation … Tue 18th Nov 2008
With Christ at the Centre Hamilton, Ont., is located at the centre of the Golden Horse… Fri 7th Nov 2008
A Congress of Thanksgiving Uniforms were everywhere! From the Toronto lakefront to the … Sun 26th Oct 2008
Winds of the Spirit Sweep Thro… We instantly noticed him sitting at the back of the congrega… Thu 23rd Oct 2008
Kings Singers to Perform in Lo… The London Citadel Band of The Salvation Army is pleased to … Wed 22nd Oct 2008
Restructuring Roll-Out Lt-Colonel Donald Copple, Chief Secretary, has announced the… Tue 21st Oct 2008
A Call to be Radical Commissioners William and Marilyn Francis made their first v… Fri 17th Oct 2008
Bermudian Salvationists Assist… Six Salvationists from Bermuda flew to Galveston, Texas… Wed 8th Oct 2008
Experimental Kids' Kamp a Reso… Fun, friendship, fellowship and faith have all been on the m… Wed 8th Oct 2008
Territorial Day of Prayer for … Greetings, As Symposium 2008 draws closer I am inviting e… Wed 8th Oct 2008
Dudley Coles' Leap of Faith It took Dudley Coles 10 years to plan and write Leap of Fait… Wed 24th Sep 2008
Salvation Army Night with the … For a number of years, Blue Jays President and CEO Paul Godf… Thu 18th Sep 2008
Fighting Human Trafficking on … The Newfoundland and Labrador Human Trafficking Committ… Mon 15th Sep 2008
Celebrating Service in Quebec The Salvation Army in Quebec recently held a retirement cele… Wed 3rd Sep 2008