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 401 to 425
< 1 2 … 15 16 17 18 19 … 48 49 >
Title Summary Date
Newmarket Salvation Army Reach… Newmarket, Ont. - The Salvation Army Northridge Community Ch… Tue 2nd Oct 2007
Winnipeg Salvationists Welcome… To the rousing music of Winnipeg East Band, the 16 cadets of… Tue 2nd Oct 2007
Confronting The Elephant In Th… National Porn Sunday encourages congregations to take a clos… Mon 1st Oct 2007
International Day of Older Per… October 1 has been designated as International Day of Older … Mon 1st Oct 2007
Travelling Light In Newfoundla… Newfoundland - Two women's camps were recently held in the N… Mon 1st Oct 2007
New Chapter In A Long Establis… Hamilton, Ont. - The Salvation Army Meadowlands Church (form… Fri 28th Sep 2007
Pakistan Territorial Commander… The following is a news release from International Headquart… Fri 28th Sep 2007
Dealing with Personal Burnout Whose heart has not been thrilled by Elijah’s exploit… Thu 27th Sep 2007
Moms and Kids Camp at Scotian … Nova Scotia - Mothers (most of them single parents) who face… Thu 27th Sep 2007
Pray For Myanmar Last year the Partners in Mission resource material highligh… Thu 27th Sep 2007
“Holiness - Revisitedâ… Culture is unavoidable. It is in the air we breathe. Whether… Wed 26th Sep 2007
Bikers Give Salvation Army A B… Langley, B.C. - The second annual Mercy Ride helped raise $2… Wed 26th Sep 2007
A Theology Of Immigration Major Ray Harris gleans guidance from Ruth When I stepped in… Tue 25th Sep 2007
Coats For Kids Campaign Is A C… Cobourg - The whole community is getting involved in their 1… Tue 25th Sep 2007
Salvation Army In Canada Launc… The Salvation Army in Canada has launched its first annual f… Tue 25th Sep 2007
Was It A Sign? Do you believe in signs and premonitions? I do. It was a … Tue 25th Sep 2007
First Daughter Jenna Bush Sits… In her first television interview, Jenna Bush speaks candidl… Mon 24th Sep 2007
What Did Jesus Say About Money… When I was a child, I attended a Good News Club at my school… Mon 24th Sep 2007
Canada Post Workers Stamp Out … B.C. - This Saturday, Sept. 22, in Dawson Creek and Fort St.… Fri 21st Sep 2007
Summer ESL Program Most Succes… Ontario Central-East Division- Volunteers with The Salvation… Fri 21st Sep 2007
International Day of Older Peo… We can all acknowledge that this business of aging is nothin… Thu 20th Sep 2007
The Face Of The Salvation Army… From September 6-9, 2007, open air meetings were held across… Thu 20th Sep 2007
Married Female Officer Is Inst… Major Susan van Duinen, the first female married officer to … Wed 19th Sep 2007
Canadian Idol Fans Support The… Drumheller, AB - On Tuesday September 11, more than 1,200 Dr… Tue 18th Sep 2007
When it’s time to say … Breaking the law with Vadim Khurin When was the last time yo… Tue 18th Sep 2007