View loading error when a table contains relation and some data

[mootensai]

View loading error when a table contains relation and some data

[mootensai]

Can you show me the error?

[RGTimothy]

These 2 images below are the error.

[mootensai]

Please show me the full error, generated models, & SQLs..

[mootensai]

this is because you don't setup the foreign key of table_a_id column at table_b

[iurijacob]

I'm having the same issue. This occurs when your tables have composite names, like my_table1.
So, for example, in crud\Generator.php in method generateGridViewFieldIndex, about line 941 you have:

$modelRel = $rel[2] ? Inflector::pluralize($rel[3]) : $rel[3];
$output = "[
    'attribute' => '$attribute',
    'label' => " . $this->generateString(ucwords(Inflector::humanize($rel[5]))) . ",
    'value' => function(\$model){
        return \$model->$modelRel->$labelCol;
    },
    'filterType' => GridView::FILTER_SELECT2,
    'filter' => \\yii\\helpers\\ArrayHelper::map(\\$this->nsModel\\$rel[1]::find()->asArray()->all(), '$rel[4]', '$labelCol'),
    'filterWidgetOptions' => [
        'pluginOptions' => ['allowClear' => true],
    ],
    'filterInputOptions' => ['placeholder' => '$humanize', 'id' => '$id']
],\n";
return $output;

Note that $modeRelat line 941 is set to pluralize or the normal attribute pattern (with underscore separating words). But at line 946 it should be in variablize pattern (with camelcase separating words).

In the case above we can fix the issue by changing the line 946 to:

$modelRel = $rel[2] ? Inflector::pluralize($rel[3]) : Inflector::variablize($rel[3]);

The same can be done in generateDetailViewField method, about line 826, that get fixed by replacing these lines:

$output = "[
'attribute' => '$rel[3].$labelCol',
'label' => " . $this->generateString(ucwords(Inflector::humanize($rel[5]))) . ",

with these lines:

$modelRel = $rel[2] ? Inflector::pluralize($rel[3]) : Inflector::variablize($rel[3]);
$output = "[
'attribute' => '$modelRel.$labelCol',
'label' => " . $this->generateString(ucwords(Inflector::humanize($rel[5]))) . ",

I'm testing it by now, but it seems that the issue is cleared.

[mootensai]

                                                                                  Please test @dev version‎. Is dev version is still generate the same error?

[iurijacob]

Yes. I'm using the @dev version.

[mootensai]

Sorry, I don't quite get it.. Is it still error when u use @dev version?

[iurijacob]

Yes, the error still occurs in @dev version. You have to fix the code mentioned above in order to fix the issue.

[mootensai]

could you give me your sqldump? I've tested @dev version with http://downloads.mysql.com/docs/sakila-db.zip database. And when I generate actors, film-actors, and films (many-many relationship / film-actors have composite pk), it's fine.

[iurijacob]

Great!! it seems to be working now.
Although it still stucks in self-referenced tables. But everything else is just fine.

[mootensai]

Yes! For self reference table I'm trying to build nested builder.. it's on https://github.com/mootensai/yii2-enhanced-gii-nested but it's unfinished