Can't activate languages

[patbe60]

Hello

I tried to install all possible versions of Joomfish newer than 2.1 (first release) this means: 2.1.2, 2.1.3, 2.2
But I always get the following error when selecting the language menu in JF component:

Unknown column 'l.ordering' in 'order clause' SQL=SELECT l.* FROM jos_languages AS l ORDER BY l.ordering

May be you can help me. If not, please give me a link to redownload the first release of version 2.1.

I have also checked my database. Joomfish is installing only two tables:

jos_jf_content
jos_jf_tableinfo

My system: Joomla 1.5.22, php 5.3.2

Patrik

[patbe60]

Ok, I have found the error:

You always wrote __languages instead of __jf_languages

Now it works.

[patbe60]

But now I have a problem in the frontend: Forthough the default language is active I get this error message:

Joom!Fish config error: Default language is inactive!

Please check configuration, try to use first active language

[wgary]

I have the same error and I am not able to activate any language.
If I open the tab "langauges" I will get error: Unknown column 'l.ordering' in 'order clause' SQL=SELECT l.* FROM jos_languages AS l ORDER BY l.ordering
If I will activate the languages and save I will get "Error saving languages".

Could you please explain how to fix this issue?
in frontend I will get also error 500!

br
Wolfgang

[patbe60]

I will not renew my Club Membership. I'm very very disapointed about not supporting paying members. It's very easy to get money from users and after not to support them!!!!

It makes me very angry.

Shame on you!

Patrik Bernhard

[pixnflix]

I am having the same issue. Hope this will be fixed soon!

[jbosschers]

Hey people,

I had the same problem and found a solution that worked for me !!! (no thanks to the support crew...)

HERE IT IS
After installing JoomFish 2.1.5, you'll find these 2 tables in your DB:
1. jos_languages
2. jos_languages_bak

switch these tables around, rename table 1 to table 2 and rename table 2 to table 1.
This will give you an error on the jos_jf_languages view (which has been now converted to a table).

From this moment your site should be working fine again... (front- and backend).
but there's still an error in your DB, so you or your ISP won't be able to make a backup, you fix this by executing the following query on your DB. (please remember to replace the DBusername with your own)

THE QUERY

Code: Select all

DROP TABLE IF EXISTS `bup_jf_languages`;

DROP VIEW IF EXISTS `bup_jf_languages`;

CREATE ALGORITHM=UNDEFINED DEFINER=`DBusername`@`%` SQL SECURITY DEFINER VIEW `jos_jf_languages` AS select `l`.`lang_id` AS `lang_id`,`l`.`lang_code` AS `lang_code`,`l`.`title` AS `title`,`l`.`title_native` AS `title_native`,`l`.`sef` AS `sef`,`l`.`description` AS `description`,`l`.`published` AS `published`,`l`.`image` AS `image`,`lext`.`image_ext` AS `image_ext`,`lext`.`fallback_code` AS `fallback_code`,`lext`.`params` AS `params`,`lext`.`ordering` AS `ordering` from (`jos_languages_bak` `l` left join `jos_jf_languages_ext` `lext` on((`l`.`lang_id` = `lext`.`lang_id`))) order by `lext`.`ordering`;

NOTICE THE "jos_languages_bak" table name in the FROM statement

This worked for me, hope it does the same for you guys!!!

Greetz, Lipholn

[trip]

Hi
what is the purpose of this table _jf_languages and why is this missing in the install ?

Matthew

[sderrico]

THANK YOU JBOSSCHERS!

Reversing the name of the table works.

Have a great day!
Sébastien

[anelinde]

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