J4 Issue ? ?
avatar brianteeman
brianteeman
21 Jan 2020

The content navigation plugin doesn't work at all. Looks like an error in the query regarding workflows

avatar brianteeman brianteeman - open - 21 Jan 2020
avatar joomla-cms-bot joomla-cms-bot - change - 21 Jan 2020
Labels Added: ?
avatar joomla-cms-bot joomla-cms-bot - labeled - 21 Jan 2020
avatar alikon alikon - change - 23 Jan 2020
Labels Added: J4 Issue
avatar alikon alikon - labeled - 23 Jan 2020
avatar brianteeman brianteeman - change - 25 Jan 2020
Labels Added: ?
avatar brianteeman brianteeman - labeled - 25 Jan 2020
avatar wilsonge
wilsonge - comment - 26 Jan 2020

I can't reproduce this. Sets up ok and menu on the right hand side as well as previous/next buttons in the main text both work ok

Screenshot 2020-01-26 at 00 28 22

I used tiny - but here is the text in raw form so we can compare notes:

Screenshot 2020-01-26 at 00 28 37

avatar brianteeman
brianteeman - comment - 26 Jan 2020

That's the page break stuff. I am talking about the next article link

avatar wilsonge
wilsonge - comment - 26 Jan 2020

Sorry can you show me a screenshot? I'm kinda confused

avatar brianteeman
brianteeman - comment - 26 Jan 2020

image

image

In Joomla 3 that would produce the previous next buttons as shown below but in J4 nothing happens due to an error in the sql (i think)

image

This is the query that I believe is wrong as if I remover the workflow related part of the query I do at least get values from that query

SELECT a.id, a.title, a.catid, a.language, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END AS catslug
FROM c6cko_content AS a
LEFT JOIN c6cko_categories AS cc ON cc.id = a.catid
LEFT JOIN c6cko_workflow_stages AS ws ON ws.id = a.state
WHERE a.catid = 14 AND a.state = 1 AND a.access IN (1,1,5)  AND (ws.condition = 1 OR ws.condition = -2) AND (publish_up IS NULL OR publish_up <= '2020-01-26 17:51:10') AND (publish_down IS NULL OR publish_down >= '2020-01-26 17:51:10')
ORDER BY  CASE WHEN a.publish_up IS NULL THEN a.created ELSE a.publish_up END  DESC
avatar wilsonge
wilsonge - comment - 27 Jan 2020

Pretty sure the Joomla state should not be on the workflow stage - I guess it's a legacy of when we had bad naming on all that stuff and swagged stage/state around a bit

avatar brianteeman
brianteeman - comment - 27 Jan 2020

so you understand what I was referring to now?

I didnt contribute a fix as I'm not wasting my time if workflows is going to be pulled. Still waiting to see the report from fftf

avatar wilsonge wilsonge - change - 9 Feb 2020
Status New Closed
Closed_Date 0000-00-00 00:00:00 2020-02-09 15:37:14
Closed_By wilsonge
avatar wilsonge
wilsonge - comment - 9 Feb 2020

PR here #27871

avatar wilsonge wilsonge - close - 9 Feb 2020

Add a Comment

Login with GitHub to post a comment