Articles visible in database and frontend but not visible in backend

General questions relating to Joomla! 4.x.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting.
Forum Post Assistant - If you are serious about wanting help, you should use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10
Post Reply
vbangaru
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Mon Jan 21, 2013 4:37 am

Articles visible in database and frontend but not visible in backend

Post by vbangaru » Mon Jan 10, 2022 5:21 am

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

User avatar
toivo
Joomla! Master
Joomla! Master
Posts: 17210
Joined: Thu Feb 15, 2007 5:48 am
Location: Sydney, Australia

Re: Articles visible in database and frontend but not visible in backend

Post by toivo » Mon Jan 10, 2022 6:42 am

How did you import those articles, by using a third party extension perhaps?
Toivo Talikka, Global Moderator

vbangaru
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Mon Jan 21, 2013 4:37 am

Re: Articles visible in database and frontend but not visible in backend

Post by vbangaru » Mon Jan 10, 2022 8:37 am

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

User avatar
ceford
Joomla! Hero
Joomla! Hero
Posts: 2508
Joined: Mon Feb 24, 2014 10:38 pm
Location: Edinburgh, Scotland
Contact:

Re: Articles visible in database and frontend but not visible in backend

Post by ceford » Mon Jan 10, 2022 9:41 am

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
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Mon Jan 21, 2013 4:37 am

Re: Articles visible in database and frontend but not visible in backend

Post by vbangaru » Mon Jan 10, 2022 10:20 am

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

User avatar
brian
Joomla! Master
Joomla! Master
Posts: 12773
Joined: Fri Aug 12, 2005 7:19 am
Location: Leeds, UK
Contact:

Re: Articles visible in database and frontend but not visible in backend

Post by brian » Mon Jan 10, 2022 10:52 am

@ceford is correct.

You cant "work around it" you will need to create the required matching entries in the workflows table
"Exploited yesterday... Hacked tomorrow"
Blog http://brian.teeman.net/
Joomla Hidden Secrets http://hiddenjoomlasecrets.com/

User avatar
ceford
Joomla! Hero
Joomla! Hero
Posts: 2508
Joined: Mon Feb 24, 2014 10:38 pm
Location: Edinburgh, Scotland
Contact:

Re: Articles visible in database and frontend but not visible in backend

Post by ceford » Mon Jan 10, 2022 3:40 pm

vbangaru wrote:
Mon Jan 10, 2022 10:20 am
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
Joomla! Intern
Joomla! Intern
Posts: 72
Joined: Mon Nov 14, 2016 5:04 pm

Re: Articles visible in database and frontend but not visible in backend

Post by nfbauti » Mon Jan 10, 2022 11:06 pm

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
Con Joomla hasta el fin de los tiempos ;)

User avatar
pe7er
Joomla! Master
Joomla! Master
Posts: 24875
Joined: Thu Aug 18, 2005 8:55 pm
Location: Nijmegen, Netherlands
Contact:

Re: Articles visible in database and frontend but not visible in backend

Post by pe7er » Tue Jan 11, 2022 11:20 am

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.
Kind Regards,
Peter Martin, Global Moderator
Company website: https://db8.nl/en/ - Joomla specialist, Nijmegen, Netherlands
The best website: https://the-best-website.com

User avatar
ceford
Joomla! Hero
Joomla! Hero
Posts: 2508
Joined: Mon Feb 24, 2014 10:38 pm
Location: Edinburgh, Scotland
Contact:

Re: Articles visible in database and frontend but not visible in backend

Post by ceford » Tue Jan 11, 2022 12:37 pm

pe7er wrote:
Tue Jan 11, 2022 11:20 am
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

User avatar
brian
Joomla! Master
Joomla! Master
Posts: 12773
Joined: Fri Aug 12, 2005 7:19 am
Location: Leeds, UK
Contact:

Re: Articles visible in database and frontend but not visible in backend

Post by brian » Tue Jan 11, 2022 12:52 pm

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;

"Exploited yesterday... Hacked tomorrow"
Blog http://brian.teeman.net/
Joomla Hidden Secrets http://hiddenjoomlasecrets.com/

alexandreelise
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Fri Jun 22, 2018 3:14 pm

Re: Articles visible in database and frontend but not visible in backend

Post by alexandreelise » Wed Nov 09, 2022 4:38 pm

brian wrote:
Tue Jan 11, 2022 12:52 pm
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.

User avatar
bascherz
Joomla! Explorer
Joomla! Explorer
Posts: 256
Joined: Mon Jan 16, 2006 1:33 am
Location: Vienna, VA
Contact:

Re: Articles visible in database and frontend but not visible in backend

Post by bascherz » Fri Jun 09, 2023 3:52 pm

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
Bruce Scherzinger


Post Reply

Return to “General Questions/New to Joomla! 4.x”