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 1 to 25
< 1 2 3 4 5 6 7 8 9 10 >
Title Summary Date
Poll Mon 8th Jun 2009
December 2008 Fri 30th Jan 2009
January 2009 Fri 30th Jan 2009
November 2008 Fri 30th Jan 2009
Partners in Mission Here you will find all promotional material from the Resourc… Fri 16th Jan 2009
October 2008 Tue 4th Nov 2008
September 2008 Tue 4th Nov 2008
Symposium 2008 Symposium 2008 provides Salvationists an opportunity to seek… Thu 30th Oct 2008
Abus d'alcool ou d'autres drog… Position de principe sur l’abus d’alcool ou d&rs… Tue 28th Oct 2008
Position Statement on Abortion The Salvation Army believes in the sanctity of human life be… Tue 28th Oct 2008
Position Statement on Capital … Because Salvationists believe in the sanctity of all human l… Tue 28th Oct 2008
Position Statement on Euthanas… Human life is a sacred gift from God. The Salvation Army bel… Tue 28th Oct 2008
Position Statement on Family The Salvation Army believes the family, as the basic communi… Tue 28th Oct 2008
Position Statement on Gambling The Salvation Army takes a stand against gambling that invol… Tue 28th Oct 2008
Position Statement on Gay & Le… The Salvation Army upholds the dignity of all persons. For t… Tue 28th Oct 2008
Position Statement on Human Di… The Salvation Army believes that all people are made in the … Tue 28th Oct 2008
Position Statement on Justice … God is the ultimate power and authority in the universe, so … Tue 28th Oct 2008
Position Statement on Marriage The Salvation Army believes marriage is the covenanting toge… Tue 28th Oct 2008
Position Statement on Pornogra… The Salvation Army believes that all persons are created in … Tue 28th Oct 2008
Position Statement on Reproduc… Current advances in research are opening doors to possibilit… Tue 28th Oct 2008
Position Statement on Responsi… As people made in the image of God (Genesis 1:27), we have b… Tue 28th Oct 2008
Position Statement on Substanc… The Salvation Army encourages a healthy spiritual, emotional… Tue 28th Oct 2008
Position Statement on the Sabb… Salvationists desire to worship God at all times and in all … Tue 28th Oct 2008
Position Statement on World Pe… The Salvation Army believes that the plan for creation is th… Tue 28th Oct 2008
Position Statements (English) Abortion Capital Punishment Environment Euthanasia Famil… Tue 28th Oct 2008