Articles visible in database and frontend but not visible in backend

[vbangaru]

Imported content table from Joomla 3 website to Joomla 4 website. All articles are visible in frontend and even in database but only one random article is visible in backend articles dashboard. Tried various options, but could not get them. Can any one help me out.
Check screen shots -
https://prnt.sc/26bxqu9
https://prnt.sc/26bxsp9

[toivo]

How did you import those articles, by using a third party extension perhaps?

[vbangaru]

No by third party extension. Exported the table in sql from old database and imported in new website database table.

[ceford]

I have a vague recollection of this coming up before and the problem was missing entries in workflow tables - even if you are not using Workflows.

[vbangaru]

Thank you for your reply. But can you please let me know how to work it around?

[brian]

@ceford is correct.

You cant "work around it" you will need to create the required matching entries in the workflows table

[ceford]

Thank you for your reply. But can you please let me know how to work it around?

See this post: viewtopic.php?f=812&t=989825

[nfbauti]

I had a problem the same as yours, I dealt with it in the Issue Tracker and in the end I solved the problem by reinstalling components and plugins that I had in use and the problem fixed itself.

https://issues.joomla.org/tracker/joomla-cms/36616

[pe7er]

Recently I had the same problem:
I imported articles directly in the database into the #__content table like I often did in Joomla 3.
However in Joomla 4 they were not visible.

In Content > Categories, the category item counters counted the imported articles.
But they were not visible in Content > Articles.

I solved it by creating the necessary references in the #__workflow_associations table for each imported article:
item_id = article ID, stage_id = 1 and extension = com_content.article.

[ceford]

Recently I had the same problem:
I imported articles directly in the database into the #__content table like I often did in Joomla 3.
However in Joomla 4 they were not visible.

In Content > Categories, the category item counters counted the imported articles.
But they were not visible in Content > Articles.

I solved it by creating the necessary references in the #__workflow_associations table for each imported article:
item_id = article ID, stage_id = 1 and extension = com_content.article.

I have added this to a list of common problems so we can refer users to it in the future:

https://docs.joomla.org/J4.x:Assorted_I ... in_backend

[brian]

This query should do it for you. Replace #_ with your own database prefix

Code: Select all

INSERT INTO #__workflow_associations
(item_id, stage_id, extension)
SELECT id as item_id,  '1', 'com_content.article' FROM #__content;

[alexandreelise]

This query should do it for you. Replace #_ with your own database prefix

Code: Select all

INSERT INTO #__workflow_associations
(item_id, stage_id, extension)
SELECT id as item_id,  '1', 'com_content.article' FROM #__content;

Hi brian,
I stumbled upon the same problem on my Joomla 4.2.5 website and the query you provided that is also in the official documentation seem to not manage duplicates when trying to insert in the workflow associations table.
Here is the query I did that handle duplicates gracefully. I contributed to the official docs too so anybody can use it too.
Here it is

Code: Select all

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);

Hope it helps someone.
Take care and have a delightful day.

[bascherz]

This just "happened" on my J!4.3.2 site within the past couple days. I don't know the circumstances because someone else created the article that the backend lost. Does anyone know what causes this?

Thanks!
Bruce

[macpalm]

I believe I have this issue happening on my V4.3.4 site... I´ve spotted some articles appearing in a Site Map on the front end, that aren't showing in the Admin panel article listing. The only way I can find the articles in the backend is using the Smart Search in the Admin > Components and the article appear as published. The aren't articles I want appearing in the front end, so I tried unpublishing them using the Smart Search options, which seems to work until you check the front end and they are still visible.

What is causing this problem?

I'm not especially confident working in the database, to run the code given above. Is there a step by step someone can point me to to help further?

Thanks

[bascherz]

I think the earlier posters here described what's going on. Seems like a bug to me, and it may have been addressed in a later release; I haven't tested it. But the fact is that adding simple entries into the #__workflow_associations database table means it's fairly easy to patch in the near term.

[Georgie232]

I have a vague recollection of this coming up before and the problem was missing entries in workflow tables - even if you are not using Workflows.

ooooo! THX

[AlexRag]

I ran into this issue recently having migrated a site from J3>J4.

I followed these steps:
1. Checked Database Structure (System > Maintenance > Database> Fix)
2. Checked Category Structure (Content > Categories > Rebuild)
3. Ran the SQL Query to fix the associations table for Workflows as noted above by Brian
4. Enabled Workflow (Content >Articles > Options) and created at least one Workflow. You can disable Workflow and the articles will still appear in the backend.