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 2007-10-01 and 2007-10-31

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

Found 9 Pages:
Title Summary Date
Chatham Corps Tue 30th Oct 2007
Christmas With The Salvation A… Tue 30th Oct 2007
Williams Lake Tue 30th Oct 2007
Music In Their Souls Mon 29th Oct 2007
Forgotten Password Forgotten Password Tue 23rd Oct 2007
Salvationist.ca - Communicatin… Welcome to the website that communicates mission and news to… Tue 23rd Oct 2007
Free Songster Christmas Resour… Hear and Singharmony(TM) really is "the world's easiest… Thu 18th Oct 2007
Playing On The Edge - Deryck D… To listen to the sample tracks below, click twice on the blu… Wed 3rd Oct 2007
International Day of Older Per… We can all acknowledge that this business of aging is nothin… Mon 1st Oct 2007

Found 49 Articles: showing 1 to 25
< 1 2 >
Title Summary Date
Toronto Marlies - Great Hockey… The Toronto Marlies Hockey Club and The Salvation Army have … Wed 31st Oct 2007
Faith leaders bring peace, lov… Toronto - Today, Habitat for Humanity is holding its fifth a… Tue 30th Oct 2007
God's Army Is Growing In Newfo… N.L. W Div -A Good News Report from Dover Corps - This past … Tue 30th Oct 2007
How I Met The Salvation Army I had it all. At the age of 31, I was an international bank… Tue 30th Oct 2007
Students Deliver Leftover Cafe… Kingston, ON - A group of Queen's University students is rai… Mon 29th Oct 2007
The Greening Of The Army A new report shows that The Salvation Army has a long way to… Mon 29th Oct 2007
25th Annual Motorcycle Toy Run Regina, SK - The 25th annual motorcycle toy run was held und… Fri 26th Oct 2007
A Call To Downward Mobility Books, tapes, CDs and DVDs on leadership cram modern booksto… Thu 25th Oct 2007
Chief Secretary Receives Honor… On October 20, 2007, in Langley BC, Colonel Glen Shepherd wa… Thu 25th Oct 2007
The Gift Of Christmas The Salvation Army in Mississauga, Ont. presents "The Gift o… Thu 25th Oct 2007
U.S. Social Services Conferenc… Canadian officers or employees who plan to attend the U.S. N… Thu 25th Oct 2007
Cadets Winter Assignments Christmas is coming, and so are Winter assignments. We thoug… Wed 24th Oct 2007
The Salvation Army Responds to… ALEXANDRIA, VA (October 23, 2007) - Having completed recover… Wed 24th Oct 2007
Upcoming Salvation Army Broadc… The next Salvation Army broadcast is sponsored by the Stratf… Wed 24th Oct 2007
"Running Sober" Run … October 20, Halifax -  Rick MacDonald’s Running So… Tue 23rd Oct 2007
Actress Who Played in "Ma… Deborah Kerr died last Tuesday in Suffolk England at the age… Tue 23rd Oct 2007
Built To Last? Over the last century, rapid change in technology has seen t… Tue 23rd Oct 2007
Canadian Officer Appointed to … EFFECTIVE 1 FEBRUARY 2008 LT. COLONELS ROBERT AND MARGUERITE… Mon 22nd Oct 2007
Recent Graduates Of Booth Coll… Congratulations to recent extended learning students who hav… Mon 22nd Oct 2007
Sally Ann mobile food service … Prince George, B.C. - Last weekend The Salvation Army's mobi… Mon 22nd Oct 2007
What Did Jesus Say About Salva… This Salvationist series takes a closer look at the teaching… Mon 22nd Oct 2007
Good Without God, But Better W… Canadians who believe in God are more likely than non-believ… Fri 19th Oct 2007
Supporting Our Troops Quebec - The women of 3 Wing Bagotville’s Emmanuel Ch… Fri 19th Oct 2007
The Salvation Army Launches Mo… Prince George, B.C. - This past weekend The Salvation Army i… Thu 18th Oct 2007
"Sally Ann" Attends … Northwest Territories - The Salvation Army resource centre i… Wed 17th Oct 2007