Differences

This shows you the differences between two versions of the page.

--- documentation:joomla_upgrade [2013/12/17 08:33] – nine
+++ documentation:joomla_upgrade [2013/12/17 12:45] (current) – nine
@@ Line 7: / Line 7: @@
   - install system language packs
   - configure content language: extensions -> language -> content
+  - IDs of tables **jos_languages**.id and **j25_languages**.lang_id must correspond
+  - copy joomfish language tables: <code>
+CREATE TABLE j25_falang_content( PRIMARY KEY (id)) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci SELECT * FROM jos_jf_content;
+CREATE TABLE j25_falang_tableinfo( PRIMARY KEY (id)) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci SELECT * FROM jos_jf_tableinfo;
+ALTER TABLE j25_falang_content CHANGE COLUMN id id INT UNSIGNED NOT NULL AUTO_INCREMENT;
+ALTER TABLE j25_falang_tableinfo CHANGE COLUMN id id INT UNSIGNED NOT NULL AUTO_INCREMENT;
+</code>
+  - Als nächstes wähle ich die Tabelle j25_falang_tableinfo in phpmyadmin und lösche alle Einträge ausser: categories, content, menu und modules.
+  - fix table j25_falang_content: <code>
+## the element 'link' does not exist in falang
+delete from j25_falang_content where reference_table = 'menu' and reference_field = 'link';
+## replace name with title
+update j25_falang_content set reference_field='title' where reference_table='menu' and reference_field='name';
+## deleting the old table language of Joomfish
+delete from j25_falang_content where reference_table = 'languages';
+##  Also in this table run the following command and fix field params
+delete from j25_falang_content where reference_table = 'menu' and reference_field = 'params';
+</code>
+  - install falang package
+  - enable module **FaLang Language Switcher**
+  - Activate the plugin **"System - Language Filter" (Language Filter)**
+  - activate the plugin **System - FaLang Database Driver**
+===== easybook reloaded =====
+<code>
+CREATE TABLE j25_easybook( PRIMARY KEY (id)) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci SELECT * FROM jos_easybook;
+ALTER TABLE j25_easybook CHANGE COLUMN id id INT UNSIGNED NOT NULL AUTO_INCREMENT;
+</code>