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 229 Pages: showing 1 to 25
< 1 2 3 4 5 6 7 8 9 10 >
Title Summary Date
Poll Mon 8th Jun 2009
December 2008 Fri 30th Jan 2009
January 2009 Fri 30th Jan 2009
November 2008 Fri 30th Jan 2009
Partners in Mission Here you will find all promotional material from the Resourc… Fri 16th Jan 2009
October 2008 Tue 4th Nov 2008
September 2008 Tue 4th Nov 2008
Symposium 2008 Symposium 2008 provides Salvationists an opportunity to seek… Thu 30th Oct 2008
Abus d'alcool ou d'autres drog… Position de principe sur l’abus d’alcool ou d&rs… Tue 28th Oct 2008
Position Statement on Abortion The Salvation Army believes in the sanctity of human life be… Tue 28th Oct 2008
Position Statement on Capital … Because Salvationists believe in the sanctity of all human l… Tue 28th Oct 2008
Position Statement on Euthanas… Human life is a sacred gift from God. The Salvation Army bel… Tue 28th Oct 2008
Position Statement on Family The Salvation Army believes the family, as the basic communi… Tue 28th Oct 2008
Position Statement on Gambling The Salvation Army takes a stand against gambling that invol… Tue 28th Oct 2008
Position Statement on Gay & Le… The Salvation Army upholds the dignity of all persons. For t… Tue 28th Oct 2008
Position Statement on Human Di… The Salvation Army believes that all people are made in the … Tue 28th Oct 2008
Position Statement on Justice … God is the ultimate power and authority in the universe, so … Tue 28th Oct 2008
Position Statement on Marriage The Salvation Army believes marriage is the covenanting toge… Tue 28th Oct 2008
Position Statement on Pornogra… The Salvation Army believes that all persons are created in … Tue 28th Oct 2008
Position Statement on Reproduc… Current advances in research are opening doors to possibilit… Tue 28th Oct 2008
Position Statement on Responsi… As people made in the image of God (Genesis 1:27), we have b… Tue 28th Oct 2008
Position Statement on Substanc… The Salvation Army encourages a healthy spiritual, emotional… Tue 28th Oct 2008
Position Statement on the Sabb… Salvationists desire to worship God at all times and in all … Tue 28th Oct 2008
Position Statement on World Pe… The Salvation Army believes that the plan for creation is th… Tue 28th Oct 2008
Position Statements (English) Abortion Capital Punishment Environment Euthanasia Famil… Tue 28th Oct 2008

Found 1208 Articles: showing 1 to 25
< 1 2 3 4 5 6 … 44 45 46 47 48 49 >
Title Summary Date
A Prayer for My People The seventh World Christian Gathering of Indigenous People h… Tue 3rd Feb 2009
Our Daily Bread When my wife, Rochelle, and I went grocery shopping this wee… Tue 3rd Feb 2009
Gaining Acceptance Following our first year of studies at the College for Offic… Mon 2nd Feb 2009
A Place of Renewal If Major Roy Bridger, executive director of The Salvation Ar… Fri 30th Jan 2009
An Uncertain Future Home to more than a million people, Kenya’s Kibera is … Wed 28th Jan 2009
The Miracle of Adoption Adoption has been an interesting experience for our family. … Mon 26th Jan 2009
Being Found The movie August Rush is about a musical prodigy, Evan, who … Wed 21st Jan 2009
Making a Difference Last summer I attended a beautiful wedding on a warm July af… Wed 21st Jan 2009
The Porcupine and the Snake I once heard an Australian preacher describe the conflict be… Mon 19th Jan 2009
Proclaiming Kingdom Culture Lt-Colonels Raphael and Winsome Mason were appointed to the … Fri 16th Jan 2009
The Gift of Life In this Salvationist.ca series, Captain Amy Reardon, Editor … Wed 14th Jan 2009
The Wolf in Sheep's Clothing Go figure,” my friend commented. “You have a pic… Wed 14th Jan 2009
Call to Prayer for the Middle … Dear Fellow Salvationists, Once more those lands so famil… Mon 12th Jan 2009
Venturing Forth The Winnipeg kitchen is a beehive of activity. Four hundred … Mon 12th Jan 2009
Christmas with The Salvation A… Any producer will reluctantly admit that finding an audience… Sun 11th Jan 2009
Wholeness As a challenging new year lies ahead, the word that keeps co… Fri 9th Jan 2009
New Year's Resolution I know it’s trendy these days to make fun of New Year&… Thu 8th Jan 2009
Hope in the City Breakfast It’s a classic rags-to-riches story Frank O’Dea … Wed 7th Jan 2009
New Blankets for Yellowknife S… Northwest Territories Deputy Minister for the Department of … Wed 7th Jan 2009
Surviving the Cash Crunch In these days of economic uncertainty, the topic of personal… Wed 7th Jan 2009
Yad Vashem As I slowly journeyed through the visual and auditory histor… Wed 7th Jan 2009
Missing the Good Life Is it OK to be cynical? I've been batting this one around in… Tue 6th Jan 2009
Holding the Line Paul Goodyear is the territorial finance secretary. Under hi… Mon 5th Jan 2009
Haven of Hope and Health We have an unofficial motto here,” declares Ivy Scobie… Mon 29th Dec 2008
Being Wise at Christmas Wisdom is a precious thing because it is rare. Have you noti… Mon 22nd Dec 2008

Found 2 Events:
Title Summary Date
Harvest of Hope Congress - Ont… Harvest of Hope Congress - October 10 - 12, 2008.  Toro… Fri 10th Oct 2008
test test event great things go here Mon 7th Jul 2008

Found one Job Posting:
Title Summary Date
Part Time Weekend Cook FACILITY: Halton Lighthouse LOCATION: Oakville, Ontario CL… Wed 10th Dec 2008

Found 6 Podcasts:
Title Summary Date
Heartbeat: Episode #5 Episode #5: Yellowknife with Captains Derek and Ma… Tue 14th Oct 2008
Heartbeat: Episode #5 Episode #5: Yellowknife with Captains Derek and Ma… Fri 10th Oct 2008
Heartbeat: Episode #4 Episode #4: Gifts of Hope with Major Gillian Brown… Fri 3rd Oct 2008
Heartbeat: Episode #3 Episode #3: Federal Election 2008 with Major Grant… Fri 26th Sep 2008
Heartbeat: Episode #2 Episode #2: Young Adult Retention Project with Jam… Fri 19th Sep 2008
Heartbeat: Episode #1 Episode #1: Human Sexual Trafficking with Dianna Bussey… Fri 12th Sep 2008