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 229 Pages: showing 126 to 150
< 1 2 3 4 5 6 7 8 9 10 >
Title Summary Date
Contact Tue 27th Mar 2007
Mission & Vision Statement Mission Statement The Mission of the Pastoral Services Offi… Tue 27th Mar 2007
Officer Care Program Please be assured that the confidentiality of your approach … Tue 27th Mar 2007
Pastoral Services: About Us Tue 27th Mar 2007
Spiritual Formation (Pilot Stu… Tue 27th Mar 2007
Spiritual Formation Groups Tue 27th Mar 2007
Who We Are Content is being developed and will be posted soon. Thanks f… Tue 27th Mar 2007
125 special guests Jabulani: “Jabulani” means … Thu 22nd Mar 2007
Accommodations The following are accomodation suggestions: You can also rec… Wed 21st Mar 2007
Celebration 125 Registration Here's the registration information page. Wed 21st Mar 2007
Event schedule Come and celebrate 125 years of God's work in and through Th… Wed 21st Mar 2007
Time & Talents Various Resourc… larger image Pursuing Spiritual Transformation Series G… Fri 16th Feb 2007
Agincourt Community Church Fri 8th Dec 2006
Booth College 25th Anniversary… Fri 8th Dec 2006
Camp Rainbow Fri 8th Dec 2006
Winterberry Heights Church Fri 8th Dec 2006
Album Click a pictures to see a larger version. CSB Concer… Tue 28th Nov 2006
Homosexualité Position de principe sur la sexualité des gais … Mon 13th Nov 2006
- Current News Current News On Monday, 15 January 2007, a random sampling… Fri 10th Nov 2006
- Literature Literature Barrett, R. (1998). Liberating the corporate so… Fri 10th Nov 2006
- Pilot project Pilot project The initial survey was delivered to two pilot… Fri 10th Nov 2006
- Project Rationale Project rationale In its origin, The Salvation Army was kno… Fri 10th Nov 2006
- Timeline Timeline   Task Timeframe Meeting wit… Fri 10th Nov 2006
Position Statement on Poverty … The measure of any society is how well it cares for its weak… Fri 10th Nov 2006
Values at Work Fri 10th Nov 2006