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 International-News, United-Kingdom

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

Found 32 Articles: showing 1 to 25
< 1 2 >
Title Summary Date
Seeking Justice Together General Shaw Clifton officially dedicated to God the work of… Thu 4th Sep 2008
Salvation Army Officers Appoin… International Headquarters announces that The Salvation Army… Fri 15th Aug 2008
Salvation Army Delegates Gain … The Salvation Army was represented by 45 delegates from 20 t… Thu 14th Aug 2008
The Salvation Army Commences W… The Salvation Army’s International Headquarters in Lo… Thu 22nd Nov 2007
The General Conducts Colonel B… ‘WELCOME in the name of the risen Christ!’ With… Thu 11th Oct 2007
Pakistan Territorial Commander… The following is a news release from International Headquart… Fri 28th Sep 2007
Being a Salvationist and a Law… IN April last year I set up my own legal practice. I did thi… Thu 17th May 2007
UK Territory Leader Inducted a… COMMISSIONER Betty Matear (Territorial President of Women's … Wed 2nd May 2007
Meeting of Enlarged Internatio… THE first meeting of the enlarged International Doctrine Cou… Mon 23rd Apr 2007
Promotion to Glory I am sorry to share with you the news that Sister Mrs. Betty… Tue 3rd Apr 2007
Stories from The Salvation Arm… THE Salvation Army recently finished a project in Pakistan t… Thu 8th Mar 2007
Missing daughter of SA officer… Makarena, daughter of Cpts Mauricio and Erika Urzua in Ecuad… Wed 7th Feb 2007
General Announces Internationa… EFFECTIVE 1 JULY 2007-COMMISSIONER CHRISTINE MACMILLAN, terr… Thu 1st Feb 2007
New Territorial Leaders EFFECTIVE 1 JULY 2007-Commissioners William and Marilyn Fran… Thu 1st Feb 2007
Daughter of SA officers kidnap… We are shocked and saddened by the news that the teenage dau… Mon 29th Jan 2007
Salvation Army is now an offic… Norway, Iceland & The Faeros Territory: Now that The Salvati… Fri 26th Jan 2007
New Website Dedicated to the O… A new website dedicated to the Office of the General is to b… Thu 25th Jan 2007
Episode 220: The Salvation Arm… Human trafficking is a scourge of… Wed 17th Jan 2007
Salvation Army plans change wi… A visit by The Salvation Army’s international leader … Wed 29th Nov 2006
Judgment in The Salvation Army… STRASBOURG, FRANCE -- On Thursday, October 6, The European C… Thu 19th Oct 2006
Sports ministry desk to be est… Following consultation with senior International Headquarter… Fri 13th Oct 2006
International doctrine council The General of The Salvation Army is pleased to announce tha… Wed 27th Sep 2006
Pray for Peace… General … At the height of the Israel-Hezbollah conflict in August, Ge… Fri 22nd Sep 2006
Papua New Guinea 'rascals' are… The Salvation Army continues to bring Christ's message of ho… Mon 18th Sep 2006
Overseas updates Cpts Sheldon and Clare Feener, CO's at Gorseinon Corps in mi… Tue 12th Sep 2006