Error installing 1.0.8.1

Open to all! Ask other shopowners for help.
Nigel
Contributor
Posts: 114
Joined: Mon Jan 11, 2021 1:39 am
Phoenix Version:
Has thanked: 29 times
Been thanked: 8 times

Error installing 1.0.8.1

Post 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
You do not have the required permissions to view the files attached to this post.


Join The Code Co-op to get access to your library in the Code Co-op Forum
ecartz
Core Team
Posts: 3084
Joined: Tue Nov 05, 2019 6:02 pm
Phoenix Version:
Has thanked: 4 times
Been thanked: 208 times

Re: Error installing 1.0.8.1

Post by ecartz »

What version of MySQL is that? Note that 5.6 and older are past end-of-life.
Nigel
Contributor
Posts: 114
Joined: Mon Jan 11, 2021 1:39 am
Phoenix Version:
Has thanked: 29 times
Been thanked: 8 times

Re: Error installing 1.0.8.1

Post 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.
ecartz
Core Team
Posts: 3084
Joined: Tue Nov 05, 2019 6:02 pm
Phoenix Version:
Has thanked: 4 times
Been thanked: 208 times

Re: Error installing 1.0.8.1

Post 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.
Nigel
Contributor
Posts: 114
Joined: Mon Jan 11, 2021 1:39 am
Phoenix Version:
Has thanked: 29 times
Been thanked: 8 times

Re: Error installing 1.0.8.1

Post 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 !
heatherbell
Senior Contributor
Posts: 2540
Joined: Mon Oct 07, 2019 4:39 am
Phoenix Version:
Has thanked: 35 times
Been thanked: 243 times

Re: Error installing 1.0.8.1

Post 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
Nigel
Contributor
Posts: 114
Joined: Mon Jan 11, 2021 1:39 am
Phoenix Version:
Has thanked: 29 times
Been thanked: 8 times

Re: Error installing 1.0.8.1

Post 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.
ecartz
Core Team
Posts: 3084
Joined: Tue Nov 05, 2019 6:02 pm
Phoenix Version:
Has thanked: 4 times
Been thanked: 208 times

Re: Error installing 1.0.8.1

Post by ecartz »

In phpMyAdmin, try

Code: Select all

select @@version as version;
or

Code: Select all

SHOW VARIABLES LIKE ‘%version%’;
Nigel
Contributor
Posts: 114
Joined: Mon Jan 11, 2021 1:39 am
Phoenix Version:
Has thanked: 29 times
Been thanked: 8 times

Re: Error installing 1.0.8.1

Post by Nigel »

It creates Action Recorder, Address book and Address Format tables then fails.
Nigel
Contributor
Posts: 114
Joined: Mon Jan 11, 2021 1:39 am
Phoenix Version:
Has thanked: 29 times
Been thanked: 8 times

Re: Error installing 1.0.8.1

Post 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 ?


Join The Code Co-op to get access to your library in the Code Co-op Forum
Post Reply