Forums

Hello,

iam totally new to CCv5, so iam just testing the possibilities. Few minutes ago i testet the tutorial (Basic...) at the FAQ site, to Display a list of articles. Ther Comes the Problem, when i pushes the button test Connection.

It showed me an List of my articles, but it displayed only the collumns, the lines between the rows (only the formal aspects of my view) NO Content in ther, blank, empty,... nothing.

Any Idea what went wrong? I tried to figure it out with your Forum-search an Google but i found no significant hint, so i hope you can help me here. My written english ist terrible, iknow, hope anyone understands my question.

Hi Merten,

Please enable the "debug" under the "Front list" or (admin list) "Settings" tab then check the listing again, please copy and paste the debug data then here!

Regards,
Max

Here it comes:

Connection Name: Test_Connection
Model: Article
Frontend List - CollumnsList: Test_Connection.id:ID Test_Connection.title:Title

Array
(
[0] => SELECT `Extension`.`id` AS `Extension.id`, `Extension`.`name` AS `Extension.name` FROM `ers1_jos_chronoengine_extensions` AS `Extension` WHERE `Extension`.`enabled` = '1' ORDER BY `Extension`.`ordering` ASC
[1] => SELECT `Connection`.`id` AS `Connection.id`, `Connection`.`title` AS `Connection.title`, `Connection`.`params` AS `Connection.params`, `Connection`.`extras` AS `Connection.extras`, `Connection`.`published` AS `Connection.published` FROM `ers1_jos_chronoengine_connections` AS `Connection` WHERE `Connection`.`title` = 'Test_Connection' AND `Connection`.`published` = '1'
[2] => SELECT COUNT(*) AS `Artikel.count` FROM `ers1_jos_content` AS `Artikel`
[3] => SELECT `Artikel`.`id` AS `Artikel.id`, `Artikel`.`asset_id` AS `Artikel.asset_id`, `Artikel`.`title` AS `Artikel.title`, `Artikel`.`alias` AS `Artikel.alias`, `Artikel`.`introtext` AS `Artikel.introtext`, `Artikel`.`fulltext` AS `Artikel.fulltext`, `Artikel`.`state` AS `Artikel.state`, `Artikel`.`catid` AS `Artikel.catid`, `Artikel`.`created` AS `Artikel.created`, `Artikel`.`created_by` AS `Artikel.created_by`, `Artikel`.`created_by_alias` AS `Artikel.created_by_alias`, `Artikel`.`modified` AS `Artikel.modified`, `Artikel`.`modified_by` AS `Artikel.modified_by`, `Artikel`.`checked_out` AS `Artikel.checked_out`, `Artikel`.`checked_out_time` AS `Artikel.checked_out_time`, `Artikel`.`publish_up` AS `Artikel.publish_up`, `Artikel`.`publish_down` AS `Artikel.publish_down`, `Artikel`.`images` AS `Artikel.images`, `Artikel`.`urls` AS `Artikel.urls`, `Artikel`.`attribs` AS `Artikel.attribs`, `Artikel`.`version` AS `Artikel.version`, `Artikel`.`ordering` AS `Artikel.ordering`, `Artikel`.`metakey` AS `Artikel.metakey`, `Artikel`.`metadesc` AS `Artikel.metadesc`, `Artikel`.`access` AS `Artikel.access`, `Artikel`.`hits` AS `Artikel.hits`, `Artikel`.`metadata` AS `Artikel.metadata`, `Artikel`.`featured` AS `Artikel.featured`, `Artikel`.`language` AS `Artikel.language`, `Artikel`.`xreference` AS `Artikel.xreference` FROM `ers1_jos_content` AS `Artikel` LIMIT 30
)

Hope someone figures it out...
:)

Sorry !
The Model is called: Artikel

Ahhhh!
Fixed with Trial and Error. Named the Model to Article, the Collumns List to Article.id:ID and the Connection also to Article. Now it works quite fine, but i dont know why, maybe someone of you can just explain it to me in few words.