1.0.8.5 Questions / Comments / Concerns

[Nigel]

Should the last file to be removed actually be "focusRequiredTab.php" and not focusRequired.php as this doesn't seem to exist.

[Nigel]

All seems fine now after making those additional deletions.
The duplicate link has gone and it still works.

[raiwa]

Updated 1.0.8.4 to 1.0.8.5:
I get the following error in Admin: Modules: Content:

Notice: Trying to access array offset on value of type null in
C:\xampp_7.4.11\htdocs\xxxxxxxxxxxxxxx\includes\system\versioned\1.0.8.1\country.php
on line
37

When the GDPR Link[account] module is installed. Uninstalled and reinstalled it, but the same error.

[ecartz]

Notice: Trying to access array offset on value of type null in
C:\xampp_7.4.11\htdocs\xxxxxxxxxxxxxxx\includes\system\versioned\1.0.8.1\country.php
on line
37

TY. https://github.com/CE-PhoenixCart/Phoen ... 03e9f87fd8

[Xpajun]

I'm having problems with the action_recorder Table - I get this error when I try installing it in the database:

Code: Select all

SQL query:

CREATE TABLE action_recorder (
  id int NOT NULL auto_increment,
  module varchar(255) NOT NULL,
  user_id int,
  user_name varchar(255),
  identifier varchar(255) NOT NULL,
  success char(1),
  date_added datetime NOT NULL,
  PRIMARY KEY (id),
  KEY idx_action_recorder_module_date (module, date_added),
  KEY idx_action_recorder_user_id (user_id)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

MySQL said: Documentation
#1071 - Specified key was too long; max key length is 1000 bytes
Open new phpMyAdmin window

I'm using MariaDB 10.3.27-MariaDB

[Xpajun]

Also the same problem with pages Table

[ecartz]

Please set the tables to InnoDB. E.g.

Code: Select all

CREATE TABLE action_recorder (
  id int NOT NULL auto_increment,
  module varchar(255) NOT NULL,
  user_id int,
  user_name varchar(255),
  identifier varchar(255) NOT NULL,
  success char(1),
  date_added datetime NOT NULL,
  PRIMARY KEY (id),
  KEY idx_action_recorder_module_date (module, date_added),
  KEY idx_action_recorder_user_id (user_id)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci Engine InnoDB

[Xpajun]

Please set the tables to InnoDB. E.g.

Code: Select all

CREATE TABLE action_recorder (
  id int NOT NULL auto_increment,
  module varchar(255) NOT NULL,
  user_id int,
  user_name varchar(255),
  identifier varchar(255) NOT NULL,
  success char(1),
  date_added datetime NOT NULL,
  PRIMARY KEY (id),
  KEY idx_action_recorder_module_date (module, date_added),
  KEY idx_action_recorder_user_id (user_id)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci Engine InnoDB

Thank you Matt - that worked - the only tables that were affected were action_recorder, configuration and pages.
This was from the phoenix.sql as included in Phoenix 1.0.8.5 - Having just looked at my tables i notice that the Engine is MyISAM on them all - the problem with using old databases I suppose

[LeeFoster]

I must have done something wrong as I don't even have the categories/products option on my drop down.

[LeeFoster]

I must have done something wrong as I don't even have the categories/products option on my drop down.

OK this was a me issue, caused by another addon and is fixed now.

However, I have lost all my tabs on the product admin page. Can anyone point me in the direction of getting them back?