"Tags" in Multi Language

azid

Hi,

How can I make the "Tags" support multi language? I've tried add a "language" in the "Tags" Database but it show error.

Many thanks.

admin

To clarify, you added a "language" field to the fuel_tags table? What error did you see?

azid

@admin,

I've added a "language" field to fuel_tags by using:
ALTER TABLE `fuel_tags` ADD `languague` VARCHAR( 30 ) NOT NULL DEFAULT 'en' AFTER `precedence`

After that, I click "Tags" it show me:
A Database Error Occurred Error Number: 1052 Column 'language' in where clause is ambiguous SELECT DISTINCT fuel_tags.language, fuel_tags.language FROM (`fuel_tags`) LEFT JOIN `fuel_categories` ON `fuel_categories`.`id` = `fuel_tags`.`category_id` WHERE `language` != '' ORDER BY `fuel_tags`.`language` asc Filename: /home/testing.com/public_html/fuel/modules/fuel/core/MY_Model.php Line Number: 1124

I also added the "language" field in fuel_categories but it work fine.

Thanks a lot.

admin

What if you change line 735 of the base_module_model to the following:
$where[$this->table_name.'.'.$field.' !='] = '';

azid

@admin

After change, I can go "Tags" and it show the "Language" selection. But when I click "Create", it show another error:

A Database Error Occurred Error Number: 1305 FUNCTION fuel_tags.CONCAT does not exist SELECT fuel_tags.id, fuel_tags.CONCAT(name, " - ", language) AS val_field FROM (`fuel_tags`) LEFT JOIN `fuel_categories` ON `fuel_categories`.`id` = `fuel_tags`.`category_id` ORDER BY `val_field` ASC Filename: /home/testing.com/public_html/fuel/modules/fuel/core/MY_Model.php Line Number: 1124

admin

I've just pushed a fix for this in the develop branch:
https://github.com/daylightstudio/FUEL-CMS/commit/62074986ca7dc0ad29361c8c1aa6a181e1c2024e

azid

Thanks, let me try and get back to you.

azid

@admin,

After I updated the code and click the "Tags", it show the error as below:

A Database Error Occurred Error Number: 1054 Unknown column 'fuel_tags.fuel_tags.language' in 'where clause' SELECT DISTINCT fuel_tags.language, fuel_tags.language FROM (`fuel_tags`) LEFT JOIN `fuel_categories` ON `fuel_categories`.`id` = `fuel_tags`.`category_id` WHERE `fuel_tags`.`language` != '' AND `fuel_tags`.`fuel_tags`.`language` != '' ORDER BY `fuel_tags`.`language` asc Filename: /home/testing.com/public_html/fuel/modules/fuel/core/MY_Model.php Line Number: 1124

admin

Are you sure you updated it correctly? I just downloaded a fresh version of FUEL and tried it and don't see that error.

azid

It works now, thanks.

I download a fresh version and overwrite the original one.