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 between 2008-11-01 and 2008-11-30

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

Found 2 Pages:
Title Summary Date
October 2008 Tue 4th Nov 2008
September 2008 Tue 4th Nov 2008

Found 22 Articles:
Title Summary Date
Enhanced Community Very few offenders serve life sentences. This means that man… Fri 28th Nov 2008
I Believe in Miracles I believe God performs miracles today. Every time I see a ma… Fri 28th Nov 2008
It’s Christmas Time As we approach Christmas, I’ve been reading the ancien… Fri 28th Nov 2008
Lt-Colonels Copple Promoted to… Lt-Colonels Donald and Ann Copple, Chief Secretary and Terri… 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
OK Kids I wish there had been something like the OK Kids support gro… Wed 19th Nov 2008
Cadet Winter Assignments 2008 Cadets are on the move again. CFOT, working in consultation … Tue 18th Nov 2008
Persecuted, Not Abandoned Captain Elizabeth Nelson is a Canadian Salvationist living i… Fri 14th Nov 2008
Photo Caption Contest #2 In the comments section below, tell us what you think the ca… Fri 14th Nov 2008
Remember Jesus Earlier this week I was asked to say a short word during our… Fri 14th Nov 2008
In His Blood Recently assigned to the United Nations Mission in Sudan, Ca… Wed 12th Nov 2008
Symphony of Life I recently attended the Winnipeg Symphony Orchestra’s … Tue 11th Nov 2008
It is Finished I didn’t grow up during the Great Wars of the last cen… Mon 10th Nov 2008
Speak No Evil? In this Salvationist.ca series, Captain Amy Reardon, Editor … Fri 7th Nov 2008
With Christ at the Centre Hamilton, Ont., is located at the centre of the Golden Horse… Fri 7th Nov 2008
Spiritual Life at Booth As you probably already know, Booth College is a Christian i… Thu 6th Nov 2008
A Cultural Shift In 1964 (in the good old days when I was an only child) my p… Wed 5th Nov 2008
Known, Accepted and Loved Every day we live with a great irony: we have an unending de… Tue 4th Nov 2008
The Five Territorial Propositi… The first video is footage of Dr. Jeremy Mills, Symposium 20… Tue 4th Nov 2008
Symposium 2008 Ends With Prais… On Sunday morning, there was a spirit of optimism and unity … Mon 3rd Nov 2008
Dreaming Big at Symposium 2008 Friday was a busy day for Symposium 2008 delegates. Man… Sat 1st Nov 2008