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 126 to 150
< 1 2 … 4 5 6 7 8 … 48 49 >
Title Summary Date
Hand Cutting Should I cut off my hand or leave it alone? This is the ques… Mon 15th Sep 2008
New Website Features Salvationist.ca has added two new features to the website. O… Mon 15th Sep 2008
Brewing Justice General Shaw Clifton has said that the quest for social just… Sat 13th Sep 2008
Election Primer Canadians are in the midst of the third federal election in … Thu 11th Sep 2008
Total Praise After a particularly wet summer, the warm sunshine of southe… Wed 10th Sep 2008
Would Jesus Have Voted? As a matter of history, we know that Jesus of Nazareth didn&… Mon 8th Sep 2008
Far and Wide Bike Trek Matthew Bursey cycled across the continent to increase aware… Fri 5th Sep 2008
Seeking Justice Together General Shaw Clifton officially dedicated to God the work of… Thu 4th Sep 2008
Celebrating Service in Quebec The Salvation Army in Quebec recently held a retirement cele… Wed 3rd Sep 2008
Offering a Hand Up Life doesn’t often turn out how we expect it to. This … Wed 3rd Sep 2008
Cry Freedom In February 2007, General Shaw Clifton announced the establi… Mon 1st Sep 2008
Considering Officership Salvation Army officership is something that almost every Sa… Fri 29th Aug 2008
Interacting with Current Cultu… In November 2005, more than 150 Salvationists from across Ca… Tue 26th Aug 2008
Mobilize 2008 Prepares for Eme… More than 200 delegates from across Canada met in Calgary to… Fri 22nd Aug 2008
Salvation Army Identity In November 2005, more than 150 Salvationists from across Ca… Fri 22nd Aug 2008
Olympic Fever Hits Belleville Right across the country, Canadians are following their Olym… Thu 21st Aug 2008
Salvation Warm Salvationist greetings from London! The theme of thi… Wed 20th Aug 2008
Newfoundland and Labrador Prov… Despite the cold, wet weather, the spirits and expectations … Tue 19th Aug 2008
Wake the Sleeping Giant Youth and children’s ministry in Quebec is like a slee… Mon 18th Aug 2008
It Starts With One I was commissioned as a Salvation Army officer on Sunday, Ju… Fri 15th Aug 2008
Salvation Army Officers Appoin… International Headquarters announces that The Salvation Army… Fri 15th Aug 2008
No Action Without Reflection "Salvationists pride themselves on being ‘doers o… Thu 14th Aug 2008
Salvation Army Delegates Gain … The Salvation Army was represented by 45 delegates from 20 t… Thu 14th Aug 2008
Serving a Hurting World   The hubbub of kids making arts and crafts, shooting … Wed 13th Aug 2008
Stand By Me Generation Y, also known as the Millennials, are the young p… Mon 11th Aug 2008