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

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

Found 1208 Articles: showing 1026 to 1050
< 1 2 … 40 41 42 43 44 … 48 49 >
Title Summary Date
Salvation Army staff bust thie… Ottawa - The staff at the Ottawa Grace Manor Long Term Care … Fri 1st Sep 2006
Episode 201: The Salvation Arm… The Salvation Army Connection: Ep… Thu 31st Aug 2006
A new little life is celebrate… Kentville, N.S. - Damian Bladen, born Feb. 4, 2006, lies pea… Wed 30th Aug 2006
New youth detox centre in Vict… Victoria, B.C. - The Salvation Army plans to open a new yout… Wed 30th Aug 2006
One-year anniversary of Hurric… ALEXANDRIA, VA (August 28, 2006) - In the year since Hurri… Tue 29th Aug 2006
Rick's story Rick MacDonald tells his story of recovery at the Booth Cent… Mon 28th Aug 2006
Caption competition: winners Thank you for the great response to the request to send in c… Fri 25th Aug 2006
Episode 200: The Salvation Arm… The Salvation Army Connection: Ep… Fri 25th Aug 2006
Feed the Need The Army’s strategy in downtown Halifax is pretty sim… Fri 25th Aug 2006
Newfoundland Salvationist Reci… Dr. Otto Tucker, a Salvationist from St. John’s Templ… Thu 24th Aug 2006
Scotian Glen camp carries on d… Campers and staff are carrying on with their normal routines… Thu 24th Aug 2006
Canadian officers are installe… Reading Central Corps, UK Central South Division - On Sunday… Tue 22nd Aug 2006
Caption competition Have a go at our first caption competition. Comment on this … Tue 22nd Aug 2006
Warehouse Mission transforms l… When Fred was found, he lay almost unconscious under a downt… Mon 21st Aug 2006
Corner Brook's achievements Corner Brook Citadel Corps, Nfld.: Celbrating their 82nd co… Fri 18th Aug 2006
Episode 199: The Salvation Arm… The Salvation Army Connection: Ep… Fri 18th Aug 2006
Living the Vision Territorial Leadership is exploring where we are in God  Fri 18th Aug 2006
The Salvation Army in British … Canada has often been described as the melting pot for the w… Thu 17th Aug 2006
Musgrave Harbour celebrates Celebrations include: New YPSM, Grace Gillam, is pictured w… Wed 16th Aug 2006
Chief Secretary's quarterly re… The following is the Chief Secretary’s 2nd quarter re… Tue 15th Aug 2006
Episode 198: The Salvation Arm… The Salvation Army Connection: Ep… Mon 14th Aug 2006
For the sake of the children There is an expression in The Salvation Army about “ma… Mon 14th Aug 2006
Multiculturalism in your congr… Think of multiculturalism in your congregation as a new menu… Mon 14th Aug 2006
New life celebrated/new soldie… Napanee, Ont. - New members of the corps, Shawn and Sandra H… Fri 11th Aug 2006
New commitments The Salvation Army St. John Community Church in New Brunswic… Thu 10th Aug 2006