Forums

hi everybody,

Before the first : congratulations to dev for CC6

First : Why don't create a forum specialy for CC6 ? It's very different and search propulse always CC5 topic... and topic for CC5 seams to be useless for CC6

Two : CC6 seams to be the best component to match db table and make a very good job but why the debugging is so hard ? It's so hard to know the problem occurs

Third : my problem

From a K2 categories list I link a view of a k2 category named k2_items.
I would want to list every item K2 in the view of "k2 category view" and nothing appears

the debug this

Array
(
    [read-catK2-fiche] => Array
        (
            [log] => Array
                (
                    [0] => SELECT `k2_categories`.`id` AS `k2_categories.id`, `k2_categories`.`name` AS `k2_categories.name`, `k2_categories`.`parent` AS `k2_categories.parent`, `k2_categories`.`alias` AS `k2_categories.alias` FROM `arobas_k2_categories` AS `k2_categories` WHERE `k2_categories`.`id` = '7';
                )

        )

    [read-k2-items] => Array
        (
            [log] => Array
                (
                    [0] => SELECT COUNT(`k2_items`.`id`) AS `k2_items.count` FROM `arobas_k2_items` AS `k2_items` WHERE `k2_items`.`catid` = '7' AND `k2_items`.`published` = '1' AND `k2_items`.`trash` = '';
                    [1] => SELECT `k2_items`.`id` AS `k2_items.id`, `k2_items`.`title` AS `k2_items.title`, `k2_items`.`alias` AS `k2_items.alias`, `k2_items`.`catid` AS `k2_items.catid`, `k2_items`.`introtext` AS `k2_items.introtext` FROM `arobas_k2_items` AS `k2_items` WHERE `k2_items`.`catid` = '7' AND `k2_items`.`published` = '1' AND `k2_items`.`trash` = '' LIMIT 30;
                )

        )

)

it seams to be ok with query, i defined "table-items" with

Data provider
{var:read-k2-items}

Columns list
k2_items.id:ID
k2_items.title:Title

Columns views
k2_items.id
k2_items.title

and all is in view

{fn:read-catK2-fiche}
{fn:read-k2-items}
<h3>Catégorie K2 {var:read-catK2-fiche.k2_categories.name}</h3>
<p>Alias : {var:read-catK2-fiche.k2_categories.alias}</p>
<p>Les articles publiés de cette catégorie</p>
{view:table-items} // Only a grey bar appaers


Thanks for all

Hi Chris,

after {fn:read-k2-items}, please write: {var/pr:read-k2-items} in order to debug the records found, the next Connectivity update will display this in the debug report.

You are not using any columns views, so please keep that field empty.

There is a "Connectivity v6" tag, you can use that to filter the topics for v6 only, and then run a search.

Best regards,
Max

Thanks Max

I see the report and all items K2 are inside like this

Array
(
    [0] => Array
        (
            [k2_items] => Array
                (
                    [id] => 417
                    [title] => Qu’est-ce qu’une SOFICA ?
                    [alias] => qu’est-ce-qu’une-sofica-?
                    [catid] => 7
                    [introtext] => <span style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium 'Times New Roman'; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: #000000; WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px"><span style="LINE-HEIGHT: 18px; BORDER-COLLAPSE: collapse; FONT-FAMILY: Arial, Helvetica, sans-serif; FONT-SIZE: 12px">
<p style="margin: 0.35em 0px 0.8em; padding: 0px;" align="justify"><span style="font-family: verdana,geneva;"><span style="font-size: 10pt;"><strong>Les Sociétés pour le Financement de l'Industrie Cinématographique et Audiovisuelle (SOFICA)</strong><span-converted-space></span-converted-space><span-converted-space></span-converted-space> </span></span></p>
<p style="margin: 0.35em 0px 0.8em; padding: 0px;" align="justify"><span style="font-family: verdana,geneva;"><span style="font-size: 10pt;">Le capital de ces sociétés doit avoir fait l'objet d'un agrément préalable par la direction générale des impôts. Une SOFICA dispose de 12 mois (18 sous déragation), selon la libération du capital, pour investir à hauteur de 90 % dans des productions cinématographiques et/ou audiovisuelles, les 10% restant étant investis en actif monétaire.</span></span></p>
</span><span style="font-family: verdana,geneva;"><span style="font-size: 10pt;">sont des sociétés anonymes soumises à l'impôt sur les sociétés dans les conditions de droit commun. Elles ont été créées par la<span-converted-space></span-converted-space><span-converted-space></span-converted-space> </span></span></span><span style="font-family: verdana,geneva;"><span style="font-size: 10pt;">loi du 11 juillet 1985</span></span>
                )

        )

    [1] => Array
        (
            [k2_items] => Array
                (
                    [id] => 418
                    [title] => Qui peut souscrire ?
                    [alias] => qui-peut-souscrire-?
                    [catid] => 7
                    [introtext] => Le bénéfice de la déduction fiscale est réservé aux personnes physiques soumises à l’impôt sur le revenu en France.
                )

        )

    [2] => Array
        (
            [k2_items] => Array
                (
                    [id] => 419
                    [title] => Combien puis-je investir ?
                    [alias] => combien-puis-je-investir-?
                    [catid] => 7
                    [introtext] => <span><span><span><span>
<p><span><span>Vous pouvez investir dans la limite de 25 % de votre revenu et sans excéder un plafond de 18.000€, avec un minimum de l'ordre de 5.000€</span></span></p>
</span></span></span><span>
<p> </p>
</span></span>
<p><span><span> </span></span></p>
                )

...Etc ...

"columns views" is now empty but nothing appears
Ichecked and rechecked but i don't no
thanks for your help