View action not working

Hi,

On view linkable field i have the value "Demanda.otro".

Then on HTML field, I have: Demanda.otro:Más información

And on View action "Code" field: <h1 class="titulo-pagina">Datos de la Demanda #{Demanda.idD}</h1>

When I click over the link, the page shows:

1054
Unknown column 'Demanda. IS NULL' in 'where clause' SQL=SELECT `Demanda`.`idD` AS `Demanda.idD`, `Demanda`.`created` AS `Demanda.created`, `Demanda`.`name` AS `Demanda.name`, `Demanda`.`descripcion` AS `Demanda.descripcion`, `Demanda`.`newestado` AS `Demanda.newestado`, `Demanda`.`nombreProtagonista` AS `Demanda.nombreProtagonista`, `Demanda`.`apellidosProtagonista` AS `Demanda.apellidosProtagonista` FROM `sioa-demanda` AS `Demanda` WHERE `Demanda`.` IS NULL
Oh My Gosh! You Found It!!!
Looks like the page you're trying to visit doesn't exist.
Please check the URL and try your luck again.

because my link url is index.php/demanda?cont=lists&ccname=Demanda&act=view

How can I solve the problem? Thanks

Hi yusufo,

Do you have the latest update installed ? the link must contain the primary key value in this format:

&gcb=123

If this doesn't work then you can use the "Links" box and provide the view link.

Regards,
Max

Thanks Max but it doesn't work.

Is possible to not working because the connection is associated with a MySQL View.

Can you take a look with a link, an username and a password?

Thanks for your great extensions and great support.

Hi again,

I tested with another connection that is a MySQL table and the view link works without errors.

So, the problem is with a connection that is related to a MySQL view.

Thanks.

Hi Yusofo,

A MySQL View doesn't have a primary key column set so probably won't work easily with ChronoConnectivity. Can you access the table directly instead?

Bob

Hi Bob,

I make a MySQL view to JOIN 3 MySQL tables. Is there a way to make it possible without use a MySQL View?

Thanks for your help.

You need to get it working with 1 table first, then test with 3 tables, you can use the "Relations" section in Connectivity, use the "Add new model" and set the relation settings for the other tables.

Regards,
Max

Thanks Max. With 1 table it works great. I will try to make relations later.

Thank you very much.