Live Helper Chat support forum.. Forum is locked. New place for questions - Github Discussions

You are not logged in.

Announcement

#1 2019-01-04 12:44:10

tiagocaus
Member
Registered: 2015-03-02
Posts: 23

My chat stopped working after I upgraded to the latest version.

My chat stopped working after I upgraded to the latest version.

After I type my password, there is a white screen.

Offline

#2 2019-01-04 12:52:38

PeopleInside
Administrator
From: Italy
Registered: 2014-04-10
Posts: 4,046
Website

Re: My chat stopped working after I upgraded to the latest version.

Hi tiagocaus , thank you for your question on the live helper chat forum!
I am sorry to see you are having issue on upgrading LHC.

Before upgrade i strongly suggest to do a full folder and database backup.
If you are seeing a blank screen i suggest to turn on debug mode and try to login again and see error logs printed on the page also check your server error log file.

Are you sure to have following the upgrade procedure and all necessary folder has been transferred?
Maybe try again the upgrade process can help.


lol PeopleInside - Live helper chat - free limited forum support!
wink For commercial support or GitHub [see FAQ here]
ops If you want to support this open source project, just donate [see support page]
glasses Something wrong with the forum? [contact a superhero]

Offline

#3 2019-01-04 12:53:21

PeopleInside
Administrator
From: Italy
Registered: 2014-04-10
Posts: 4,046
Website

Re: My chat stopped working after I upgraded to the latest version.


lol PeopleInside - Live helper chat - free limited forum support!
wink For commercial support or GitHub [see FAQ here]
ops If you want to support this open source project, just donate [see support page]
glasses Something wrong with the forum? [contact a superhero]

Offline

#4 2019-01-04 22:16:35

tiagocaus
Member
Registered: 2015-03-02
Posts: 23

Re: My chat stopped working after I upgraded to the latest version.

Hello, I'll do the debugging.
From the beginning I have been updating always following the informed procedure, I never had problem this is the first time.

In debugging you have a lot of information, including sensitive information such as database data.

What information is most important for me to put here?

Offline

#5 2019-01-04 22:22:43

tiagocaus
Member
Registered: 2015-03-02
Posts: 23

Re: My chat stopped working after I upgraded to the latest version.

[== PHP ==]
ezcPersistentQueryException Object
(
    [originalMessage] => A query failed internally in Persistent Object: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lh_users.pswd_updated' in 'field list' Query: 'SELECT `lh_users`.`id`, `lh_users`.`username`, `lh_users`.`password`, `lh_users`.`email`, `lh_users`.`name`, `lh_users`.`chat_nickname`, `lh_users`.`skype`, `lh_users`.`xmpp_username`, `lh_users`.`surname`, `lh_users`.`job_title`, `lh_users`.`disabled`, `lh_users`.`hide_online`, `lh_users`.`all_departments`, `lh_users`.`invisible_mode`, `lh_users`.`inactive_mode`, `lh_users`.`active_chats_counter`, `lh_users`.`closed_chats_counter`, `lh_users`.`pending_chats_counter`, `lh_users`.`departments_ids`, `lh_users`.`rec_per_req`, `lh_users`.`filepath`, `lh_users`.`filename`, `lh_users`.`time_zone`, `lh_users`.`session_id`, `lh_users`.`operation_admin`, `lh_users`.`max_active_chats`, `lh_users`.`auto_accept`, `lh_users`.`exclude_autoasign`, `lh_users`.`attr_int_1`, `lh_users`.`attr_int_2`, `lh_users`.`attr_int_3`, `lh_users`.`pswd_updated` FROM `lh_users` WHERE `lh_users`.`username` = :ezcValue1 ORDER BY id DESC LIMIT 1 OFFSET 0'
    [message:protected] => A query failed internally in Persistent Object: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lh_users.pswd_updated' in 'field list' Query: 'SELECT `lh_users`.`id`, `lh_users`.`username`, `lh_users`.`password`, `lh_users`.`email`, `lh_users`.`name`, `lh_users`.`chat_nickname`, `lh_users`.`skype`, `lh_users`.`xmpp_username`, `lh_users`.`surname`, `lh_users`.`job_title`, `lh_users`.`disabled`, `lh_users`.`hide_online`, `lh_users`.`all_departments`, `lh_users`.`invisible_mode`, `lh_users`.`inactive_mode`, `lh_users`.`active_chats_counter`, `lh_users`.`closed_chats_counter`, `lh_users`.`pending_chats_counter`, `lh_users`.`departments_ids`, `lh_users`.`rec_per_req`, `lh_users`.`filepath`, `lh_users`.`filename`, `lh_users`.`time_zone`, `lh_users`.`session_id`, `lh_users`.`operation_admin`, `lh_users`.`max_active_chats`, `lh_users`.`auto_accept`, `lh_users`.`exclude_autoasign`, `lh_users`.`attr_int_1`, `lh_users`.`attr_int_2`, `lh_users`.`attr_int_3`, `lh_users`.`pswd_updated` FROM `lh_users` WHERE `lh_users`.`username` = :ezcValue1 ORDER BY id DESC LIMIT 1 OFFSET 0'
    [string:Exception:private] => 
    [code:protected] => 0
    [file:protected] => /home/XXXXXX/public_html/chat/ezcomponents/PersistentObject/src/persistent_session.php
    [line:protected] => 828
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/XXXXXX/public_html/chat/ezcomponents/PersistentObject/src/handlers/load_handler.php
                    [line] => 269
                    [function] => performQuery
                    [class] => ezcPersistentSession
                    [type] => ->
                    [args] => Array
                        (
                            [0] => ezcQuerySelect Object
                                (
                                    [selectString:protected] => SELECT `lh_users`.`id`, `lh_users`.`username`, `lh_users`.`password`, `lh_users`.`email`, `lh_users`.`name`, `lh_users`.`chat_nickname`, `lh_users`.`skype`, `lh_users`.`xmpp_username`, `lh_users`.`surname`, `lh_users`.`job_title`, `lh_users`.`disabled`, `lh_users`.`hide_online`, `lh_users`.`all_departments`, `lh_users`.`invisible_mode`, `lh_users`.`inactive_mode`, `lh_users`.`active_chats_counter`, `lh_users`.`closed_chats_counter`, `lh_users`.`pending_chats_counter`, `lh_users`.`departments_ids`, `lh_users`.`rec_per_req`, `lh_users`.`filepath`, `lh_users`.`filename`, `lh_users`.`time_zone`, `lh_users`.`session_id`, `lh_users`.`operation_admin`, `lh_users`.`max_active_chats`, `lh_users`.`auto_accept`, `lh_users`.`exclude_autoasign`, `lh_users`.`attr_int_1`, `lh_users`.`attr_int_2`, `lh_users`.`attr_int_3`, `lh_users`.`pswd_updated`
                                    [fromString:protected] => FROM `lh_users`
                                    [useIndexString:protected] => 
                                    [whereString:protected] => WHERE `lh_users`.`username` = :ezcValue1
                                    [groupString:protected] => 
                                    [havingString:protected] => 
                                    [orderString:protected] => ORDER BY id DESC
                                    [limitString:protected] => LIMIT 1 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] => nameDatabase
                                                    [password] => passwordxx
                                                    [protocol] => tcp
                                                    [hostspec] => localhost
                                                    [port] => 3306
                                                    [socket] => 
                                                    [database] => nameDatabase
                                                )

                                            [dsn:ezcDbHandlerMysql:private] => mysql:dbname=nameDatabase;host=localhost;port=3306
                                            [reconnectedCounter:ezcDbHandlerMysql:private] => 0
                                            [transactionNestingLevel:protected] => 0
                                            [transactionErrorFlag:protected] => 
                                        )

                                    [aliases:ezcQuery:private] => Array
                                        (
                                            [id] => `lh_users`.`id`
                                            [username] => `lh_users`.`username`
                                            [password] => `lh_users`.`password`
                                            [email] => `lh_users`.`email`
                                            [name] => `lh_users`.`name`
                                            [chat_nickname] => `lh_users`.`chat_nickname`
                                            [skype] => `lh_users`.`skype`
                                            [xmpp_username] => `lh_users`.`xmpp_username`
                                            [surname] => `lh_users`.`surname`
                                            [job_title] => `lh_users`.`job_title`
                                            [disabled] => `lh_users`.`disabled`
                                            [hide_online] => `lh_users`.`hide_online`
                                            [all_departments] => `lh_users`.`all_departments`
                                            [invisible_mode] => `lh_users`.`invisible_mode`
                                            [inactive_mode] => `lh_users`.`inactive_mode`
                                            [active_chats_counter] => `lh_users`.`active_chats_counter`
                                            [closed_chats_counter] => `lh_users`.`closed_chats_counter`
                                            [pending_chats_counter] => `lh_users`.`pending_chats_counter`
                                            [departments_ids] => `lh_users`.`departments_ids`
                                            [rec_per_req] => `lh_users`.`rec_per_req`
                                            [filepath] => `lh_users`.`filepath`
                                            [filename] => `lh_users`.`filename`
                                            [time_zone] => `lh_users`.`time_zone`
                                            [session_id] => `lh_users`.`session_id`
                                            [operation_admin] => `lh_users`.`operation_admin`
                                            [max_active_chats] => `lh_users`.`max_active_chats`
                                            [auto_accept] => `lh_users`.`auto_accept`
                                            [exclude_autoasign] => `lh_users`.`exclude_autoasign`
                                            [attr_int_1] => `lh_users`.`attr_int_1`
                                            [attr_int_2] => `lh_users`.`attr_int_2`
                                            [attr_int_3] => `lh_users`.`attr_int_3`
                                            [pswd_updated] => `lh_users`.`pswd_updated`
                                            [erLhcoreClassModelUser] => lh_users
                                        )

                                    [boundCounter:ezcQuery:private] => 1
                                    [boundParameters:ezcQuery:private] => Array
                                        (
                                        )

                                    [boundParametersType:ezcQuery:private] => Array
                                        (
                                        )

                                    [boundValues:ezcQuery:private] => Array
                                        (
                                            [:ezcValue1] => username
                                        )

                                    [boundValuesType:ezcQuery:private] => Array
                                        (
                                            [:ezcValue1] => 2
                                        )

                                    [expr] => ezcQueryExpression Object
                                        (
                                            [db:protected] => ezcDbHandlerMysql Object
                                                (
                                                    [identifierQuoteChars:protected] => Array
                                                        (
                                                            [start] => `
                                                            [end] => `
                                                        )

                                                    [dbParams:ezcDbHandlerMysql:private] => Array
                                                        (
                                                            [phptype] => mysql
                                                            [dbsyntax] => mysql
                                                            [username] => nameDatabase
                                                            [password] => passwordxx
                                                            [protocol] => tcp
                                                            [hostspec] => localhost
                                                            [port] => 3306
                                                            [socket] => 
                                                            [database] => nameDatabase
                                                        )

                                                    [dsn:ezcDbHandlerMysql:private] => mysql:dbname=nameDatabase;host=localhost;port=3306
                                                    [reconnectedCounter:ezcDbHandlerMysql:private] => 0
                                                    [transactionNestingLevel:protected] => 0
                                                    [transactionErrorFlag:protected] => 
                                                )

                                            [aliases:ezcQueryExpression:private] => Array
                                                (
                                                    [id] => `lh_users`.`id`
                                                    [username] => `lh_users`.`username`
                                                    [password] => `lh_users`.`password`
                                                    [email] => `lh_users`.`email`
                                                    [name] => `lh_users`.`name`
                                                    [chat_nickname] => `lh_users`.`chat_nickname`
                                                    [skype] => `lh_users`.`skype`
                                                    [xmpp_username] => `lh_users`.`xmpp_username`
                                                    [surname] => `lh_users`.`surname`
                                                    [job_title] => `lh_users`.`job_title`
                                                    [disabled] => `lh_users`.`disabled`
                                                    [hide_online] => `lh_users`.`hide_online`
                                                    [all_departments] => `lh_users`.`all_departments`
                                                    [invisible_mode] => `lh_users`.`invisible_mode`
                                                    [inactive_mode] => `lh_users`.`inactive_mode`
                                                    [active_chats_counter] => `lh_users`.`active_chats_counter`
                                                    [closed_chats_counter] => `lh_users`.`closed_chats_counter`
                                                    [pending_chats_counter] => `lh_users`.`pending_chats_counter`
                                                    [departments_ids] => `lh_users`.`departments_ids`
                                                    [rec_per_req] => `lh_users`.`rec_per_req`
                                                    [filepath] => `lh_users`.`filepath`
                                                    [filename] => `lh_users`.`filename`
                                                    [time_zone] => `lh_users`.`time_zone`
                                                    [session_id] => `lh_users`.`session_id`
                                                    [operation_admin] => `lh_users`.`operation_admin`
                                                    [max_active_chats] => `lh_users`.`max_active_chats`
                                                    [auto_accept] => `lh_users`.`auto_accept`
                                                    [exclude_autoasign] => `lh_users`.`exclude_autoasign`
                                                    [attr_int_1] => `lh_users`.`attr_int_1`
                                                    [attr_int_2] => `lh_users`.`attr_int_2`
                                                    [attr_int_3] => `lh_users`.`attr_int_3`
                                                    [pswd_updated] => `lh_users`.`pswd_updated`
                                                    [erLhcoreClassModelUser] => lh_users
                                                )

                                            [quoteValues:protected] => 1
                                            [intervalMap:protected] => Array
                                                (
                                                    [SECOND] => SECOND
                                                    [MINUTE] => MINUTE
                                                    [HOUR] => HOUR
                                                    [DAY] => DAY
                                                    [MONTH] => MONTH
                                                    [YEAR] => YEAR
                                                )

                                        )

                                )

                        )

                )

            [1] => Array
                (
                    [file] => /home/XXXXXX/public_html/chat/ezcomponents/PersistentObject/src/persistent_session.php
                    [line] => 194
                    [function] => find
                    [class] => ezcPersistentLoadHandler
                    [type] => ->
                    [args] => Array
                        (
                            [0] => ezcPersistentFindQuery Object
                                (
                                    [properties:protected] => Array
                                        (
                                            [className] => erLhcoreClassModelUser
                                            [query] => ezcQuerySelect Object
                                                (
                                                    [selectString:protected] => SELECT `lh_users`.`id`, `lh_users`.`username`, `lh_users`.`password`, `lh_users`.`email`, `lh_users`.`name`, `lh_users`.`chat_nickname`, `lh_users`.`skype`, `lh_users`.`xmpp_username`, `lh_users`.`surname`, `lh_users`.`job_title`, `lh_users`.`disabled`, `lh_users`.`hide_online`, `lh_users`.`all_departments`, `lh_users`.`invisible_mode`, `lh_users`.`inactive_mode`, `lh_users`.`active_chats_counter`, `lh_users`.`closed_chats_counter`, `lh_users`.`pending_chats_counter`, `lh_users`.`departments_ids`, `lh_users`.`rec_per_req`, `lh_users`.`filepath`, `lh_users`.`filename`, `lh_users`.`time_zone`, `lh_users`.`session_id`, `lh_users`.`operation_admin`, `lh_users`.`max_active_chats`, `lh_users`.`auto_accept`, `lh_users`.`exclude_autoasign`, `lh_users`.`attr_int_1`, `lh_users`.`attr_int_2`, `lh_users`.`attr_int_3`, `lh_users`.`pswd_updated`
                                                    [fromString:protected] => FROM `lh_users`
                                                    [useIndexString:protected] => 
                                                    [whereString:protected] => WHERE `lh_users`.`username` = :ezcValue1
                                                    [groupString:protected] => 
                                                    [havingString:protected] => 
                                                    [orderString:protected] => ORDER BY id DESC
                                                    [limitString:protected] => LIMIT 1 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] => nameDatabase
                                                                    [password] => passwordxx
                                                                    [protocol] => tcp
                                                                    [hostspec] => localhost
                                                                    [port] => 3306
                                                                    [socket] => 
                                                                    [database] => nameDatabase
                                                                )

                                                            [dsn:ezcDbHandlerMysql:private] => mysql:dbname=nameDatabase;host=localhost;port=3306
                                                            [reconnectedCounter:ezcDbHandlerMysql:private] => 0
                                                            [transactionNestingLevel:protected] => 0
                                                            [transactionErrorFlag:protected] => 
                                                        )

                                                    [aliases:ezcQuery:private] => Array
                                                        (
                                                            [id] => `lh_users`.`id`
                                                            [username] => `lh_users`.`username`
                                                            [password] => `lh_users`.`password`
                                                            [email] => `lh_users`.`email`
                                                            [name] => `lh_users`.`name`
                                                            [chat_nickname] => `lh_users`.`chat_nickname`
                                                            [skype] => `lh_users`.`skype`
                                                            [xmpp_username] => `lh_users`.`xmpp_username`
                                                            [surname] => `lh_users`.`surname`
                                                            [job_title] => `lh_users`.`job_title`
                                                            [disabled] => `lh_users`.`disabled`
                                                            [hide_online] => `lh_users`.`hide_online`
                                                            [all_departments] => `lh_users`.`all_departments`
                                                            [invisible_mode] => `lh_users`.`invisible_mode`
                                                            [inactive_mode] => `lh_users`.`inactive_mode`
                                                            [active_chats_counter] => `lh_users`.`active_chats_counter`
                                                            [closed_chats_counter] => `lh_users`.`closed_chats_counter`
                                                            [pending_chats_counter] => `lh_users`.`pending_chats_counter`
                                                            [departments_ids] => `lh_users`.`departments_ids`
                                                            [rec_per_req] => `lh_users`.`rec_per_req`
                                                            [filepath] => `lh_users`.`filepath`
                                                            [filename] => `lh_users`.`filename`
                                                            [time_zone] => `lh_users`.`time_zone`
                                                            [session_id] => `lh_users`.`session_id`
                                                            [operation_admin] => `lh_users`.`operation_admin`
                                                            [max_active_chats] => `lh_users`.`max_active_chats`
                                                            [auto_accept] => `lh_users`.`auto_accept`
                                                            [exclude_autoasign] => `lh_users`.`exclude_autoasign`
                                                            [attr_int_1] => `lh_users`.`attr_int_1`
                                                            [attr_int_2] => `lh_users`.`attr_int_2`
                                                            [attr_int_3] => `lh_users`.`attr_int_3`
                                                            [pswd_updated] => `lh_users`.`pswd_updated`
                                                            [erLhcoreClassModelUser] => lh_users
                                                        )

                                                    [boundCounter:ezcQuery:private] => 1
                                                    [boundParameters:ezcQuery:private] => Array
                                                        (
                                                        )

                                                    [boundParametersType:ezcQuery:private] => Array
                                                        (
                                                        )

                                                    [boundValues:ezcQuery:private] => Array
                                                        (
                                                            [:ezcValue1] => username
                                                        )

                                                    [boundValuesType:ezcQuery:private] => Array
                                                        (
                                                            [:ezcValue1] => 2
                                                        )

                                                    [expr] => ezcQueryExpression Object
                                                        (
                                                            [db:protected] => ezcDbHandlerMysql Object
                                                                (
                                                                    [identifierQuoteChars:protected] => Array
                                                                        (
                                                                            [start] => `
                                                                            [end] => `
                                                                        )

                                                                    [dbParams:ezcDbHandlerMysql:private] => Array
                                                                        (
                                                                            [phptype] => mysql
                                                                            [dbsyntax] => mysql
                                                                            [username] => nameDatabase
                                                                            [password] => passwordxx
                                                                            [protocol] => tcp
                                                                            [hostspec] => localhost
                                                                            [port] => 3306
                                                                            [socket] => 
                                                                            [database] => nameDatabase
                                                                        )

                                                                    [dsn:ezcDbHandlerMysql:private] => mysql:dbname=nameDatabase;host=localhost;port=3306
                                                                    [reconnectedCounter:ezcDbHandlerMysql:private] => 0
                                                                    [transactionNestingLevel:protected] => 0
                                                                    [transactionErrorFlag:protected] => 
                                                                )

                                                            [aliases:ezcQueryExpression:private] => Array
                                                                (
                                                                    [id] => `lh_users`.`id`
                                                                    [username] => `lh_users`.`username`
                                                                    [password] => `lh_users`.`password`
                                                                    [email] => `lh_users`.`email`
                                                                    [name] => `lh_users`.`name`
                                                                    [chat_nickname] => `lh_users`.`chat_nickname`
                                                                    [skype] => `lh_users`.`skype`
                                                                    [xmpp_username] => `lh_users`.`xmpp_username`
                                                                    [surname] => `lh_users`.`surname`
                                                                    [job_title] => `lh_users`.`job_title`
                                                                    [disabled] => `lh_users`.`disabled`
                                                                    [hide_online] => `lh_users`.`hide_online`
                                                                    [all_departments] => `lh_users`.`all_departments`
                                                                    [invisible_mode] => `lh_users`.`invisible_mode`
                                                                    [inactive_mode] => `lh_users`.`inactive_mode`
                                                                    [active_chats_counter] => `lh_users`.`active_chats_counter`
                                                                    [closed_chats_counter] => `lh_users`.`closed_chats_counter`
                                                                    [pending_chats_counter] => `lh_users`.`pending_chats_counter`
                                                                    [departments_ids] => `lh_users`.`departments_ids`
                                                                    [rec_per_req] => `lh_users`.`rec_per_req`
                                                                    [filepath] => `lh_users`.`filepath`
                                                                    [filename] => `lh_users`.`filename`
                                                                    [time_zone] => `lh_users`.`time_zone`
                                                                    [session_id] => `lh_users`.`session_id`
                                                                    [operation_admin] => `lh_users`.`operation_admin`
                                                                    [max_active_chats] => `lh_users`.`max_active_chats`
                                                                    [auto_accept] => `lh_users`.`auto_accept`
                                                                    [exclude_autoasign] => `lh_users`.`exclude_autoasign`
                                                                    [attr_int_1] => `lh_users`.`attr_int_1`
                                                                    [attr_int_2] => `lh_users`.`attr_int_2`
                                                                    [attr_int_3] => `lh_users`.`attr_int_3`
                                                                    [pswd_updated] => `lh_users`.`pswd_updated`
                                                                    [erLhcoreClassModelUser] => lh_users
                                                                )

                                                            [quoteValues:protected] => 1
                                                            [intervalMap:protected] => Array
                                                                (
                                                                    [SECOND] => SECOND
                                                                    [MINUTE] => MINUTE
                                                                    [HOUR] => HOUR
                                                                    [DAY] => DAY
                                                                    [MONTH] => MONTH
                                                                    [YEAR] => YEAR
                                                                )

                                                        )

                                                )

                                        )

                                )

                            [1] => 
                        )

                )

            [2] => Array
                (
                    [file] => /home/XXXXXX/public_html/chat/lib/models/lhuser/erlhcoreclassmodeluser.php
                    [line] => 287
                    [function] => find
                    [class] => ezcPersistentSession
                    [type] => ->
                    [args] => Array
                        (
                            [0] => ezcPersistentFindQuery Object
                                (
                                    [properties:protected] => Array
                                        (
                                            [className] => erLhcoreClassModelUser
                                            [query] => ezcQuerySelect Object
                                                (
                                                    [selectString:protected] => SELECT `lh_users`.`id`, `lh_users`.`username`, `lh_users`.`password`, `lh_users`.`email`, `lh_users`.`name`, `lh_users`.`chat_nickname`, `lh_users`.`skype`, `lh_users`.`xmpp_username`, `lh_users`.`surname`, `lh_users`.`job_title`, `lh_users`.`disabled`, `lh_users`.`hide_online`, `lh_users`.`all_departments`, `lh_users`.`invisible_mode`, `lh_users`.`inactive_mode`, `lh_users`.`active_chats_counter`, `lh_users`.`closed_chats_counter`, `lh_users`.`pending_chats_counter`, `lh_users`.`departments_ids`, `lh_users`.`rec_per_req`, `lh_users`.`filepath`, `lh_users`.`filename`, `lh_users`.`time_zone`, `lh_users`.`session_id`, `lh_users`.`operation_admin`, `lh_users`.`max_active_chats`, `lh_users`.`auto_accept`, `lh_users`.`exclude_autoasign`, `lh_users`.`attr_int_1`, `lh_users`.`attr_int_2`, `lh_users`.`attr_int_3`, `lh_users`.`pswd_updated`
                                                    [fromString:protected] => FROM `lh_users`
                                                    [useIndexString:protected] => 
                                                    [whereString:protected] => WHERE `lh_users`.`username` = :ezcValue1
                                                    [groupString:protected] => 
                                                    [havingString:protected] => 
                                                    [orderString:protected] => ORDER BY id DESC
                                                    [limitString:protected] => LIMIT 1 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] => nameDatabase
                                                                    [password] => passwordxx
                                                                    [protocol] => tcp
                                                                    [hostspec] => localhost
                                                                    [port] => 3306
                                                                    [socket] => 
                                                                    [database] => nameDatabase
                                                                )

                                                            [dsn:ezcDbHandlerMysql:private] => mysql:dbname=nameDatabase;host=localhost;port=3306
                                                            [reconnectedCounter:ezcDbHandlerMysql:private] => 0
                                                            [transactionNestingLevel:protected] => 0
                                                            [transactionErrorFlag:protected] => 
                                                        )

                                                    [aliases:ezcQuery:private] => Array
                                                        (
                                                            [id] => `lh_users`.`id`
                                                            [username] => `lh_users`.`username`
                                                            [password] => `lh_users`.`password`
                                                            [email] => `lh_users`.`email`
                                                            [name] => `lh_users`.`name`
                                                            [chat_nickname] => `lh_users`.`chat_nickname`
                                                            [skype] => `lh_users`.`skype`
                                                            [xmpp_username] => `lh_users`.`xmpp_username`
                                                            [surname] => `lh_users`.`surname`
                                                            [job_title] => `lh_users`.`job_title`
                                                            [disabled] => `lh_users`.`disabled`
                                                            [hide_online] => `lh_users`.`hide_online`
                                                            [all_departments] => `lh_users`.`all_departments`
                                                            [invisible_mode] => `lh_users`.`invisible_mode`
                                                            [inactive_mode] => `lh_users`.`inactive_mode`
                                                            [active_chats_counter] => `lh_users`.`active_chats_counter`
                                                            [closed_chats_counter] => `lh_users`.`closed_chats_counter`
                                                            [pending_chats_counter] => `lh_users`.`pending_chats_counter`
                                                            [departments_ids] => `lh_users`.`departments_ids`
                                                            [rec_per_req] => `lh_users`.`rec_per_req`
                                                            [filepath] => `lh_users`.`filepath`
                                                            [filename] => `lh_users`.`filename`
                                                            [time_zone] => `lh_users`.`time_zone`
                                                            [session_id] => `lh_users`.`session_id`
                                                            [operation_admin] => `lh_users`.`operation_admin`
                                                            [max_active_chats] => `lh_users`.`max_active_chats`
                                                            [auto_accept] => `lh_users`.`auto_accept`
                                                            [exclude_autoasign] => `lh_users`.`exclude_autoasign`
                                                            [attr_int_1] => `lh_users`.`attr_int_1`
                                                            [attr_int_2] => `lh_users`.`attr_int_2`
                                                            [attr_int_3] => `lh_users`.`attr_int_3`
                                                            [pswd_updated] => `lh_users`.`pswd_updated`
                                                            [erLhcoreClassModelUser] => lh_users
                                                        )

                                                    [boundCounter:ezcQuery:private] => 1
                                                    [boundParameters:ezcQuery:private] => Array
                                                        (
                                                        )

                                                    [boundParametersType:ezcQuery:private] => Array
                                                        (
                                                        )

                                                    [boundValues:ezcQuery:private] => Array
                                                        (
                                                            [:ezcValue1] => username
                                                        )

                                                    [boundValuesType:ezcQuery:private] => Array
                                                        (
                                                            [:ezcValue1] => 2
                                                        )

                                                    [expr] => ezcQueryExpression Object
                                                        (
                                                            [db:protected] => ezcDbHandlerMysql Object
                                                                (
                                                                    [identifierQuoteChars:protected] => Array
                                                                        (
                                                                            [start] => `
                                                                            [end] => `
                                                                        )

                                                                    [dbParams:ezcDbHandlerMysql:private] => Array
                                                                        (
                                                                            [phptype] => mysql
                                                                            [dbsyntax] => mysql
                                                                            [username] => nameDatabase
                                                                            [password] => passwordxx
                                                                            [protocol] => tcp
                                                                            [hostspec] => localhost
                                                                            [port] => 3306
                                                                            [socket] => 
                                                                            [database] => nameDatabase
                                                                        )

                                                                    [dsn:ezcDbHandlerMysql:private] => mysql:dbname=nameDatabase;host=localhost;port=3306
                                                                    [reconnectedCounter:ezcDbHandlerMysql:private] => 0
                                                                    [transactionNestingLevel:protected] => 0
                                                                    [transactionErrorFlag:protected] => 
                                                                )

                                                            [aliases:ezcQueryExpression:private] => Array
                                                                (
                                                                    [id] => `lh_users`.`id`
                                                                    [username] => `lh_users`.`username`
                                                                    [password] => `lh_users`.`password`
                                                                    [email] => `lh_users`.`email`
                                                                    [name] => `lh_users`.`name`
                                                                    [chat_nickname] => `lh_users`.`chat_nickname`
                                                                    [skype] => `lh_users`.`skype`
                                                                    [xmpp_username] => `lh_users`.`xmpp_username`
                                                                    [surname] => `lh_users`.`surname`
                                                                    [job_title] => `lh_users`.`job_title`
                                                                    [disabled] => `lh_users`.`disabled`
                                                                    [hide_online] => `lh_users`.`hide_online`
                                                                    [all_departments] => `lh_users`.`all_departments`
                                                                    [invisible_mode] => `lh_users`.`invisible_mode`
                                                                    [inactive_mode] => `lh_users`.`inactive_mode`
                                                                    [active_chats_counter] => `lh_users`.`active_chats_counter`
                                                                    [closed_chats_counter] => `lh_users`.`closed_chats_counter`
                                                                    [pending_chats_counter] => `lh_users`.`pending_chats_counter`
                                                                    [departments_ids] => `lh_users`.`departments_ids`
                                                                    [rec_per_req] => `lh_users`.`rec_per_req`
                                                                    [filepath] => `lh_users`.`filepath`
                                                                    [filename] => `lh_users`.`filename`
                                                                    [time_zone] => `lh_users`.`time_zone`
                                                                    [session_id] => `lh_users`.`session_id`
                                                                    [operation_admin] => `lh_users`.`operation_admin`
                                                                    [max_active_chats] => `lh_users`.`max_active_chats`
                                                                    [auto_accept] => `lh_users`.`auto_accept`
                                                                    [exclude_autoasign] => `lh_users`.`exclude_autoasign`
                                                                    [attr_int_1] => `lh_users`.`attr_int_1`
                                                                    [attr_int_2] => `lh_users`.`attr_int_2`
                                                                    [attr_int_3] => `lh_users`.`attr_int_3`
                                                                    [pswd_updated] => `lh_users`.`pswd_updated`
                                                                    [erLhcoreClassModelUser] => lh_users
                                                                )

                                                            [quoteValues:protected] => 1
                                                            [intervalMap:protected] => Array
                                                                (
                                                                    [SECOND] => SECOND
                                                                    [MINUTE] => MINUTE
                                                                    [HOUR] => HOUR
                                                                    [DAY] => DAY
                                                                    [MONTH] => MONTH
                                                                    [YEAR] => YEAR
                                                                )

                                                        )

                                                )

                                        )

                                )

                        )

                )

            [3] => Array
                (
                    [file] => /home/XXXXXX/public_html/chat/lib/models/lhuser/erlhcoreclassmodeluser.php
                    [line] => 364
                    [function] => getUserList
                    [class] => erLhcoreClassModelUser
                    [type] => ::
                    [args] => Array
                        (
                            [0] => Array
                                (
                                    [filter] => Array
                                        (
                                            [username] => username
                                        )

                                    [limit] => 1
                                )

                        )

                )

            [4] => Array
                (
                    [file] => /home/XXXXXX/public_html/chat/lib/core/lhuser/lhuser.php
                    [line] => 88
                    [function] => findOne
                    [class] => erLhcoreClassModelUser
                    [type] => ::
                    [args] => Array
                        (
                            [0] => Array
                                (
                                    [filter] => Array
                                        (
                                            [username] => username
                                        )

                                )

                        )

                )

            [5] => Array
                (
                    [file] => /home/XXXXXX/public_html/chat/cache/compiledtemplates/c556ec02b74bdcf598432345111e4c5d.php
                    [line] => 2
                    [function] => authenticate
                    [class] => erLhcoreClassUser
                    [type] => ->
                    [args] => Array
                        (
                            [0] => username
                            [1] => password
                            [2] => 
                        )

                )

            [6] => Array
                (
                    [file] => /home/XXXXXX/public_html/chat/lib/core/lhcore/lhmodule.php
                    [line] => 97
                    [args] => Array
                        (
                            [0] => /home/XXXXXX/public_html/chat/cache/compiledtemplates/c556ec02b74bdcf598432345111e4c5d.php
                        )

                    [function] => include
                )

            [7] => Array
                (
                    [file] => /home/XXXXXX/public_html/chat/lib/core/lhcore/lhmodule.php
                    [line] => 485
                    [function] => runModule
                    [class] => erLhcoreClassModule
                    [type] => ::
                    [args] => Array
                        (
                        )

                )

            [8] => Array
                (
                    [file] => /home/XXXXXX/public_html/chat/index.php
                    [line] => 39
                    [function] => moduleInit
                    [class] => erLhcoreClassModule
                    [type] => ::
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
)

Last edited by tiagocaus (2019-01-04 22:24:34)

Offline

#6 2019-01-05 00:11:51

PeopleInside
Administrator
From: Italy
Registered: 2014-04-10
Posts: 4,046
Website

Re: My chat stopped working after I upgraded to the latest version.

Hi tiagocaus ,
i cannot help much as i am not the programmer and i am not a programmer.

Maybe you can try to resume the backup and upgrade again... something has gone wrong in update i suppose.

If you need more custom help you can find more info on commercial support on my signature. The commercial support are not provided by me.


lol PeopleInside - Live helper chat - free limited forum support!
wink For commercial support or GitHub [see FAQ here]
ops If you want to support this open source project, just donate [see support page]
glasses Something wrong with the forum? [contact a superhero]

Offline

#7 2019-01-06 12:09:55

tiagocaus
Member
Registered: 2015-03-02
Posts: 23

Re: My chat stopped working after I upgraded to the latest version.

For more than a year I've always been updating the same way.

It was not my mistake, but it's some chat update error.

Offline

#8 2019-01-06 13:07:21

PeopleInside
Administrator
From: Italy
Registered: 2014-04-10
Posts: 4,046
Website

Re: My chat stopped working after I upgraded to the latest version.

I am using the last version and i have no issue.
Maybe you can add more information about php used (what is the version) also mysql version.
If you need there are commercial support (more info on my forum signature)


lol PeopleInside - Live helper chat - free limited forum support!
wink For commercial support or GitHub [see FAQ here]
ops If you want to support this open source project, just donate [see support page]
glasses Something wrong with the forum? [contact a superhero]

Offline

#9 2019-01-09 14:31:09

tiagocaus
Member
Registered: 2015-03-02
Posts: 23

Re: My chat stopped working after I upgraded to the latest version.

Very suggestive. Create a problem and have me pay to get it right.

I'll change the service.

Offline

#10 2019-01-09 15:27:44

PeopleInside
Administrator
From: Italy
Registered: 2014-04-10
Posts: 4,046
Website

Re: My chat stopped working after I upgraded to the latest version.

Hi tiagocaus , thank you for your message!
You do not have to pay. I am a user as you and i upgrade my installation every time an update is released.

No issue with the last version 3.14 for me. What i can give here is just suggestions for try to help to resolve your issue.
As i have not the solution i wrote some way you can try.

You are free to use the service that feel more near to your need and your feeling smile

Have a great day!  cool


lol PeopleInside - Live helper chat - free limited forum support!
wink For commercial support or GitHub [see FAQ here]
ops If you want to support this open source project, just donate [see support page]
glasses Something wrong with the forum? [contact a superhero]

Offline

Board footer