warnings and an ajax error

Is your name from stargate atlantis?

Ah anyway thanks for reporting that, Drupal 7 is still a work in progress, will add this to the things I still need to do.

I can confirm the same ajax error message

subscribe.
confirm this with node_finder and autocomplete.

I confirm the error on an autocomplete field, with "Find items by this field" restricted to "Title"

Full error message goes:

An AJAX HTTP error occurred.
HTTP Result Code: 500
Debugging information follows.
Path: http://ophelias-macbook.local:8081/drupal/finder_autocomplete/autocomple...
StatusText: Service unavailable (with message)
ResponseText: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'nodestatus' in 'where clause': SELECT node.title AS finder_element_1_node_title
FROM
{node} node
WHERE (( (nodestatus = :db_condition_placeholder_0) ))
GROUP BY finder_element_1_node_title; Array
(
[:db_condition_placeholder_0] => 1
)
in finder_find_query() (line 1036 of /Applications/drupal-7C/apps/drupal/htdocs/sites/all/modules/finder/finder.module).

And when "Find items by this field" is restricted to "Body" the error goes:

An AJAX HTTP error occurred.
HTTP Result Code: 500
Debugging information follows.
Path: http://ophelias-macbook.local:8081/drupal/finder_autocomplete/autocomple...
StatusText: Service unavailable (with message)
ResponseText: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bitnami_drupal7.node_revisions' doesn't exist: SELECT node_revisions.body AS finder_element_1_node_revisions_body
FROM
{node} node
INNER JOIN {node_revisions} node_revisions ON node_revisions.vid = node.vid
WHERE (( (nodestatus = :db_condition_placeholder_0) ))
GROUP BY finder_element_1_node_revisions_body; Array
(
[:db_condition_placeholder_0] => 1
)
in finder_find_query() (line 1036 of /Applications/drupal-7C/apps/drupal/htdocs/sites/all/modules/finder/finder.module).

Notice: Undefined index: rows in finder_text_finder_element() (Zeile 114 von mydomain.com/sites/all/modules/finder/modules/finder_text/finder_text.module).
Notice: Undefined index: minlength in finder_text_finder_element() (Zeile 127 von mydomain.com/sites/all/modules/finder/modules/finder_text/finder_text.module).

These errors happen when you don't save your finder element after creating it. I can't reproduce the problem any other way, and those values should always be there.

I have fixed the node_revision/s thing mentioned in #5.

I get these error:

Ein AJAX-HTTP-Fehler ist aufgetreten
HTTP-Rückgabe-Code: 500
Im Folgenden finden Sie Debugging-Informationen.
Pfad: http://.../finder_autocomplete/autocomplete/3/4
Statustext: Service unavailable (with message)
Antworttext: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'node_revision.body' in 'field list': SELECT node.title AS finder_element_4_node_title, node_revision.body AS finder_element_4_node_revision_body
FROM
{node} node
WHERE ((nodestatus AND 1) AND ((node.title LIKE :finder_0 OR node_revision.body LIKE :finder_1)))
GROUP BY finder_element_4_node_title, finder_element_4_node_revision_body; Array
(
[:finder_0] => %Dar%
[:finder_1] => %Dar%
)
in finder_find_query() (Zeile 1050 von /.../sites/all/modules/finder/finder.module).

And these errors come up when i click on the "find" button:

Notice: Use of undefined constant node - assumed 'node' in finder_node_finder_find() (Zeile 193 von /.../sites/all/modules/finder/modules/finder_node/finder_node.module).

Notice: Use of undefined constant status - assumed 'status' in finder_node_finder_find() (Zeile 193 von /.../sites/all/modules/finder/modules/finder_node/finder_node.module).

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'node_revision.body' in 'field list': SELECT node.nid AS nid, node.title AS finder_element_4_node_title, node_revision.body AS finder_element_4_node_revision_body, 'nid' AS base_field, 'node' AS base_table FROM {node} node WHERE ((nodestatus AND 1) AND ((((node.title LIKE :finder_0 OR node_revision.body LIKE :finder_1))))) GROUP BY nid; Array ( [:finder_0] => %Dar% [:finder_1] => %Dar% ) in finder_find_query() (Zeile 1050 von /.../sites/all/modules/finder/finder.module).

Any ideas how to fix these errors?

Error on finder element select list:

Notice: Use of undefined constant node - assumed 'node' in finder_node_finder_find() (Zeile 193 von /.../sites/all/modules/finder/modules/finder_node/finder_node.module).
Notice: Use of undefined constant status - assumed 'status' in finder_node_finder_find() (Zeile 193 von /.../sites/all/modules/finder/modules/finder_node/finder_node.module).
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 (nodestatus AND 1)) GROUP BY finder_element_1_node_title' at line 1: SELECT node.title AS finder_element_1_node_title FROM {node} node WHERE ((node.type AND (article) AND IN) AND (nodestatus AND 1)) GROUP BY finder_element_1_node_title; Array ( ) in finder_find_query() (Zeile 1050 von /.../sites/all/modules/finder/finder.module).

Cant use finder at the moment its too bugy for drupal 7.

Status --> Active.

A couple of those were bugs, though unrelated to the original bug report in this issue. It sounds like you're having a number of unrelated issues, you may want to try the next 'dev' and see where to go from there. You might need to check your 'status report' for database updates. If you continue to have problems, please start a new issue for each one.

Actually ignore my remarks about database updates, I don't think that is the case at all.

The reality is some of the fields like "body" no longer exist in Drupal 7, so you will be unable to search them with finder node.
Probably will phase the finder node module out, it's useless - use finder views.

I get errors when I try and click on finder 2/ content finder/ people finder

Error message

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'name' in 'where clause': SELECT t__0.* FROM {finder} t__0 WHERE (name IN (:db_condition_placeholder_0)) ; Array ( [:db_condition_placeholder_0] => %ctools_export_ui ) in ctools_export_load_object() (line 427 of /home/jspcaorg/public_html/modules/ctools/includes/export.inc).

how do I use this module?