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-05-01 and 2007-05-31

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

Found 27 Pages: showing 1 to 25
< 1 2 >
Title Summary Date
Professional Counselling Assis… Goals That Salvation Army Officer families provide an emot… Thu 31st May 2007
Finance Department E-Bulletin Finance Department E-Bulletin... Welcome to the information… Mon 14th May 2007
Annotated Bibliography Thu 10th May 2007
Building Spiritual Community Thu 10th May 2007
Care For Close Relationships Thu 10th May 2007
Counseling: When to Refer Thu 10th May 2007
Family & Parenting Thu 10th May 2007
Holiday Ideas & Options Thu 10th May 2007
Links Thu 10th May 2007
Managing Transitions & Change Thu 10th May 2007
Pastoral Ministry Resources Thu 10th May 2007
Personal Development Thu 10th May 2007
Self Care Resources Thu 10th May 2007
Supervision/Consulting Thu 10th May 2007
Testimonials Thu 10th May 2007
Transformation Leadership Thu 10th May 2007
Booth College Mon 7th May 2007
Celebration OneTwoFive Mon 7th May 2007
Holy Land Tour Mon 7th May 2007
Ignite Mon 7th May 2007
Kootenay Valley Community Chur… Mon 7th May 2007
Nelson Community Church Mon 7th May 2007
Newfoundland & Labrador Congre… Mon 7th May 2007
Planned Giving Mon 7th May 2007
SAYTUNES SAYCAMPS Mon 7th May 2007

Found 48 Articles: showing 1 to 25
< 1 2 >
Title Summary Date
CSB Anniversary Festival - Bac… Former Staff Bandmasters Unite for CSB Anniversary Festival … Thu 31st May 2007
Local celebrities serve food a… Pembroke, Ont. - A number of local celebrities took turns se… Thu 31st May 2007
Billy Graham Visits the Virgin… As last month's campus shootings at Virginia Tech demonstrat… Wed 30th May 2007
Did You Know? Ron Zima, Public Relations and Major Gift Representative in … Wed 30th May 2007
History Bites May 29- On this day in 1837, Charles W. Fry, the English mus… Tue 29th May 2007
Under The Big Top Promo Video Ladies and gentleman, boys and girls, children of all ages, … Tue 29th May 2007
History Bites May 28 - On this day, 1914, the SS Empress of Ireland, carry… Mon 28th May 2007
Meet the Neighbours! Community partnerships are crucial to small-town ministry. I… Mon 28th May 2007
SA volunteer helps others for … Truro, N.S. - At 24, Sharon Hughes underwent her first of fo… Mon 28th May 2007
"Jump Start" invests… In 2005 The Salvation Army in Cobourg, Ont. joined with Cana… Thu 24th May 2007
Salvation Army Broadcast The next S.A. broadcast is Monday, May 28 from 9 to 11 p.m. … Thu 24th May 2007
A mother-daughter enrolment at… It was a mother & daughter / senior & junior soldier enrolme… Wed 23rd May 2007
A Salvation Army Lenten Digita… Lent 2007 - Reflections A.    Story - In the early … Tue 22nd May 2007
Dedication of new kitchen At last food can be prepared without the interference of bir… Tue 22nd May 2007
New French Ministry in Edmunds… The Maritime Division has expanded its ministry to Edmundsto… Mon 21st May 2007
The Rural Myth Country living is not always idyllic. Across Canada, the Arm… Mon 21st May 2007
Emergency Preparedness Kits The Salvation Army and St. John Ambulance have partnered wit… Fri 18th May 2007
God's Army grows in Newmarket Newmarket - The Salvation Army Northridge Community Church h… Fri 18th May 2007
Being a Salvationist and a Law… IN April last year I set up my own legal practice. I did thi… Thu 17th May 2007
Belleville corps celebrates ne… On May 6, 2007, one soldier and 23 adherents were enrolled a… Thu 17th May 2007
Grand Opening at Rideau Height… Kingston, Ont. - The Salvation Army Rideau Heights Community… Wed 16th May 2007
Refugee Sandwich If you have ever worked with refugees, and been confused by … Tue 15th May 2007
Age of Protection Bill Passes … Bill C-22 (Age of Protection) was passed by the House of Com… Mon 14th May 2007
Letter to the Editor Dear Colonel Moulton, I just read the information you posted… Mon 14th May 2007
Snapshot of Rural Ministry Winds of change are blowing … Small-town churches are … Mon 14th May 2007