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 501 to 525
< 1 2 … 19 20 21 22 23 … 48 49 >
Title Summary Date
New Video Series by Chuck Cols… Christian leaders Chuck Colson and Rick Warren have joined t… Fri 3rd Aug 2007
Kirkland Lake Businessman Dona… Kirkland Lake, Ont. - Mark Simpson, owner and operator of Sq… Thu 2nd Aug 2007
Annual Salvation Army Fundrais… Nanaimo, B.C. - The third annual Salvation Army charity golf… Wed 1st Aug 2007
The Salvation Army Partners Wi… "Having enough food to feed your family is a huge concern fo… Wed 1st Aug 2007
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