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/web75/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/web75/web/index.php line 4
Search Results
Skip to Content
Enlarge TextClick to print16 16 2611 Sign In

Search Results

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

Found 64 Pages: showing 1 to 25
< 1 2 3 >
Title Summary Date
Forgotten Password Forgotten Password
Privacy Policy This website's policy is to respect and protect the privacy …
SalvationArmyEthics.org
Search Results
Sign In If you have forgotten your password, click here.
Signed In Welcome , you are signed in with the following privileges:
Debora Jayne Gowland Memorial … We would like to express our sincere thanks to the families …
Faith and the City Schedule an… Friday, 15 June 2007 “God’s Servant for Your Goo…
Faith and the City Youth Conte… We are thrilled to announce the winner of our Faith & th…
Faith and the City Symposium 16 June 2007, Winnipeg, Manitoba Where do faith and the cit…
Position Statement on Justice … God is the ultimate power and authority in the universe, so …
Abus d'alcool ou d'autres drog… Position de principe sur l’abus d’alcool ou d&rs…
Avortement Position de Principe sur L'Avortment L’Armée d…
Current News January 15, 2007? Over 3000 surveys have been distributed t…
Diversité humaine Position de principe sur la diversité humaine L&rsqu…
Environnement Position de principe sur la responsabilité en mati&eg…
Euthanasie Position de principe sur l’euthanasie, le suicide assi…
Famille Position de principe sur la famille L’Armée du…
Insémination artificielle et … L'INSÉMINATION ARTIFICIELLE ET LA FÉCONDATION …
Jeu Position de principe sur le jeu L’Armée du Sal…
Literature Barrett, R. (1998). Liberating the corporate soul: Building …
Mariage Position de principe sur le mariage L’Armée du…
Observance du dimanche Position de principe sur l’observance du dimanche Pou…
Paix mondiale Position de principe sur la paix dans le monde L’Arm&…
Pauvreté et justice économiq… Position de principe sur la pauvreté et la justice &e…

Found 80 Articles: showing 1 to 25
< 1 2 3 4 >
Title Summary Date
Respect There is something I would like to share with you, - it…
Whither the Weather.... Well, it's been a drizzly and cool Spring up here in Winnipe…
Txt Cmmndmnts The 10 Commandments, in TXT Spk: #3: No OMGs BY Cliff KuangF…
Even the Pope is FB savvy! As part of the Vatican's World Communications Day, the organ…
A Great Friend has Moved On Booth College and the Salvation Army Ethics Centre said good…
40th Anniversary of the CANADI… Knowing their March 20, 1969 marriage would be a huge press …
God's Chisel Here is a beautiful video shared with me by a friend on Face…
Earl Robinson article Click here to view: http://www.mediafire.com/?xnbtnztjdi3&qu…
The New Urbanism There’s a movement afoot called ‘The New Urbanis…
I wonder if you wonder Yes, our current site is always oddly formatted - yes, I rea…
To the Struggle Against World …   The artist, Zurab Tsereteli, w…
By My God I Leap Over Walls By my God I leap over walls (Psalm 18:29) A theological re…
A Grandmother's Tribe Set between a tiny village and the largest slum in Africa, c…
Hope and Beauty BUENOS AIRES, Argentina (CNN) -- It is the most popular phot…
Poverty and Corruption Poverty and Corruption By Colleen Marshall Originally publ…
(Untitled) Rodney Stark wrote a great book called The Rise of Christian…
Ethics and Pandemics   In the flurry of activity and worry around the new &…
Commuter Challenge 2009 Join us for the 10th anniversary of Commuter Challenge in Ma…
Starbucks Shared Planet Starbucks reports on their commitment to Ethical Sourcing, E…
The Slave Next Door
SEXTING?!?! Sexting and Our Moral Future Posted By editor On April 20…
Street Folk of Old? We were reminded of a delightful old song this week.  T…
Vote for Hannah! Hi everyone! Canadian Living Magazine & Free the Childr…
The Good Chocolate Guide THE STOP THE TRAFFIK GOOD CHOCOLATE GUIDE TO CANADA  …
Earth Keeping We missed Earth Hour here in the EC - did you know about Ear…