Migration to Joomla 4.1.5

Need help upgrading your Joomla! website or converting to Joomla! 4.x?

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Post Reply
rockfish
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Tue Jun 26, 2018 5:42 pm

Migration to Joomla 4.1.5

Post by rockfish » Sun Jul 03, 2022 6:59 pm

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
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Wed Mar 16, 2022 6:29 pm

Re: Migration to Joomla 4.1.5

Post by toomanyremotes » Fri Jul 08, 2022 10:13 pm

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
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Wed Mar 16, 2022 6:29 pm

Re: Migration to Joomla 4.1.5

Post by toomanyremotes » Wed Jul 13, 2022 1:16 am

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.

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 29123
Joined: Mon Oct 27, 2008 9:27 pm
Location: Romerike, Norway

Re: Migration to Joomla 4.1.5

Post by Per Yngve Berg » Wed Jul 13, 2022 8:04 am

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

Is the database schema up to 3.10.10?

toomanyremotes
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Wed Mar 16, 2022 6:29 pm

Re: Migration to Joomla 4.1.5

Post by toomanyremotes » Wed Jul 13, 2022 3:58 pm

Database Fix: Yes

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

Thank you.

toomanyremotes
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Wed Mar 16, 2022 6:29 pm

Re: Migration to Joomla 4.1.5

Post by toomanyremotes » Wed Jul 13, 2022 5:13 pm

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
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Wed Mar 16, 2022 6:29 pm

Re: Migration to Joomla 4.1.5

Post by toomanyremotes » Wed Jul 13, 2022 5:47 pm

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.

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 29123
Joined: Mon Oct 27, 2008 9:27 pm
Location: Romerike, Norway

Re: Migration to Joomla 4.1.5

Post by Per Yngve Berg » Wed Jul 13, 2022 5:57 pm

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
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Wed Mar 16, 2022 6:29 pm

Re: Migration to Joomla 4.1.5

Post by toomanyremotes » Wed Jul 13, 2022 9:54 pm

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

toomanyremotes
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Wed Mar 16, 2022 6:29 pm

Re: Migration to Joomla 4.1.5

Post by toomanyremotes » Fri Jul 15, 2022 12:39 am

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);


Post Reply

Return to “Migrating and Upgrading to Joomla! 4.x”