anelinde wrote:I have the same problem :
Unknown column 'l.ordering' in 'order clause' SQL=SELECT l.* FROM jos_languages AS l ORDER BY l.ordering
when i go to the admin-page for language activation. And I get this error when trying to activate:
An error occured while saving your languages.
Also, the whole site is not working when Joomfish is installed (only the frontpage).
How can I solve this? Altering the tables i the DB as suggested in this forum doesn't work.
Linde
Hi, Linde! Solution your bug is here:
http://www.bestweb.com.ua/en/blog/91-ho ... der-clause
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 Joom!Fish language configuration again and save. Everything works
