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 1 to 25
< 1 2 3 >
Title Summary Date
Forgotten Password Forgotten Password
Privacy Policy This website's policy is to respect and protect the privacy …
SalvationArmyEthics.org
Search Results
Sign In If you have forgotten your password, click here.
Signed In Welcome , you are signed in with the following privileges:
Debora Jayne Gowland Memorial … We would like to express our sincere thanks to the families …
Faith and the City Schedule an… Friday, 15 June 2007 “God’s Servant for Your Goo…
Faith and the City Youth Conte… We are thrilled to announce the winner of our Faith & th…
Faith and the City Symposium 16 June 2007, Winnipeg, Manitoba Where do faith and the cit…
Position Statement on Justice … God is the ultimate power and authority in the universe, so …
Abus d'alcool ou d'autres drog… Position de principe sur l’abus d’alcool ou d&rs…
Avortement Position de Principe sur L'Avortment L’Armée d…
Current News January 15, 2007? Over 3000 surveys have been distributed t…
Diversité humaine Position de principe sur la diversité humaine L&rsqu…
Environnement Position de principe sur la responsabilité en mati&eg…
Euthanasie Position de principe sur l’euthanasie, le suicide assi…
Famille Position de principe sur la famille L’Armée du…
Insémination artificielle et … L'INSÉMINATION ARTIFICIELLE ET LA FÉCONDATION …
Jeu Position de principe sur le jeu L’Armée du Sal…
Literature Barrett, R. (1998). Liberating the corporate soul: Building …
Mariage Position de principe sur le mariage L’Armée du…
Observance du dimanche Position de principe sur l’observance du dimanche Pou…
Paix mondiale Position de principe sur la paix dans le monde L’Arm&…
Pauvreté et justice économiq… Position de principe sur la pauvreté et la justice &e…