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 576 to 600
< 1 2 … 22 23 24 25 26 … 48 49 >
Title Summary Date
History Bites June 1 - On this day in 1884, two years after The Salvation … Fri 1st Jun 2007
Spiritual Direction: What is i… Spiritual Direction is the process of accompanying people on… Fri 1st Jun 2007
The Salvation Army Ladore Conf… Upcoming special events held at the Ladore Conference Centre… Fri 1st Jun 2007
CSB Anniversary Festival - Bac… Former Staff Bandmasters Unite for CSB Anniversary Festival … Thu 31st May 2007
Local celebrities serve food a… Pembroke, Ont. - A number of local celebrities took turns se… Thu 31st May 2007
Billy Graham Visits the Virgin… As last month's campus shootings at Virginia Tech demonstrat… Wed 30th May 2007
Did You Know? Ron Zima, Public Relations and Major Gift Representative in … Wed 30th May 2007
History Bites May 29- On this day in 1837, Charles W. Fry, the English mus… Tue 29th May 2007
Under The Big Top Promo Video Ladies and gentleman, boys and girls, children of all ages, … Tue 29th May 2007
History Bites May 28 - On this day, 1914, the SS Empress of Ireland, carry… Mon 28th May 2007
Meet the Neighbours! Community partnerships are crucial to small-town ministry. I… Mon 28th May 2007
SA volunteer helps others for … Truro, N.S. - At 24, Sharon Hughes underwent her first of fo… Mon 28th May 2007
"Jump Start" invests… In 2005 The Salvation Army in Cobourg, Ont. joined with Cana… Thu 24th May 2007
Salvation Army Broadcast The next S.A. broadcast is Monday, May 28 from 9 to 11 p.m. … Thu 24th May 2007
A mother-daughter enrolment at… It was a mother & daughter / senior & junior soldier enrolme… Wed 23rd May 2007
A Salvation Army Lenten Digita… Lent 2007 - Reflections A.    Story - In the early … Tue 22nd May 2007
Dedication of new kitchen At last food can be prepared without the interference of bir… Tue 22nd May 2007
New French Ministry in Edmunds… The Maritime Division has expanded its ministry to Edmundsto… Mon 21st May 2007
The Rural Myth Country living is not always idyllic. Across Canada, the Arm… Mon 21st May 2007
Emergency Preparedness Kits The Salvation Army and St. John Ambulance have partnered wit… Fri 18th May 2007
God's Army grows in Newmarket Newmarket - The Salvation Army Northridge Community Church h… Fri 18th May 2007
Being a Salvationist and a Law… IN April last year I set up my own legal practice. I did thi… Thu 17th May 2007
Belleville corps celebrates ne… On May 6, 2007, one soldier and 23 adherents were enrolled a… Thu 17th May 2007
Grand Opening at Rideau Height… Kingston, Ont. - The Salvation Army Rideau Heights Community… Wed 16th May 2007
Refugee Sandwich If you have ever worked with refugees, and been confused by … Tue 15th May 2007