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

juancmonsalves · 2020-11-16 14:13:25

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.

remdex · 2020-11-16 14:21:52

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

juancmonsalves · 2020-11-16 19:32:49

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
)

)

juancmonsalves · 2020-11-18 16:40:13

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

PeopleInside · 2020-11-18 16:46:39

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)