Error installing 1.0.8.1

[heatherbell]

where exactly am I entering that ?

Are you using phpMyadmin?

[ecartz]

In phpMyAdmin or whatever you use to run SQL queries.

Alternately, you could try changing

Code: Select all

CREATE TABLE administrators (
  id int NOT NULL auto_increment,
  user_name varchar(255) binary NOT NULL,
  user_password varchar(60) NOT NULL,
  PRIMARY KEY (id),
  UNIQUE KEY uq_administrator_user_name (user_name)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

to either

Code: Select all

CREATE TABLE administrators (
  id int NOT NULL auto_increment,
  user_name varchar(255) NOT NULL,
  user_password varchar(60) NOT NULL,
  PRIMARY KEY (id),
  UNIQUE KEY uq_administrator_user_name (user_name)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

or

Code: Select all

CREATE TABLE administrators (
  id int NOT NULL auto_increment,
  user_name varchar(191) binary NOT NULL,
  user_password varchar(60) NOT NULL,
  PRIMARY KEY (id),
  UNIQUE KEY uq_administrator_user_name (user_name)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

and see if that helps.

[Nigel]

The first option failed but second query, pasted into phoenix.sql and uploaded, run via install, got as far as table categories_description

The next table is configuration but the following are all highlighted in blue in vs code rather than configuration being in white like other table names.
Is configuration a reserved word ?

DROP TABLE IF EXISTS configuration;
CREATE TABLE configuration (


Yes Heather, I have got PHPMyAdmin, its hosted with the database etc. and web space, not local.

[Nigel]

It seems the version of MySQL is 5.0.12.

I think they should be called Legacy internet hosting !

[ecartz]

Code: Select all

  configuration_key varchar(191) NOT NULL,

[Nigel]

Code: Select all

  configuration_key varchar(191) NOT NULL,

Yep, did that.
Now the customers table !
Not sure how to proceed here.

Is this silly changing all this, should I just go back to version 1.0.8 and not 81 ?

[ecartz]

Code: Select all

   UNIQUE KEY uq_customers_email_address (customers_email_address(191))

Then in the pages table:

Code: Select all

  slug varchar(191) NOT NULL,

[Nigel]

I've made all those changes and it's now succeeded.
Thanks.

Is this down to limitations of MySQL versions that don't allow for all the unicode charsets etc. ?

[heatherbell]

Is this silly changing all this, should I just go back to version 1.0.8 and not 81 ?

Not sure why you are installing a version that has not been released, presumed you had a reason. Sometimes I install a latest github branch just to help testing but only ever on a test site.
You should see what version phpMyAdmin your server is running by clicking the phpMyAdmin logo, top left of database.
I know I would go back to 1.0.8.0 and get a different host!

[Nigel]

Is this silly changing all this, should I just go back to version 1.0.8 and not 81 ?

Not sure why you are installing a version that has not been released, presumed you had a reason. Sometimes I install a latest github branch just to help testing but only ever on a test site.
You should see what version phpMyAdmin your server is running by clicking the phpMyAdmin logo, top left of database.
I know I would go back to 1.0.8.0 and get a different host!

My reason was to test and to see what it had over the earlier versions.
Clearly it's not ready for use just yet.
Now I'm in, half of admin doesn't show. Maybe because of the amendments I made or something being worked on.

Sorry for wasting peoples' time, it did, however, give me another bat to beat my hosting company with, so it was worth it for that alone.
Thanks to you and ecartz for your efforts.