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

You are not logged in.

Announcement

#1 2020-11-16 14:13:25

juancmonsalves
Member
From: Venezuela
Registered: 2020-07-29
Posts: 18

upgrade from 3.48 to 3.50 failed. lhc_users_login table doesn't exist

Hello There,

After finish upgrade proccess from 3.48 to 3.50 web application failed to load because lhc_users_login table doesn't exist.

In the back office indicate that my database is up to date.

I rollback the upgrade.

Any idea? I must upgrade 3.49 first and the 3.50?

I have updated my app many times and I didn't have problems. This is the firt time with failed status.

Best Regards.

Offline

#2 2020-11-16 14:21:52

remdex
Administrator
From: Lithuania
Registered: 2012-09-23
Posts: 3,661
Website

Re: upgrade from 3.48 to 3.50 failed. lhc_users_login table doesn't exist

Looks like you forgot first to click update database in back office before replacing files.

Offline

#3 2020-11-16 19:32:49

juancmonsalves
Member
From: Venezuela
Registered: 2020-07-29
Posts: 18

Re: upgrade from 3.48 to 3.50 failed. lhc_users_login table doesn't exist

My Steps...

->Restore Database and app to 3.48

->In Upgrade appears: Live Helper Chat update
Your version - 3.48
Current version - 3.50

-> I clicked Update Database Button

-> I saw Live Helper Chat update
Your version - 3.48
Current version - 3.50
Database structure check
Your database does not require any updates

-> I logged out from LHC

-> I downloades latest version of LHC and update folders with this command
for i in doc ezcomponents lib modules pos translations design ; do cp -vr $i/ /var/www/html/chat/; done

-> I have disabled cache in settings and enable debug mode

-> When I try to login, after write user and password, I receive:
PDOException Object
(
    [message:protected] => SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bdChat.lh_users_login' doesn't exist
    [string:Exception:private] =>
    [code:protected] => 42S02
    [file:protected] => /var/www/html/chat/lib/core/lhcore/lhdbtrait.php
    [line:protected] => 257
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /var/www/html/chat/lib/core/lhcore/lhdbtrait.php
                    [line] => 257
                    [function] => execute
                    [class] => PDOStatement
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

            [1] => Array
                (
                    [file] => /var/www/html/chat/modules/lhuser/login.php
                    [line] => 138
                    [function] => getCount
                    [class] => erLhcoreClassModelUserLogin
                    [type] => ::
                    [args] => Array
                        (
                            [0] => Array
                                (
                                    [filter] => Array
                                        (
                                            [type] => 2
                                            [status] => 0
                                            [user_id] => 1
                                        )

                                )

                        )

                )

            [2] => Array
                (
                    [file] => /var/www/html/chat/lib/core/lhcore/lhmodule.php
                    [line] => 96
                    [args] => Array
                        (
                            [0] => /var/www/html/chat/modules/lhuser/login.php
                        )

                    [function] => include
                )

            [3] => Array
                (
                    [file] => /var/www/html/chat/lib/core/lhcore/lhmodule.php
                    [line] => 555
                    [function] => runModule
                    [class] => erLhcoreClassModule
                    [type] => ::
                    [args] => Array
                        (
                        )

                )

            [4] => Array
                (
                    [file] => /var/www/html/chat/index.php
                    [line] => 44
                    [function] => moduleInit
                    [class] => erLhcoreClassModule
                    [type] => ::
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] =>
    [errorInfo] => Array
        (
            [0] => 42S02
            [1] => 1146
            [2] => Table 'bdChat.lh_users_login' doesn't exist
        )

)

Offline

#4 2020-11-18 16:40:13

juancmonsalves
Member
From: Venezuela
Registered: 2020-07-29
Posts: 18

Re: upgrade from 3.48 to 3.50 failed. lhc_users_login table doesn't exist

Hi,

We have finished the update. This is the excuted workflow:

1.- Backup App&DB
2.- Access to LHC App and check for updates. Everithing up to date
3.- Download and update folders for upgrade.
4.- Clean cache
5.- Without logoff, Access one more time to LHC App and check for updates and apply new updates of the database

This workflow works fine for us... Thank you


Actualización de Live Helper Chat
Su versión - 3.51
Versión actual - 3.51

Comprobación de estructura de la base de datos
Su base de datos no requiere actualización

Offline

#5 2020-11-18 16:46:39

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

Re: upgrade from 3.48 to 3.50 failed. lhc_users_login table doesn't exist

Hi, juancmonsalves!
I'm happy to read your issue seems to be solved.
Today we released version 3.52. I have already updated my installation after doing a full folder and database backup.

Enjoy and have a nice week.
Stay safe!

3.52v Departments statistic (inactive chats)


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

#6 2020-11-20 13:21:31

juancmonsalves
Member
From: Venezuela
Registered: 2020-07-29
Posts: 18

Re: upgrade from 3.48 to 3.50 failed. lhc_users_login table doesn't exist

Thanks for all your work. Free Software and Free Culturo is possible!!!

Best Regards.

Note: This issue is closed.

Offline

Board footer