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 tags Disaster, USA

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

Found 25 Articles:
Title Summary Date
Bermudian Salvationists Assist… Six Salvationists from Bermuda flew to Galveston, Texas… Wed 8th Oct 2008
U.S. Social Services Conferenc… Canadian officers or employees who plan to attend the U.S. N… Thu 25th Oct 2007
The Salvation Army Responds to… ALEXANDRIA, VA (October 23, 2007) - Having completed recover… Wed 24th Oct 2007
One of Humanity’s Darke… “The Salvation Army was the greatest thing that happen… Tue 11th Sep 2007
The Salvation Army Offers Aid … Wednesday August 8, 2007 - As fears of epidemic rise followi… Thu 9th Aug 2007
Retired Officers Introduce New… USA - Joe and Doris Noland are retired Salvation Army office… Mon 30th Jul 2007
The Salvation Army Ladore Conf… Upcoming special events held at the Ladore Conference Centre… Fri 1st Jun 2007
The Salvation Army continues t… Released April 17,2007 - The Salvation Army continues to mon… Wed 18th Apr 2007
Ain't broke, don't fix it IN professional sports, there are only two kinds of managers… Thu 22nd Feb 2007
Salvation Army aids Florida to… About 50 National Guard troops, residents and volunteers hel… Mon 5th Feb 2007
Support given to 1.7 million h… Since Hurricane Katrina struck the Gulf Coast on Aug. 29, 20… Mon 29th Jan 2007
Officers saved by a doorbell Pembroke,Ont. - Early this past Sunday morning, Cpts Robert … Fri 5th Jan 2007
Press interview with US Nation… The late management guru Peter Drucker called the Salvation … Tue 5th Dec 2006
Former Canadian envoys commiss… Douglas and Hélène Kornwolf were recently commissioned… Mon 13th Nov 2006
The South welcomes Canadian of… On August 26, 2006, in a service of installation, Canadian o… Wed 20th Sep 2006
Episode 203: The Salvation Arm… The Salvation Army Connection: Ep… Fri 15th Sep 2006
One-year anniversary of Hurric… ALEXANDRIA, VA (August 28, 2006) - In the year since Hurri… Tue 29th Aug 2006
Scotian Glen camp carries on d… Campers and staff are carrying on with their normal routines… Thu 24th Aug 2006
LIGHT IN THE DARKNESS - Whose … As the 2004 Boxing Day tsunami swept over the coast of Sri L… Thu 20th Jul 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
Much Loved Christian Author Hi… Beverly Lewis's The Englisher Debuts at #25 on the USA Today… Mon 15th May 2006
United 93: How Faith Triumphed… Paul Greengrass' new film is not easy to watch. But we all c… Thu 11th May 2006
Ruth's Epic Story Experience Ruth's adventure at the Sight and Sound Theatre i… Thu 20th Apr 2006