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 76 to 100
< 1 2 3 4 5 6 … 44 45 46 47 48 49 >
Title Summary Date
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
Never Give Up Happy Thanksgiving! As we pause this month to be thankful fo… Fri 10th Oct 2008
Photo Caption Contest #1 Salvationist.ca has launched its monthly photo caption conte… Fri 10th Oct 2008
Sincerity of Heart Last Sunday I took the bus to church. As I passed through li… Fri 10th Oct 2008
Get Out There! If you think that coming to Booth College means you will be … Thu 9th Oct 2008
Bermudian Salvationists Assist… Six Salvationists from Bermuda flew to Galveston, Texas… Wed 8th Oct 2008
Experimental Kids' Kamp a Reso… Fun, friendship, fellowship and faith have all been on the m… Wed 8th Oct 2008
God Counts the Apples in a See… Have you ever wanted to do something really amazing, but tho… Wed 8th Oct 2008
Territorial Day of Prayer for … Greetings, As Symposium 2008 draws closer I am inviting e… Wed 8th Oct 2008
The Courage to Obey (Part 1) Every now and then, Scripture gives us a verse or a paragrap… Wed 8th Oct 2008
Music To My Ears “Before a young man is ordained into the ministry, he … Mon 6th Oct 2008