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 tag Officer-Appointments

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

Found 20 Articles:
Title Summary Date
Annual Change 2008 See a pdf version here: Annual Change 2008 ANNUAL CHANGE 200… Fri 25th Apr 2008
International Appointments for… Commissioner Barry C Swanson, International Secretary for th… Fri 28th Mar 2008
The Joys of Service How a surprise appointment turned into a welcome opportunity… Tue 19th Feb 2008
Why I Love Being A Corps Offic… One of the great strengths of our movement is the ability of… Tue 29th Jan 2008
International Appointments And… EFFECTIVE 1 MAY 2008 COMMISSIONER LINDA BOND, an officer of … Wed 2nd Jan 2008
Canadian Officer Appointed to … EFFECTIVE 1 FEBRUARY 2008 LT. COLONELS ROBERT AND MARGUERITE… Mon 22nd Oct 2007
Married Female Officer Is Inst… Major Susan van Duinen, the first female married officer to … Wed 19th Sep 2007
Announcement-Officer Appointme… Dear Friends: On behalf of the Territorial Commander, I am p… Thu 5th Apr 2007
Territorial appointment announ… In light of the visit of General Shaw Clifton and Commission… Thu 5th Apr 2007
Announcement from the Office o… March 26, 2007 -  Dear Friends: On behalf of the Territor… Mon 26th Mar 2007
A new officer in Québec On February 8th, cadet Désiré Mounanga was ordained as… Fri 16th Feb 2007
New Territorial Leaders EFFECTIVE 1 JULY 2007-Commissioners William and Marilyn Fran… Thu 1st Feb 2007
Officer appointments: positive… These days, “marching orders” are preceded by di… Mon 4th Dec 2006
Officer Appointments: Who Deci… Congregation members and officers themselves now have greate… Tue 7th Nov 2006
Battling cancer, Salvation Arm… The divisional leader of the Salvation Army in western and c… Thu 21st Sep 2006
The South welcomes Canadian of… On August 26, 2006, in a service of installation, Canadian o… Wed 20th Sep 2006
Announcement from the office o… Re: Appointments and Promotions On behalf of the territoria… Thu 7th Sep 2006
Canadian officers are installe… Reading Central Corps, UK Central South Division - On Sunday… Tue 22nd Aug 2006
Canadian officer's undertake n… Commissioner Trevor Tuck, territorial commander, recently in… Thu 20th Jul 2006
New officers prepare for minis… This month the Canada and Bermuda Territory welcomes 13 new … Fri 23rd Jun 2006