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

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

Found 22 Pages:
Title Summary Date
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

Found 41 Articles: showing 1 to 25
< 1 2 >
Title Summary Date
Symposium 2008 Is Underway On Thursday, October 30, over 140 delegates convened at Jack… Fri 31st Oct 2008
Symposium 2008 Opening Service… Commissioner William W. Francis, Territorial Commander, spea… Fri 31st Oct 2008
Symposium 2008 Video Blog #1 Visit Salvationist.ca/symposium for more updates. Fri 31st Oct 2008
Symposium October 31 Preparati… Jeremy Mills offers an update for October 31. Salvationists … Fri 31st Oct 2008
What Is Normal? Do you ever pause to wonder what we mean when we say someone… Fri 31st Oct 2008
Moving Forward, Together Symposium 2008 provides Salvationists an opportunity to seek… Thu 30th Oct 2008
The Idol of the Market The market, as we know, is an entity that by its very nature… Wed 29th Oct 2008
Welcoming the World In this Salvationist.ca series entitled Talking It Over, Cap… Tue 28th Oct 2008
The UP Escalator The down escalator is faster than the up escalator. That&rsq… Mon 27th Oct 2008
A Congress of Thanksgiving Uniforms were everywhere! From the Toronto lakefront to the … Sun 26th Oct 2008
The Future Looks Bright The moment of revelation came unexpectedly. It was summer 20… Fri 24th Oct 2008
Let's Get Together One of my favourite things about Booth College is the close-… Thu 23rd Oct 2008
Winds of the Spirit Sweep Thro… We instantly noticed him sitting at the back of the congrega… Thu 23rd Oct 2008
Kings Singers to Perform in Lo… The London Citadel Band of The Salvation Army is pleased to … Wed 22nd Oct 2008
Passionate Life in Service We have all heard the expression, “I never really appr… Wed 22nd Oct 2008
The Courage to Obey (Part 2) In Ephesians 2:8 we read: “For it is by grace you have… Wed 22nd Oct 2008
Restructuring Roll-Out Lt-Colonel Donald Copple, Chief Secretary, has announced the… Tue 21st Oct 2008
Safe Eyes My oldest son, who is 10, casually shared with my wife and I… Mon 20th Oct 2008
A Call to be Radical Commissioners William and Marilyn Francis made their first v… Fri 17th Oct 2008
Exile vs. End Times I usually tend to stay away from lengthy debates about wheth… Fri 17th Oct 2008
In My Father’s House I am a mature woman who is relearning what it means to be pa… Thu 16th Oct 2008
Santa Shuffle Now in its 18th year, The Salvation Army’s Santa Shuff… Thu 16th Oct 2008
Election Day Well, it’s the day after Canada’s 40th election … Wed 15th Oct 2008
Visions from God Have you ever had a vision from God? Not just a wish or a dr… Tue 14th Oct 2008
Fear Takes the Bus Our flight from Toronto to Calgary was at 27,000 feet and cl… Mon 13th Oct 2008

Found one Event:
Title Summary Date
Harvest of Hope Congress - Ont… Harvest of Hope Congress - October 10 - 12, 2008.  Toro… Fri 10th Oct 2008

Found 3 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