subpanel sorting error

[pixprotom]

I am using 6.1.3. I am getting a lot of errors with sorting column, mostly in subpanels and custom fields. I looked at the SQL that is generated and there seems to be errors there. It creates a column for a related contact name but in phpmyadmin that column is empty even though on the web it has a contact name there. when I run the SQL that is produced when sorting that column it wants to sort that column that is empty in the phpmyadmin so the sort doesn't work.

It seems strange that columns in a subpanel have sort arrows by default but the sort doesn't work. And another field that was set to sort => false works perfect when I set it to true.

I created a module with a related field to account and another related field to contact and a third field that is just text. the two related fields have sort arrows but don't sort and the text field was set to sort=>false and when I set it to true it works perfectly.

Does anyone know how to correct this?