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 2007-07-01 and 2007-07-31

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

Found 30 Articles: showing 1 to 25
< 1 2 >
Title Summary Date
Appointment to the National Co… OTTAWA, ONTARIO - On June 2, 2007, The Honourable Monte Solb… Tue 31st Jul 2007
Are Your Spidey Senses Tinglin… For the theologically astute, there’s more to Hollywo… Mon 30th Jul 2007
Retired Officers Introduce New… USA - Joe and Doris Noland are retired Salvation Army office… Mon 30th Jul 2007
Bermuda Salvation Army Youth T… The Salvation Army Cedar Hill boy scouts, along with other b… Fri 27th Jul 2007
Newfoundland and Labrador West… Click here to view "Interchange", a newsletter with updates … Fri 27th Jul 2007
Things Are Looking Up In Walla… In his introductory remarks to the crowd gathered on Friday … Fri 27th Jul 2007
Get Anger under Control with a… Learning to control anger is a crucial life lesson - one tha… Thu 26th Jul 2007
Food For Fares Program Prince George, B.C. - The Food For Fares program will take p… Wed 25th Jul 2007
Salvationists Offer Support Af… Toronto - Last night Salvationists joined in a candlelight v… Wed 25th Jul 2007
Pray For China My first visit to China felt like going home. My grandparent… Tue 24th Jul 2007
Radio Broadcast A Salvation Army broadcast, sponsored by the Kitchener Commu… Tue 24th Jul 2007
Homeless Needs Are Met By City… St. John, N.B. - Recently The Salvation Army Booth Residenti… Mon 23rd Jul 2007
Integrated Mission Toolbox Tapping into people’s natural strengths produces resu… Mon 23rd Jul 2007
Meeting God, Meeting Friends, … Victoria, B.C. - The Salvation Army Westsong Community Churc… Thu 19th Jul 2007
Tips For Christians Who Want T… Canadian Members of Parliament receive thousands of messages… Thu 19th Jul 2007
A generous soul Beginning in the late 80s Ed Mirvish hung a sign on his stor… Tue 17th Jul 2007
Missions Fundraiser Orillia, Ont. - The Salvation Army, 157 Coldwater Rd. W., is… Tue 17th Jul 2007
The Reel Jesus When it comes to depicting the King of kings on celluloid, a… Mon 16th Jul 2007
Interview: Our New Leaders On July 1, 2007 Commissioners William and Marilyn Francis as… Fri 13th Jul 2007
Salvationists welcome new terr… On Thursday, July 12, a great crowd of Salvationists and fri… Fri 13th Jul 2007
Free Magazines! Uses for the special summer evangelism issue of Faith & Frie… Thu 12th Jul 2007
Welcome and Installation of Ne… Jackson's Point Divisional Camp - The installation of Commis… Tue 10th Jul 2007
Faith and Film Studios are recognizing the value of faith-based entertainme… Mon 9th Jul 2007
Bible Resource Centre The American Bible Society (www.bibles.com) is proud to anno… Thu 5th Jul 2007
Instruments Needed Majors Woody and Sharon Hale were recent guests for officers… Thu 5th Jul 2007