SQL Statement DebuggerRecord::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 8Call 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 DebuggerRecord::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 8Call 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 |