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 2008-09-01 and 2008-09-30

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

Found 6 Pages:
Title Summary Date
Heartbeat Podcast Episodes Heartbeat is the official news podcast of The Salvation Army… Mon 15th Sep 2008
Darlene's Test The last weekend  Darlene's Test of April brought t… Thu 11th Sep 2008
Margaret's Test Typing my text into the box While in His Hands, for one m… Thu 11th Sep 2008
Christmas with Salvation Army Tue 2nd Sep 2008
Edmonton Temple Band Anniversa… Tue 2nd Sep 2008
Justice/Ethics For more information about social justice and ethics, please… Tue 2nd Sep 2008

Found 30 Articles: showing 1 to 25
< 1 2 >
Title Summary Date
A New Heaven and a New Earth Oprah Winfrey recently co-hosted a 10-week spirituality clas… Tue 30th Sep 2008
Help in the Heart of Quebec Ci… Luc arrived at the Hôtellerie without a penny in his p… Mon 29th Sep 2008
Meet My Car Franky! “Culture resides in our minds, in the stories we tell … Mon 29th Sep 2008
Out of Our Comfort Zone A few months ago I went to a farmers’ workshop in a ru… Fri 26th Sep 2008
Defining Neighbour Look at those autumn leaves. What a beautiful time of the ye… Thu 25th Sep 2008
Dudley Coles' Leap of Faith It took Dudley Coles 10 years to plan and write Leap of Fait… Wed 24th Sep 2008
Release the Captives “Over the last 10 years, the numbers of women and chil… Wed 24th Sep 2008
The Church and the Golden Arch… With the exception of Antarctica, you can have a Big Mac on … Wed 24th Sep 2008
Here I Am I’d like to use this blog space as a way to give peopl… Tue 23rd Sep 2008
God is in Control On the night before his execution, Peter slept like a baby. … Mon 22nd Sep 2008
Prayer Warriors Begin Their Jo… Salvationists in Winnipeg were buzzing with energy and excit… Fri 19th Sep 2008
Unity in Mission As the new corps officers of High Point Community Church, my… Fri 19th Sep 2008
Salvation Army Night with the … For a number of years, Blue Jays President and CEO Paul Godf… Thu 18th Sep 2008
The Army's Got Talent It’s evening. I’m at Camp Sunrise in Gibson, B.C… Thu 18th Sep 2008
Who Will Lead Us? Fear is a real emotion. Last week I watched my youngest daug… Thu 18th Sep 2008
Dion’s Open Book As someone who has spent the past 18 years of my life workin… Wed 17th Sep 2008
I Have a Question I have a question that doesn’t require an answer. It&r… Tue 16th Sep 2008
There's No Life Like It I didn’t grow up dreaming about being a Salvation Army… Tue 16th Sep 2008
Fighting Human Trafficking on … The Newfoundland and Labrador Human Trafficking Committ… Mon 15th Sep 2008
Hand Cutting Should I cut off my hand or leave it alone? This is the ques… Mon 15th Sep 2008
New Website Features Salvationist.ca has added two new features to the website. O… Mon 15th Sep 2008
Brewing Justice General Shaw Clifton has said that the quest for social just… Sat 13th Sep 2008
Election Primer Canadians are in the midst of the third federal election in … Thu 11th Sep 2008
Total Praise After a particularly wet summer, the warm sunshine of southe… Wed 10th Sep 2008
Would Jesus Have Voted? As a matter of history, we know that Jesus of Nazareth didn&… Mon 8th Sep 2008

Found 3 Podcasts:
Title Summary Date
Heartbeat: Episode #3 Episode #3: Federal Election 2008 with Major Grant… Fri 26th Sep 2008
Heartbeat: Episode #2 Episode #2: Young Adult Retention Project with Jam… Fri 19th Sep 2008
Heartbeat: Episode #1 Episode #1: Human Sexual Trafficking with Dianna Bussey… Fri 12th Sep 2008