magento2 – Magento 2 custom ui_grid filterSearch issue

i have an error when attempting to search for a keyword in my custom table

See error here

In my grid XML declaration i have the following:

...
<dataSource name="my_grid_data_source">
    <argument name="dataProvider" xsi:type="configurableObject">
        <argument name="data" xsi:type="array">
            <item name="config" xsi:type="array">
                <item name="update_url" xsi:type="url" path="mui/index/render"/>
                <item name="storageConfig" xsi:type="array">
                    <item name="indexField" xsi:type="string">id</item>
                </item>
            </item>
        </argument>
        <argument name="class" xsi:type="string">VendorModuleUiDataProviderModuleGridDataProvider</argument>
        <argument name="name" xsi:type="string">my_grid_data_source</argument>
        <argument name="primaryFieldName" xsi:type="string">id</argument>
        <argument name="requestFieldName" xsi:type="string">id</argument>
    </argument>
    <argument name="data" xsi:type="array">
        <item name="js_config" xsi:type="array">
            <item name="component" xsi:type="string">Magento_Ui/js/grid/provider</item>
        </item>
    </argument>
</dataSource>
...

<listingToolbar>
    ...
    <filterSearch name="fulltext"></filterSearch>
    ...
</listingToolbar>

I have the database indexes in place (created from the install script)
see full text indexes here

However, when i try to search for something, i am getting that error i posted in the beginning of this question.
What am i missing?