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 51 to 75
< 1 2 3 4 5 6 … 44 45 46 47 48 49 >
Title Summary Date
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
Symposium 2008 Is Underway On Thursday, October 30, over 140 delegates convened at Jack… Fri 31st Oct 2008
Symposium 2008 Opening Service… Commissioner William W. Francis, Territorial Commander, spea… Fri 31st Oct 2008
Symposium 2008 Video Blog #1 Visit Salvationist.ca/symposium for more updates. Fri 31st Oct 2008
Symposium October 31 Preparati… Jeremy Mills offers an update for October 31. Salvationists … Fri 31st Oct 2008
What Is Normal? Do you ever pause to wonder what we mean when we say someone… Fri 31st Oct 2008
Moving Forward, Together Symposium 2008 provides Salvationists an opportunity to seek… Thu 30th Oct 2008
The Idol of the Market The market, as we know, is an entity that by its very nature… Wed 29th Oct 2008
Welcoming the World In this Salvationist.ca series entitled Talking It Over, Cap… Tue 28th Oct 2008
The UP Escalator The down escalator is faster than the up escalator. That&rsq… Mon 27th Oct 2008
A Congress of Thanksgiving Uniforms were everywhere! From the Toronto lakefront to the … Sun 26th Oct 2008