Installed Focus template for Joomla 4, imported *****content from J3 into J4 using phpMyAdmin. Import goes well but no article showing up in the J4 backend. Searched internet. Some say it has something to do with the *****workflow_associations table but queries like -
INSERT INTO *****_workflow_associations (item_id, stage_id, extension)
SELECT id AS item_id
, '1', 'com_content.article' FROM *****_content
;
or different variations of it I found on the internet hasn't worked throwing me error like -
#1062 - Duplicate entry '100-com_content.article' for key 'PRIMARY'
Note - ***** is of course replaced by my table prefix.
Please help. Thanks.