external db connection

Hi Max, I'm having an issue before las chronoform update.
working with external db, it tryes to call the table id instead of the table name (i.e. dbname.56). the error code is 1146, obviously the searched table don't exist.
Can you verify this strange behavior?
​
Thanks in advance

Another trouble I'm facing is that if I put the primary key in read data action and join rules, the join rule doesn't work, instead it takes tables primary keys, then I have to delete the join primary key in every read data action with joins

Should only put the primary key in the extra models if it's ACTUALLY a primary /foreign key. Otherwise use the manual relationship.

Thank you healyhatman. But the real problem is the external dB connection. I hope that a solution will come as soon as possible. It appended with the last chronoform update. Before it all worked fine

What about the NEW latest update?

Tomorrow I will do some other test, but I'm really sure that in the last update is passed the table id instead of the table name. I hope you can solve it soon

Please read my first post of this topic for details. I'm having a great problem with external dB connection

Hi healyhatman. Is there a way to fast hack the read data action code in order to pass the table name instead of table id?
It would be a good solution to my problem.
​
Thank you

In libraries/cegcore2/admin/chronoforms/extensions/functions/read_data can't help more than that sorry I'm out at the moment

Ok. I will let you know if it works.
​
Thank you very much

hi healyhatman, as I thought, in the y1zly_chronoengine_forms6 table I found that in the "functions" column corresponding to the form in which I use external db connection, inside the json the "db_table" param value is an ID instead of a table name.
For the moment I can manage replacing ids with table names directly in the json corresponding the interessed forms.
​
I know you're out at te moment, but if you coud be more precise to tell me what is the function that manage external db tables I could save some time to make some correction.
​
Thank you

Replacing IDs with table name make the form working. The problem occurs when I save the form, but for the moment I can manage it by changing IDs into table names.
​
I hope you can solve this soon.