PHPMyAdmin, manual mysql import Categories,Artiles, Menu joomla 3.10.12 to joomla 5.1.2
Backup each before do anything
1. J3 export table _categories, _content, _menu:
_categories export type extension = 'com_content' only
_content export all data
_menu export menutype='mainmenu' or require menu only, not export all
2. J5 Import _categories, _content, _menu :
_categories remove all extension = 'com_content', then import from j3
_content add column 'xreference' varchar 50 null, import all. Then remove column 'xreference'
_menu remove menutype='mainmenu', import from j3
ISSUES MUST COUNTER: #_ is prefix table
1. J5 BACK END + FRONT END article not view, not access: reason j5 require table __workflow_associations
Run this query:
INSERT INTO #_workflow_associations (item_id, stage_id, extension)
SELECT c.id as item_id, '1', 'com_content.article' FROM #_content AS c
WHERE NOT EXISTS (SELECT wa.item_id FROM #_workflow_associations AS wa WHERE wa.item_id = c.id);
2. J5 FRONT END article not view: reason j5 _content have `publish_down`. set null is allow view
UPDATE `#_content` SET `publish_down`=null;
-
3. J5 FRONT END 'Category not found': this relate table _assests, but we use administrator>Articles>Categoryies -> Rebuild
This will update _asset, -> category blog view
4. J5 Front End main menu links wrong article,category blog link: reason J5 table _menu require 'component_id', must set component_id to article component
UPDATE `#_menu` SET `component_id`=MUST_GET_COMPONENT_ID WHERE menutype = 'mainmenu'
5. Reset #_menu template_style_id:
#_menu set template_style_id=0
