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 between 2006-11-01 and 2006-11-30

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

Found 11 Pages:
Title Summary Date
Album Click a pictures to see a larger version. CSB Concer… Tue 28th Nov 2006
Homosexualité Position de principe sur la sexualité des gais … Mon 13th Nov 2006
- Current News Current News On Monday, 15 January 2007, a random sampling… Fri 10th Nov 2006
- Literature Literature Barrett, R. (1998). Liberating the corporate so… Fri 10th Nov 2006
- Pilot project Pilot project The initial survey was delivered to two pilot… Fri 10th Nov 2006
- Project Rationale Project rationale In its origin, The Salvation Army was kno… Fri 10th Nov 2006
- Timeline Timeline   Task Timeframe Meeting wit… Fri 10th Nov 2006
Position Statement on Poverty … The measure of any society is how well it cares for its weak… Fri 10th Nov 2006
Values at Work Fri 10th Nov 2006
Other News from the Finance De… New MSA Policy In July 2008 the Territorial Finance Council… Mon 6th Nov 2006
Cabinet The Salvation Army's leadership team in Canada and Bermuda p… Wed 1st Nov 2006

Found 52 Articles: showing 1 to 25
< 1 2 3 >
Title Summary Date
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…
00:00
00:00
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…
00:00
00:00
Feature: Novemnber 20 is National…		 Fri 17th Nov 2006
Medicine Hat, Alberta, honours… March 16, 2006, is a day Sarah Smith, daughter of officer's … Fri 17th Nov 2006
Recognition given to those hel… Pasadena, NF - The community service award for an organizati… Fri 17th Nov 2006