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-11-01 and 2007-11-30

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

Found 6 Pages:
Title Summary Date
All News All News Thu 29th Nov 2007
RBC Banking and the Salvation … Royal Bank of Canada In July 2007, the Salvation Army in Ca… Wed 28th Nov 2007
Online Christmas Kettle Tue 27th Nov 2007
Scarborough Citadel Reunion Tue 27th Nov 2007
Magazine Outreach Ways Your Church Can Share Faith & Friends Faith & F… Mon 26th Nov 2007
(Untitled) Wed 21st Nov 2007

Found 27 Articles: showing 1 to 25
< 1 2 >
Title Summary Date
There’s A Butterfly On … Summer has ended, days are shorter, but the sun still shines… Fri 30th Nov 2007
On the Rocks? Or Will That Be … Why it’s important to teach your kids about the dange… Thu 29th Nov 2007
How Can I Deal With Tragedy An… How can I keep my family strong in the midst of it? The olde… Tue 27th Nov 2007
YMCA Recognizes Peacemakers Kitchener,ON - On November 23, peace medallions for 2007 wer… Tue 27th Nov 2007
Bonsai Tree Sacred Cow Small churches have the potential for explosive growth if nu… Mon 26th Nov 2007
Hockey Fans Handed Salvation A… Edmonton - Oiler fans were handed 17,000 Salvation Army bell… Mon 26th Nov 2007
Ten Ways To Have A Great Chris… 1. Before heading to the shops, decide how much to spend on … Fri 23rd Nov 2007
The Prairie and Northern Terri… Click here to view a copy of the latest Divisional Commander… Fri 23rd Nov 2007
Ancestors In The Attic The program 'ANCESTORS IN THE ATTIC'  focuses on the life… Thu 22nd Nov 2007
The Salvation Army Commences W… The Salvation Army’s International Headquarters in Lo… Thu 22nd Nov 2007
Christmas With The Salvation A… The Christmas season is upon us and we want to remind you of… Wed 21st Nov 2007
‘Naughty or Nice’… This Christmas season, whether a store greets you with   Tue 20th Nov 2007
Toronto Marlies and The Salvat… Join us Saturday December 8 for Salvation Army Day at Ricoh … Tue 20th Nov 2007
Children's Movie Described As … The children's movie "The Golden Compass" (Nicole Kidman) is… Mon 19th Nov 2007
Priestly Pastors Are officers control freaks or are congregations abdicating … Mon 19th Nov 2007
History Of The Salvation Army … The Salvation Army's kettles have been used for more than a … Thu 15th Nov 2007
Display Your Christian Faith P… Wearing a Christian T-Shirt or Christian jewelry is a great … Wed 14th Nov 2007
The Salvation Army Builds 205 … Following the completion of 100 homes in Galagodawatte durin… Wed 14th Nov 2007
Magic Mirror Sacred Cow Mirror, mirror, on the wall … who’s the fairest… Mon 12th Nov 2007
Toys From the Worlds Largest C… Toronto - On Thursday, November 8, the Guinness World Record… Mon 12th Nov 2007
Salvation Army Christmas Cards Etobicoke, Ont. - The Salvation Army Lakeshore Community Chu… Thu 8th Nov 2007
Brantford Salvation Army Dedic… The Salvation Army Wyndfield Community Church is one of the … Wed 7th Nov 2007
Arrested Poker Players Offered… Winnipeg - Poker players who were arrested during raids at t… Tue 6th Nov 2007
Old Sweater Sacred Cow Choosing Kingdom values over sentimentality. We all have an … Mon 5th Nov 2007
Salvationist.ca Top Ten Mosted… 1. Home page 2. CFOT 3. CSB 4. HELPS 5. Catalogue 6. THEME 7… Mon 5th Nov 2007