SysGen falhou gerar Joomla

[bjverde]

SysGen falhou ao gerar os formularios Joomla 2.5.8

tabela categories

$controller = new ();
$list = $controller->selectAll();
$frm->addSelectField('CHECKED_OUT', 'CHECKED OUT',true,$list,null,null,null,null,null,null,' ',null);
$frm->addDateField('CHECKED_OUT_TIME', 'CHECKED OUT TIME',true);
$controller = new ();
$list = $controller->selectAll();
$frm->addSelectField('ACCESS', 'ACCESS',false,$list,null,null,null,null,null,null,' ',null);

[bjverde]

tabela banners

$controller = new ();
$list = $controller->selectAll();
$frm->addSelectField('STATE', 'STATE',true,$list,null,null,null,null,null,null,' ',null);
$controller = new ();
$list = $controller->selectAll();
$frm->addSelectField('CATID', 'CATID',true,$list,null,null,null,null,null,null,' ',null);

[bjverde]

Fazendo o Select TDAO::getSqlToFieldsFromDatabaseMySQL https://github.com/bjverde/formDin/blob/master/base/classes/webform/TDAO.class.php#L1687

Apresenta colunas KEY_TYPE = MUL no caso FOREIGN KEY porém os campos REFERENCED_TABLE_NAME e REFERENCED_COLUMN_NAME estão em branco.

[bjverde]

Referencias sobre o probelma

• https://premaseem.wordpress.com/2013/05/14/what-does-mul-mean-in-mysql-for-the-key/
• https://stackoverflow.com/questions/5317889/sql-keys-mul-vs-pri-vs-uni
• https://dev.mysql.com/doc/refman/5.7/en/show-columns.html

O Valor MUL é apenas quando a coluna tem index MULtivalorado não quer dizer que seja um FK

[bjverde]

A correção é alterar o linha L1696 TDAO.class.php https://github.com/bjverde/formDin/blob/master/base/classes/webform/TDAO.class.php#L1696

Para

, case when upper(c.COLUMN_KEY) = 'PRI' then 'PK' when ( upper(c.COLUMN_KEY) = 'MUL' AND k.REFERENCED_TABLE_NAME is not null) then 'FOREIGN KEY' else 0 end  KEY_TYPE

[bjverde]

Depends on the next version of FormDin 4.7.9 and issue https://github.com/bjverde/formDin/issues/207