[#3675] Error message with list and filter, when no value

Hi. Last week we added a list to our website based on the field 'my team'. In that field there is a integer or multiple like '101 102', so this user is in team 102. And everyone who is in the same team of the user that views the list is shown in the list.

But when you are not in a team, we get a error. How can we hide the error or display the message: you are not in a team yet? Or maybe it is possible to hide the menu when someone is not in a team?

The message:

The filter:

Try the below quick fix.

IN: administrator/components/com_comprofiler/library/cb/cb.lists.php
ON: Line 347
FROM: TO:
Created the below bug ticket to further track the issue.

forge.joomlapolis.com/issues/3675

Hi Kyle,

Thanks for the help. Great and quick support, I appreciate it!

The following message is shown:

Er bevindt zich een fout in de database query. Administratoren kunnen debugging inschakelen
om te zien wat er misloopt om het probleem dan te kunnen oplossen.

Translation:
There is an error in the database query. Admin can enable debugging, to see what is going wrong.

So, the normal error message is still shown. Is it also possible to hide this message?

Or can I create a code, that if the user has no team number attached to his profile, that he will see the message: "You aren't in a team yet." ?

Try removing the filter and see if issue persists. Additional changes as follows.

IN: administrator/components/com_comprofiler/library/cb/cb.lists.php
ON: Line 349
FROM: TO:
IN: administrator/components/com_comprofiler/library/cb/cb.lists.php
ON: Line 353
FROM: TO:

I changed like you said, but the message that there is a problem with the query is still published.

I translated the message into a friendly sentence, so the user knows why he does not see a team.

The url width from the error isn't shown anymore, so that's fixed.

That means there is a problem with the filter. Review the debug information at the bottom of the page. Find the userlist query where your filter is at and see what's wrong with it. Please remove the filter and test if issue persists. With debug mode and maximum error reporting set in Joomla global configuration the error should be more specific though.