Child pages
  • [install] Double table prefix in some SQLs during upgrade from 5.2.x to 5.3.x
Skip to end of metadata
Go to start of metadata

I'm seeing following error after "Module Select" step when upgrading from 5.2.x to 5.3.x:

Error: (1146) Table 'alex_inportal_upgrade.51x_51x_SystemCache' doesn't exist

The error is produced by this SQL, that have table prefix added twice in some places:

INSERT INTO 51x_51x_SystemCache (VarName, Data)
SELECT 'tmp_translation' AS VarName, l1_Translation AS Data
FROM 51x_LanguageLabels
WHERE PhraseKey = 'LC_IMPORTLANG_PHRASEWARNING' 

This happens because <%TABLE_PREFIX%> keyword (that is replaced with table prefix) was used in places where table prefix is inserted anyway (e.g. INSERT INTO clause).

Solution

Remove excessive usages of <%TABLE_PREFIX%> in upgrades.sql.

Related Tasks

INP-1500 - Getting issue details... STATUS