Migration & Conversion, Data Import & Export, Hosting, Database Management, Joomla Migration

This Joomla 2.5 and 3.x plugin changing automatically the Database Collation and Database Character set including all tables and columns. It will also converting tables from MyISAM to InnoDB. The new Joomla 3.5 is designed to work with the UTF8mb4 collation and the InnoDB Engine of MySQL. This collation allows you to use Emoji and other multibyte characters such as certain Traditional Chinese glyphs, Cherokee etc. In this case you need to change the collation to “UTF-8 Multibyte”. Joomla 3.5 is doing this for all the own core tables while upgrading to the newest Joomla Version. But you may need to repeat that step for all the "old" extensions or after installing or upgrading extensions which are using other collation. After installing new extensions you are strongly advised to check this. If an extension involves fields with different collations then this could end in an error like: "Illegal mix of collations".

  • Get this
  • Favourite
  • Report

The "Collation and Engine - Changer" can be used to switch the Database Collation and Database Character set including all tables and columns to UTF8mb4 (or to an other collation). It will also converting all tables from MyISAM to InnoDB. In this way you are using the same like Joomla 3.5 is doing for the core tables. All this can be easily done from your Joomla backend.

Whenever you have one of these problems:

  • you have to switch from one collation to an other
  • you have to switch from MyISAM to InnoDB
  • you got the error: "Illegal mix of collations"
  • you have to migrate an website from Joomla 2.5 to 3.5
  • you are using extensions that are not using UTF8mb4

then the CE-Changer is your solution.


Every Joomla site may well need this to keep database tables in line.

Ease of use

Once configured, this is click and go. Job Done
Configuration may be tricky for those who haven't configured my.conf before


Matthias has a day job and works hard at it. If there's a glitch (as there was in activating my subscription) he's on it as soon as possible


Multilingual support!

Value for money

Easy. Saved a

I used this to: Keeping legacy Joomla extensions in line with future requirements


I purchased CE-Changer to convert my data tables from MyISAM to InnoDB in my two Joomla sites -both of which date back to version 1.5.

Ease of use

The programme was easy to use. I had trouble configuring the MySQL file my.cnf with an old version of MySQL.


Incredible Support. Matthias helped with converting both Joomla sites daily for over a week due to my problems giving him cpanel access.


Instructions were clear and easy to understand with additional help always available..

Value for money

This is a great low cost way to switch to the innodb engine and Matthias is there every step of the way if you need help. Highly recommended

I used this to: Only four tables could be not switched to innodb because of my old version of mysql.
Before MySQL 5.6 Full-Text Search is supported only with MyISAM Engine.


Paid download | SEO & Metadata | MCTrading
139 reviews
SEO-Generator is a SEO extension for Joomla, which automatically generates keywords and description for each article by pulling text from the title and/or the content, to help with SEO. It also gives you the ability to set different title configurations, robots meta tags and google webmaster verification keys. Joomla provides a great system for including metadata keywords and description on articles. When editing an article there is a spot on the right hand side of the page to edit the keywords and description (it’s under “Metadata Information”). This information is used to provide the tags for the page and to connect pages using the standard Related Articles module that comes with Joomla. But what if you don’t want to have to think up and type in keywords and description every time? Wouldn’t it be nice if the related articles plugin could just always work on the full text of the articles? That’s what this plugin solves. It works with every language. Whenever you create or save an article in Frontend or Backend, this plugin automatically fills in the keywords and description for you. It does this for the keywords by: 1. Parsing all the words in the article and ordering them by number of times used (you can choose to generate keywords from title, content or both) 2. Removes the most common words in your language from the list by comparing it against a blacklist 3. Adds the top words into the keywords section (Limit keywords by length or number) After saving the article you can also make some own changes and any words you add to the keyword or description section will not be overwritten when you save. But what is with that many old articles without keywords? This version adds the ability to regenerate keywords for all articles in the database. Simply set the option to “Yes”, reload "Frontpage" and set it back to “No.” All articles in the database will now have keywords. You can save, delete or change the keywords for all articles by changing the options "Regenerate All Keywords and save it" and "Minimum Word Length" or the "Keywords-Blacklist". If you are not using "save by writing" then the description and keywords aren't saved in the article but the searchengine can get it from the sourcetext, because they are also generated "on the fly". There are Keyword-Blacklists in english and in german but you can use google translation to create your own Keyword-Blacklist. On these websites you can see how it works: Thats not all here some other options: * HTML page title configuration. Set your page titles in three different ways * You can also customize what the separator is (in this ex. it's a pipe, can be any character). * Additionally, you can customize the front page of your site's title tag to display a custom string. * You can have one of four different layouts


Paid download | Social Edition | MCTrading
127 reviews
Article-Generator is a SEO extension for Joomla, which automatically generates new articles with own keywords by pulling text from any feed-source you want, to help with SEO. It gives you the ability to set many different configurations for each feed-source. It keeps you’re site fresh and gives you’re visitors something to read and you have nothing to do. All is done by an cronjob - every 5 minutes, if you wish. It filters the feed-sources by keywords, generates a new article which automatically has own keywords, removes links, link-texts or images - if you want, adds advertising which you can change at any time you want, integrates the original article with an lightbox-effect and refreshes your own website-feed. There are many options to make it possible with every feed-source you want. The new articles improve your page SEO and make your site win positions in the search engines. By default, Article-Generator inserts below the content random backlinks to some of my developer-pages. This feature can be disabled with a single click. Or you can change these backlinks in the code. Then you can use this feature to have backlinks to your own related websites. This can improve SEO. Article-Generator is fully configurable and each feed-source can be configured with different parameters. With these many options each article can be customized to your website and content and the new articles are added to your website just as if you wrote them yourself: *get fulltext from all feeds *post as different user *choose section and category *store original Author name in the article *choose access group for the article *show on frontpage *expiration for the article from 7 days to 1 year (in predefined steps) *auto-unpublish *posting of original date *set Feed-Date as created date *insert advertising-field which you can change later for all written articles *filter feed-source by keywords / negative keywords (to ignore posts) *cut the article at any tag *full text fetch on feeds that support it *show intro with advert and no readmore *show intro and then advert in readmore *show intro and then fulltext with advert in readmore *show intro in readmore or not *Links inside the feed content are set with nofollow to improve SEO *delete links or links and link-texts in intro or fulltext *delete links from images in the feed content *delete images in intro or fulltext *switch Feed-Intro and Feed-Fulltext *include link to original-article *open original-article-link in Lightbox, Slimbox, Shadowbox or Squeezebox *set JCE params like width and height *use curl or fsockopen *posting without repeating an article by checking the title *Duplicate avoidance which is very useful for SEO purposes *choose number of SEO-Keywords for the new article *choose minimum length of SEO-Keywords for the new article *blacklist of SEO-Keywords for the new article *activate cronjob on the server or on to generate articles around the clock On these websites you can see how it works:


Paid download | SEF | MCTrading
3 reviews
This native Joomla 2.5 and 3.x plugin automatically generates new aliases for all your joomla articles in one step by using the title from each article. It gives you the ability to choose between the joomla transliteration aliases or joomla unicode aliases. Joomla provides a great system for creating aliases for each article by using the article-title. But if you need to change between transliteration or unicode then you have to create new aliases manually for each single article. When editing an article there is a spot near the title to edit the alias. So you can do this manually. But what if you don’t want to have to spend many time for this? Wouldn’t it be nice if this is done automatically for all your joomla articles in one step directly in the database? That’s what this plugin is doing. Whenever you have one of these problems: you have to switch from transliteration aliases to unicode aliases in joomla configuration you have to switch from unicode aliases to transliteration aliases in joomla configuration you won't switch between unicode and transliteration but you have wrong aliases (e.g. some date- and time-stamps) you have manually given aliases for your articles and you like to switch back to the title-aliases then the ALIAS-Generator is your solution. Aliases are short pieces of text that represent the title of your Joomla Articles in a machine-friendly format. This format allows only lowercase letters and dashes (-). Aliases are used by Joomla to make Search Engine Friendly URLs. There are technical limitations to the types of characters that can be included in URLs, so Joomla prevents problems with invalid characters by allowing you to specify an alias. You can fill in an alias yourself. If you leave the alias field empty, Joomla will automatically create an alias from the Title field of an item when it is saved. This means that if you edit the title of an item, but you leave the old alias in its field, the alias (and the URL that is created from it) will not change. Empty the alias field if you want generate a new alias. In joomla configuration you can choose the way how joomla is creating these aliases. You can choose between "Transliteration" and "Unicode" aliases. When saving edited content, the former setting attempts to convert, where appropriate, any alias text into the corresponding Latin characters. The latter setting leaves any non-Latin characters in the alias text unchanged. Changing this parameter does not retroactively change aliases, it just changes the behaviour of automatic alias generation for future content editing and creation. Now you can use ALIAS-Generator to do this also for all your existing articles automatically in one step.

Collation and Engine - Changer

Last updated:
Apr 09 2016
Date added:
Mar 28 2016
GPLv2 or later
Paid download

This extension does NOT implement the Joomla! Update System

Demo Support Documentation
  • Overall
  • Functionality

  • Ease of use

  • Documentation

  • Support

  • Value for money