Skip to content

Upgrading from RealURL 1.x to RealURL 2.x

Dmitry Dulepov edited this page Jul 15, 2019 · 5 revisions

Upgrading from RealURL 1.x to RealURL 2.x

RealURL 2.x is compatible with RealURL 1.x by configuration.

If you are upgrading from RealURL 1.x to 2.x, you may need to manually convert some database tables to the new format. Unfortunately, primary keys had to change and TYPO3 does not handle that well. You can try doing it in the Install tool or just execute the following SQL script using mysql command line tool:

ALTER TABLE tx_realurl_pathcache CHANGE cache_id uid int(11) NOT NULL;
ALTER TABLE tx_realurl_pathcache DROP PRIMARY KEY;
ALTER TABLE tx_realurl_pathcache MODIFY uid int(11) NOT NULL auto_increment primary key;

DROP TABLE tx_realurl_chashcache;
DROP TABLE tx_realurl_urldecodecache;
DROP TABLE tx_realurl_urlencodecache;
DROP TABLE tx_realurl_errorlog;

You should execute this script right before you upgrade RealURL from 1.x to 2.x! Then you should check for required database upgrade in the Install tool or in the extension properties.

To improve performance you are strongly recommended to create a page with a complete sitemap and navigate to it when logged out from the Backend or using a different browser. This will fill in the RealURL cache.

About page types

Unlike version 1.x, realurl 2.x does not decode subpages under pages with separator page type. Please, switch page type to folder.