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-03-01 and 2007-03-31

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

Found 18 Pages:
Title Summary Date
---24/7 Journals Tue 27th Mar 2007
--Annotated Bibliography Tue 27th Mar 2007
--Links Tue 27th Mar 2007
-Divisional Pastoral Carers Tue 27th Mar 2007
-Resources Tue 27th Mar 2007
-Retreat Centres Tue 27th Mar 2007
-Signs of Needing Help Tue 27th Mar 2007
Contact Tue 27th Mar 2007
Mission & Vision Statement Mission Statement The Mission of the Pastoral Services Offi… Tue 27th Mar 2007
Officer Care Program Please be assured that the confidentiality of your approach … Tue 27th Mar 2007
Pastoral Services: About Us Tue 27th Mar 2007
Spiritual Formation (Pilot Stu… Tue 27th Mar 2007
Spiritual Formation Groups Tue 27th Mar 2007
Who We Are Content is being developed and will be posted soon. Thanks f… Tue 27th Mar 2007
125 special guests Jabulani: “Jabulani” means … Thu 22nd Mar 2007
Accommodations The following are accomodation suggestions: You can also rec… Wed 21st Mar 2007
Celebration 125 Registration Here's the registration information page. Wed 21st Mar 2007
Event schedule Come and celebrate 125 years of God's work in and through Th… Wed 21st Mar 2007

Found 49 Articles: showing 1 to 25
< 1 2 >
Title Summary Date
Episode 231: The Salvation Arm… To mark Refugee Rights Day on Apr… Fri 30th Mar 2007
Hunters are thanked for their … Kenora, B.C. - The following letter to the Editor was receiv… Fri 30th Mar 2007
NL Provincial Congress Will be held in Corner Brook at the Pepsi Centre June 22-24,… Fri 30th Mar 2007
Rethinking Thin Christian women are not immune from body image issues. Scien… Thu 29th Mar 2007
Dealing with 'whole life' a wo… It's been a rough two months, but Robert Simmons is determin… Tue 27th Mar 2007
Thine is the Glory! Toronto - On Good Friday, the North York Temple Corps will b… Tue 27th Mar 2007
Announcement from the Office o… March 26, 2007 -  Dear Friends: On behalf of the Territor… Mon 26th Mar 2007
“Under the Big Top  Ladies and gentleman, boys and girls, children of all ages, … Mon 26th Mar 2007
Episode 230: The Salvation Arm… Generations is a Salvation Army p… Mon 26th Mar 2007
Installation and Welcome Meeti… The above meeting will be held at the ONC Divisional Camp au… Mon 26th Mar 2007
Prayers to Celebrate Diversity In 1980, Kool and the Gang released a song called “Cel… Mon 26th Mar 2007
Sight For My Blindness May God help us see what others don’t.During this pas… Mon 26th Mar 2007
Announcement from the Chief Se… March 23, 2007 - Dear Friends: On behalf of the territorial… Fri 23rd Mar 2007
Canada's top 25 worship songs Different styles of music help us interpret and express diff… Fri 23rd Mar 2007
Come On and Celebrate! Join in a birthday bash marking 125 years of Salvation Army … Thu 22nd Mar 2007
How to Procrastinate Effective… Oh no! I forgot to do my homework!” Nathan cried. Now … Thu 22nd Mar 2007
The Toronto Passion Play Queensway Cathedral presents The Toronto Passion Play, a dra… Thu 22nd Mar 2007
The Gateway looks to expansion The Salvaton Army Gateway has been around since 1980 providi… Wed 21st Mar 2007
HELPS On-Line (Helping Every L… H.E.L.P.S. On-Line is a new resource from the corps ministri… Tue 20th Mar 2007
Happy 70th anniversary Dartmouth, N.S. Community Church - Retired CSM, Frank Banfie… Mon 19th Mar 2007
New president at Booth College The Board of Trustees of The Salvation Army William and Cath… Mon 19th Mar 2007
Episode 229: The Salvation Arm… Brian Burditt is Director of Worl… Fri 16th Mar 2007
Jabulani ministers at Celebrat… “Jabulani” means “Rejoice” in the Af… Fri 16th Mar 2007
New commitments Smiths Falls, Ont. - Congratulations to the four new soldier… Fri 16th Mar 2007
Register now for Celebration O… Come to Winnipeg June 15-17, 2007, and celebrate 125 years o… Fri 16th Mar 2007