When I go for language activation to the JoomFish language manager, I get this error when trying to activate default language:

An error occured while saving your languages

Also in the language configuration see the following error:

Unknown column 'l.ordering' in 'order clause' SQL=SELECT l.* FROM jos_languages AS l ORDER BY l.ordering
Warning: Invalid argument supplied for foreach() in www/administrator/components/com_joomfish/models/languages.php on line 188


Also see information about what Joom!Fish is not set the default language into front-end too:

Joom!Fish config error: Default language is inactive!
Please check configuration, try to use first active language

The solution is to delete and create a table jos_languages. Open your phpMyAdmin and delete this table. Then run this SQL-query to your base:

CREATE TABLE IF NOT EXISTS `jos_languages` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`active` tinyint(1) NOT NULL default '0',
`iso` varchar(20) default NULL,
`code` varchar(20) NOT NULL default '',
`shortcode` varchar(20) default NULL,
`image` varchar(100) default NULL,
`fallback_code` varchar(20) NOT NULL default '',
`params` text NOT NULL,
`ordering` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

INSERT INTO `jos_languages` (`id`, `name`, `active`, `iso`, `code`, `shortcode`, `image`, `fallback_code`, `params`, `ordering`) VALUES
(1, 'English (United Kingdom)', 1, 'en_GB.utf8, en_GB.UT', 'en-GB', 'en', '', '', '', 1);

Enter into the Joom!Fish language configuration again and save the config. Everything works.

Please be aware, that this issue is only if you are using Joomla 1.5.x. Not if you are using 2.5.

Pin It on Pinterest

Share This