Advertisement
Articles visible in database and frontend but not visible in backend
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
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
-
- Joomla! Apprentice
- Posts: 7
- Joined: Mon Jan 21, 2013 4:37 am
Articles visible in database and frontend but not visible in backend
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
Check screen shots -
https://prnt.sc/26bxqu9
https://prnt.sc/26bxsp9
Advertisement
- toivo
- Joomla! Master
- Posts: 18012
- Joined: Thu Feb 15, 2007 5:48 am
- Location: Sydney, Australia
Re: Articles visible in database and frontend but not visible in backend
How did you import those articles, by using a third party extension perhaps?
Toivo Talikka, Global Moderator
-
- Joomla! Apprentice
- Posts: 7
- Joined: Mon Jan 21, 2013 4:37 am
Re: Articles visible in database and frontend but not visible in backend
No by third party extension. Exported the table in sql from old database and imported in new website database table.
- ceford
- Joomla! Hero
- Posts: 2978
- Joined: Mon Feb 24, 2014 10:38 pm
- Location: Edinburgh, Scotland
- Contact:
Re: Articles visible in database and frontend but not visible in backend
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.
-
- Joomla! Apprentice
- Posts: 7
- Joined: Mon Jan 21, 2013 4:37 am
Re: Articles visible in database and frontend but not visible in backend
Thank you for your reply. But can you please let me know how to work it around?
- brian
- Joomla! Master
- Posts: 12813
- Joined: Fri Aug 12, 2005 7:19 am
- Location: Leeds, UK
- Contact:
Re: Articles visible in database and frontend but not visible in backend
@ceford is correct.
You cant "work around it" you will need to create the required matching entries in the workflows table
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/
Blog http://brian.teeman.net/
Joomla Hidden Secrets http://hiddenjoomlasecrets.com/
- ceford
- Joomla! Hero
- Posts: 2978
- Joined: Mon Feb 24, 2014 10:38 pm
- Location: Edinburgh, Scotland
- Contact:
-
- Joomla! Intern
- Posts: 84
- Joined: Mon Nov 14, 2016 5:04 pm
Re: Articles visible in database and frontend but not visible in backend
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
https://issues.joomla.org/tracker/joomla-cms/36616
Con Joomla hasta el fin de los tiempos 

- pe7er
- Joomla! Master
- Posts: 25372
- Joined: Thu Aug 18, 2005 8:55 pm
- Location: Nijmegen, Netherlands
- Contact:
Re: Articles visible in database and frontend but not visible in backend
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 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
Peter Martin, Global Moderator
Company website: https://db8.nl/en/ - Joomla specialist, Nijmegen, Netherlands
The best website: https://the-best-website.com
- ceford
- Joomla! Hero
- Posts: 2978
- Joined: Mon Feb 24, 2014 10:38 pm
- Location: Edinburgh, Scotland
- Contact:
Re: Articles visible in database and frontend but not visible in backend
I have added this to a list of common problems so we can refer users to it in the future: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.
https://docs.joomla.org/J4.x:Assorted_I ... in_backend
- brian
- Joomla! Master
- Posts: 12813
- Joined: Fri Aug 12, 2005 7:19 am
- Location: Leeds, UK
- Contact:
Re: Articles visible in database and frontend but not visible in backend
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/
Blog http://brian.teeman.net/
Joomla Hidden Secrets http://hiddenjoomlasecrets.com/
-
- Joomla! Apprentice
- Posts: 6
- Joined: Fri Jun 22, 2018 3:14 pm
Re: Articles visible in database and frontend but not visible in backend
Hi brian,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;
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);
Take care and have a delightful day.
- bascherz
- Joomla! Explorer
- Posts: 258
- Joined: Mon Jan 16, 2006 1:33 am
- Location: Vienna, VA
- Contact:
Re: Articles visible in database and frontend but not visible in backend
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
Thanks!
Bruce
Bruce Scherzinger
-
- Joomla! Fledgling
- Posts: 3
- Joined: Tue Nov 17, 2009 10:07 am
Re: Articles visible in database and frontend but not visible in backend
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
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
- Joomla! Explorer
- Posts: 258
- Joined: Mon Jan 16, 2006 1:33 am
- Location: Vienna, VA
- Contact:
Re: Articles visible in database and frontend but not visible in backend
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.
Bruce Scherzinger
-
- Joomla! Apprentice
- Posts: 5
- Joined: Sat Oct 30, 2021 12:20 pm
-
- Joomla! Apprentice
- Posts: 7
- Joined: Sun Dec 14, 2008 5:40 am
Re: Articles visible in database and frontend but not visible in backend
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.
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.
Advertisement