Fatal error: Call to undefined method stdClass::build_join()

Whenever you start typing in the autocomplete field I get an error prompt with the error above. This happens on both a Finder block and a finder page. I have had no success in getting the module to work and it's exactly what I need. Is there any other information you need to troubleshoot?

I tried deleting the autocomplete field and using a basic text field and once I enter a search term and hit "search" I get a white screen with the same error:

Fatal error: Call to undefined method stdClass::build_join() in /home/content/44/7598244/html/drupal/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1164

This is using a views finder. I will try with a node finder and see if the same problem persists.

I am also getting the following errors on the Finder List page

    Notice: Undefined offset: 2 in finder_views_plugin_display_finder->query() (line 124 of /home/content/44/7598244/html/drupal/sites/all/modules/finder/modules/finder_views/includes/finder_views_plugin_display_finder.inc).
    Notice: Undefined offset: 1 in finder_views_plugin_display_finder->query() (line 124 of /home/content/44/7598244/html/drupal/sites/all/modules/finder/modules/finder_views/includes/finder_views_plugin_display_finder.inc).
    Notice: Undefined offset: 0 in finder_views_plugin_display_finder->query() (line 124 of /home/content/44/7598244/html/drupal/sites/all/modules/finder/modules/finder_views/includes/finder_views_plugin_display_finder.inc).

I set up a Node Finder and I get the following error when typing in the autocomplete field and/or hitting the search button:

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN) AND ((node.title = 'Th'))))) GROUP BY nid' at line 1: SELECT node.nid AS nid, node.title AS finder_element_11_node_title_title, 'nid' AS base_field, 'node' AS base_table FROM {node} node WHERE ((((node.type AND (movie) AND IN) AND ((node.title = :finder_0))))) GROUP BY nid; Array ( [:finder_0] => Th ) in finder_find_query() (line 1054 of /home/content/44/7598244/html/drupal/sites/all/modules/finder/finder.module).

I created a fresh Drupal 7.7 install on another server and installed the following modules:

Chaos tool suite (ctools) 7.x-1.x-dev (2011-Aug-06)
Finder 7.x-1.1 (2011-Aug-23)
Views 7.x-3.x-dev (2011-Aug-23)

- I added a Basic Page with the title "Test Page"
- Created a view titled "Basic" with a block display with all of the default settings. The only field is "Content: Title"
- Created a Views Finder with all of the default settings with,
- Checkmark next to "Form on Page"
- Find items from this view => drop down select to "Basic"
- Added a Autocomplete textfield element with default settings.
- Find items by this field I have highlighted "Content: Title"
- Navigated to the Finder Page "/finder/1"
- Began typing "Test Page" in the search field

And I got the same error as my original Drupal install

An AJAX HTTP error occurred.
HTTP Result Code: 200
Debugging information follows.
Path: http://MYSITEHERE/drupal7/finder_autocomplete/autocomplete/1/2
StatusText: OK
ResponseText: 
Fatal error:  Call to undefined method stdClass::build_join() in /home/sylense/public_html/MYSITEHERE/drupal7/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1164

Does this help?

I also just tried it against the stable releases of Ctools & Views:
Chaos tool suite (ctools) 7.x-1.0-rc1 and Views 7.x-3.0-rc1

Thanks! Can't wait to try out the next release