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 category SA Feature

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

Found 505 Articles: showing 1 to 25
< 1 2 3 4 5 6 … 16 17 18 19 20 21 >
Title Summary Date
Gaining Acceptance Following our first year of studies at the College for Offic… Mon 2nd Feb 2009
A Place of Renewal If Major Roy Bridger, executive director of The Salvation Ar… Fri 30th Jan 2009
An Uncertain Future Home to more than a million people, Kenya’s Kibera is … Wed 28th Jan 2009
The Miracle of Adoption Adoption has been an interesting experience for our family. … Mon 26th Jan 2009
Making a Difference Last summer I attended a beautiful wedding on a warm July af… Wed 21st Jan 2009
The Porcupine and the Snake I once heard an Australian preacher describe the conflict be… Mon 19th Jan 2009
Proclaiming Kingdom Culture Lt-Colonels Raphael and Winsome Mason were appointed to the … Fri 16th Jan 2009
The Gift of Life In this Salvationist.ca series, Captain Amy Reardon, Editor … Wed 14th Jan 2009
Venturing Forth The Winnipeg kitchen is a beehive of activity. Four hundred … Mon 12th Jan 2009
Wholeness As a challenging new year lies ahead, the word that keeps co… Fri 9th Jan 2009
Surviving the Cash Crunch In these days of economic uncertainty, the topic of personal… Wed 7th Jan 2009
Holding the Line Paul Goodyear is the territorial finance secretary. Under hi… Mon 5th Jan 2009
Haven of Hope and Health We have an unofficial motto here,” declares Ivy Scobie… Mon 29th Dec 2008
Being Wise at Christmas Wisdom is a precious thing because it is rare. Have you noti… Mon 22nd Dec 2008
The Gift of Presence Shopping for others can be tough. Finding the gift that&rsqu… Sat 20th Dec 2008
It's a Guarantee Since October 2007, the Gifts of Hope program has provided a… Thu 18th Dec 2008
No Longer the Same There was no panic, no screaming. We just watched while my d… Mon 15th Dec 2008
Infant Holy It all began with a tiny infant. Not just any child. This wa… Thu 11th Dec 2008
Ethical Shopping Any article on ethical shopping has to say at the outset tha… Tue 9th Dec 2008
All I Want for Christmas In this Salvationist.ca series, Captain Amy Reardon, Editor … Fri 5th Dec 2008
Stories from the Kettle I’ve been working on Salvation Army Christmas kettles … Tue 2nd Dec 2008
Oberammergau Passion Play 2010 As the leaders of The Salvation Army in Canada and Bermuda, … Mon 1st Dec 2008
Enhanced Community Very few offenders serve life sentences. This means that man… Fri 28th Nov 2008
Alternative Measures The Salvation Army seeks the restoration of people, not the … Tue 25th Nov 2008
Reality Check Prostitution has been called the world’s oldest profes… Fri 21st Nov 2008