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/web75/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/web75/web/index.php line 4
Search Results
Skip to Content
Enlarge TextClick to print16 16 2611 Sign In

Search Results

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

Found 64 Pages: showing 26 to 50
< 1 2 3 >
Title Summary Date
Peine Capitale Position de Principe sur la Peine Capitale Du fait qu'elle …
Pilot project The initial survey was delivered to two pilot sites in June …
Pornographie Position de principe sur la pornographie L'Armée du …
Project Rationale In its origin, The Salvation Army was known for soup, soap a…
Timeline Task/Timeline Meeting with territorial social services leade…
- Core values of The Salvation… Click on the link below to view a PDF document of the core v…
Position Statement on Abortion The Salvation Army believes in the sanctity of human life be…
Position Statement on Capital … Because Salvationists believe in the sanctity of all human l…
Position Statement on Euthanas… Human life is a sacred gift from God. The Salvation Army bel…
Position Statement on Family The Salvation Army believes the family, as the basic communi…
Position Statement on Gambling The Salvation Army takes a stand against gambling that invol…
Position Statement on Gay & Le… The Salvation Army upholds the dignity of all persons. For t…
Position Statement on Human Di… The Salvation Army believes that all people are made in the …
Position Statement on Marriage The Salvation Army believes marriage is the covenanting toge…
Position Statement on Pornogra… The Salvation Army believes that all persons are created in …
Position Statement on Reproduc… Current advances in research are opening doors to possibilit…
Position Statement on Responsi… As people made in the image of God (Genesis 1:27), we have b…
Position Statement on Substanc… The Salvation Army encourages a healthy spiritual, emotional…
Position Statement on the Sabb… Salvationists desire to worship God at all times and in all …
Position Statement on World Pe… The Salvation Army believes that the plan for creation is th…
Affiliations American Philosophical Association Association o…
Bibliographies Christian Ethics Clergy Ethics
Codes of Ethics Salvation Army The Salvation Army in Canada & Bermuda h…
Contact & Location Where Are We Located? Booth College 447 Webb Place Winnip…
Events/Bookings FAITH? IN THE CITY A Salvation Army Ethics Centre Symposium …