No Code Attached Yet
avatar EJBJane
EJBJane
12 Jun 2025

### 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';

avatar EJBJane EJBJane - open - 12 Jun 2025
avatar joomla-cms-bot joomla-cms-bot - change - 12 Jun 2025
Labels Added: No Code Attached Yet
avatar joomla-cms-bot joomla-cms-bot - labeled - 12 Jun 2025
avatar brianteeman
brianteeman - comment - 15 Jun 2025

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.

avatar chmst chmst - close - 15 Jun 2025
avatar chmst chmst - change - 15 Jun 2025
Status New Closed
Closed_Date 0000-00-00 00:00:00 2025-06-15 11:30:52
Closed_By chmst
avatar chmst
chmst - comment - 15 Jun 2025

Closing. It is not a bug, as you removed associations by yourself.

4 Delete workflow associations for some articles

avatar EJBJane
EJBJane - comment - 16 Jun 2025

okay thanks

Add a Comment

Login with GitHub to post a comment