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 701 to 725
< 1 2 … 27 28 29 30 31 … 48 49 >
Title Summary Date
New commitments Smiths Falls, Ont. - Congratulations to the four new soldier… Fri 16th Mar 2007
Register now for Celebration O… Come to Winnipeg June 15-17, 2007, and celebrate 125 years o… Fri 16th Mar 2007
Public Relations: A huge chall… Photo: Mrs. Titcombe-Volet and former hockey player Yvan Cou… Thu 15th Mar 2007
Salvation Army camping ministr… As Divisional Leaders in Ontario we write to acquaint and up… Thu 15th Mar 2007
Salvation Army food banks get … B.C. - Salvation Army food banks will get a boost this month… Thu 15th Mar 2007
Event to Commemorate the Aboli… Please join us to commemorate 200 years since the abolition … Wed 14th Mar 2007
Making a difference in their c… Majors Ethel Richardson & Deborah Bungay of Ontario Great La… Wed 14th Mar 2007
Mississauga Temple reaches out… Mississauga, Ont. - The Salvation Army family services assis… Tue 13th Mar 2007
When your life is shattered A woman who simply signs herself as "Pointless in Zion, Illi… Tue 13th Mar 2007
How to Prevent Death By Sermon If you want exciting worship, turn off your “brain sec… Mon 12th Mar 2007
Paying too much for insurance? As a member of The Salvation Army you may qualify for specia… Mon 12th Mar 2007
Despite blizzard MissionFest T… Toronto - More than 20,000 persevered through the blizzard t… Fri 9th Mar 2007
Episode 228: The Salvation Arm… The Army's New York Staff Band wa… Fri 9th Mar 2007
Need a laugh? The corps officer stands up one Sunday and announces: "I hav… Fri 9th Mar 2007
Seniors find themselves happil… Retired baby boomers welcome here. Whether in the workplace … Fri 9th Mar 2007
Stories from The Salvation Arm… THE Salvation Army recently finished a project in Pakistan t… Thu 8th Mar 2007
To Bangladesh and Back Nipawin, Sask. - Cpt Melodie Routly recently experienced a t… Thu 8th Mar 2007
Announcement: Administrative R… Commissioner M. Christine MacMillan has made the following a… Wed 7th Mar 2007
Lakeshore Breeze Lakeshore Breeze is a monthly newsletter produced by the Ont… Wed 7th Mar 2007
Banding: To Serve the Present … The present-day brass band continues to evolve as one of the… Tue 6th Mar 2007
Plugged Into Worship We asked Salvationists what type of worship inspires a   Mon 5th Mar 2007
The teddy bear that has it all He's cute, He's cuddly. And he recites nine Bible verses. Ba… Mon 5th Mar 2007
Episode 227: The Salvation Arm… The United Nations has designated… Fri 2nd Mar 2007
Sandra’s story Nearly 40 years ago, in beautiful Kenya in a little mission … Fri 2nd Mar 2007
Laughter is God’s gift … I love to laugh. I am drawn to laughter and to those who lau… Thu 1st Mar 2007