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

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

Found 1208 Articles: showing 776 to 800
< 1 2 … 30 31 32 33 34 … 48 49 >
Title Summary Date
Officer annual change dates For your information and planning, kindly note the following… Thu 1st Feb 2007
RCMP takes on corps officer as… Mapleridge, BC - Cpt Ed Chiu is now working alongside the Ri… Thu 1st Feb 2007
Gospel coffee house Truro, NS - The Salvation Army is hosting a gospel coffee ho… Wed 31st Jan 2007
Pastors' & Leaders' conference On Friday, March 2, MissionFest Toronto is launching its fir… Wed 31st Jan 2007
Caption Competition We are looking for your best captions for this vintage Army … Tue 30th Jan 2007
Mister Major: Salvation Army p… It's a Friday morning and Salvation Army Maj. Martin Ketteri… Tue 30th Jan 2007
Toronto councillor has cost-fr… "Don't give them money," says Case Ootes. This would drive d… Tue 30th Jan 2007
Daughter of SA officers kidnap… We are shocked and saddened by the news that the teenage dau… Mon 29th Jan 2007
Making Connections In November 2005, more than 150 officers and lay Salvationis… Mon 29th Jan 2007
Support given to 1.7 million h… Since Hurricane Katrina struck the Gulf Coast on Aug. 29, 20… Mon 29th Jan 2007
They come for a good breakfast… WE'RE almost too late. In the 10 minutes elapsing between th… Mon 29th Jan 2007
Episode 222: The Salvation Arm… Major Joanne Biggs (Ret.), Chapla… Fri 26th Jan 2007
Impressions of Indonesia During the first week of September, 2006, my wife and I were… Fri 26th 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
Where are the Homeless? The following is a recent letter sent to the editor of the P… Thu 25th Jan 2007
God's Army grows in St. John's St. John's Citadel, NF - Pictured from left are: Captain Jul… Wed 24th Jan 2007
MissionFest Toronto 2007 Takes place March 1 to 3 at the Toronto Congress Centre. ΓΆβ… Tue 23rd Jan 2007
The Hand of God in the Heart o… The Salvation Army Gateway is a shelter and drop-in center f… Mon 22nd Jan 2007
Episode 221: The Salvation Arm… Commissioner William Francis is t… Sat 20th Jan 2007
Historical Society The Salvation Army Historical Society (Canada and Bermuda) w… Fri 19th Jan 2007
History The Salvation Army began its work in Canada in 1882, just fi… Fri 19th Jan 2007
Mission and Values For a download of the printable pdf color version of the Mis… Fri 19th Jan 2007
Our Doctrines We believe that the Scriptures of the Old and New Testaments… Fri 19th Jan 2007
The Crest   Click here to download the recent issue of The Cre… Fri 19th Jan 2007