Live Helper Chat support forum.. Old google groups forum can be found here

You are not logged in.

Announcement

#1 2021-03-05 11:15:17

bongoit
Member
Registered: 2020-04-21
Posts: 7

Error during upgrade - stuck in "Site maintenance"

Hi,

I am upgrading from 3.57 to 3.64. I am unable to log in due to Site maintenance.

The message I get is "This service is currently unavailable", etc.

in /cache/default.log there is the error:

A query failed internally in Persistent Object: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lh_users.avatar' in 'field list'

Is there a way I can fix my database?

All the best,
Justin

Offline

#2 2021-03-05 11:17:00

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

Re: Error during upgrade - stuck in "Site maintenance"

Seems you did not followed update procedure.

Follow this document to update database.
https://doc.livehelperchat.com/docs/upgrading/


Copy from doc/shell/upgrade.php file to root folder of LHC
In your browser type chatfolder/upgrade.php, it will update database to the most recent version and clear cache automatically
Delete upgrade.php from root folder

Offline

#3 2021-03-05 11:35:18

bongoit
Member
Registered: 2020-04-21
Posts: 7

Re: Error during upgrade - stuck in "Site maintenance"

Great, many thanks!

I am using the softaculous system to run updates, I will let them know there is a problem with their system.

All the best,
Justin

Offline

Board footer