[SOLVED] CB Articles does not show any articles

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 <
ORDER BY a.created DESC
LIMIT 0 , 30

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 <
ORDER BY a.created DESC
LIMIT 0 , 30

Regarding ticket system - most likely you triggered a security issue (if you tried to post this sql script in the ticket).

Regarding the CB Articles plugin 1.0.6, I just tested on my Joomla 1.7.2 / CB 1.7.1 and it worked just fine.

Perhaps something went wrong with the migration?

Try adding a new article and see if it shows up.

Hi!

Thanks for your quick answer. Adding a new article was the first which I tried. But it is the same - no article is showing up.

The very strange thing is if I take the sql query which gets build in joomla17.php (getArticles) and run it manually via phpmyadmin I do get the articles but if the query gets run via $_CB_database->setQuery($query) the returning array is empty!?
Any ideas about that strange behavior ?

Best regards
Frank

I am testing with Joomla 1.7.2 and CB 1.7.1.

Please try the same.

Hi!

I did upgrade to Joomla 1.7.3 and CB 1.7.1 and finally find out that I have to set the setting "No section" to "Enabled"

Joomla 1.7 does not have sections anymore - so probably you can remove this setting completly.

Best regards
Frank

opened new item for fixing

forge.joomlapolis.com/issues/2995