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 Announcement, Internet

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

Found 24 Articles:
Title Summary Date
Safe Eyes My oldest son, who is 10, casually shared with my wife and I… Mon 20th Oct 2008
SARoots.ca In recent years hundreds of Salvationists from across the te… Tue 8th Jan 2008
Announcement From The Office O… Lt-Colonels Donald and Ann Copple, currently serving as divi… Mon 3rd Dec 2007
Salvation Army Christmas Cards Etobicoke, Ont. - The Salvation Army Lakeshore Community Chu… Thu 8th Nov 2007
Tyndale Seminary Has New Chair Toronto - Dr. Howard Snyder will be installed to The Donald … Mon 15th Oct 2007
Leading Mission Divisional Str… From the office of the chief secretary: I am writing on beha… Fri 12th Oct 2007
Personnel Services Announcemen… IHQ has given approval for  personnel services to institu… Fri 7th Sep 2007
New Cabinet Appointments Commissioner William W. Francis, territorial commander, has … Fri 24th Aug 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
Announcement from the Chief Se… March 23, 2007 - Dear Friends: On behalf of the territorial… Fri 23rd Mar 2007
New president at Booth College The Board of Trustees of The Salvation Army William and Cath… Mon 19th Mar 2007
French national website launch… I am pleased to announce that we have launched the French Na… Thu 1st Feb 2007
General to connect electronica… MARCH 2007 will see the General initiating a huge step forwa… Thu 1st Feb 2007
Officer annual change dates For your information and planning, kindly note the following… Thu 1st Feb 2007
New Website Dedicated to the O… A new website dedicated to the Office of the General is to b… Thu 25th Jan 2007
God behind new online initiati… The Anglican Church in Australia has fully embraced the far-… Thu 21st Dec 2006
Canada's Christian Channel wel… TORONTO, Dec 18, 2006 - The Christian Channel is adding musi… Tue 19th Dec 2006
Announcement from the office o… November 21, 2006 - On behalf of the Territorial Commander, … Tue 21st Nov 2006
New Canadian website brings Bi… Thanks to a new interactive website called BibleKids.ca, chi… Mon 30th Oct 2006
International doctrine council The General of The Salvation Army is pleased to announce tha… Wed 27th Sep 2006
Lying Online Everything is at your fingertips on the Net, and increasing … Fri 15th Sep 2006
Announcement from the office o… Re: Appointments and Promotions On behalf of the territoria… Thu 7th Sep 2006
PRAYERS FOR THE NATIONS: An ap… Our hearts fill with anguish and grief on hearing the news r… Sat 5th Aug 2006