Error message: exceeded 100000 distinct ids

Looks like you don’t have an upward bound on the number of records your query is attempting to pull in and there are more than 10,000 records being returned in the query which exceeds the max number allowed.
You could put more conditions on your query or add a max number of records returned on your model.

Not really the issue, as it’s a SF limit from what I read here: Help And Training Community

This object is public and has over 200,000 records, and limit is 100,000

on models I limit to 100 records

Weird thing is I only see/get this error when on community page , but not in SF, so was wondering if any way to just hide the error message, as all loads fine.

You could try to right click the error message, inspect with the browser, and see what css classes are associated with it and try to add css “display: none;” to hide it. If this is possible, this would hide all error messages though.

A couple thoughts:  

1. It could be possible that one or more of your model conditions are on a field the public community user doesn’t have access to - the condition is failing and that’s why it’s bringing in all the Ids.
2. You can also go into your page XML and add this line to the page node it to show page problems in the console. This way they won’t disturb users, but can still be used for debugging. This will work for Skuid page problems, but I’m not sure if it will work for Salesforce errors, so see #1.

   pageProblemsLocation="console"

   So if your page is called “MyPage” the first line of the XML would look like this

<skuid__page unsavedchangeswarning="yes" personalizationmode="server" theme="Ink" showsidebar="false" showheader="false" pageProblemsLocation="console">

Note that if the page is a dependent page, you should make this change in the principal page.