Live Helper Chat support forum.. Forum is locked. New place for questions - Github Discussions
You are not logged in.
- Topics: Active | Unanswered
Announcement
#1 2017-10-14 09:08:39
- crashedbyme
- Member
- Registered: 2017-02-17
- Posts: 2
Not able to connect to chat support and chat list is showing 503 error
Hello Sir,
Today we have noticed that our live helper chat support is offline even i am online on backend. I checked in console, it was showing some 503 error response from server. So i checked on server and debug_output than it showing following error. Till yesterday it was working. I tried updating new version 2.73 as instructed but the problem is still there. I also tried manually creating the column in database but still showing same error. Please suggest.
[== PHP ==]
[originalMessage] => A query failed internally in Persistent Object: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lh_chat.transfer_uid' in 'field list' Query: 'SELECT `lh_chat`.`id`, `lh_chat`.`nick`, `lh_chat`.`status`, `lh_chat`.`status_sub`, `lh_chat`.`status_sub_arg`, `lh_chat`.`status_sub_sub`, `lh_chat`.`time`, `lh_chat`.`user_id`, `lh_chat`.`dep_id`, `lh_chat`.`product_id`, `lh_chat`.`user_status`, `lh_chat`.`user_closed_ts`, `lh_chat`.`support_informed`, `lh_chat`.`hash`, `lh_chat`.`ip`, `lh_chat`.`email`, `lh_chat`.`phone`, `lh_chat`.`referrer`, `lh_chat`.`session_referrer`, `lh_chat`.`country_code`, `lh_chat`.`country_name`, `lh_chat`.`remarks`, `lh_chat`.`lat`, `lh_chat`.`lon`, `lh_chat`.`city`, `lh_chat`.`user_typing`, `lh_chat`.`user_typing_txt`, `lh_chat`.`operator_typing`, `lh_chat`.`operator_typing_id`, `lh_chat`.`has_unread_messages`, `lh_chat`.`user_tz_identifier`, `lh_chat`.`unread_messages_informed`, `lh_chat`.`reinform_timeout`, `lh_chat`.`last_user_msg_time`, `lh_chat`.`last_msg_id`, `lh_chat`.`mail_send`, `lh_chat`.`additional_data`, `lh_chat`.`wait_time`, `lh_chat`.`chat_duration`, `lh_chat`.`chat_variables`, `lh_chat`.`priority`, `lh_chat`.`chat_initiator`, `lh_chat`.`online_user_id`, `lh_chat`.`operation`, `lh_chat`.`operation_admin`, `lh_chat`.`screenshot_id`, `lh_chat`.`transfer_timeout_ts`, `lh_chat`.`transfer_timeout_ac`, `lh_chat`.`transfer_if_na`, `lh_chat`.`transfer_uid`, `lh_chat`.`na_cb_executed`, `lh_chat`.`chat_locale`, `lh_chat`.`chat_locale_to`, `lh_chat`.`fbst`, `lh_chat`.`nc_cb_executed`, `lh_chat`.`tslasign`, `lh_chat`.`unanswered_chat`, `lh_chat`.`last_op_msg_time`, `lh_chat`.`has_unread_op_messages`, `lh_chat`.`lsync`, `lh_chat`.`unread_op_messages_informed`, `lh_chat`.`device_type`, `lh_chat`.`sender_user_id`, `lh_chat`.`usaccept`, `lh_chat`.`uagent`, `lh_chat`.`auto_responder_id` FROM `lh_chat` ORDER BY lh_chat.id DESC LIMIT 20 OFFSET 0'
[message:protected] => A query failed internally in Persistent Object: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lh_chat.transfer_uid' in 'field list' Query: 'SELECT `lh_chat`.`id`, `lh_chat`.`nick`, `lh_chat`.`status`, `lh_chat`.`status_sub`, `lh_chat`.`status_sub_arg`, `lh_chat`.`status_sub_sub`, `lh_chat`.`time`, `lh_chat`.`user_id`, `lh_chat`.`dep_id`, `lh_chat`.`product_id`, `lh_chat`.`user_status`, `lh_chat`.`user_closed_ts`, `lh_chat`.`support_informed`, `lh_chat`.`hash`, `lh_chat`.`ip`, `lh_chat`.`email`, `lh_chat`.`phone`, `lh_chat`.`referrer`, `lh_chat`.`session_referrer`, `lh_chat`.`country_code`, `lh_chat`.`country_name`, `lh_chat`.`remarks`, `lh_chat`.`lat`, `lh_chat`.`lon`, `lh_chat`.`city`, `lh_chat`.`user_typing`, `lh_chat`.`user_typing_txt`, `lh_chat`.`operator_typing`, `lh_chat`.`operator_typing_id`, `lh_chat`.`has_unread_messages`, `lh_chat`.`user_tz_identifier`, `lh_chat`.`unread_messages_informed`, `lh_chat`.`reinform_timeout`, `lh_chat`.`last_user_msg_time`, `lh_chat`.`last_msg_id`, `lh_chat`.`mail_send`, `lh_chat`.`additional_data`, `lh_chat`.`wait_time`, `lh_chat`.`chat_duration`, `lh_chat`.`chat_variables`, `lh_chat`.`priority`, `lh_chat`.`chat_initiator`, `lh_chat`.`online_user_id`, `lh_chat`.`operation`, `lh_chat`.`operation_admin`, `lh_chat`.`screenshot_id`, `lh_chat`.`transfer_timeout_ts`, `lh_chat`.`transfer_timeout_ac`, `lh_chat`.`transfer_if_na`, `lh_chat`.`transfer_uid`, `lh_chat`.`na_cb_executed`, `lh_chat`.`chat_locale`, `lh_chat`.`chat_locale_to`, `lh_chat`.`fbst`, `lh_chat`.`nc_cb_executed`, `lh_chat`.`tslasign`, `lh_chat`.`unanswered_chat`, `lh_chat`.`last_op_msg_time`, `lh_chat`.`has_unread_op_messages`, `lh_chat`.`lsync`, `lh_chat`.`unread_op_messages_informed`, `lh_chat`.`device_type`, `lh_chat`.`sender_user_id`, `lh_chat`.`usaccept`, `lh_chat`.`uagent`, `lh_chat`.`auto_responder_id` FROM `lh_chat` ORDER BY lh_chat.id DESC LIMIT 20 OFFSET 0'
[string:Exception:private] =>
[code:protected] => 0
[file:protected] => D:\xampp\htdocs\online\online\chatsupport\ezcomponents\PersistentObject\src\persistent_session.php
[line:protected] => 822
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => D:\xampp\htdocs\online\online\chatsupport\ezcomponents\PersistentObject\src\handlers\load_handler.php
[line] => 269
[function] => performQuery
[class] => ezcPersistentSession
[type] => ->
[args] => Array
(
[0] => ezcQuerySelect Object
(
[selectString:protected] => SELECT `lh_chat`.`id`, `lh_chat`.`nick`, `lh_chat`.`status`, `lh_chat`.`status_sub`, `lh_chat`.`status_sub_arg`, `lh_chat`.`status_sub_sub`, `lh_chat`.`time`, `lh_chat`.`user_id`, `lh_chat`.`dep_id`, `lh_chat`.`product_id`, `lh_chat`.`user_status`, `lh_chat`.`user_closed_ts`, `lh_chat`.`support_informed`, `lh_chat`.`hash`, `lh_chat`.`ip`, `lh_chat`.`email`, `lh_chat`.`phone`, `lh_chat`.`referrer`, `lh_chat`.`session_referrer`, `lh_chat`.`country_code`, `lh_chat`.`country_name`, `lh_chat`.`remarks`, `lh_chat`.`lat`, `lh_chat`.`lon`, `lh_chat`.`city`, `lh_chat`.`user_typing`, `lh_chat`.`user_typing_txt`, `lh_chat`.`operator_typing`, `lh_chat`.`operator_typing_id`, `lh_chat`.`has_unread_messages`, `lh_chat`.`user_tz_identifier`, `lh_chat`.`unread_messages_informed`, `lh_chat`.`reinform_timeout`, `lh_chat`.`last_user_msg_time`, `lh_chat`.`last_msg_id`, `lh_chat`.`mail_send`, `lh_chat`.`additional_data`, `lh_chat`.`wait_time`, `lh_chat`.`chat_duration`, `lh_chat`.`chat_variables`, `lh_chat`.`priority`, `lh_chat`.`chat_initiator`, `lh_chat`.`online_user_id`, `lh_chat`.`operation`, `lh_chat`.`operation_admin`, `lh_chat`.`screenshot_id`, `lh_chat`.`transfer_timeout_ts`, `lh_chat`.`transfer_timeout_ac`, `lh_chat`.`transfer_if_na`, `lh_chat`.`transfer_uid`, `lh_chat`.`na_cb_executed`, `lh_chat`.`chat_locale`, `lh_chat`.`chat_locale_to`, `lh_chat`.`fbst`, `lh_chat`.`nc_cb_executed`, `lh_chat`.`tslasign`, `lh_chat`.`unanswered_chat`, `lh_chat`.`last_op_msg_time`, `lh_chat`.`has_unread_op_messages`, `lh_chat`.`lsync`, `lh_chat`.`unread_op_messages_informed`, `lh_chat`.`device_type`, `lh_chat`.`sender_user_id`, `lh_chat`.`usaccept`, `lh_chat`.`uagent`, `lh_chat`.`auto_responder_id`
[fromString:protected] => FROM `lh_chat`
[useIndexString:protected] =>
[whereString:protected] =>
[groupString:protected] =>
[havingString:protected] =>
[orderString:protected] => ORDER BY lh_chat.id DESC
[limitString:protected] => LIMIT 20 OFFSET 0
[lastInvokedMethod:protected] => order
[lockString:protected] =>
[db:protected] => ezcDbHandlerMysql Object
(
[identifierQuoteChars:protected] => Array
(
[start] => `
[end] => `
)
[dbParams:ezcDbHandlerMysql:private] => Array
(
[phptype] => mysql
[dbsyntax] => mysql
[username] => root
[password] => ***
[protocol] => tcp
[hostspec] => 127.0.0.1
[port] => 3306
[socket] =>
[database] => chats
)
[dsn:ezcDbHandlerMysql:private] => mysql:dbname=chats;host=127.0.0.1;port=3306
[reconnectedCounter:ezcDbHandlerMysql:private] => 0
[transactionNestingLevel:protected] => 0
[transactionErrorFlag:protected] =>
)
[aliases:ezcQuery:private] => Array
(
[id] => `lh_chat`.`id`
[nick] => `lh_chat`.`nick`
[status] => `lh_chat`.`status`
[status_sub] => `lh_chat`.`status_sub`
[status_sub_arg] => `lh_chat`.`status_sub_arg`
[status_sub_sub] => `lh_chat`.`status_sub_sub`
[time] => `lh_chat`.`time`
[user_id] => `lh_chat`.`user_id`
[dep_id] => `lh_chat`.`dep_id`
[product_id] => `lh_chat`.`product_id`
[user_status] => `lh_chat`.`user_status`
[user_closed_ts] => `lh_chat`.`user_closed_ts`
[support_informed] => `lh_chat`.`support_informed`
[hash] => `lh_chat`.`hash`
[ip] => `lh_chat`.`ip`
[email] => `lh_chat`.`email`
[phone] => `lh_chat`.`phone`
[referrer] => `lh_chat`.`referrer`
[session_referrer] => `lh_chat`.`session_referrer`
[country_code] => `lh_chat`.`country_code`
[country_name] => `lh_chat`.`country_name`
[remarks] => `lh_chat`.`remarks`
[lat] => `lh_chat`.`lat`
[lon] => `lh_chat`.`lon`
[city] => `lh_chat`.`city`
[user_typing] => `lh_chat`.`user_typing`
[user_typing_txt] => `lh_chat`.`user_typing_txt`
[operator_typing] => `lh_chat`.`operator_typing`
[operator_typing_id] => `lh_chat`.`operator_typing_id`
[has_unread_messages] => `lh_chat`.`has_unread_messages`
[user_tz_identifier] => `lh_chat`.`user_tz_identifier`
[unread_messages_informed] => `lh_chat`.`unread_messages_informed`
[reinform_timeout] => `lh_chat`.`reinform_timeout`
[last_user_msg_time] => `lh_chat`.`last_user_msg_time`
[last_msg_id] => `lh_chat`.`last_msg_id`
[mail_send] => `lh_chat`.`mail_send`
[additional_data] => `lh_chat`.`additional_data`
[wait_time] => `lh_chat`.`wait_time`
[chat_duration] => `lh_chat`.`chat_duration`
[chat_variables] => `lh_chat`.`chat_variables`
[priority] => `lh_chat`.`priority`
[chat_initiator] => `lh_chat`.`chat_initiator`
[online_user_id] => `lh_chat`.`online_user_id`
[operation] => `lh_chat`.`operation`
[operation_admin] => `lh_chat`.`operation_admin`
[screenshot_id] => `lh_chat`.`screenshot_id`
[transfer_timeout_ts] => `lh_chat`.`transfer_timeout_ts`
[transfer_timeout_ac] => `lh_chat`.`transfer_timeout_ac`
[transfer_if_na] => `lh_chat`.`transfer_if_na`
[transfer_uid] => `lh_chat`.`transfer_uid`
[na_cb_executed] => `lh_chat`.`na_cb_executed`
[chat_locale] => `lh_chat`.`chat_locale`
[chat_locale_to] => `lh_chat`.`chat_locale_to`
[fbst] => `lh_chat`.`fbst`
[nc_cb_executed] => `lh_chat`.`nc_cb_executed`
[tslasign] => `lh_chat`.`tslasign`
[unanswered_chat] => `lh_chat`.`unanswered_chat`
[last_op_msg_time] => `lh_chat`.`last_op_msg_time`
[has_unread_op_messages] => `lh_chat`.`has_unread_op_messages`
[lsync] => `lh_chat`.`lsync`
[unread_op_messages_informed] => `lh_chat`.`unread_op_messages_informed`
[device_type] => `lh_chat`.`device_type`
[sender_user_id] => `lh_chat`.`sender_user_id`
[usaccept] => `lh_chat`.`usaccept`
[uagent] => `lh_chat`.`uagent`
[auto_responder_id] => `lh_chat`.`auto_responder_id`
[erLhcoreClassModelChat] => lh_chat
)
[boundCounter:ezcQuery:private] => 0
[boundParameters:ezcQuery:private] => Array
(
)
[boundParametersType:ezcQuery:private] => Array
(
)
[boundValues:ezcQuery:private] => Array
(
)
[boundValuesType:ezcQuery:private] => Array
(
)
[expr] => ezcQueryExpression Object
(
[db:protected] => ezcDbHandlerMysql Object
(
[identifierQuoteChars:protected] => Array
(
[start] => `
[end] => `
)
[dbParams:ezcDbHandlerMysql:private] => Array
(
[phptype] => mysql
[dbsyntax] => mysql
[username] => root
[password] => ***
[protocol] => tcp
[hostspec] => 127.0.0.1
[port] => 3306
[socket] =>
[database] => chats
)
[dsn:ezcDbHandlerMysql:private] => mysql:dbname=chats;host=127.0.0.1;port=3306
[reconnectedCounter:ezcDbHandlerMysql:private] => 0
[transactionNestingLevel:protected] => 0
[transactionErrorFlag:protected] =>
)
[aliases:ezcQueryExpression:private] => Array
(
[id] => `lh_chat`.`id`
[nick] => `lh_chat`.`nick`
[status] => `lh_chat`.`status`
[status_sub] => `lh_chat`.`status_sub`
[status_sub_arg] => `lh_chat`.`status_sub_arg`
[status_sub_sub] => `lh_chat`.`status_sub_sub`
[time] => `lh_chat`.`time`
[user_id] => `lh_chat`.`user_id`
[dep_id] => `lh_chat`.`dep_id`
[product_id] => `lh_chat`.`product_id`
[user_status] => `lh_chat`.`user_status`
[user_closed_ts] => `lh_chat`.`user_closed_ts`
[support_informed] => `lh_chat`.`support_informed`
[hash] => `lh_chat`.`hash`
[ip] => `lh_chat`.`ip`
[email] => `lh_chat`.`email`
[phone] => `lh_chat`.`phone`
[referrer] => `lh_chat`.`referrer`
[session_referrer] => `lh_chat`.`session_referrer`
[country_code] => `lh_chat`.`country_code`
[country_name] => `lh_chat`.`country_name`
[remarks] => `lh_chat`.`remarks`
[lat] => `lh_chat`.`lat`
[lon] => `lh_chat`.`lon`
[city] => `lh_chat`.`city`
[user_typing] => `lh_chat`.`user_typing`
[user_typing_txt] => `lh_chat`.`user_typing_txt`
[operator_typing] => `lh_chat`.`operator_typing`
[operator_typing_id] => `lh_chat`.`operator_typing_id`
[has_unread_messages] => `lh_chat`.`has_unread_messages`
[user_tz_identifier] => `lh_chat`.`user_tz_identifier`
[unread_messages_informed] => `lh_chat`.`unread_messages_informed`
[reinform_timeout] => `lh_chat`.`reinform_timeout`
[last_user_msg_time] => `lh_chat`.`last_user_msg_time`
[last_msg_id] => `lh_chat`.`last_msg_id`
[mail_send] => `lh_chat`.`mail_send`
[additional_data] => `lh_chat`.`additional_data`
[wait_time] => `lh_chat`.`wait_time`
[chat_duration] => `lh_chat`.`chat_duration`
[chat_variables] => `lh_chat`.`chat_variables`
[priority] => `lh_chat`.`priority`
[chat_initiator] => `lh_chat`.`chat_initiator`
[online_user_id] => `lh_chat`.`online_user_id`
[operation] => `lh_chat`.`operation`
[operation_admin] => `lh_chat`.`operation_admin`
[screenshot_id] => `lh_chat`.`screenshot_id`
[transfer_timeout_ts] => `lh_chat`.`transfer_timeout_ts`
[transfer_timeout_ac] => `lh_chat`.`transfer_timeout_ac`
[transfer_if_na] => `lh_chat`.`transfer_if_na`
[transfer_uid] => `lh_chat`.`transfer_uid`
[na_cb_executed] => `lh_chat`.`na_cb_executed`
[chat_locale] => `lh_chat`.`chat_locale`
[chat_locale_to] => `lh_chat`.`chat_locale_to`
[fbst] => `lh_chat`.`fbst`
[nc_cb_executed] => `lh_chat`.`nc_cb_executed`
[tslasign] => `lh_chat`.`tslasign`
[unanswered_chat] => `lh_chat`.`unanswered_chat`
[last_op_msg_time] => `lh_chat`.`last_op_msg_time`
[has_unread_op_messages] => `lh_chat`.`has_unread_op_messages`
[lsync] => `lh_chat`.`lsync`
[unread_op_messages_informed] => `lh_chat`.`unread_op_messages_informed`
[device_type] => `lh_chat`.`device_type`
[sender_user_id] => `lh_chat`.`sender_user_id`
[usaccept] => `lh_chat`.`usaccept`
[uagent] => `lh_chat`.`uagent`
[auto_responder_id] => `lh_chat`.`auto_responder_id`
[erLhcoreClassModelChat] => lh_chat
)
[quoteValues:protected] => 1
[intervalMap:protected] => Array
(
[SECOND] => SECOND
[MINUTE] => MINUTE
[HOUR] => HOUR
[DAY] => DAY
[MONTH] => MONTH
[YEAR] => YEAR
)
)
)
)
)
[1] => Array
(
[file] => D:\xampp\htdocs\online\online\chatsupport\ezcomponents\PersistentObject\src\persistent_session.php
[line] => 194
[function] => find
[class] => ezcPersistentLoadHandler
[type] => ->
[args] => Array
(
[0] => ezcPersistentFindQuery Object
(
[properties:protected] => Array
(
[className] => erLhcoreClassModelChat
[query] => ezcQuerySelect Object
(
[selectString:protected] => SELECT `lh_chat`.`id`, `lh_chat`.`nick`, `lh_chat`.`status`, `lh_chat`.`status_sub`, `lh_chat`.`status_sub_arg`, `lh_chat`.`status_sub_sub`, `lh_chat`.`time`, `lh_chat`.`user_id`, `lh_chat`.`dep_id`, `lh_chat`.`product_id`, `lh_chat`.`user_status`, `lh_chat`.`user_closed_ts`, `lh_chat`.`support_informed`, `lh_chat`.`hash`, `lh_chat`.`ip`, `lh_chat`.`email`, `lh_chat`.`phone`, `lh_chat`.`referrer`, `lh_chat`.`session_referrer`, `lh_chat`.`country_code`, `lh_chat`.`country_name`, `lh_chat`.`remarks`, `lh_chat`.`lat`, `lh_chat`.`lon`, `lh_chat`.`city`, `lh_chat`.`user_typing`, `lh_chat`.`user_typing_txt`, `lh_chat`.`operator_typing`, `lh_chat`.`operator_typing_id`, `lh_chat`.`has_unread_messages`, `lh_chat`.`user_tz_identifier`, `lh_chat`.`unread_messages_informed`, `lh_chat`.`reinform_timeout`, `lh_chat`.`last_user_msg_time`, `lh_chat`.`last_msg_id`, `lh_chat`.`mail_send`, `lh_chat`.`additional_data`, `lh_chat`.`wait_time`, `lh_chat`.`chat_duration`, `lh_chat`.`chat_variables`, `lh_chat`.`priority`, `lh_chat`.`chat_initiator`, `lh_chat`.`online_user_id`, `lh_chat`.`operation`, `lh_chat`.`operation_admin`, `lh_chat`.`screenshot_id`, `lh_chat`.`transfer_timeout_ts`, `lh_chat`.`transfer_timeout_ac`, `lh_chat`.`transfer_if_na`, `lh_chat`.`transfer_uid`, `lh_chat`.`na_cb_executed`, `lh_chat`.`chat_locale`, `lh_chat`.`chat_locale_to`, `lh_chat`.`fbst`, `lh_chat`.`nc_cb_executed`, `lh_chat`.`tslasign`, `lh_chat`.`unanswered_chat`, `lh_chat`.`last_op_msg_time`, `lh_chat`.`has_unread_op_messages`, `lh_chat`.`lsync`, `lh_chat`.`unread_op_messages_informed`, `lh_chat`.`device_type`, `lh_chat`.`sender_user_id`, `lh_chat`.`usaccept`, `lh_chat`.`uagent`, `lh_chat`.`auto_responder_id`
[fromString:protected] => FROM `lh_chat`
[useIndexString:protected] =>
[whereString:protected] =>
[groupString:protected] =>
[havingString:protected] =>
[orderString:protected] => ORDER BY lh_chat.id DESC
[limitString:protected] => LIMIT 20 OFFSET 0
[lastInvokedMethod:protected] => order
[lockString:protected] =>
[db:protected] => ezcDbHandlerMysql Object
(
[identifierQuoteChars:protected] => Array
(
[start] => `
[end] => `
)
[dbParams:ezcDbHandlerMysql:private] => Array
(
[phptype] => mysql
[dbsyntax] => mysql
[username] => root
[password] => ***
[protocol] => tcp
[hostspec] => 127.0.0.1
[port] => 3306
[socket] =>
[database] => chats
)
[dsn:ezcDbHandlerMysql:private] => mysql:dbname=chats;host=127.0.0.1;port=3306
[reconnectedCounter:ezcDbHandlerMysql:private] => 0
[transactionNestingLevel:protected] => 0
[transactionErrorFlag:protected] =>
)
[aliases:ezcQuery:private] => Array
(
[id] => `lh_chat`.`id`
[nick] => `lh_chat`.`nick`
[status] => `lh_chat`.`status`
[status_sub] => `lh_chat`.`status_sub`
[status_sub_arg] => `lh_chat`.`status_sub_arg`
[status_sub_sub] => `lh_chat`.`status_sub_sub`
[time] => `lh_chat`.`time`
[user_id] => `lh_chat`.`user_id`
[dep_id] => `lh_chat`.`dep_id`
[product_id] => `lh_chat`.`product_id`
[user_status] => `lh_chat`.`user_status`
[user_closed_ts] => `lh_chat`.`user_closed_ts`
[support_informed] => `lh_chat`.`support_informed`
[hash] => `lh_chat`.`hash`
[ip] => `lh_chat`.`ip`
[email] => `lh_chat`.`email`
[phone] => `lh_chat`.`phone`
[referrer] => `lh_chat`.`referrer`
[session_referrer] => `lh_chat`.`session_referrer`
[country_code] => `lh_chat`.`country_code`
[country_name] => `lh_chat`.`country_name`
[remarks] => `lh_chat`.`remarks`
[lat] => `lh_chat`.`lat`
[lon] => `lh_chat`.`lon`
[city] => `lh_chat`.`city`
[user_typing] => `lh_chat`.`user_typing`
[user_typing_txt] => `lh_chat`.`user_typing_txt`
[operator_typing] => `lh_chat`.`operator_typing`
[operator_typing_id] => `lh_chat`.`operator_typing_id`
[has_unread_messages] => `lh_chat`.`has_unread_messages`
[user_tz_identifier] => `lh_chat`.`user_tz_identifier`
[unread_messages_informed] => `lh_chat`.`unread_messages_informed`
[reinform_timeout] => `lh_chat`.`reinform_timeout`
[last_user_msg_time] => `lh_chat`.`last_user_msg_time`
[last_msg_id] => `lh_chat`.`last_msg_id`
[mail_send] => `lh_chat`.`mail_send`
[additional_data] => `lh_chat`.`additional_data`
[wait_time] => `lh_chat`.`wait_time`
[chat_duration] => `lh_chat`.`chat_duration`
[chat_variables] => `lh_chat`.`chat_variables`
[priority] => `lh_chat`.`priority`
[chat_initiator] => `lh_chat`.`chat_initiator`
[online_user_id] => `lh_chat`.`online_user_id`
[operation] => `lh_chat`.`operation`
[operation_admin] => `lh_chat`.`operation_admin`
[screenshot_id] => `lh_chat`.`screenshot_id`
[transfer_timeout_ts] => `lh_chat`.`transfer_timeout_ts`
[transfer_timeout_ac] => `lh_chat`.`transfer_timeout_ac`
[transfer_if_na] => `lh_chat`.`transfer_if_na`
[transfer_uid] => `lh_chat`.`transfer_uid`
[na_cb_executed] => `lh_chat`.`na_cb_executed`
[chat_locale] => `lh_chat`.`chat_locale`
[chat_locale_to] => `lh_chat`.`chat_locale_to`
[fbst] => `lh_chat`.`fbst`
[nc_cb_executed] => `lh_chat`.`nc_cb_executed`
[tslasign] => `lh_chat`.`tslasign`
[unanswered_chat] => `lh_chat`.`unanswered_chat`
[last_op_msg_time] => `lh_chat`.`last_op_msg_time`
[has_unread_op_messages] => `lh_chat`.`has_unread_op_messages`
[lsync] => `lh_chat`.`lsync`
[unread_op_messages_informed] => `lh_chat`.`unread_op_messages_informed`
[device_type] => `lh_chat`.`device_type`
[sender_user_id] => `lh_chat`.`sender_user_id`
[usaccept] => `lh_chat`.`usaccept`
[uagent] => `lh_chat`.`uagent`
[auto_responder_id] => `lh_chat`.`auto_responder_id`
[erLhcoreClassModelChat] => lh_chat
)
[boundCounter:ezcQuery:private] => 0
[boundParameters:ezcQuery:private] => Array
(
)
[boundParametersType:ezcQuery:private] => Array
(
)
[boundValues:ezcQuery:private] => Array
(
)
[boundValuesType:ezcQuery:private] => Array
(
)
[expr] => ezcQueryExpression Object
(
[db:protected] => ezcDbHandlerMysql Object
(
[identifierQuoteChars:protected] => Array
(
[start] => `
[end] => `
)
[dbParams:ezcDbHandlerMysql:private] => Array
(
[phptype] => mysql
[dbsyntax] => mysql
[username] => root
[password] => ***
[protocol] => tcp
[hostspec] => 127.0.0.1
[port] => 3306
[socket] =>
[database] => chats
)
[dsn:ezcDbHandlerMysql:private] => mysql:dbname=chats;host=127.0.0.1;port=3306
[reconnectedCounter:ezcDbHandlerMysql:private] => 0
[transactionNestingLevel:protected] => 0
[transactionErrorFlag:protected] =>
)
[aliases:ezcQueryExpression:private] => Array
(
[id] => `lh_chat`.`id`
[nick] => `lh_chat`.`nick`
[status] => `lh_chat`.`status`
[status_sub] => `lh_chat`.`status_sub`
[status_sub_arg] => `lh_chat`.`status_sub_arg`
[status_sub_sub] => `lh_chat`.`status_sub_sub`
[time] => `lh_chat`.`time`
[user_id] => `lh_chat`.`user_id`
[dep_id] => `lh_chat`.`dep_id`
[product_id] => `lh_chat`.`product_id`
[user_status] => `lh_chat`.`user_status`
[user_closed_ts] => `lh_chat`.`user_closed_ts`
[support_informed] => `lh_chat`.`support_informed`
[hash] => `lh_chat`.`hash`
[ip] => `lh_chat`.`ip`
[email] => `lh_chat`.`email`
[phone] => `lh_chat`.`phone`
[referrer] => `lh_chat`.`referrer`
[session_referrer] => `lh_chat`.`session_referrer`
[country_code] => `lh_chat`.`country_code`
[country_name] => `lh_chat`.`country_name`
[remarks] => `lh_chat`.`remarks`
[lat] => `lh_chat`.`lat`
[lon] => `lh_chat`.`lon`
[city] => `lh_chat`.`city`
[user_typing] => `lh_chat`.`user_typing`
[user_typing_txt] => `lh_chat`.`user_typing_txt`
[operator_typing] => `lh_chat`.`operator_typing`
[operator_typing_id] => `lh_chat`.`operator_typing_id`
[has_unread_messages] => `lh_chat`.`has_unread_messages`
[user_tz_identifier] => `lh_chat`.`user_tz_identifier`
[unread_messages_informed] => `lh_chat`.`unread_messages_informed`
[reinform_timeout] => `lh_chat`.`reinform_timeout`
[last_user_msg_time] => `lh_chat`.`last_user_msg_time`
[last_msg_id] => `lh_chat`.`last_msg_id`
[mail_send] => `lh_chat`.`mail_send`
[additional_data] => `lh_chat`.`additional_data`
[wait_time] => `lh_chat`.`wait_time`
[chat_duration] => `lh_chat`.`chat_duration`
[chat_variables] => `lh_chat`.`chat_variables`
[priority] => `lh_chat`.`priority`
[chat_initiator] => `lh_chat`.`chat_initiator`
[online_user_id] => `lh_chat`.`online_user_id`
[operation] => `lh_chat`.`operation`
[operation_admin] => `lh_chat`.`operation_admin`
[screenshot_id] => `lh_chat`.`screenshot_id`
[transfer_timeout_ts] => `lh_chat`.`transfer_timeout_ts`
[transfer_timeout_ac] => `lh_chat`.`transfer_timeout_ac`
[transfer_if_na] => `lh_chat`.`transfer_if_na`
[transfer_uid] => `lh_chat`.`transfer_uid`
[na_cb_executed] => `lh_chat`.`na_cb_executed`
[chat_locale] => `lh_chat`.`chat_locale`
[chat_locale_to] => `lh_chat`.`chat_locale_to`
[fbst] => `lh_chat`.`fbst`
[nc_cb_executed] => `lh_chat`.`nc_cb_executed`
[tslasign] => `lh_chat`.`tslasign`
[unanswered_chat] => `lh_chat`.`unanswered_chat`
[last_op_msg_time] => `lh_chat`.`last_op_msg_time`
[has_unread_op_messages] => `lh_chat`.`has_unread_op_messages`
[lsync] => `lh_chat`.`lsync`
[unread_op_messages_informed] => `lh_chat`.`unread_op_messages_informed`
[device_type] => `lh_chat`.`device_type`
[sender_user_id] => `lh_chat`.`sender_user_id`
[usaccept] => `lh_chat`.`usaccept`
[uagent] => `lh_chat`.`uagent`
[auto_responder_id] => `lh_chat`.`auto_responder_id`
[erLhcoreClassModelChat] => lh_chat
)
[quoteValues:protected] => 1
[intervalMap:protected] => Array
(
[SECOND] => SECOND
[MINUTE] => MINUTE
[HOUR] => HOUR
[DAY] => DAY
[MONTH] => MONTH
[YEAR] => YEAR
)
)
)
)
)
[1] =>
)
)
[2] => Array
(
[file] => D:\xampp\htdocs\online\online\chatsupport\lib\core\lhcore\lhdbtrait.php
[line] => 278
[function] => find
[class] => ezcPersistentSession
[type] => ->
[args] => Array
(
[0] => ezcPersistentFindQuery Object
(
[properties:protected] => Array
(
[className] => erLhcoreClassModelChat
[query] => ezcQuerySelect Object
(
[selectString:protected] => SELECT `lh_chat`.`id`, `lh_chat`.`nick`, `lh_chat`.`status`, `lh_chat`.`status_sub`, `lh_chat`.`status_sub_arg`, `lh_chat`.`status_sub_sub`, `lh_chat`.`time`, `lh_chat`.`user_id`, `lh_chat`.`dep_id`, `lh_chat`.`product_id`, `lh_chat`.`user_status`, `lh_chat`.`user_closed_ts`, `lh_chat`.`support_informed`, `lh_chat`.`hash`, `lh_chat`.`ip`, `lh_chat`.`email`, `lh_chat`.`phone`, `lh_chat`.`referrer`, `lh_chat`.`session_referrer`, `lh_chat`.`country_code`, `lh_chat`.`country_name`, `lh_chat`.`remarks`, `lh_chat`.`lat`, `lh_chat`.`lon`, `lh_chat`.`city`, `lh_chat`.`user_typing`, `lh_chat`.`user_typing_txt`, `lh_chat`.`operator_typing`, `lh_chat`.`operator_typing_id`, `lh_chat`.`has_unread_messages`, `lh_chat`.`user_tz_identifier`, `lh_chat`.`unread_messages_informed`, `lh_chat`.`reinform_timeout`, `lh_chat`.`last_user_msg_time`, `lh_chat`.`last_msg_id`, `lh_chat`.`mail_send`, `lh_chat`.`additional_data`, `lh_chat`.`wait_time`, `lh_chat`.`chat_duration`, `lh_chat`.`chat_variables`, `lh_chat`.`priority`, `lh_chat`.`chat_initiator`, `lh_chat`.`online_user_id`, `lh_chat`.`operation`, `lh_chat`.`operation_admin`, `lh_chat`.`screenshot_id`, `lh_chat`.`transfer_timeout_ts`, `lh_chat`.`transfer_timeout_ac`, `lh_chat`.`transfer_if_na`, `lh_chat`.`transfer_uid`, `lh_chat`.`na_cb_executed`, `lh_chat`.`chat_locale`, `lh_chat`.`chat_locale_to`, `lh_chat`.`fbst`, `lh_chat`.`nc_cb_executed`, `lh_chat`.`tslasign`, `lh_chat`.`unanswered_chat`, `lh_chat`.`last_op_msg_time`, `lh_chat`.`has_unread_op_messages`, `lh_chat`.`lsync`, `lh_chat`.`unread_op_messages_informed`, `lh_chat`.`device_type`, `lh_chat`.`sender_user_id`, `lh_chat`.`usaccept`, `lh_chat`.`uagent`, `lh_chat`.`auto_responder_id`
[fromString:protected] => FROM `lh_chat`
[useIndexString:protected] =>
[whereString:protected] =>
[groupString:protected] =>
[havingString:protected] =>
[orderString:protected] => ORDER BY lh_chat.id DESC
[limitString:protected] => LIMIT 20 OFFSET 0
[lastInvokedMethod:protected] => order
[lockString:protected] =>
[db:protected] => ezcDbHandlerMysql Object
(
[identifierQuoteChars:protected] => Array
(
[start] => `
[end] => `
)
[dbParams:ezcDbHandlerMysql:private] => Array
(
[phptype] => mysql
[dbsyntax] => mysql
[username] => root
[password] => ***
[protocol] => tcp
[hostspec] => 127.0.0.1
[port] => 3306
[socket] =>
[database] => chats
)
[dsn:ezcDbHandlerMysql:private] => mysql:dbname=chats;host=127.0.0.1;port=3306
[reconnectedCounter:ezcDbHandlerMysql:private] => 0
[transactionNestingLevel:protected] => 0
[transactionErrorFlag:protected] =>
)
[aliases:ezcQuery:private] => Array
(
[id] => `lh_chat`.`id`
[nick] => `lh_chat`.`nick`
[status] => `lh_chat`.`status`
[status_sub] => `lh_chat`.`status_sub`
[status_sub_arg] => `lh_chat`.`status_sub_arg`
[status_sub_sub] => `lh_chat`.`status_sub_sub`
[time] => `lh_chat`.`time`
[user_id] => `lh_chat`.`user_id`
[dep_id] => `lh_chat`.`dep_id`
[product_id] => `lh_chat`.`product_id`
[user_status] => `lh_chat`.`user_status`
[user_closed_ts] => `lh_chat`.`user_closed_ts`
[support_informed] => `lh_chat`.`support_informed`
[hash] => `lh_chat`.`hash`
[ip] => `lh_chat`.`ip`
[email] => `lh_chat`.`email`
[phone] => `lh_chat`.`phone`
[referrer] => `lh_chat`.`referrer`
[session_referrer] => `lh_chat`.`session_referrer`
[country_code] => `lh_chat`.`country_code`
[country_name] => `lh_chat`.`country_name`
[remarks] => `lh_chat`.`remarks`
[lat] => `lh_chat`.`lat`
[lon] => `lh_chat`.`lon`
[city] => `lh_chat`.`city`
[user_typing] => `lh_chat`.`user_typing`
[user_typing_txt] => `lh_chat`.`user_typing_txt`
[operator_typing] => `lh_chat`.`operator_typing`
[operator_typing_id] => `lh_chat`.`operator_typing_id`
[has_unread_messages] => `lh_chat`.`has_unread_messages`
[user_tz_identifier] => `lh_chat`.`user_tz_identifier`
[unread_messages_informed] => `lh_chat`.`unread_messages_informed`
[reinform_timeout] => `lh_chat`.`reinform_timeout`
[last_user_msg_time] => `lh_chat`.`last_user_msg_time`
[last_msg_id] => `lh_chat`.`last_msg_id`
[mail_send] => `lh_chat`.`mail_send`
[additional_data] => `lh_chat`.`additional_data`
[wait_time] => `lh_chat`.`wait_time`
[chat_duration] => `lh_chat`.`chat_duration`
[chat_variables] => `lh_chat`.`chat_variables`
[priority] => `lh_chat`.`priority`
[chat_initiator] => `lh_chat`.`chat_initiator`
[online_user_id] => `lh_chat`.`online_user_id`
[operation] => `lh_chat`.`operation`
[operation_admin] => `lh_chat`.`operation_admin`
[screenshot_id] => `lh_chat`.`screenshot_id`
[transfer_timeout_ts] => `lh_chat`.`transfer_timeout_ts`
[transfer_timeout_ac] => `lh_chat`.`transfer_timeout_ac`
[transfer_if_na] => `lh_chat`.`transfer_if_na`
[transfer_uid] => `lh_chat`.`transfer_uid`
[na_cb_executed] => `lh_chat`.`na_cb_executed`
[chat_locale] => `lh_chat`.`chat_locale`
[chat_locale_to] => `lh_chat`.`chat_locale_to`
[fbst] => `lh_chat`.`fbst`
[nc_cb_executed] => `lh_chat`.`nc_cb_executed`
[tslasign] => `lh_chat`.`tslasign`
[unanswered_chat] => `lh_chat`.`unanswered_chat`
[last_op_msg_time] => `lh_chat`.`last_op_msg_time`
[has_unread_op_messages] => `lh_chat`.`has_unread_op_messages`
[lsync] => `lh_chat`.`lsync`
[unread_op_messages_informed] => `lh_chat`.`unread_op_messages_informed`
[device_type] => `lh_chat`.`device_type`
[sender_user_id] => `lh_chat`.`sender_user_id`
[usaccept] => `lh_chat`.`usaccept`
[uagent] => `lh_chat`.`uagent`
[auto_responder_id] => `lh_chat`.`auto_responder_id`
[erLhcoreClassModelChat] => lh_chat
)
[boundCounter:ezcQuery:private] => 0
[boundParameters:ezcQuery:private] => Array
(
)
[boundParametersType:ezcQuery:private] => Array
(
)
[boundValues:ezcQuery:private] => Array
(
)
[boundValuesType:ezcQuery:private] => Array
(
)
[expr] => ezcQueryExpression Object
(
[db:protected] => ezcDbHandlerMysql Object
(
[identifierQuoteChars:protected] => Array
(
[start] => `
[end] => `
)
[dbParams:ezcDbHandlerMysql:private] => Array
(
[phptype] => mysql
[dbsyntax] => mysql
[username] => root
[password] => ***
[protocol] => tcp
[hostspec] => 127.0.0.1
[port] => 3306
[socket] =>
[database] => chats
)
[dsn:ezcDbHandlerMysql:private] => mysql:dbname=chats;host=127.0.0.1;port=3306
[reconnectedCounter:ezcDbHandlerMysql:private] => 0
[transactionNestingLevel:protected] => 0
[transactionErrorFlag:protected] =>
)
[aliases:ezcQueryExpression:private] => Array
(
[id] => `lh_chat`.`id`
[nick] => `lh_chat`.`nick`
[status] => `lh_chat`.`status`
[status_sub] => `lh_chat`.`status_sub`
[status_sub_arg] => `lh_chat`.`status_sub_arg`
[status_sub_sub] => `lh_chat`.`status_sub_sub`
[time] => `lh_chat`.`time`
[user_id] => `lh_chat`.`user_id`
[dep_id] => `lh_chat`.`dep_id`
[product_id] => `lh_chat`.`product_id`
[user_status] => `lh_chat`.`user_status`
[user_closed_ts] => `lh_chat`.`user_closed_ts`
[support_informed] => `lh_chat`.`support_informed`
[hash] => `lh_chat`.`hash`
[ip] => `lh_chat`.`ip`
[email] => `lh_chat`.`email`
[phone] => `lh_chat`.`phone`
[referrer] => `lh_chat`.`referrer`
[session_referrer] => `lh_chat`.`session_referrer`
[country_code] => `lh_chat`.`country_code`
[country_name] => `lh_chat`.`country_name`
[remarks] => `lh_chat`.`remarks`
[lat] => `lh_chat`.`lat`
[lon] => `lh_chat`.`lon`
[city] => `lh_chat`.`city`
[user_typing] => `lh_chat`.`user_typing`
[user_typing_txt] => `lh_chat`.`user_typing_txt`
[operator_typing] => `lh_chat`.`operator_typing`
[operator_typing_id] => `lh_chat`.`operator_typing_id`
[has_unread_messages] => `lh_chat`.`has_unread_messages`
[user_tz_identifier] => `lh_chat`.`user_tz_identifier`
[unread_messages_informed] => `lh_chat`.`unread_messages_informed`
[reinform_timeout] => `lh_chat`.`reinform_timeout`
[last_user_msg_time] => `lh_chat`.`last_user_msg_time`
[last_msg_id] => `lh_chat`.`last_msg_id`
[mail_send] => `lh_chat`.`mail_send`
[additional_data] => `lh_chat`.`additional_data`
[wait_time] => `lh_chat`.`wait_time`
[chat_duration] => `lh_chat`.`chat_duration`
[chat_variables] => `lh_chat`.`chat_variables`
[priority] => `lh_chat`.`priority`
[chat_initiator] => `lh_chat`.`chat_initiator`
[online_user_id] => `lh_chat`.`online_user_id`
[operation] => `lh_chat`.`operation`
[operation_admin] => `lh_chat`.`operation_admin`
[screenshot_id] => `lh_chat`.`screenshot_id`
[transfer_timeout_ts] => `lh_chat`.`transfer_timeout_ts`
[transfer_timeout_ac] => `lh_chat`.`transfer_timeout_ac`
[transfer_if_na] => `lh_chat`.`transfer_if_na`
[transfer_uid] => `lh_chat`.`transfer_uid`
[na_cb_executed] => `lh_chat`.`na_cb_executed`
[chat_locale] => `lh_chat`.`chat_locale`
[chat_locale_to] => `lh_chat`.`chat_locale_to`
[fbst] => `lh_chat`.`fbst`
[nc_cb_executed] => `lh_chat`.`nc_cb_executed`
[tslasign] => `lh_chat`.`tslasign`
[unanswered_chat] => `lh_chat`.`unanswered_chat`
[last_op_msg_time] => `lh_chat`.`last_op_msg_time`
[has_unread_op_messages] => `lh_chat`.`has_unread_op_messages`
[lsync] => `lh_chat`.`lsync`
[unread_op_messages_informed] => `lh_chat`.`unread_op_messages_informed`
[device_type] => `lh_chat`.`device_type`
[sender_user_id] => `lh_chat`.`sender_user_id`
[usaccept] => `lh_chat`.`usaccept`
[uagent] => `lh_chat`.`uagent`
[auto_responder_id] => `lh_chat`.`auto_responder_id`
[erLhcoreClassModelChat] => lh_chat
)
[quoteValues:protected] => 1
[intervalMap:protected] => Array
(
[SECOND] => SECOND
[MINUTE] => MINUTE
[HOUR] => HOUR
[DAY] => DAY
[MONTH] => MONTH
[YEAR] => YEAR
)
)
)
)
)
)
)
[3] => Array
(
[file] => D:\xampp\htdocs\online\online\chatsupport\cache\compiledtemplates\05fa59ade5cc79d08d7d4482ae07b94f.php
[line] => 2
[function] => getList
[class] => erLhcoreClassModelChat
[type] => ::
[args] => Array
(
[0] => Array
(
[smart_select] => 1
[limit] => 20
[offset] => 0
)
)
)
[4] => Array
(
[file] => D:\xampp\htdocs\online\online\chatsupport\lib\core\lhcore\lhmodule.php
[line] => 98
[args] => Array
(
[0] => D:\xampp\htdocs\online\online\chatsupport\cache\compiledtemplates\05fa59ade5cc79d08d7d4482ae07b94f.php
)
[function] => include
)
[5] => Array
(
[file] => D:\xampp\htdocs\online\online\chatsupport\lib\core\lhcore\lhmodule.php
[line] => 486
[function] => runModule
[class] => erLhcoreClassModule
[type] => ::
[args] => Array
(
)
)
[6] => Array
(
[file] => D:\xampp\htdocs\online\online\chatsupport\index.php
[line] => 39
[function] => moduleInit
[class] => erLhcoreClassModule
[type] => ::
[args] => Array
(
)
)
)
[previous:Exception:private] =>
)Last edited by crashedbyme (2017-10-14 09:13:07)
Offline
#2 2017-10-14 09:39:49
- PeopleInside
- Administrator
- From: Italy
- Registered: 2014-04-10
- Posts: 4,046
- Website
Re: Not able to connect to chat support and chat list is showing 503 error
Hi crashedbyme,
welcome in the live helper chat forum !
Thank you for your interest in the live helper chat open source project!
I AM sorry to read about issue on upgrading, this should not happen usually.
Before every update we suggest to make a full folder and database backup, if something went wrong you will be able to resume your backup.
My suggestion is to resume the old backup than try to follow the FAQ here:
05 - Fix common issue on the first install of Live helper chat.
If you are unable to fix the issue you can try a clean install near the old with a different folder name,
if this works you can transfer all settings on the new chat.
If you need to fix the issue in the existent chat you have to consider the commercial support.
11 - Commercial Support
I hope you will be able to fix the issue soon!
Have a great day!
PeopleInside - Live helper chat - free limited forum support!
For commercial support or GitHub [see FAQ here]
If you want to support this open source project, just donate [see support page]
Something wrong with the forum? [contact a superhero]
Offline