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 876 to 900
< 1 2 … 34 35 36 37 38 … 48 49 >
Title Summary Date
Immigrant & Refugee Services c… Ontario central division - Florence Gruer, settlement counse… Fri 1st Dec 2006
The Long Haul - The Salvation … Three centuries before Salvation Army founder William Booth … Fri 1st Dec 2006
Christ is making a comeback th… HOLLYWOOD -- I believe our nation is on the threshold of a m… Thu 30th Nov 2006
Renowned writer to publish boo… To mark World Aids Day 2006 (Friday 1 December), The Salvati… Thu 30th Nov 2006
West 49 store collects coats f… Canada's leading skateboard retailer collected over 7,700 wi… Thu 30th Nov 2006
Salvation Army plans change wi… A visit by The Salvation Army’s international leader … Wed 29th Nov 2006
Penticton celebrates 85 years The city of Penticton is located in British Columbia's beaut… Tue 28th Nov 2006
Cause for celebration Harry's Harbour in the Nfld. & Lab W Div celebrates 106 year… Mon 27th Nov 2006
Position available in Sri Lank… We write to inform you of a position available in the Sri La… Mon 27th Nov 2006
Three Models of Corps Governan… What works best-a corps council, the Carver model or a missi… Mon 27th Nov 2006
Episode 213: The Salvation Arm… Feature: December 1st is World AI… Sun 26th Nov 2006
Crummy Church Signs I read an article recently titled “It’s Not Chu… Fri 24th Nov 2006
Stuff a cruiser campaign Kenora, Ont. - On Sat. Nov. 25 the Kenora detachment of the … Fri 24th Nov 2006
Territorial leader to be inter… As part of The Salvation Army's Christmas campaign, Commissi… Fri 24th Nov 2006
Children making a difference Qualicum Beach, BC - Children in the Christian Fellowship Ce… Thu 23rd Nov 2006
King's Point celebrates 85 yea… King's Point Corps in the Nfld. & Lab. W Div recently celebr… Thu 23rd Nov 2006
Newfoundland - College for Off… The Salvation Army training college and three hectares of la… Wed 22nd Nov 2006
Announcement from the office o… November 21, 2006 - On behalf of the Territorial Commander, … Tue 21st Nov 2006
Canada Post donates to Salvati… Toronto - Canada Post donated $25,000 to The Salvation Army … Tue 21st Nov 2006
Facing the music What part is music playing in The Salvation Army of the new … Tue 21st Nov 2006
A New Way of Leading Springdale Corps, Newfoundland, sings the praises of the new… Mon 20th Nov 2006
Giving Hope at the Toronto San… A 128-member Salvation Army contingent participated in the 1… Mon 20th Nov 2006
Salvation Army provides lunche… Cranbrook, B.C. - At last count 79 lunches were being delive… Mon 20th Nov 2006
Severe rainstorm attacks Vanco… Last Wednesday, a severe rainstorm hit Vancouver Island and … Mon 20th Nov 2006
Episode 212: The Salvation Arm… Feature: Novemnber 20 is National… Fri 17th Nov 2006