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 251 to 275
< 1 2 … 9 10 11 12 13 … 48 49 >
Title Summary Date
His Land Has Gripped My Heart! Why does my heart yearn to visit the Land of the Book? Woody… Wed 27th Feb 2008
Headquarters to Participate in… To help bring attention to the environmental cause, The Salv… Tue 26th Feb 2008
Commissioner Linda Bond Fri 22nd Feb 2008
National Council on Welfare The National Council of Welfare, which was created in 1969, … Fri 22nd Feb 2008
The Joys of Service How a surprise appointment turned into a welcome opportunity… Tue 19th Feb 2008
Entering Into Covenant “I have chosen you out of the world” - Jesus (Jo… Fri 15th Feb 2008
Hooked On A Feeling Two teenagers offer words of advice on dating, relationships… Mon 11th Feb 2008
The General's Pastoral Letter … February 2008 - From the Office of the General to Salvationi… Mon 11th Feb 2008
Spirit of the West Email: Paula Marshall Sun 10th Feb 2008
Jubilee Brass Takes Part In Ne… Brantford, ON - On Sunday, October 14, 2007, Jubilee Brass o… Fri 8th Feb 2008
Manitoba Morphosis Frigid Manitoba temperatures didn’t hold back sixty f… Fri 8th Feb 2008
Canada’s Parliament Bui… Every day and every hour the bells peal out the message of o… Thu 7th Feb 2008
Calvary Covenant Good Friday and Easter Sunday stand at the zenith of the Chr… Wed 6th Feb 2008
A Deadly Duo Two drunken men in a truck spelled disaster In 1993, a devas… Tue 5th Feb 2008
10 Ways to Support Partners i… Looking for new ideas to spark your creative interest? Tired… Mon 4th Feb 2008
Mission Or Maintenance? IS the corps which I lead, or where I soldier, focused on mi… Thu 31st Jan 2008
MissionFest Toronto MissionFest Toronto 2008 - March 6 to 8 - One weekend   Tue 29th Jan 2008
Why I Love Being A Corps Offic… One of the great strengths of our movement is the ability of… Tue 29th Jan 2008
Dress for Success They say the clothes make the man-or woman! Why do we worry … Mon 28th Jan 2008
Thrift Store Workers Return Va… Orillia - Kudos to Salvation Army Thrift Store staff in Oril… Fri 25th Jan 2008
Divorce: Are We Still Taking S… WHEN I entered the school for officers’ training in 1… Thu 24th Jan 2008
City Shares Money From Parking… Penticton, B.C. - The City of Penticton donated $2,299 to Th… Wed 23rd Jan 2008
Brigitte Kloosterman Tue 22nd Jan 2008
Eric and Rachael Olson Tue 22nd Jan 2008
Life For Old Blue Boxes Toronto - We're not to use our old blue boxes when recycling… Tue 22nd Jan 2008