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 176 to 200
< 1 2 … 6 7 8 9 10 … 48 49 >
Title Summary Date
God’s Fellow Workers Co… “For the past two years, God has been shaping your hea… Tue 24th Jun 2008
Domestic Abuse and the Way Out At Kate Booth House, one woman learns to feel beautiful agai… Mon 23rd Jun 2008
Recapturing the Wonder Newfoundland West Women’s Camp Four hundred women m… Thu 19th Jun 2008
Making Red Deer 'Green' Corps members help clean up Red Deer’s parks An ent… Wed 18th Jun 2008
A Career in Music Music and The Salvation Army have been the central pillars o… Mon 16th Jun 2008
General's Pastoral Letters Num… June 2008 - From the Office of the General to Salvation… Mon 16th Jun 2008
A Willing Heart Ministry should be a joy, not a burden I don’t know a… Mon 9th Jun 2008
Smithers Salvation Army Center… Renovations of the Salvation Army thrift store, community an… Tue 3rd Jun 2008
Let's Talk About Sex As a parent, how do you counsel kids to abstain? Is “s… Mon 2nd Jun 2008
2008 Soldier and Adherent Enro… Charlottetown, PEI (L-R) Nancy Wood - New Adherent, Jane … Fri 30th May 2008
Embracing Diversity Organizers were thrilled with the response to the Together c… Fri 30th May 2008
Prayer Request from Zimbabwe The Territorial Commander requests special prayer for Zimbab… Fri 30th May 2008
Empress of Ireland Remembered On Sunday, May 25, Salvationists and friends gathered under … Thu 29th May 2008
Service Opportunities for Salv… The following are the latest service opportunities list prov… Thu 29th May 2008
Hope for the Homeless in Halto… From left, Carol Willems-Payne, family shelter co-rdinator; … Wed 28th May 2008
Ministering in Myanmar The Salvation Army provides aid to cyclone victims in Myanma… Wed 28th May 2008
Summer Outreach Have you forgotten to order your copies of the summer evange… Tue 27th May 2008
St. Catherines Booth Centre Ce… Vi Callahan Residence Manager celebrating completion of 22 t… Mon 26th May 2008
The Christian Community Develo… The Christian Community Development Association (www.ccda.or… Mon 26th May 2008
Volunteer Appreciation - Penti… This year's theme is a fitting one for the over 150 voluntee… Mon 26th May 2008
Rural Ministry Symposium 2008 Sponsored by Queen's Theological College October 27-29th, 20… Thu 22nd May 2008
VisionTV - The Naked Archaeolo… As mentioned previously, this documentary series follows Can… Thu 22nd May 2008
Five New Auxiliary Captains   Major Jean Moulton visited CFOT this week and had … Tue 20th May 2008
Myanmar/China Prayer Request At such a time as this, our Canadian leaders are calling on … Tue 20th May 2008
Weakened Arms Held High As members of our local congregation, it is our responsibili… Mon 19th May 2008