 Related JobsMDB2_Error Object ( [error_message_prefix] => [mode] => 1 [level] => 1024 [code] => -2 [message] => MDB2 Error: syntax error [userinfo] => _doQuery: [Error message: Could not execute statement] [Last executed query: SELECT * FROM job WHERE live = 1 AND id != 5805 AND description NOT LIKE '%%' AND region_id = AND (salary_band_id = NULL OR salary_band_id = '1') ORDER BY id DESC LIMIT 4] [Native code: 1064] [Native message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND (salary_band_id = NULL OR salary_band_id = '1') ORDER BY id DESC LIMIT' at line 1] [backtrace] => Array ( [0] => Array ( [file] => /var/www/vhosts/viewcreatives.com/lib/pear_lib/MDB2.php [line] => 973 [function] => PEAR_Error [class] => PEAR_Error [type] => -> [args] => Array ( [0] => MDB2 Error: syntax error [1] => -2 [2] => 1 [3] => 1024 [4] => _doQuery: [Error message: Could not execute statement] [Last executed query: SELECT * FROM job WHERE live = 1 AND id != 5805 AND description NOT LIKE '%%' AND region_id = AND (salary_band_id = NULL OR salary_band_id = '1') ORDER BY id DESC LIMIT 4] [Native code: 1064] [Native message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND (salary_band_id = NULL OR salary_band_id = '1') ORDER BY id DESC LIMIT' at line 1] ) ) [1] => Array ( [file] => /var/www/vhosts/viewcreatives.com/lib/pear_lib/PEAR.php [line] => 564 [function] => MDB2_Error [class] => MDB2_Error [object] => MDB2_Error Object *RECURSION* [type] => -> [args] => Array ( [0] => -2 [1] => 1 [2] => 1024 [3] => _doQuery: [Error message: Could not execute statement] [Last executed query: SELECT * FROM job WHERE live = 1 AND id != 5805 AND description NOT LIKE '%%' AND region_id = AND (salary_band_id = NULL OR salary_band_id = '1') ORDER BY id DESC LIMIT 4] [Native code: 1064] [Native message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND (salary_band_id = NULL OR salary_band_id = '1') ORDER BY id DESC LIMIT' at line 1] ) ) [2] => Array ( [file] => /var/www/vhosts/viewcreatives.com/lib/pear_lib/MDB2.php [line] => 1442 [function] => raiseError [class] => PEAR [object] => MDB2_Driver_mysqli Object ( [string_quoting] => Array ( [start] => ' [end] => ' [escape] => \ [escape_pattern] => \ ) [identifier_quoting] => Array ( [start] => ` [end] => ` [escape] => ` ) [sql_comments] => Array ( [0] => Array ( [start] => -- [end] => [escape] => ) [1] => Array ( [start] => # [end] => [escape] => ) [2] => Array ( [start] => /* [end] => */ [escape] => ) ) [start_transaction] => 1 [varchar_max_length] => 65532 [db_index] => 1 [dsn] => Array ( [phptype] => mysqli [dbsyntax] => mysqli [username] => webuser [password] => w3bp4ssw0rd [protocol] => tcp [hostspec] => localhost [port] => [socket] => [database] => [mode] => ) [connected_dsn] => Array ( [phptype] => mysqli [dbsyntax] => mysqli [username] => webuser [password] => w3bp4ssw0rd [protocol] => tcp [hostspec] => localhost [port] => [socket] => [database] => [mode] => ) [connection] => mysqli Object ( ) [opened_persistent] => [database_name] => viewcreatives [connected_database_name] => viewcreatives [connected_server_info] => 5.0.45 [supported] => Array ( [sequences] => emulated [indexes] => 1 [affected_rows] => 1 [summary_functions] => 1 [order_by_text] => 1 [transactions] => 1 [savepoints] => 1 [current_id] => emulated [limit_queries] => 1 [LOBs] => 1 [replace] => 1 [sub_selects] => 1 [auto_increment] => 1 [primary_key] => 1 [result_introspection] => 1 [prepared_statements] => 1 [identifier_quoting] => 1 [pattern_escaping] => 1 [new_link] => 1 ) [options] => Array ( [ssl] => [field_case] => 0 [disable_query] => [result_class] => MDB2_Result_%s [buffered_result_class] => MDB2_BufferedResult_%s [result_wrap_class] => [result_buffering] => 1 [fetch_class] => stdClass [persistent] => [debug] => 0 [debug_handler] => MDB2_defaultDebugOutput [debug_expanded_output] => [default_text_field_length] => 4096 [lob_buffer_length] => 8192 [log_line_break] => [idxname_format] => %s_idx [seqname_format] => %s_seq [savepoint_format] => MDB2_SAVEPOINT_%s [statement_format] => MDB2_STATEMENT_%1$s_%2$s [seqcol_name] => sequence [quote_identifier] => [use_transactions] => 1 [decimal_places] => 2 [portability] => 127 [modules] => Array ( [ex] => Extended [dt] => Datatype [mg] => Manager [rv] => Reverse [na] => Native [fc] => Function ) [emulate_prepared] => [datatype_map] => Array ( ) [datatype_map_callback] => Array ( ) [nativetype_map_callback] => Array ( ) [default_table_type] => [multi_query] => ) [wildcards] => Array ( [0] => % [1] => _ ) [as_keyword] => AS [warnings] => Array ( ) [debug_output] => [in_transaction] => [nested_transaction_counter] => [has_transaction_error] => [offset] => 0 [limit] => 0 [phptype] => mysqli [dbsyntax] => mysqli [last_query] => SELECT * FROM job WHERE live = 1 AND id != 5805 AND description NOT LIKE '%%' AND region_id = AND (salary_band_id = NULL OR salary_band_id = '1') ORDER BY id DESC LIMIT 4 [fetchmode] => 2 [modules] => Array ( [Datatype] => MDB2_Driver_Datatype_mysqli Object ( [valid_default_values] => Array ( [text] => [boolean] => 1 [integer] => 0 [decimal] => 0 [float] => 0 [timestamp] => 1970-01-01 00:00:00 [time] => 00:00:00 [date] => 1970-01-01 [clob] => [blob] => ) [lobs] => Array ( ) [db_index] => 1 ) ) [destructor_registered] => 1 [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => PEAR_Error [_expected_errors] => Array ( ) [datatype] => MDB2_Driver_Datatype_mysqli Object ( [valid_default_values] => Array ( [text] => [boolean] => 1 [integer] => 0 [decimal] => 0 [float] => 0 [timestamp] => 1970-01-01 00:00:00 [time] => 00:00:00 [date] => 1970-01-01 [clob] => [blob] => ) [lobs] => Array ( ) [db_index] => 1 ) [loaded_version_modules] => Array ( [0] => datatype ) ) [type] => -> [args] => Array ( [0] => [1] => -2 [2] => [3] => [4] => _doQuery: [Error message: Could not execute statement] [Last executed query: SELECT * FROM job WHERE live = 1 AND id != 5805 AND description NOT LIKE '%%' AND region_id = AND (salary_band_id = NULL OR salary_band_id = '1') ORDER BY id DESC LIMIT 4] [Native code: 1064] [Native message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND (salary_band_id = NULL OR salary_band_id = '1') ORDER BY id DESC LIMIT' at line 1] [5] => MDB2_Error [6] => 1 ) ) [3] => Array ( [file] => /var/www/vhosts/viewcreatives.com/lib/pear_lib/MDB2/Driver/mysqli.php [line] => 597 [function] => raiseError [class] => MDB2_Driver_Common [object] => MDB2_Driver_mysqli Object ( [string_quoting] => Array ( [start] => ' [end] => ' [escape] => \ [escape_pattern] => \ ) [identifier_quoting] => Array ( [start] => ` [end] => ` [escape] => ` ) [sql_comments] => Array ( [0] => Array ( [start] => -- [end] => [escape] => ) [1] => Array ( [start] => # [end] => [escape] => ) [2] => Array ( [start] => /* [end] => */ [escape] => ) ) [start_transaction] => 1 [varchar_max_length] => 65532 [db_index] => 1 [dsn] => Array ( [phptype] => mysqli [dbsyntax] => mysqli [username] => webuser [password] => w3bp4ssw0rd [protocol] => tcp [hostspec] => localhost [port] => [socket] => [database] => [mode] => ) [connected_dsn] => Array ( [phptype] => mysqli [dbsyntax] => mysqli [username] => webuser [password] => w3bp4ssw0rd [protocol] => tcp [hostspec] => localhost [port] => [socket] => [database] => [mode] => ) [connection] => mysqli Object ( ) [opened_persistent] => [database_name] => viewcreatives [connected_database_name] => viewcreatives [connected_server_info] => 5.0.45 [supported] => Array ( [sequences] => emulated [indexes] => 1 [affected_rows] => 1 [summary_functions] => 1 [order_by_text] => 1 [transactions] => 1 [savepoints] => 1 [current_id] => emulated [limit_queries] => 1 [LOBs] => 1 [replace] => 1 [sub_selects] => 1 [auto_increment] => 1 [primary_key] => 1 [result_introspection] => 1 [prepared_statements] => 1 [identifier_quoting] => 1 [pattern_escaping] => 1 [new_link] => 1 ) [options] => Array ( [ssl] => [field_case] => 0 [disable_query] => [result_class] => MDB2_Result_%s [buffered_result_class] => MDB2_BufferedResult_%s [result_wrap_class] => [result_buffering] => 1 [fetch_class] => stdClass [persistent] => [debug] => 0 [debug_handler] => MDB2_defaultDebugOutput [debug_expanded_output] => [default_text_field_length] => 4096 [lob_buffer_length] => 8192 [log_line_break] => [idxname_format] => %s_idx [seqname_format] => %s_seq [savepoint_format] => MDB2_SAVEPOINT_%s [statement_format] => MDB2_STATEMENT_%1$s_%2$s [seqcol_name] => sequence [quote_identifier] => [use_transactions] => 1 [decimal_places] => 2 [portability] => 127 [modules] => Array ( [ex] => Extended [dt] => Datatype [mg] => Manager [rv] => Reverse [na] => Native [fc] => Function ) [emulate_prepared] => [datatype_map] => Array ( ) [datatype_map_callback] => Array ( ) [nativetype_map_callback] => Array ( ) [default_table_type] => [multi_query] => ) [wildcards] => Array ( [0] => % [1] => _ ) [as_keyword] => AS [warnings] => Array ( ) [debug_output] => [in_transaction] => [nested_transaction_counter] => [has_transaction_error] => [offset] => 0 [limit] => 0 [phptype] => mysqli [dbsyntax] => mysqli [last_query] => SELECT * FROM job WHERE live = 1 AND id != 5805 AND description NOT LIKE '%%' AND region_id = AND (salary_band_id = NULL OR salary_band_id = '1') ORDER BY id DESC LIMIT 4 [fetchmode] => 2 [modules] => Array ( [Datatype] => MDB2_Driver_Datatype_mysqli Object ( [valid_default_values] => Array ( [text] => [boolean] => 1 [integer] => 0 [decimal] => 0 [float] => 0 [timestamp] => 1970-01-01 00:00:00 [time] => 00:00:00 [date] => 1970-01-01 [clob] => [blob] => ) [lobs] => Array ( ) [db_index] => 1 ) ) [destructor_registered] => 1 [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => PEAR_Error [_expected_errors] => Array ( ) [datatype] => MDB2_Driver_Datatype_mysqli Object ( [valid_default_values] => Array ( [text] => [boolean] => 1 [integer] => 0 [decimal] => 0 [float] => 0 [timestamp] => 1970-01-01 00:00:00 [time] => 00:00:00 [date] => 1970-01-01 [clob] => [blob] => ) [lobs] => Array ( ) [db_index] => 1 ) [loaded_version_modules] => Array ( [0] => datatype ) ) [type] => -> [args] => Array ( [0] => [1] => [2] => [3] => Could not execute statement [4] => _doQuery ) ) [4] => Array ( [file] => /var/www/vhosts/viewcreatives.com/lib/pear_lib/MDB2.php [line] => 2514 [function] => _doQuery [class] => MDB2_Driver_mysqli [object] => MDB2_Driver_mysqli Object ( [string_quoting] => Array ( [start] => ' [end] => ' [escape] => \ [escape_pattern] => \ ) [identifier_quoting] => Array ( [start] => ` [end] => ` [escape] => ` ) [sql_comments] => Array ( [0] => Array ( [start] => -- [end] => [escape] => ) [1] => Array ( [start] => # [end] => [escape] => ) [2] => Array ( [start] => /* [end] => */ [escape] => ) ) [start_transaction] => 1 [varchar_max_length] => 65532 [db_index] => 1 [dsn] => Array ( [phptype] => mysqli [dbsyntax] => mysqli [username] => webuser [password] => w3bp4ssw0rd [protocol] => tcp [hostspec] => localhost [port] => [socket] => [database] => [mode] => ) [connected_dsn] => Array ( [phptype] => mysqli [dbsyntax] => mysqli [username] => webuser [password] => w3bp4ssw0rd [protocol] => tcp [hostspec] => localhost [port] => [socket] => [database] => [mode] => ) [connection] => mysqli Object ( ) [opened_persistent] => [database_name] => viewcreatives [connected_database_name] => viewcreatives [connected_server_info] => 5.0.45 [supported] => Array ( [sequences] => emulated [indexes] => 1 [affected_rows] => 1 [summary_functions] => 1 [order_by_text] => 1 [transactions] => 1 [savepoints] => 1 [current_id] => emulated [limit_queries] => 1 [LOBs] => 1 [replace] => 1 [sub_selects] => 1 [auto_increment] => 1 [primary_key] => 1 [result_introspection] => 1 [prepared_statements] => 1 [identifier_quoting] => 1 [pattern_escaping] => 1 [new_link] => 1 ) [options] => Array ( [ssl] => [field_case] => 0 [disable_query] => [result_class] => MDB2_Result_%s [buffered_result_class] => MDB2_BufferedResult_%s [result_wrap_class] => [result_buffering] => 1 [fetch_class] => stdClass [persistent] => [debug] => 0 [debug_handler] => MDB2_defaultDebugOutput [debug_expanded_output] => [default_text_field_length] => 4096 [lob_buffer_length] => 8192 [log_line_break] => [idxname_format] => %s_idx [seqname_format] => %s_seq [savepoint_format] => MDB2_SAVEPOINT_%s [statement_format] => MDB2_STATEMENT_%1$s_%2$s [seqcol_name] => sequence [quote_identifier] => [use_transactions] => 1 [decimal_places] => 2 [portability] => 127 [modules] => Array ( [ex] => Extended [dt] => Datatype [mg] => Manager [rv] => Reverse [na] => Native [fc] => Function ) [emulate_prepared] => [datatype_map] => Array ( ) [datatype_map_callback] => Array ( ) [nativetype_map_callback] => Array ( ) [default_table_type] => [multi_query] => ) [wildcards] => Array ( [0] => % [1] => _ ) [as_keyword] => AS [warnings] => Array ( ) [debug_output] => [in_transaction] => [nested_transaction_counter] => [has_transaction_error] => [offset] => 0 [limit] => 0 [phptype] => mysqli [dbsyntax] => mysqli [last_query] => SELECT * FROM job WHERE live = 1 AND id != 5805 AND description NOT LIKE '%%' AND region_id = AND (salary_band_id = NULL OR salary_band_id = '1') ORDER BY id DESC LIMIT 4 [fetchmode] => 2 [modules] => Array ( [Datatype] => MDB2_Driver_Datatype_mysqli Object ( [valid_default_values] => Array ( [text] => [boolean] => 1 [integer] => 0 [decimal] => 0 [float] => 0 [timestamp] => 1970-01-01 00:00:00 [time] => 00:00:00 [date] => 1970-01-01 [clob] => [blob] => ) [lobs] => Array ( ) [db_index] => 1 ) ) [destructor_registered] => 1 [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => PEAR_Error [_expected_errors] => Array ( ) [datatype] => MDB2_Driver_Datatype_mysqli Object ( [valid_default_values] => Array ( [text] => [boolean] => 1 [integer] => 0 [decimal] => 0 [float] => 0 [timestamp] => 1970-01-01 00:00:00 [time] => 00:00:00 [date] => 1970-01-01 [clob] => [blob] => ) [lobs] => Array ( ) [db_index] => 1 ) [loaded_version_modules] => Array ( [0] => datatype ) ) [type] => -> [args] => Array ( [0] => SELECT * FROM job WHERE live = 1 AND id != 5805 AND description NOT LIKE '%%' AND region_id = AND (salary_band_id = NULL OR salary_band_id = '1') ORDER BY id DESC LIMIT 4 [1] => [2] => mysqli Object ( ) [3] => viewcreatives ) ) [5] => Array ( [file] => /var/www/vhosts/viewcreatives.com/httpdocs/lib/classes/class.vacancy.php [line] => 510 [function] => query [class] => MDB2_Driver_Common [object] => MDB2_Driver_mysqli Object ( [string_quoting] => Array ( [start] => ' [end] => ' [escape] => \ [escape_pattern] => \ ) [identifier_quoting] => Array ( [start] => ` [end] => ` [escape] => ` ) [sql_comments] => Array ( [0] => Array ( [start] => -- [end] => [escape] => ) [1] => Array ( [start] => # [end] => [escape] => ) [2] => Array ( [start] => /* [end] => */ [escape] => ) ) [start_transaction] => 1 [varchar_max_length] => 65532 [db_index] => 1 [dsn] => Array ( [phptype] => mysqli [dbsyntax] => mysqli [username] => webuser [password] => w3bp4ssw0rd [protocol] => tcp [hostspec] => localhost [port] => [socket] => [database] => [mode] => ) [connected_dsn] => Array ( [phptype] => mysqli [dbsyntax] => mysqli [username] => webuser [password] => w3bp4ssw0rd [protocol] => tcp [hostspec] => localhost [port] => [socket] => [database] => [mode] => ) [connection] => mysqli Object ( ) [opened_persistent] => [database_name] => viewcreatives [connected_database_name] => viewcreatives [connected_server_info] => 5.0.45 [supported] => Array ( [sequences] => emulated [indexes] => 1 [affected_rows] => 1 [summary_functions] => 1 [order_by_text] => 1 [transactions] => 1 [savepoints] => 1 [current_id] => emulated [limit_queries] => 1 [LOBs] => 1 [replace] => 1 [sub_selects] => 1 [auto_increment] => 1 [primary_key] => 1 [result_introspection] => 1 [prepared_statements] => 1 [identifier_quoting] => 1 [pattern_escaping] => 1 [new_link] => 1 ) [options] => Array ( [ssl] => [field_case] => 0 [disable_query] => [result_class] => MDB2_Result_%s [buffered_result_class] => MDB2_BufferedResult_%s [result_wrap_class] => [result_buffering] => 1 [fetch_class] => stdClass [persistent] => [debug] => 0 [debug_handler] => MDB2_defaultDebugOutput [debug_expanded_output] => [default_text_field_length] => 4096 [lob_buffer_length] => 8192 [log_line_break] => [idxname_format] => %s_idx [seqname_format] => %s_seq [savepoint_format] => MDB2_SAVEPOINT_%s [statement_format] => MDB2_STATEMENT_%1$s_%2$s [seqcol_name] => sequence [quote_identifier] => [use_transactions] => 1 [decimal_places] => 2 [portability] => 127 [modules] => Array ( [ex] => Extended [dt] => Datatype [mg] => Manager [rv] => Reverse [na] => Native [fc] => Function ) [emulate_prepared] => [datatype_map] => Array ( ) [datatype_map_callback] => Array ( ) [nativetype_map_callback] => Array ( ) [default_table_type] => [multi_query] => ) [wildcards] => Array ( [0] => % [1] => _ ) [as_keyword] => AS [warnings] => Array ( ) [debug_output] => [in_transaction] => [nested_transaction_counter] => [has_transaction_error] => [offset] => 0 [limit] => 0 [phptype] => mysqli [dbsyntax] => mysqli [last_query] => SELECT * FROM job WHERE live = 1 AND id != 5805 AND description NOT LIKE '%%' AND region_id = AND (salary_band_id = NULL OR salary_band_id = '1') ORDER BY id DESC LIMIT 4 [fetchmode] => 2 [modules] => Array ( [Datatype] => MDB2_Driver_Datatype_mysqli Object ( [valid_default_values] => Array ( [text] => [boolean] => 1 [integer] => 0 [decimal] => 0 [float] => 0 [timestamp] => 1970-01-01 00:00:00 [time] => 00:00:00 [date] => 1970-01-01 [clob] => [blob] => ) [lobs] => Array ( ) [db_index] => 1 ) ) [destructor_registered] => 1 [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => PEAR_Error [_expected_errors] => Array ( ) [datatype] => MDB2_Driver_Datatype_mysqli Object ( [valid_default_values] => Array ( [text] => [boolean] => 1 [integer] => 0 [decimal] => 0 [float] => 0 [timestamp] => 1970-01-01 00:00:00 [time] => 00:00:00 [date] => 1970-01-01 [clob] => [blob] => ) [lobs] => Array ( ) [db_index] => 1 ) [loaded_version_modules] => Array ( [0] => datatype ) ) [type] => -> [args] => Array ( [0] => SELECT * FROM job WHERE live = 1 AND id != 5805 AND description NOT LIKE '%%' AND region_id = AND (salary_band_id = NULL OR salary_band_id = '1') ORDER BY id DESC LIMIT 4 ) ) [6] => Array ( [file] => /var/www/vhosts/viewcreatives.com/httpdocs/jobs/job-detail.php [line] => 669 [function] => getRelatedJobs [class] => Vacancy [object] => Vacancy Object ( [id:private] => 5805 ) [type] => -> [args] => Array ( ) ) ) [callback] => ) MDB2 Error: syntax error |
|