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 2008-01-01 and 2008-12-31

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

Found 56 Pages: showing 1 to 25
< 1 2 3 >
Title Summary Date
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
Positions de principe (francai… Avortement Peine capitale Euthanasie, suicide assist&eacut… Tue 28th Oct 2008
Privacy Policy This website's policy is to respect and protect the privacy … Tue 28th Oct 2008
Correctional and Justice Servi… The Salvation Army offers material, emotional and spiritual … Thu 23rd Oct 2008
Partners in Mission Welcome to the 2009 Partners in Mission Resource Page. He… Fri 17th Oct 2008
Heartbeat Podcast Episodes Heartbeat is the official news podcast of The Salvation Army… Mon 15th Sep 2008

Found 272 Articles: showing 1 to 25
< 1 2 3 4 5 6 … >
Title Summary Date
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
The Gift of Presence Shopping for others can be tough. Finding the gift that&rsqu… Sat 20th Dec 2008
Toy Drive Every year, more than 130,000 children receive toys from The… Fri 19th Dec 2008
Gift Giving One evening my four-year-old son was saying his prayers and … Thu 18th Dec 2008
How the Christmas Kettle Made … Each year, clients from The Salvation Army’s Hope Acre… Thu 18th Dec 2008
It's a Guarantee Since October 2007, the Gifts of Hope program has provided a… Thu 18th Dec 2008
Community Support in Langley, … Langley, B.C., is getting behind the Army’s Gateway of… Wed 17th Dec 2008
No Longer the Same There was no panic, no screaming. We just watched while my d… Mon 15th Dec 2008
Infant Holy It all began with a tiny infant. Not just any child. This wa… Thu 11th Dec 2008
Today is a Gift I watched Kung Fu Panda with my kids last weekend. I love th… Wed 10th Dec 2008
Commissioner Francis Installed… Commissioner William W. Francis, Territorial Commander of Th… Tue 9th Dec 2008
Ethical Shopping Any article on ethical shopping has to say at the outset tha… Tue 9th Dec 2008
All I Want for Christmas In this Salvationist.ca series, Captain Amy Reardon, Editor … Fri 5th Dec 2008
No Room in the Inn Luke 2:7: “And she gave birth to her firstborn, a son.… Fri 5th Dec 2008
The Salvation Army's 100th You… Over the past two years The Salvation Army has been busy upl… Thu 4th Dec 2008
Heaven’s Rehearsal A few weeks ago, an event called “Heaven’s Rehea… Tue 2nd Dec 2008
Stories from the Kettle I’ve been working on Salvation Army Christmas kettles … Tue 2nd Dec 2008
Oberammergau Passion Play 2010 As the leaders of The Salvation Army in Canada and Bermuda, … Mon 1st Dec 2008
Senior Reserved Appointments Following extensive consultation with territories, and in-de… Mon 1st Dec 2008
Enhanced Community Very few offenders serve life sentences. This means that man… Fri 28th Nov 2008
I Believe in Miracles I believe God performs miracles today. Every time I see a ma… Fri 28th Nov 2008
It’s Christmas Time As we approach Christmas, I’ve been reading the ancien… Fri 28th Nov 2008
Lt-Colonels Copple Promoted to… Lt-Colonels Donald and Ann Copple, Chief Secretary and Terri… Fri 28th Nov 2008
Alternative Measures The Salvation Army seeks the restoration of people, not the … Tue 25th Nov 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