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 tags Education, Hot-Topics

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

Found 46 Articles: showing 1 to 25
< 1 2 >
Title Summary Date
The Future Looks Bright The moment of revelation came unexpectedly. It was summer 20… Fri 24th Oct 2008
Would Jesus Have Voted? As a matter of history, we know that Jesus of Nazareth didn&… Mon 8th Sep 2008
Captain Dr. Paul Thistle Recei… Photo copyright 2008 Doug MacLellan On Wednesday, June 11… Fri 4th Jul 2008
Booth College admissions@boothcollege.ca or phone 1.877.942.6684 ext 850 V… Sat 1st Mar 2008
Divorce: Are We Still Taking S… WHEN I entered the school for officers’ training in 1… Thu 24th Jan 2008
Hungry for God Why more and more Christians are fasting for revival Before … Mon 21st Jan 2008
God Sent Me A Balloon My name is Scotty and I live near Newton, Illinois. I am a C… Fri 18th Jan 2008
Old Sweater Sacred Cow Choosing Kingdom values over sentimentality. We all have an … Mon 5th Nov 2007
The Greening Of The Army A new report shows that The Salvation Army has a long way to… Mon 29th Oct 2007
Built To Last? Over the last century, rapid change in technology has seen t… Tue 23rd Oct 2007
Recent Graduates Of Booth Coll… Congratulations to recent extended learning students who hav… Mon 22nd Oct 2007
Good Without God, But Better W… Canadians who believe in God are more likely than non-believ… Fri 19th Oct 2007
Tyndale Seminary Has New Chair Toronto - Dr. Howard Snyder will be installed to The Donald … Mon 15th Oct 2007
Confronting The Elephant In Th… National Porn Sunday encourages congregations to take a clos… Mon 1st Oct 2007
Dealing with Personal Burnout Whose heart has not been thrilled by Elijah’s exploit… Thu 27th Sep 2007
First Daughter Jenna Bush Sits… In her first television interview, Jenna Bush speaks candidl… Mon 24th Sep 2007
What Did Jesus Say About Money… When I was a child, I attended a Good News Club at my school… Mon 24th Sep 2007
Workers' Rites What happens when an employee's freedom of religion crosses … Fri 14th Sep 2007
Salvation Army calls for praye… The Salvation Army has designated Sept. 28-30, 2007, as a we… Wed 12th Sep 2007
Atheists Remain a Small Minori… Vast Majority of People Believe, Identify, Attend Services. … Thu 23rd Aug 2007
The Ongoing Popularity of Marr… Marriage continues to be highly valued by most Canadians. So… Tue 14th Aug 2007
Get Anger under Control with a… Learning to control anger is a crucial life lesson - one tha… Thu 26th Jul 2007
Tips For Christians Who Want T… Canadian Members of Parliament receive thousands of messages… Thu 19th Jul 2007
SAROOTS The SAROOTS weekend is fast approaching and will be held on … Thu 14th Jun 2007
Age of Protection Bill Passes … Bill C-22 (Age of Protection) was passed by the House of Com… Mon 14th May 2007