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 851 to 875
< 1 2 … 33 34 35 36 37 … 48 49 >
Title Summary Date
Con artist posing as Sally Ann Calgary - Posing as a Salation Army volunteer, a scam artist… Mon 18th Dec 2006
God With Us-To the End of the … In the Gospel of Matthew, Jesus urges his followers to embra… Mon 18th Dec 2006
Homeless shelter in the works Salmon Arm, B.C.- The Salvation Army is planning a 10-bed em… Fri 15th Dec 2006
Sounds of the Season TORONTO-On Saturday, December 2, Salvationists and friends g… Fri 15th Dec 2006
Walking the Road to Bethlehem Edmonton - For Castledowns Salvation Army Church, the birth … Fri 15th Dec 2006
I'm in His Hands On February 5, 2005 Lt-Col Mary Belle Leach was diagnosed wi… Thu 14th Dec 2006
Ottawa celebrates Christmas wi… The Ottawa Salvation Army presented the 21st Annual Festival… Thu 14th Dec 2006
Sherbrooke, Quebec, celebrates… L"Eglise Communataire de Sherbrooke recently celebrated 10 y… Wed 13th Dec 2006
Being a Geek pays off! A new computer donation program provides underprivileged chi… Tue 12th Dec 2006
Salvation Army supports motion… Conservative MP Joy Smith introduced a private member's bill… Tue 12th Dec 2006
Episode 215: The Salvation Arm… Feature: Jim Kurz is a branch man… Mon 11th Dec 2006
Man of Mystery Mark’s gospel skips the birth narrative, but gives us… Mon 11th Dec 2006
Parking tickets wiped clean in… The University of Saskatchewan's parking services department… Mon 11th Dec 2006
Parish Nurse Program provides … Abbotsford, B.C. - A nursing program to help care for member… Fri 8th Dec 2006
Students participate in "… Orillia, Ont.- Since late November three locals schools have… Fri 8th Dec 2006
Gingerbread houses raise funds… Toronto, Ont. -In celebration of Canada Mortgage and Housing… Thu 7th Dec 2006
Ottawa Senators participate in… Ottawa - The Ottawa Senators will hold a toy drive this Satu… Thu 7th Dec 2006
Six things you need to know ab… The following statistics are merely a snapshot and even they… Thu 7th Dec 2006
Salvation Army opens shelter f… B.C. - The Salvation Army established the city's first tempo… Wed 6th Dec 2006
1,636 teddies tossed! Corner Brook, NF - The fourth annual Western Star Teddy Toss… Tue 5th Dec 2006
Episode 214: The Salvation Arm… Feature: Dr. Peter Legge is the P… Tue 5th Dec 2006
Finance Department Update The Salvation Army Canada & Bermuda Territory has implemente… Tue 5th Dec 2006
Press interview with US Nation… The late management guru Peter Drucker called the Salvation … Tue 5th Dec 2006
A restored faith leads to new … Thompson, M.B. - I set out to establish a Christian life wit… Mon 4th Dec 2006
Officer appointments: positive… These days, “marching orders” are preceded by di… Mon 4th Dec 2006