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 between 2006-05-01 and 2006-05-31

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

Found 19 Pages:
Title Summary Date
Agincourt Community Church Wed 31st May 2006
Celebration ONETWOFIVE Come to Winnipeg June 15-17, 2007, and celebrate 125 years o… Wed 31st May 2006
DC Scholarships Wed 31st May 2006
Eastwood Corps Wed 31st May 2006
Testify CD Wed 31st May 2006
Candidates - Welcome Candidates Pages: Welcome | CFOT Information | (DFL) Design … Fri 26th May 2006
Residential Health Services The Salvation Army's health services reflect the caring phil… Wed 24th May 2006
The Salvation Army's Response Since its earliest days, The Salvation Army has been committ… Wed 24th May 2006
Canadian Staff Band New website coming soon. Tue 23rd May 2006
Guidelines for Tributes The War Cry is happy to print brief tributes, at no cost, as… Mon 15th May 2006
Letter to all Officers/Salvati… May 11, 2006 All Officers/Salvationists Canada & Bermuda… Fri 12th May 2006
How You Can Help You can help end Human Sexual Trafficking. Here's how: Pray… Wed 10th May 2006
If You Suspect If you suspect that someone you know has been trafficked, or… Wed 10th May 2006
Writer's guidelines The Editorial Department welcomes your submissions. The foll… Wed 10th May 2006
Retired Officers On-line Forum… This is a PRIVATE site for Retired Officers of The Salvation… Mon 8th May 2006
Welcome to the Territorial Ret… Mon 8th May 2006
Subscription Order Form To subscribe to Salvationist magazine, Faith & Friends o… Fri 5th May 2006
Employment Opportunities To post a job on this section of the website, please send an… Thu 4th May 2006
Single Spouse Officership Has the time come for the Army to enable married couples to … Thu 4th May 2006

Found 47 Articles: showing 1 to 25
< 1 2 >
Title Summary Date
Administrative Restructuring P… The Territorial Leaders met for the past few days, May 23-26… Tue 30th May 2006
Indonesia Earthquake - Update … The Salvation Army in Indonesia is preparing to send more me… Tue 30th May 2006
The Salvation Army responds to… Saturday May 27, 2006 ' The Salvation Army has launched an i… Mon 29th May 2006
Indonesia Earthquake ' Update … As the reported death toll following the earthquake which hi… Mon 29th May 2006
Episode 187: The Salvation Arm… The Salvation Army Connect… Fri 26th May 2006
The great pacific congress 200… Salvationists and friends from across the Pacific Northwest … Fri 26th May 2006
Vancouver Sun Run This year's Vancouver Sun Run took place on April 23, 2006. … Fri 26th May 2006
Curves in Burnaby donates to T… The owner of several Curves in Burnaby, B.C., Susan Ruetz, i… Thu 25th May 2006
In the midst of a crisis' Steve (not his real name) was the kind of guy that was doing… Thu 25th May 2006
Making a difference for the ho… In February, 2006, Envoy Gary Johnson, Langley South, B.C., … Wed 24th May 2006
The Salvation Army's Response … The following is a document containing The Salvation Army's … Wed 24th May 2006
Embracing multiculturalism in … In Canadian cities, some of which are among the most multicu… Tue 23rd May 2006
Aboriginal Awareness Week May 23-26 is Aboriginal Awareness Week. It is held on the fo… Mon 22nd May 2006
Couples retreat Ocean Crest Community Church, BC, sponsors their second marr… Fri 19th May 2006
Deer Lake graduates Nfld. - Matthew Feltham is presented with his graduate certi… Fri 19th May 2006
What is "Story in Convers… Story in Conversation is a live recording of dialogue betwee… Fri 19th May 2006
A new site On April 23rd, 2006 a ground-breaking ceremony is held for t… Thu 18th May 2006
Booth College celebrates its l… WINNIPEG ' April 30, 2006, Booth College marked its 24th gra… Thu 18th May 2006
Canadian Christian Women in Le… Women from throughout Canada converged on Calgary March 2-4 … Thu 18th May 2006
Episode 186: The Salvation Arm… The Salvation Army Connect… Thu 18th May 2006
Salvation Army called to the s… On Friday, May 6, 2006, at approximately 2:30 p.m., Const. J… Thu 18th May 2006
Celebrating Ninety-Five Years Congratulations to St. Anthony, Nfld. corps who recently cel… Wed 17th May 2006
Interim President of Booth Col… The Booth College Board of Trustees is pleased to announce t… Tue 16th May 2006
Peel Family Shelter Benefits F… 'Deals for Wheels' puts a van into service in Mississauga fo… Tue 16th May 2006
Fundraising results-2005/06 The National Red Shield Appeal reached $37.9 million, surpas… Mon 15th May 2006