Migration to Joomla 4.1.5

[rockfish]

I have successfully migrated four of my six websites from Joomla 3.10.10 to Joomla 4.1.5. However, one of my sites throws these errors each time I've attempted the migration:

Code: Select all

JInstaller: :Install: Error SQL Tablespace for table '`*_*`.`maur4_finder_taxonomy`' exists. Please DISCARD the tablespace before IMPORT
danger
Table '*_*.maur4_history' doesn't exist
Table '*_*.maur4_mail_templates' doesn't exist
Table '*_*.maur4_finder_taxonomy' doesn't exist

I use the same 3rd party extensions in each website, save for two: Community Builder / aa.newsticker. This website (http://www.jrtcllc.com) does not use either of these extensions.

The system info for this website is:

• PHP: 8.0.20
  MySQLI: 10.3.25-MariaDB
  OS: Linux u

I use the Pre-Update Check each time and disable Contact Enhanced PRO each time before attempting the migration.
The installer shows me the errors cited above but also shows that Joomla had migrated to version 4.1.5. The interface, however, is all askew and impossible to follow, so I remove everything, including all database tables and folders & files in the public_html folder on the server.

Help. Thanks!

[toomanyremotes]

I have tried this update on multiple stages. The errors are always the same but just these two tables:

_history doesn't exist
_mail_templates doesn't exist

That is correct, they don't. They are not listed in the TABLES table in the information_schema. It is unclear to my why the installer cares.

Also, this is at the end of my JInstaller script:

JInstaller: :Install: Error SQL Duplicate key name 'idx_language'
End of SQL updates - INCOMPLETE.
Cleaning up after installation.
Update to version 4.1.5 is complete.

Is the duplicate key name the only error were there remaining changes left to be done when the installer stopped?

Nothing is visible in the System Dashboard is empty. Nothing but an error page in the front end.

All that said, the upgrade works perfectly from a new, clean install of 3.10.10 to 4.1.5 on the same stages.

[toomanyremotes]

I staged a clean 3.10.10 site and updated it to 4.1.5. Looking at joomla_update.php in the administrator/logs directory, there are 499 database changes. The update is successful.

On a clone of my live site, updating from 3.10.10 to 4.1.5 fails at number 59:
ALTER TABLE `#__finder_links` ADD INDEX `idx_language` (`language`);
JInstaller: :Install: Error SQL Duplicate key name 'idx_language'
End of SQL updates - INCOMPLETE.
Cleaning up after installation.
Update to version 4.1.5 is complete.

I am stumped as to how get past this.

[Per Yngve Berg]

Have you run a Extensions->Manage->Database->Fix before upgrading?

Is the database schema up to 3.10.10?

[toomanyremotes]

Database Fix: Yes

Database Schema 3:10:7. How do I bring that up to date?

Thank you.

[toomanyremotes]

I checked the update log for my clean 3 to 4 update, it also has shows "The current database version (schema) is 3.10.7-2022-03-18."

[toomanyremotes]

This is the site I have been trying to update:

Database schema version (in #__schemas): 3.10.7-2022-03-18.
Update version (in #__extensions): 3.10.10.
Database driver: mysqli.
190 database changes were checked.
218 database changes did not alter table structure and were skipped.

[Per Yngve Berg]

3.10.7 is the latest database schema.

Is there rows in `#__finder_links`?

It cannot make the unique key because there are several rows with the same value.

[toomanyremotes]

No. The table is empty, both my live site and a clean install of 3.10.10.

[toomanyremotes]

All of the issues are contained in a single update script, 4.0.0-2018-07-29.sql. These are the changes I needed to make to update the site without database errors.

--Fix ALTER TABLE `#__finder_links` ADD INDEX `idx_language` (`language`); Error

ALTER TABLE `#__finder_links` DROP INDEX `idx_language`;

--Fix JInstaller: :Install: Error SQL Table 'aa95n_finder_links_terms' already exists

DROP TABLE `#__finder_links_terms`;

--ALTER TABLE `#__finder_terms` DROP INDEX `idx_term`;
--Fix JInstaller: :Install: Error SQL Can't DROP INDEX `idx_term`; check that it exists

ALTER TABLE `#__finder_terms` ADD INDEX `idx_term` (`term`);

--ALTER TABLE `#__finder_terms` ADD INDEX `idx_stem` (`stem`);
--JInstaller: :Install: Error SQL Duplicate key name 'idx_stem'
ALTER TABLE `#__finder_terms` DROP INDEX `idx_stem`;

--ALTER TABLE `#__finder_terms` ADD INDEX `idx_language` (`language`);
--JInstaller: :Install: Error SQL Duplicate key name 'idx_language'
ALTER TABLE `#__finder_terms` DROP INDEX `idx_language`;

--ALTER TABLE `#__finder_terms` ADD UNIQUE INDEX `idx_term_language` (`term`, `lan
--JInstaller: :Install: Error SQL Duplicate key name 'idx_term_language'
ALTER TABLE `#__finder_terms` DROP INDEX `idx_term_language`;

--ALTER TABLE `#__finder_tokens` ADD INDEX `idx_stem` (`stem`);
--JInstaller: :Install: Error SQL Duplicate key name 'idx_stem'
ALTER TABLE `#__finder_tokens` DROP INDEX `idx_stem`;

--ALTER TABLE `#__finder_tokens` ADD INDEX `idx_stem` (`stem`);
--JInstaller: :Install: Error SQL Duplicate key name 'idx_stem'
ALTER TABLE `#__finder_tokens` DROP INDEX `idx_stem`;


--ALTER TABLE `#__finder_tokens_aggregate` DROP COLUMN `map_suffix`;
--JInstaller: :Install: Error SQL COlumn doesn't exist
ALTER TABLE `#_finder_tokens_aggregate` ADD COLUMN `map_suffix` VARCHAR(50);