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 between 2009-01-01 and 2009-01-31

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

Found 16 Pages:
Title Summary Date
Spiritual Formation Welcome to the new Spiritual Formation area of our website.&… Jan 30, 2009
Chemically Speaking - Careforc… Chemically Speaking is a single session video suitable for p… Jan 29, 2009
Door of Hope - Careforce Lifek… An encouraging and supportive program for women survivors of… Jan 29, 2009
Healthy Lifestyle - Careforce … Healthy Lifestyle is for women of any age who are seeking to… Jan 29, 2009
Kids With Courage - Careforce … Kids with Courage is a seven session program that aims to st… Jan 29, 2009
Making Marriage Better - Caref… This program is an opportunity to enhance or rebuild your ma… Jan 29, 2009
Man to Man - Careforce Lifekey… Men are designed for action, excitement and success, yet oft… Jan 29, 2009
New Beginnings - Careforce Lif… New Beginnings is a program assisting individuals struggling… Jan 29, 2009
Search for Intimacy - Careforc… Sex is part of life.  Managed rightly it is a profound … Jan 29, 2009
Search for Life - Careforce Li… People need to feel valued, accepted and have a sense of bel… Jan 29, 2009
Valiant Man - Careforce Lifeke… Developing and maintaining a healthy sexuality is every man'… Jan 29, 2009
Woman to Woman - Careforce Lif… Will show participants how to free themselves from the past … Jan 29, 2009
Youth Search For Life - Carefo… 'What do I have to do to be loved, accepted and valued aroun… Jan 29, 2009
Focus Ministries From time to time there are different types of focus ministr… Jan 12, 2009
Contact Corps Ministries Depar… To send mail, click on a name below.  For details about… Jan 9, 2009
Events Jan 5, 2009

Found 9 Articles:
Title Summary Date
Careforce Lifekeys Resources This program was developed for small groups with trained lea… Jan 30, 2009
Sacred Rhythms For the most part, people today do very well with staying bu… Jan 28, 2009
CCM Worker Appreciation In St. George's, Bermuda, the Community Care Sunday was enha… Jan 26, 2009
Proclaiming Kingdom Culture Lt-Colonels Raphael and Winsome Mason were appointed to the … Jan 26, 2009
Effective Prayer and Bible Rea… Not Just A Children's Song... Prayer: A great and interes… Jan 22, 2009
Get Engaged in Stamping Out Wo… www.freerice.com The UN World Food Program (WFP) has create… Jan 14, 2009
Ministry Outside Our Walls Every year the Corps Ministries department from THQ make a s… Jan 14, 2009
A Year of Reaching Out NEWFOUNDLAND & LABRADOR EAST DIVISION - providing meal… Jan 7, 2009
Red Deer Reach Out to Seniors As new relationships are built with others in the community,… Jan 6, 2009