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 2007-06-01 and 2007-06-30

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

Found one Page:
Title Summary Date
Celebration 125 Webcast We will be webcasting the following meetings from Celebratio… Mon 11th Jun 2007

Found 44 Articles: showing 1 to 25
< 1 2 >
Title Summary Date
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
Final Flight My five-year-old son and I were inseparable. Could I learn t… Wed 20th Jun 2007
A Thrift Store Surprise The manager of the Grand Falls-Windsor Thrift Store, NF, got… Tue 19th Jun 2007
Celebration 125 opens with Bra… Celebration 125 began with the triumphant sound of brass, so… Tue 19th Jun 2007
Laughter is God’s gift … I love to laugh. I am drawn to laughter and to those who lau… Tue 19th Jun 2007
Salvation Army Online Store La… On Friday, June 15, 2007, The Salvation Army Canada & Bermud… Tue 19th Jun 2007
How Much Is Too Much? How to talk to your children about human trafficking ThatÃ¢â… Mon 18th Jun 2007
Caption competition: winners Thank you for the great response to the request to send in c… Fri 15th Jun 2007
Quotes for Dad Fathers are special. Enjoy these quotes that remind dads of … Fri 15th Jun 2007
SA Emergency Disaster Vehicle … Nanaimo - For the past few days, people forced from their ho… Fri 15th Jun 2007