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

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

Found 4 Pages:
Title Summary Date
Service Opportunities Overseas The following are the latest service opportunities list prov… Thu 29th May 2008
All Ontario Junior Music Camp … Wed 28th May 2008
All Ontario Junior Music Camp … www.ilovecamp.ca Wed 28th May 2008
Home Missions Supports Our Fir… “…he who gathered muc… Wed 14th May 2008

Found 27 Articles: showing 1 to 25
< 1 2 >
Title Summary Date
2008 Soldier and Adherent Enro… Charlottetown, PEI (L-R) Nancy Wood - New Adherent, Jane … Fri 30th May 2008
Embracing Diversity Organizers were thrilled with the response to the Together c… Fri 30th May 2008
Prayer Request from Zimbabwe The Territorial Commander requests special prayer for Zimbab… Fri 30th May 2008
Empress of Ireland Remembered On Sunday, May 25, Salvationists and friends gathered under … Thu 29th May 2008
Service Opportunities for Salv… The following are the latest service opportunities list prov… Thu 29th May 2008
Hope for the Homeless in Halto… From left, Carol Willems-Payne, family shelter co-rdinator; … Wed 28th May 2008
Ministering in Myanmar The Salvation Army provides aid to cyclone victims in Myanma… Wed 28th May 2008
Summer Outreach Have you forgotten to order your copies of the summer evange… Tue 27th May 2008
St. Catherines Booth Centre Ce… Vi Callahan Residence Manager celebrating completion of 22 t… Mon 26th May 2008
The Christian Community Develo… The Christian Community Development Association (www.ccda.or… Mon 26th May 2008
Volunteer Appreciation - Penti… This year's theme is a fitting one for the over 150 voluntee… Mon 26th May 2008
Rural Ministry Symposium 2008 Sponsored by Queen's Theological College October 27-29th, 20… Thu 22nd May 2008
VisionTV - The Naked Archaeolo… As mentioned previously, this documentary series follows Can… Thu 22nd May 2008
Five New Auxiliary Captains   Major Jean Moulton visited CFOT this week and had … Tue 20th May 2008
Myanmar/China Prayer Request At such a time as this, our Canadian leaders are calling on … Tue 20th May 2008
Weakened Arms Held High As members of our local congregation, it is our responsibili… Mon 19th May 2008
Extreme Clergy - Vision TV VisionTV doc series tells true stories of clergy who fight f… Thu 15th May 2008
Booth College Celebrates its 2… The last weekend of April brought to a climax the 2007-2008 … Wed 14th May 2008
VisionTV's Naked Archaeologist In the new season of his acclaimed VisionTV documentary seri… Wed 14th May 2008
Army Publications Win Eight Ch… Salvationist and Faith & Friends magazines won a total of ei… Mon 12th May 2008
Volunteer Appreciation - New W… Bakery donations distributed Lunch Volunteers Service Pun… Mon 12th May 2008
It's All About People New chief secretary shares how integrated mission continues … Sun 11th May 2008
Volunteer Appreciation - Sunse… Pictures from the Sunset Lodge volunteer appreciation dinner… Fri 9th May 2008
Volunteer Appreciation - Campb… Campbell River Appreciation Dinner for Kettle Volunteers … Tue 6th May 2008
Fire Ravages Salvation Army Wa… A weekend fire at a Toronto Salvation Army warehouse has cau… Mon 5th May 2008