startup wrote: Hello!

I'm migrating to Joomla 1.7 and CB 1.7 and having a problem with CB Articles 1.06.

I simply do not see any articles within the tab view. If I turn on debug level and maximum reporting and take the sql query (see at the bottom) directly with phpmyadmin I do get back the articles of the requested user but the query result within the php code of the Joomla 1.7 returns an empty array.

Can you lift up the dark ?

BTW: Your ticket systems seems to be broken - I only get internal server error.

Best regards
Frank

SELECT a.id, a.catid, a.title, a.hits, a.created, ROUND( r.rating_sum / r.rating_count ) AS rating, r.rating_count,
CASE WHEN CHAR_LENGTH( a.alias )
THEN CONCAT_WS( ':', a.id, a.alias )
ELSE a.id
END AS slug,
CASE WHEN CHAR_LENGTH( cc.alias )
THEN CONCAT_WS( ":", cc.id, cc.alias )
ELSE cc.id
END AS catslug
FROM j17_content AS a
LEFT JOIN j17_content_rating AS r ON r.content_id = a.id
LEFT JOIN j17_categories AS cc ON cc.id = a.catid
WHERE a.created_by =155
AND a.state =1
AND (
publish_up = '0000-00-00 00:00:00'
OR publish_up <= '2011-11-12 00:35:53'
)
AND (
publish_down = '0000-00-00 00:00:00'
OR publish_down >= '2011-11-12 00:35:53'
)
AND a.access <=3
ORDER BY a.created DESC
LIMIT 0 , 30