I've got version 5.7 running successfully and populated with a fair bit of content already, but am having problems with the search function in particular.

In the administration area I am unable to access the "Search settings" (/admin/settings/search) page at all. For some reason the page won't load (blank page in FF, "Internet Explorer cannot display the webpage" in IE).

Probably related somehow, in the front end performing a search DOES find and display results, but at the top of the page the following appears:

Looking for name. Mode = ci. 
Scanning title in node_revisions on vid. 
Scanning body in node_revisions on vid. 
Scanning teaser in node_revisions on vid. 
Looking for name. Mode = ci. 
Scanning title in node_revisions on vid. 
Scanning body in node_revisions on vid. 
Scanning teaser in node_revisions on vid. 

user warning: Table 'aboutthat.node_field_instance' doesn't exist query: SELECT nfi.field_name, nfi.type_name, nf.db_storage FROM node_field_instance nfi INNER JOIN node_field nf USING (field_name) 

WHERE nfi.widget_type='text' in /var/www/vhosts/aboutthat.de/httpdocs/includes/database.mysql.inc on line 172. 
user warning: Table 'aboutthat.node_field_instance' doesn't exist query: SELECT nfi.field_name, nfi.type_name, nf.db_storage FROM node_field_instance nfi INNER JOIN node_field nf USING (field_name) 

WHERE nfi.widget_type='text' in /var/www/vhosts/aboutthat.de/httpdocs/includes/database.mysql.inc on line 172. 

This shows up whether I'm logged in or not.

In case it might be related, I've installed the 'search config' module, but disabling it doesn't seem to change anything.

Can anyone point me in the right direction as to what might be causing the warnings/error? From searching the forums I understand a lot of search issues may have something to do with temp database tables, but I wasn't sure if that would explain the blank search settings page, and as a relatively non-technical guy I'm not sure what to do about it either way.

Thanks for any suggestions.

Comments

pcambra’s picture

The table "node_field_instance" that is giving you these errors is part of the CCK module, have you this module correctly installed on your site? Did you check if this table exist in the database?

boonies’s picture

Thanks for the reply...

Interestingly enough, I don't have CCK installed at all (never had added it), and the table doesn't exist - it's not a dependency for search as far as I can tell? Perhaps I should try installing it just to see if that helps, but I'm not sure what would requiring it to be honest...

pcambra’s picture

I dont know of other modules that install this table, is part of the .install file (download the cck module and take a look). I think that CCK or Flexinode has been installed on the site and now it isn't.
Try to:
a) execute the cron
b) disable & uninstall the search module
c) install CCK (If Flexinode is not installed) and then disable & uninstall it

Hope this helps

timgilmour’s picture

I'm running into the same issue, yet without the database errors. Anyone have any thoughts on this?