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 1001 to 1025
< 1 2 … 39 40 41 42 43 … 48 49 >
Title Summary Date
Christian Rock Band brings rel… After only two short years together, it is undeniable that C… Wed 20th Sep 2006
Effective church ministry is e… I was intrigued with a recent web poll appearing on Salvatio… Wed 20th Sep 2006
The South welcomes Canadian of… On August 26, 2006, in a service of installation, Canadian o… Wed 20th Sep 2006
Ignite-Video Promo The Ignite program is for young adults 18 to 30, committted … Tue 19th Sep 2006
Sackville, N.S. corps transfor… The Sackville Nova Scotia Corps of the Salvation Army is int… Tue 19th Sep 2006
"A Work That Must Be Done… New cadets are welcomed as officer training officially trans… Mon 18th Sep 2006
Announcement from the Secretar… The Canada and Bermuda Territory announces its plan to launc… Mon 18th Sep 2006
Papua New Guinea 'rascals' are… The Salvation Army continues to bring Christ's message of ho… Mon 18th Sep 2006
Editorial welcomes new editor … The Editorial department at territorial headquarters welcome… Fri 15th Sep 2006
Episode 203: The Salvation Arm… The Salvation Army Connection: Ep… Fri 15th Sep 2006
Lying Online Everything is at your fingertips on the Net, and increasing … Fri 15th Sep 2006
Pathway Community Church-a jou… Paradise Nfld.-On Sunday September 10, 2006, Pathway Communi… Fri 15th Sep 2006
Salvation Army responds to AID… More than 25,000 people from all around the world gathered i… Fri 15th Sep 2006
Two new cadets arrive at CFOT Two candidates approved last week are now in Winnipeg starti… Thu 14th Sep 2006
New Community Choir COME SING with the GTA Community Choir. This is a new adult … Wed 13th Sep 2006
Building Your Church, Using Yo… By Don Cousins & Judson Polling, Willow Creek Resources,… Tue 12th Sep 2006
Overseas updates Cpts Sheldon and Clare Feener, CO's at Gorseinon Corps in mi… Tue 12th Sep 2006
Etobicoke mission trip I was privileged to go with an Etobicoke corps, Toronto, mis… Mon 11th Sep 2006
Salvation Army assists evacuee… As of Friday, August 18th, The Salvation Army has assisted 5… Mon 11th Sep 2006
Episode 202: The Salvation Arm… The Salvation Army Connection: Ep… Fri 8th Sep 2006
The General sends message of s… As the fifth anniversary of the terrorist attack on the Worl… Fri 8th Sep 2006
Announcement from the office o… Re: Appointments and Promotions On behalf of the territoria… Thu 7th Sep 2006
Reality check for men buying s… Winnipeg, Man. - City police and local social agencies, incl… Wed 6th Sep 2006
Women prisoners won for Christ South America West Territory receives several reports from E… Wed 6th Sep 2006
Let the revolution begin Territorial School of Music and Gospel Arts is in full swing… Fri 1st Sep 2006