Jump to content


Update issue


4 replies to this topic

#1 breck

    Newbie

  • Members
  • Pip
  • 8 posts

Posted 11 December 2018 - 04:14 PM

So I got an allert stating there was a server files update and when I attempt to update the database tables I get this error.

Cannot update database structure from [8.0.0.4] to [8.0.0.5]. Please make sure that the user un_udname has the MySQL permission to ALTER tables in valleybe_vblivehelp. Error: 1071: Specified key was too long; max key length is 767 bytes MySQL Query: ALTER TABLE `lz_resources` CHANGE `id` `id` VARCHAR(256) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';

Any ideas?

#2 Patrick Keil

    Administrator

  • Administrators
  • 3853 posts
  • LocationSingen, Germany

Posted 12 December 2018 - 01:07 PM

Hi,

Your MySQL version might be to old. LiveZilla 8.x requires MySQL 5.7 or greater.

Can you check?

Cheers.

#3 breck

    Newbie

  • Members
  • Pip
  • 8 posts

Posted 12 December 2018 - 01:20 PM

It's 5.5.61

Just odd that your update 2 days ago was fine and yesterday it failed.

Will look into updating it.

#4 Patrick Keil

    Administrator

  • Administrators
  • 3853 posts
  • LocationSingen, Germany

Posted 12 December 2018 - 01:47 PM

The change that requires 5.7 was comes with 8.0.0.5.

Cheers.

#5 breck

    Newbie

  • Members
  • Pip
  • 8 posts

Posted 12 December 2018 - 01:55 PM

Updated from 5.5 to 5.6 ok
Attempted update from 5.6 to 5.7 and failed.
Killed all my websites. lol

Have the host working on it now.





1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users