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 176 to 200
< 1 2 3 4 5 6 7 8 9 >
Title Summary Date
Journeying With Jesus Journey with Jesus as he visits the home of friends, teaches… Mar 2, 2009
Whatever Happened to Corps Cad… Contrary to popular belief, The Salvation Army Canada and Be… Feb 27, 2009
Canadians Going Green CBC News had an intruiging report recently about how Canadia… Feb 26, 2009
Senior's Resource Packets - Wi… Don't miss these great new programs for your Senior's Minist… Feb 24, 2009
Church Planting Personnel The Corps Ministries department is pleased to welcome James … Feb 19, 2009
Journey to the Cross Don't miss this great resource, written by two acclaimed Sal… Feb 12, 2009
Unfolding Grace Unfolding Grace - Promotion Week Material 2009 Women's … Feb 9, 2009
Divisional Youth Justice Leagu… The Ontario Central East Division are helping youth to focus… Feb 6, 2009
Community Care Paws to Help Pet visitation therapy is a great way to reach out to senior… Feb 5, 2009
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
Senior's Resource Kit - Winter… The most recent edition of the Senior's Resource Kit is fill… Dec 25, 2008
Community Care Training in Bar… Community Care training in Barrie included both instruction … Dec 18, 2008
Halifax Citadel Pack Sunshine Halifax Citadel Community Care workers packed 1,133 Sunshine… Dec 10, 2008
Wiarton Community Care Reach O… Wiarton Community Care Ministries reach out to the community… Dec 9, 2008
Coffee On Us! The Corps Ministries department is offering free Tim Horton'… Nov 28, 2008
Christmas All December! Looking for a great way to teach children about Christmas du… Nov 26, 2008
Guitar Music for Christmas Are you looking for guitar music for Christmas? Now you can… Nov 26, 2008