Problem with databasejoin view in list with conditions....

[mobt.ap]

Hello, I'm in trouble in fabrik when I have a form containing a databasejoin a cacadidonw and repeat-group have sql errors displaying the list if destativo the databasejoin the problem goes away!

Error

500 - Fabrik has generated an incorrect query for the list Pedidos: <br /><br /><pre>Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=SELECT DISTINCT `jie_pedidos`.`id` AS __pk_val0, `jie_pedidos_18_repeat`.`id` AS __pk_val1 FROM `jie_pedidos` LEFT JOIN `jie_clientes` AS `jie_clientes` ON `jie_clientes`.`id` = `jie_pedidos`.`cliente` LEFT JOIN `jie_pedidos_18_repeat` AS `jie_pedidos_18_repeat` ON `jie_pedidos_18_repeat`.`parent_id` = `jie_pedidos`.`id` LEFT JOIN `jie_produtos` AS `jie_produtos` ON `jie_produtos`.`id` = `jie_pedidos_18_repeat`.`descr_prod` LEFT JOIN `jie_desc_prod` AS `jie_desc_prod` ON `jie_desc_prod`.`desconto` = `jie_pedidos_18_repeat`.`desc` LEFT JOIN `jie_vendedores` AS `jie_vendedores` ON `jie_vendedores`.`codalterdata` = `jie_pedidos`.`confirmecodigovendedor` ORDER BY `jie_pedidos`.`id` DESC</pre>

 

[troester]

Fabrik is creating the table jie_pedidos_18_repeat with the default database collation.
I assume at least one of your tables doesn't use this default collation.

 

[mobt.ap]

The error only if databasejoin is enable.

 

[troester]

And what is the collation of the table the dbjoin is pointing to?
What is the database collation?
What's the collation of the other tables?

 

[mobt.ap]

In all database collation is utf8_general_ci,

erro to be continue,

500 - Fabrik has generated an incorrect query for the list Pedidos: <br /><br /><pre>Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=SELECT DISTINCT `jie_pedidos`.`id` AS __pk_val0, `jie_pedidos_18_repeat`.`id` AS __pk_val1 FROM `jie_pedidos` LEFT JOIN `jie_clientes` AS `jie_clientes` ON `jie_clientes`.`id` = `jie_pedidos`.`cliente` LEFT JOIN `jie_pedidos_18_repeat` AS `jie_pedidos_18_repeat` ON `jie_pedidos_18_repeat`.`parent_id` = `jie_pedidos`.`id` LEFT JOIN `jie_produtos` AS `jie_produtos` ON `jie_produtos`.`id` = `jie_pedidos_18_repeat`.`descr_prod` LEFT JOIN `jie_desc_prod` AS `jie_desc_prod` ON `jie_desc_prod`.`desconto` = `jie_pedidos_18_repeat`.`desc` LEFT JOIN `jie_vendedores` AS `jie_vendedores` ON `jie_vendedores`.`codalterdata` = `jie_pedidos`.`confirmecodigovendedor` ORDER BY `jie_pedidos`.`id` DESC</pre>

 

[mobt.ap]

Problem resolved with this tool

http://www.phoca.cz/documents/38-tools/154-how-to-change-collation-in-database

Thanks for Help troester!