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

You are not logged in.

Announcement

#1 2021-04-29 10:28:35

gwerdi
Member
Registered: 2017-11-22
Posts: 8
Website

ERROR: SQLSTATE[42000] when updating livehelper

Hi
I just tried to update livehelper to newest version. When it comes to upgrade database i get the following error:

ERROR: SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

I enabled php 8 before I tried to upgrade. Then i just had a blank page with error 500. After switching back to older php version i can see the error message above now. Is there a way to upgrade database through phpmyadmin or another way to solve the problem?

Offline

#2 2021-04-29 10:39:18

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

Re: ERROR: SQLSTATE[42000] when updating livehelper

I never got this error myself. You can just execute SQL queries from "doc/update_db" folder.

Offline

#3 2021-04-29 10:43:44

gwerdi
Member
Registered: 2017-11-22
Posts: 8
Website

Re: ERROR: SQLSTATE[42000] when updating livehelper

I just tried to execute them but it seems i made a mess. I just get errors when I try to execute the files in phpmyadmin.

Offline

Board footer