Joomla Templates Club 406,261 posts

[jlgarcia9 Friend jlgarcia9Join date: March 2009Posts: 25Downloads:0Uploads:2 Thanked: 1 times in 1 posts]

#168165

Hi Friends,

When I activate Multi Language plugin, my web doesn´t work.

That´s the problem:

500 – JDatabaseMySQL::query: 1054 – Unknown column ‘ordering’ in ‘order clause’ SQL=SELECT * FROM c79c5_languages WHERE published=1 ORDER BY ordering ASC

You may not be able to visit this page because of:

an out-of-date bookmark/favourite
a search engine that has an out-of-date listing for this site
a mistyped address
you have no access to this page
The requested resource was not found.
An error has occurred while processing your request.

Please try one of the following pages:

Home Page

If difficulties persist, please contact the System Administrator of this site and report the error below..

JDatabaseMySQL::query: 1054 – Unknown column ‘ordering’ in ‘order clause’ SQL=SELECT * FROM c79c5_languages WHERE published=1 ORDER BY ordering ASC

Call stack
# Function Location
1 JSite->initialise() /home/villacam/domains/villa-cambodunum-estepona.es/public_html/index.php:31
2 JPluginHelper::importPlugin() /home/villacam/domains/villa-cambodunum-estepona.es/public_html/includes/application.php:65
3 JPluginHelper::_import() /home/villacam/domains/villa-cambodunum-estepona.es/public_html/libraries/joomla/plugin/helper.php:106
4 plgSystemLanguageFilter->__construct() /home/villacam/domains/villa-cambodunum-estepona.es/public_html/libraries/joomla/plugin/helper.php:168
5 JLanguageHelper::getLanguages() /home/villacam/domains/villa-cambodunum-estepona.es/public_html/plugins/system/languagefilter/languagefilter.php:42
6 JDatabase->loadObjectList() /home/villacam/domains/villa-cambodunum-estepona.es/public_html/libraries/joomla/language/helper.php:143
7 JDatabaseMySQL->query() /home/villacam/domains/villa-cambodunum-estepona.es/public_html/libraries/joomla/database/database.php:973
8 JError::raiseError() /home/villacam/domains/villa-cambodunum-estepona.es/public_html/libraries/joomla/database/database/mysql.php:512
9 JError::raise() /home/villacam/domains/villa-cambodunum-estepona.es/public_html/libraries/joomla/error/error.php:215

I delete my cookies, test with different browser, but I always obtain the same results.

Please, Could you help me ?

Thank you
Regards

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#410570

Hi
Please update me with your site access backend & FPT for checking.
Thank you
Viet Vu

[jlgarcia9 Friend jlgarcia9Join date: March 2009Posts: 25Downloads:0Uploads:2 Thanked: 1 times in 1 posts]

#410574

Hi,

I found this error between Quickstart Ja Droid and “Clean Joomla 1.7 installation”.

There are two main errors: Table XXXX_associations doesn´t exist and column ordering in table xxxx_languages doesn´t exit .

And there is another low error, I couldn´t change the order of the languages in the backend administrator.

You can test with a clean installation with JA Droid and activate plugin “Filter Languages”.

Thank you very much for your help
Regads

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#410575

Hi
Thank you for your report. Let’s me try from my side and respond to you
Thank you,
Viet Vu

[jlgarcia9 Friend jlgarcia9Join date: March 2009Posts: 25Downloads:0Uploads:2 Thanked: 1 times in 1 posts]

#410577

Ok, Thank you for your fast reply to me.

Regards

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#410579

LOL,
#1: Which multi language you are talking about ?
#2: I’ve another bug


Notice: Undefined index: en-GB in /var/www/joodevelopment/ja.joodevelopment.com/jatc_droid_j17/plugins/system/languagefilter/languagefilter.php on line 45
But look like it’s Joomla bug 🙂

[jlgarcia9 Friend jlgarcia9Join date: March 2009Posts: 25Downloads:0Uploads:2 Thanked: 1 times in 1 posts]

#410586

Hi,

Sorry, I don´t explain:

Multi Language: The new feature of Joomla 1.7 ( languagefilter ) and the plugin name “System – Language Filter”

Excuse me

#2: Uhhh, I´m not sure. I suppose that you create, but you need and entry in ( Language Manager: Content Languages ) with all the langauges that you install.

Sorry, My english is no good.
Thank you
Regards

---

Attachments:

1. 

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#410588

Hi
Would you mind send me a language pack for sample ?
Thank you
Viet Vu

[jlgarcia9 Friend jlgarcia9Join date: March 2009Posts: 25Downloads:0Uploads:2 Thanked: 1 times in 1 posts]

#410589

Hi,

You can download:

http://www.villa-cambodunum-estepona.es/es-ES_joomla1.7.0_front_admin.zip

and

http://www.villa-cambodunum-estepona.es/de-DE_joomla_lang_full_1.7.0v1.zip

That is the schema of the table:

CREATE TABLE IF NOT EXISTS `c79c5_languages` (
`lang_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`lang_code` char(7) NOT NULL,
`title` varchar(50) NOT NULL,
`title_native` varchar(50) NOT NULL,
`sef` varchar(50) NOT NULL,
`image` varchar(50) NOT NULL,
`description` varchar(512) NOT NULL,
`metakey` text NOT NULL,
`metadesc` text NOT NULL,
`published` int(11) NOT NULL DEFAULT ‘0’,
`ordering` int(11) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (`lang_id`),
UNIQUE KEY `idx_sef` (`sef`),
KEY `idx_ordering` (`ordering`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

and

CREATE TABLE IF NOT EXISTS `doams_associations` (
`id` varchar(50) NOT NULL COMMENT ‘A reference to the associated item.’,
`context` varchar(50) NOT NULL COMMENT ‘The context of the associated item.’,
`key` char(32) NOT NULL COMMENT ‘The key for the association computed from an md5 on associated ids.’,
PRIMARY KEY (`context`,`id`),
KEY `idx_key` (`key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Thank you

Thank you
Regards

[jlgarcia9 Friend jlgarcia9Join date: March 2009Posts: 25Downloads:0Uploads:2 Thanked: 1 times in 1 posts]

#410590

Hi,

The website is under construction : http://www.villa-cambodunum-estepona.es

With the change It´s running the Website.

Thank you

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#410591

Uhm i still dont have your bug. But see Joomla bug 😐

[jlgarcia9 Friend jlgarcia9Join date: March 2009Posts: 25Downloads:0Uploads:2 Thanked: 1 times in 1 posts]

#410592

Uhhh, you activate plugin and module, and 2 or more languages.

Thank you

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#416377

Hi
Don’t know if you have got update from Joomla! Joomla multi language issue have fixed in 1.7.1.
Please try update it ?
Thank you
Viet Vu

[Author]

Posts