Forums

Sorting tables by nonexisting fields when changing connections

bmarkus 13 Mar, 2016
Hi

I have several CC5 connections with different tables linked to menu items. In general it works, but if I sort by a column in one connections and changing to another connection, ORDER BY is not cleared it sorts the second table by field inherited from previous connection. If there are no such field in second table, SQL query fails with error.

How can I fix this behavior?

Regards... Béla
bmarkus 15 Mar, 2016
No answer, so lets continue the story. I removed all column sorting in a table and configured a default sort in MODEL tab. Great, table is sorted by default as expected. Now I sort in another connection. When going back to the first one, now it is not serted. It means that there is an interaction between the otherwise independent connections.

As it is now CC5 look unusable.
GreyHead 16 Mar, 2016
Hi Béla,

Please ask Max, the developer, using the Contact Us menu above and linking to this thread.

I have encountered what I think is the same problem - CC adds some search and sort values to the URL and / or the User Session and there is no simple way to clear them when they aren't needed.

In my application I added some code to the listing header to clear unwanted values - it worked in that case but isn't an ideal solution.

Bob
bmarkus 16 Mar, 2016
Hi Bob

thanks for the advice, I will do. Except this bug, I'm happy with CC5/FF5 and would be unhappy to drop it and rewrite applications. However I have to look for an alternative solution as 'Plan B' if no fix.

Regards,

Béla
bmarkus 17 Mar, 2016
Today I dropped ChronoConnectivity and changed over to another framework in my new project. I managed it one day and works as expected. Also, I get help in their forum within few hours so it is promising.

However the bug is still there in old projects.

😟
frimi 18 Jul, 2016
Hey,
I think I have the same problem.
I have set two forms on a page. I think the reason is that this form have identical id (id = "admin_form").
How can I change the ID?
Michael
GreyHead 18 Jul, 2016
Hi Michael,

That might be the problem though I'm a bit doubtful - does it work OK if there isn't another form on the same page (you should be able to test from the View Front Listing link).

I don't know of any way to change the id except by hacking the CC code :-(

Bob
Max_admin 21 Jul, 2016
Hi,

The solution to this problem is to use different models names in your connections.

Regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.