can't see submitted news

Sundance · 26.10.2005, 23:19

hi there,
I have just installed Mambo 4.5.2 creating a new community form scratch. I am used 4.5.1 so I am quite astonished about this:

My Editors, Publisher and Super Administrators can't see any of the newly submitted news items in the frontend. Is there a global setting like "Show unpublished items to Special"?

I can see the submitted items in the backend and handle them from there but the idea of course is that the Editors and Publishers do that from the frontend.

When I check the items in the backend their status is "unpublished". Shouldn't they bey "pending"?

Any ideas?

Regards, Sundance

Sundance · 27.10.2005, 18:25

Anybody?

How can a publisher see the newly submitted news items?

Sundance · 28.10.2005, 11:41

Hi all,

I figured it out and wanted to post the solution as well. It is new in Mambo 4.5.2 as far as can tell from my other 4.5.1 sites.

I was using a "Blog - Content Category" link in my menu. When displaying a category blog unpublished items are not shown at all, not even to Editors, Publishers or Administrators. It's as simple as that.

Only when using a "Table - Content Category" the unpublished items are shown in the list to special users so they can edit ehm from the frontend directly.

You have two choices now.

1) Create an extra usermenu item of type "Table - Content Category" for special users to each category you want them to edit or publish from the front end.

2) Change the code in /components/com_content/content.php so unpublished items are also shown in the Blog view of a category:

content.php, Mambo 4.5.2, Line 1623:

Code:

$where[] = "a.state = '1'";
if ( !$access->canEdit ) {
   $where[] = "( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '". $now ."' )";
   $where[] = "( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '". $now ."' )";
}

Change this if statement to:

Code:

if ( !$access->canEdit ) {
   $where[] = "a.state = '1'";
   $where[] = "( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '". $now ."' )";
   $where[] = "( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '". $now ."' )";
}else{
   $where[] = "a.state >= '0'";
}

Explanation (at least some words):
The where[] array contains SQL selection conditions for reading the content items out of the database. The SQL statement is different when showing a category blog compared to showing a category table. Unpublished items have state=0. The 0 state is not included in the category blog display but is in the table view (compare line 332 in function showCategory()).

Best regards,
Sundance

r2d2 · 08.09.2006, 13:24

Thanks, Sundance. This was helpful