### Steps to reproduce the issue
1 Enable workflows temporarily
2 Create articles
3 Disable workflows
4 Delete workflow associations for some articles
5 Those articles disappear from Article Manager
### Expected result
Articles should be visible regardless of workflow associations when workflows are disabled
### Actual result
Articles without workflow associations are invisible even with workflows disabled
### System information (as much as possible)
Linux dedi2762.your-server.de 6.1.0-37-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.140-1 (2025-05-22) x86_64
mysql
10.11.11-MariaDB-hz2
utf8mb4_unicode_ci
utf8mb4_general_ci
8.3.22
Apache
cgi-fcgi
Joomla! 5.3.1 Stable [ Timu ] 27-May-2025 16:00 GMT
Enabled ()
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.3
### Additional comments
When workflows are disabled in com_content configuration, the Article Manager still uses INNER JOIN with workflow tables. This causes articles without workflow associations to be invisible.
The query should use LEFT JOIN or skip workflow joins entirely when workflows are disabled. This is quite a serious bug. I spent nearly all day finding out what was wrong.
You can fix articles in MySQL witht his query but this need to be fixed:
_```
-- First, verify the stage ID and workflow setup
SELECT * FROM endv1_workflow_stages WHERE id = 1;
-- Count articles without associations
SELECT COUNT(*) as missing_count
FROM jos_content c
LEFT JOIN jos_workflow_associations wa
ON wa.item_id = c.id
AND wa.extension = 'com_content.article'
WHERE wa.item_id IS NULL;
-- Add associations for all articles that don't have them
INSERT INTO endv1_workflow_associations (item_id, stage_id, extension)
SELECT
c.id as item_id,
1 as stage_id,
'com_content.article' as extension
FROM endv1_content c
LEFT JOIN endv1_workflow_associations wa
ON wa.item_id = c.id
AND wa.extension = 'com_content.article'
WHERE wa.item_id IS NULL;
-- Verify it worked
SELECT COUNT(*) as fixed_count FROM jos_workflow_associations WHERE extension = 'com_content.article';
Labels |
Added:
No Code Attached Yet
|
Status | New | ⇒ | Closed |
Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2025-06-15 11:30:52 |
Closed_By | ⇒ | chmst |
Closing. It is not a bug, as you removed associations by yourself.
4 Delete workflow associations for some articles
okay thanks
Expected result
Articles should be visible regardless of workflow associations when workflows are disabled
The reason that workflow associations are always created for an article even when wf is not used is to enable you to switch to using wf in the future.