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 551 to 575
< 1 2 … 21 22 23 24 25 … 48 49 >
Title Summary Date
Final Flight My five-year-old son and I were inseparable. Could I learn t… Wed 20th Jun 2007
A Thrift Store Surprise The manager of the Grand Falls-Windsor Thrift Store, NF, got… Tue 19th Jun 2007
Celebration 125 opens with Bra… Celebration 125 began with the triumphant sound of brass, so… Tue 19th Jun 2007
Laughter is God’s gift … I love to laugh. I am drawn to laughter and to those who lau… Tue 19th Jun 2007
Salvation Army Online Store La… On Friday, June 15, 2007, The Salvation Army Canada & Bermud… Tue 19th Jun 2007
How Much Is Too Much? How to talk to your children about human trafficking Thatâ… Mon 18th Jun 2007
Caption competition: winners Thank you for the great response to the request to send in c… Fri 15th Jun 2007
Quotes for Dad Fathers are special. Enjoy these quotes that remind dads of … Fri 15th Jun 2007
SA Emergency Disaster Vehicle … Nanaimo - For the past few days, people forced from their ho… Fri 15th Jun 2007
SAROOTS The SAROOTS weekend is fast approaching and will be held on … Thu 14th Jun 2007
The Salvation Army Celebrates … Once again this year, Immigrant & Refugee Services will be j… Wed 13th Jun 2007
Attention All Dads! In honour of Father's Day we are looking for your best capti… Tue 12th Jun 2007
Corner Brook Social Services H… On Monday, June 4, CBC Radio in Corner Brook, NF, did their … Tue 12th Jun 2007
A fine BALANCE Living in another country has helped me evaluate what  Mon 11th Jun 2007
“In Unity there is Stren… A team of individuals from across Canada, Integrate-Haiti â… Mon 11th Jun 2007
History Bites In June 1959, Her Majesty, Queen Elizabeth II and His Royal … Fri 8th Jun 2007
Press Conference in Quebec Montreal - The Salvation Army is seeking to adapt to best fi… Fri 8th Jun 2007
Blue Jay Fans Celebrate The Sa… On Wednesday, May 16, Toronto Blue Jay fans celebrated the o… Thu 7th Jun 2007
Corps Officer Shaves His Head … Major Calvin Collins, corps officer (pastor) of The Salvatio… Thu 7th Jun 2007
Heralds of the Good News Sessi… Winnipeg - On Saturday, June 16, 23 cadets of the Heralds of… Thu 7th Jun 2007
New Hope Centre For Nanaimo's … On June 1, The Salvation Army New Hope Centre in Nanaimo, B.… Wed 6th Jun 2007
The Salvation Army Partners Wi… For four years three nursing students from Nipissing Univers… Wed 6th Jun 2007
A Legacy Worth Celebrating A look back at 125 years of Army mission and ministry in Can… Mon 4th Jun 2007
Did You Know? In the last 12 months, with assistance from B.C. Housing and… Mon 4th Jun 2007
History Bites In June 1952 Major Arnold Brown's book "What hath God Wrough… Mon 4th Jun 2007