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 for tags Booth-College, Celebration-OneTwoFive

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

Found 29 Articles: showing 1 to 25
< 1 2 >
Title Summary Date
The Future Looks Bright The moment of revelation came unexpectedly. It was summer 20… Fri 24th Oct 2008
Let's Get Together One of my favourite things about Booth College is the close-… Thu 23rd Oct 2008
Get Out There! If you think that coming to Booth College means you will be … Thu 9th Oct 2008
Here I Am I’d like to use this blog space as a way to give peopl… Tue 23rd Sep 2008
Booth College Celebrates its 2… The last weekend of April brought to a climax the 2007-2008 … Wed 14th May 2008
Booth College admissions@boothcollege.ca or phone 1.877.942.6684 ext 850 V… Sat 1st Mar 2008
Booth College Graduation 2008 BOOTH COLLEGE invites you to attend the events of GRADUATION… Sat 1st Mar 2008
Recent Graduates Of Booth Coll… Congratulations to recent extended learning students who hav… Mon 22nd Oct 2007
My Covenant was covered in sew… This is more than a catchy title for an article. It is reali… Fri 22nd Jun 2007
Celebration OneTwoFive Salvationists reflect on past, present and future as territo… Wed 20th Jun 2007
Celebration 125 opens with Bra… Celebration 125 began with the triumphant sound of brass, so… Tue 19th Jun 2007
Under The Big Top Promo Video Ladies and gentleman, boys and girls, children of all ages, … Tue 29th May 2007
Letter to the Editor Dear Colonel Moulton, I just read the information you posted… Mon 14th May 2007
A Legacy and a Promise William and Catherine Booth College celebrates 25 years of m… Thu 10th May 2007
International Leaders Visit Ca… On Wednesday, April 25, 2007, a large group of officers and … Wed 9th May 2007
CFOT Congratulates One of Its … Booth College was the scene of much excitement this weekend … Mon 7th May 2007
Booth College at 25: A Legacy … In June 1982, Catherine Booth Bible College (now William and… Tue 24th Apr 2007
“Under the Big Top  Ladies and gentleman, boys and girls, children of all ages, … Mon 26th Mar 2007
Prayers to Celebrate Diversity In 1980, Kool and the Gang released a song called “Cel… Mon 26th Mar 2007
Come On and Celebrate! Join in a birthday bash marking 125 years of Salvation Army … Thu 22nd Mar 2007
New president at Booth College The Board of Trustees of The Salvation Army William and Cath… Mon 19th Mar 2007
Jabulani ministers at Celebrat… “Jabulani” means “Rejoice” in the Af… Fri 16th Mar 2007
Register now for Celebration O… Come to Winnipeg June 15-17, 2007, and celebrate 125 years o… Fri 16th Mar 2007
Booth college graduates may be… At Booth College we are entering the second semester of our … Fri 12th Jan 2007
Celebration OneTwoFive kicks o… Yesterday, Territorial Headquarters kicked off Celebration 1… Fri 5th Jan 2007