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/web77/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/web77/web/index.php line 4
Search Results
Skip to Content
 

Search


 
Find the Army near you

Territorial Photos


Ministry Resources Poll

If you were starting a new children's ministry program, which timeframe would you use?
Choices

Syndication

14 14 1199  RSS | What is this?

Search Results

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

Found 203 Articles: showing 126 to 150
< 1 2 3 4 5 6 7 8 9 >
Title Summary Date
Anti-Trafficking News Updates The Salvation Army United States National Headquarters have … Nov 18, 2009
Christmas CDs for sale at amaz… (Click here to enlarge CD cover photo) For only $1.25 eac… Nov 15, 2009
Christmas Supplies A wide variety of Christmas kettle supplies are  availa… Nov 15, 2009
Help the Gateway expand Dion Oxford, director of The Gateway, just submitted an idea… Nov 12, 2009
November 2009 e-Tips Check out this month's e-Tips: May I Have Some Assistance Pl… Nov 4, 2009
Pioneer Clubs Pioneer Clubs is a unique ministry designed for today’… Oct 28, 2009
Olympic Mission Opportunities Here is a great opportunity for Salvation Army youth to get … Oct 20, 2009
Send The Fire - Relaunches The Salvation Army in Canada & Bermuda Territory’s… Oct 20, 2009
The Youth Have Spoken Read the results of two years' worth of research conducted b… Oct 15, 2009
Acquire the Fire - Hamilton Our focus and heart this year is all about Encountering the … Oct 8, 2009
Think Different Conference Think Different involves speakers and presenters representi… Oct 6, 2009
Raised Up In July of 2010, Salvationist youth from around the world wi… Oct 1, 2009
Resources for Preachers Sermons & Illustrations  … Sep 30, 2009
Women's Ministry Sunday A special Sunday to draw attention to ministry by and for wo… Sep 24, 2009
Let First Steps Enhance Your C… If you thought that First Steps was a new program meant to r… Sep 8, 2009
Pray for the Torch Relay Evang… The Olympic Torch will be traveling from Victoria, British C… Sep 2, 2009
Prayer for Victims of Sex Traf… MORE PRECIOUS THAN SILVER September 25 - 27, 2009 - Weekend… Jul 21, 2009
Grants for Olympic Torch Relay… The Salvation Army Olympics Outreach Program for 2010 is off… Jul 8, 2009
Fenelon Falls Citadel prayer for our on-going ministry in Fenelon in terms of our … Jun 22, 2009
A Bite From The Big Apple, New… This year the theme was A BITE FROM THE BIG APPLE, NEW YORK,… Jun 15, 2009
National Aboriginal Day Sunday June 21st is National Aboriginal Day, a day set aside… Jun 10, 2009
Ministry Opportunity for Any G… The Hospitality Team is seeking donations to prepare Welcome… Jun 8, 2009
World Elder Abuse Awareness Da… Public Call-To-Action - Celebrate the 4th Annual World Elde… Jun 8, 2009
50+ Rally, Antiques Roadshow On May 6, 2009, 145 seniors from across Newfoundland, met at… Jun 3, 2009
Reflections on Discipleship Symposium 2008, Proposition 2: The Salvation Army is intenti… Jun 3, 2009