› ›
CRITICAL SECURITY VERSION UPDATE:
https://github.com/daylightstudio/FUEL-CMS/releases/tag/1.4.13

"Tags" in Multi Language

azidazid
edited November 2014 in Modules
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.

Comments

  • adminadmin
    edited 3:44PM
    To clarify, you added a "language" field to the fuel_tags table? What error did you see?
  • azidazid
    edited 3:44PM
    @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.
  • adminadmin
    edited 3:44PM
    What if you change line 735 of the base_module_model to the following:
    $where[$this->table_name.'.'.$field.' !='] = '';
  • azidazid
    edited 3:44PM
    @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
  • adminadmin
    edited 3:44PM
    I've just pushed a fix for this in the develop branch:
    https://github.com/daylightstudio/FUEL-CMS/commit/62074986ca7dc0ad29361c8c1aa6a181e1c2024e
  • azidazid
    edited 3:44PM
    Thanks, let me try and get back to you.
  • azidazid
    edited 3:44PM
    @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
  • adminadmin
    edited 3:44PM
    Are you sure you updated it correctly? I just downloaded a fresh version of FUEL and tried it and don't see that error.
  • azidazid
    edited 3:44PM
    It works now, thanks.

    I download a fresh version and overwrite the original one.
Sign In or Register to comment.