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 1076 to 1100
< 1 2 … 42 43 44 45 46 … 48 49 >
Title Summary Date
Grande Prairie, Alta., welcome… Congratulations to new members enrolled at the Grande Praire… Wed 19th Jul 2006
Summer Camps Video The Salvation Army has summer camps located all across Canad… Wed 19th Jul 2006
National Post newspaper highli… Soldiers of compassion: A Good Cause According to a recently… Tue 18th Jul 2006
South Windsor Citadel celebrat… South Windsor Citadel Salvation Army Community Church in Ont… Tue 18th Jul 2006
AIDS Awareness Session Inviting Salvationists and Friends to an AIDS Awareness Sess… Mon 17th Jul 2006
Northridge Community Church Ce… Northridge Community Church, Newmarket, Ont., held an apprec… Mon 17th Jul 2006
Release the Captives The first annual international weekend of prayer and fasting… Mon 17th Jul 2006
SAROOTS encourages spiritual t… On Canada Day weekend, a group of committed Salvationists of… Mon 17th Jul 2006
Episode 194: The Salvation Arm…
00:00
00:00
The Salvation Army Connection: Ep…		 Fri 14th Jul 2006
Nidus Festival 2006 Feel The Current is going to be an amazing 3-day ecumenical … Fri 14th Jul 2006
Community Care in Kirkland Lak… Cpt Bonita Hebert, CO of the Kirkland Lake Community Church,… Thu 13th Jul 2006
I believe in cell groups One morning, the gathered believers were praying for each ot… Thu 13th Jul 2006
The Salvation Army in Poland Word has been received from international headquarters that … Thu 13th Jul 2006
The World's Longest BBQ The Salvation Army in Wetaskiwin, Alta., is named as one of … Thu 13th Jul 2006
No Ordinary Seaman It was 1945 and 19-year-old James Peach found himself in Por… Wed 12th Jul 2006
120 years in Pembroke The Salvation Army Pembroke Community Church recently celebr… Tue 11th Jul 2006
Fun in the Sun At Camp Sunrise in Gibson, B.C., kids find love and acceptan… Mon 10th Jul 2006
In memory of their mom Glovertown, Nfld. - Children of the late Olive Holloway dona… Mon 10th Jul 2006
Episode 193: The Salvation Arm…
00:00
00:00
The Salvation Army Connection: Ep…		 Sat 8th Jul 2006
An Army Moving Forward, Report… General John Gowans (Rtd), Commissioner Gis'le Gowans, terri… Fri 7th Jul 2006
La Scie, NL, hosts appreciatio… La Scie senior youth group organized an appreciation dinner … Fri 7th Jul 2006
Congress and Commissioning Jun… Crowds of Salvationists and friends made their way to St. Jo… Thu 6th Jul 2006
Renfrew, Ontario, celebrates 1… On the weekend of June 2-4, 2006, Renfrew celebrated their 1… Thu 6th Jul 2006
Mormons, Music and a Message -… Join the Salvation Army and See the World is written on one … Wed 5th Jul 2006
God's army grows Woodroofe Community Church, Ottawa, welcomes three new soldi… Tue 4th Jul 2006