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 for category SA Blog

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

Found 45 Articles: showing 1 to 25
< 1 2 >
Title Summary Date
A Prayer for My People The seventh World Christian Gathering of Indigenous People h… Tue 3rd Feb 2009
Our Daily Bread When my wife, Rochelle, and I went grocery shopping this wee… Tue 3rd Feb 2009
Being Found The movie August Rush is about a musical prodigy, Evan, who … Wed 21st Jan 2009
The Wolf in Sheep's Clothing Go figure,” my friend commented. “You have a pic… Wed 14th Jan 2009
New Year's Resolution I know it’s trendy these days to make fun of New Year&… Thu 8th Jan 2009
Yad Vashem As I slowly journeyed through the visual and auditory histor… Wed 7th Jan 2009
Missing the Good Life Is it OK to be cynical? I've been batting this one around in… Tue 6th Jan 2009
Gift Giving One evening my four-year-old son was saying his prayers and … Thu 18th Dec 2008
Today is a Gift I watched Kung Fu Panda with my kids last weekend. I love th… Wed 10th Dec 2008
No Room in the Inn Luke 2:7: “And she gave birth to her firstborn, a son.… Fri 5th Dec 2008
Heaven’s Rehearsal A few weeks ago, an event called “Heaven’s Rehea… Tue 2nd Dec 2008
I Believe in Miracles I believe God performs miracles today. Every time I see a ma… Fri 28th Nov 2008
It’s Christmas Time As we approach Christmas, I’ve been reading the ancien… Fri 28th Nov 2008
Remember Jesus Earlier this week I was asked to say a short word during our… Fri 14th Nov 2008
Symphony of Life I recently attended the Winnipeg Symphony Orchestra’s … Tue 11th Nov 2008
A Cultural Shift In 1964 (in the good old days when I was an only child) my p… Wed 5th Nov 2008
Known, Accepted and Loved Every day we live with a great irony: we have an unending de… Tue 4th Nov 2008
What Is Normal? Do you ever pause to wonder what we mean when we say someone… Fri 31st Oct 2008
The Idol of the Market The market, as we know, is an entity that by its very nature… Wed 29th Oct 2008
The UP Escalator The down escalator is faster than the up escalator. That&rsq… Mon 27th Oct 2008
Let's Get Together One of my favourite things about Booth College is the close-… Thu 23rd Oct 2008
The Courage to Obey (Part 2) In Ephesians 2:8 we read: “For it is by grace you have… Wed 22nd Oct 2008
Safe Eyes My oldest son, who is 10, casually shared with my wife and I… Mon 20th Oct 2008
Exile vs. End Times I usually tend to stay away from lengthy debates about wheth… Fri 17th Oct 2008
In My Father’s House I am a mature woman who is relearning what it means to be pa… Thu 16th Oct 2008