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 526 to 550
< 1 2 … 20 21 22 23 24 … 48 49 >
Title Summary Date
Welcome and Installation of Ne… Jackson's Point Divisional Camp - The installation of Commis… Tue 10th Jul 2007
Faith and Film Studios are recognizing the value of faith-based entertainme… Mon 9th Jul 2007
Bible Resource Centre The American Bible Society (www.bibles.com) is proud to anno… Thu 5th Jul 2007
Instruments Needed Majors Woody and Sharon Hale were recent guests for officers… Thu 5th Jul 2007
God's Army Grows P.E.I. - Charlottetown Community Church recently welcomed it… Wed 4th Jul 2007
Environmental Analysis Project As people made in the image of God (Genesis 1:27), we have b… Tue 3rd Jul 2007
Salvation Army Anniversary Sta… The Honorable Roger Simmons, PC and member of The Salvation … Tue 3rd Jul 2007
Highlights from Bells Corners Ottawa - Bells Corners Community church shares their latest … Mon 2nd Jul 2007
Marching Forward Commissioners William and Marilyn Francis Territorial Comman… Mon 2nd Jul 2007
Annual Change 2007 The following is information regarding the annual officer ap… Fri 29th Jun 2007
BC Mayor Visits Divisional Hea… The Government Relations portfolio continues to be a priorit… Fri 29th Jun 2007
New Thrift Store To Open In Ke… Kelowna, B.C. - The Salvation Army will open a thrift store … Fri 29th Jun 2007
Newfoundland and Labrador Cong… Covenant renewals, fresh commitments to Christ and transform… Fri 29th Jun 2007
Thrift Stores Are Running A Re… B.C.- Twenty-one Salvation Army thrift stores in the Lower M… Fri 29th Jun 2007
Ontario East Sets A Divisional… Congratulations to the Ontario East Division as they set a r… Thu 28th Jun 2007
International Social Justice C… Majors Bill & Winn Blackman, divisional leaders, BC Division… Wed 27th Jun 2007
Music Ministry Travels To Assi… Vancouver - In May, 2007, Cariboo Hill Temple songsters trav… Tue 26th Jun 2007
Bright Lights, Big City On January 9-12, Salvationists met at The Salvation Armyâ₅ Mon 25th Jun 2007
Exploring The Simple Way Shane Claiborne urges us to stop being the church we complai… Mon 25th Jun 2007
My Covenant was covered in sew… This is more than a catchy title for an article. It is reali… Fri 22nd Jun 2007
God's Army Grows Islandview Citadel, Musgravetown, NLE - Congratulations to 1… Thu 21st Jun 2007
Stop Smoking Support Group Orillia - The Salvation Army's 10-week Stop Smoking Support … Thu 21st Jun 2007
Cafe and Worship at Grand Fall… Grand Falls Citadel, NF, has adopted, on a monthly basis, a … Wed 20th Jun 2007
Celebration OneTwoFive Salvationists reflect on past, present and future as territo… Wed 20th Jun 2007
Company makes $20,000 donation… BMC Software Inc. donated $20,000 to the Salvation Army in B… Wed 20th Jun 2007