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-07-01 and 2006-07-31

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

Found 7 Pages:
Title Summary Date
Writer's Checklist 12 Keys to Great Magazine Writing 1) Will the story's openi… Fri 21st Jul 2006
Salvationist AD Thu 20th Jul 2006
Anti-Trafficking Network Conta… The Canada & Bermuda Territory established a working gro… Tue 11th Jul 2006
Around the World Internationally In 2004, Human Sexual Trafficking became a… Tue 11th Jul 2006
Resources There are many resources available for people to learn more … Tue 11th Jul 2006
Planned Giving Fri 7th Jul 2006
Territorial School of Music an… Fri 7th Jul 2006

Found 40 Articles: showing 1 to 25
< 1 2 >
Title Summary Date
International AIDS conference The world's premier gathering for the global response to HIV… Fri 28th Jul 2006
Sally Ann and RCMP educate vul… Congratulations! You've won a trip to Cancun through one of … Fri 28th Jul 2006
Episode 196: The Salvation Arm… The Salvation Army Connection: Ep… Thu 27th Jul 2006
New members welcomed/Faithful … Brantford, Ont.- New junior and senior soldiers are enrolled… Wed 26th Jul 2006
Special mission to the Caribbe… Majors Woody and Sharon Hale (Ret.) recently returned from a… Wed 26th Jul 2006
Change Islands celebrates Change Islands Citadel corps in the Newfoundland West divisi… Tue 25th Jul 2006
The price of innocence While channel surfing, I saw a documentary on television abo… Tue 25th Jul 2006
Summer camp program fundraiser Nanaimo, B.C. - The Salvation Army's kids summer camp progra… Mon 24th Jul 2006
Winnipeg teens bring sweat and… A group of Salvationists from Winnipeg recently discovered t… Mon 24th Jul 2006
Episode 195: The Salvation Arm… The Salvation Army Connection: Ep… Fri 21st Jul 2006
Canadian officer's undertake n… Commissioner Trevor Tuck, territorial commander, recently in… Thu 20th Jul 2006
Dedicated back to God On July 9, 2006, Robert Frances Oldford was dedicated back t… Thu 20th Jul 2006
LIGHT IN THE DARKNESS - Whose … As the 2004 Boxing Day tsunami swept over the coast of Sri L… Thu 20th Jul 2006
Grande Prairie, Alta., welcome… Congratulations to new members enrolled at the Grande Praire… Wed 19th Jul 2006
Summer Camps Video The Salvation Army has summer camps located all across Canad… Wed 19th Jul 2006
National Post newspaper highli… Soldiers of compassion: A Good Cause According to a recently… Tue 18th Jul 2006
South Windsor Citadel celebrat… South Windsor Citadel Salvation Army Community Church in Ont… Tue 18th Jul 2006
AIDS Awareness Session Inviting Salvationists and Friends to an AIDS Awareness Sess… Mon 17th Jul 2006
Northridge Community Church Ce… Northridge Community Church, Newmarket, Ont., held an apprec… Mon 17th Jul 2006
Release the Captives The first annual international weekend of prayer and fasting… Mon 17th Jul 2006
SAROOTS encourages spiritual t… On Canada Day weekend, a group of committed Salvationists of… Mon 17th Jul 2006
Episode 194: The Salvation Arm… The Salvation Army Connection: Ep… Fri 14th Jul 2006
Nidus Festival 2006 Feel The Current is going to be an amazing 3-day ecumenical … Fri 14th Jul 2006
Community Care in Kirkland Lak… Cpt Bonita Hebert, CO of the Kirkland Lake Community Church,… Thu 13th Jul 2006
I believe in cell groups One morning, the gathered believers were praying for each ot… Thu 13th Jul 2006