Page 1 of 3

Error installing 1.0.8.1

Posted: Thu Mar 18, 2021 12:18 pm
by Nigel
There seems to be some sort of error when installing the very latest github version.

The connection fields seem to be merging.
error1.png

Re: Error installing 1.0.8.1

Posted: Thu Mar 18, 2021 12:28 pm
by ecartz
What version of MySQL is that? Note that 5.6 and older are past end-of-life.

Re: Error installing 1.0.8.1

Posted: Thu Mar 18, 2021 1:54 pm
by Nigel
ecartz wrote: Thu Mar 18, 2021 12:28 pm What version of MySQL is that? Note that 5.6 and older are past end-of-life.

Is there something different betweem 1.0.80 and 81 to fail on this ?
I've had no problems before, even with 1.0.8.
The server capabilities all show green thumbs up.

Trying to find the version number.

Re: Error installing 1.0.8.1

Posted: Thu Mar 18, 2021 2:39 pm
by ecartz
It's saying that it can't index one of the varchar(255) columns. In 1.0.8.1, those can be 1020 bytes (more than 767). If you just want to make it work, change all the 255s in the phoenix.sql file to 191.

I've installed it since I made that change, which suggests that it works in a newer MariaDB. It should not give that error in versions of MySQL 5.7 or newer.

Re: Error installing 1.0.8.1

Posted: Thu Mar 18, 2021 2:50 pm
by Nigel
I'm waiting for my hosts to come back to me with the version number.
I'm looking around but struggling to find the info.

Knowing them, it's probably well past its best !

Re: Error installing 1.0.8.1

Posted: Thu Mar 18, 2021 2:59 pm
by heatherbell
Nigel wrote: Thu Mar 18, 2021 2:50 pm I'm looking around but struggling to find the info.
Is it not shown on admin->Tools->Server Info

Re: Error installing 1.0.8.1

Posted: Thu Mar 18, 2021 3:02 pm
by Nigel
heatherbell wrote: Thu Mar 18, 2021 2:59 pm
Nigel wrote: Thu Mar 18, 2021 2:50 pm I'm looking around but struggling to find the info.
Is it not shown on admin->Tools->Server Info
I'd have to load an older version to read it. I wiped it all.

I'll wait on the hosts first.

Re: Error installing 1.0.8.1

Posted: Thu Mar 18, 2021 3:03 pm
by ecartz
In phpMyAdmin, try

Code: Select all

select @@version as version;
or

Code: Select all

SHOW VARIABLES LIKE ‘%version%’;

Re: Error installing 1.0.8.1

Posted: Thu Mar 18, 2021 3:04 pm
by Nigel
It creates Action Recorder, Address book and Address Format tables then fails.

Re: Error installing 1.0.8.1

Posted: Thu Mar 18, 2021 3:21 pm
by Nigel
ecartz wrote: Thu Mar 18, 2021 3:03 pm In phpMyAdmin, try

Code: Select all

select @@version as version;
or

Code: Select all

SHOW VARIABLES LIKE ‘%version%’;
Sorry ecartz, where exactly am I entering that ?