Hi,

after installation (with sql manual update as written on notes) and configuration of the latest version (I build a view vith some filters on), upon a search, I obtain this error:

user warning: Table '

.temp_vfs' doesn't exist query: SELECT count(node.nid) FROM node node INNER JOIN temp_vfs temp_vfs ON node.nid = temp_vfs.nid LEFT JOIN content_type_articolo node_data_field_data_pubblicazione ON node.vid = node_data_field_data_pubblicazione.vid LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_data term_data ON term_node.tid = term_data.tid WHERE (node.status = '1') AND (( REPLACE(node_data_field_data_pubblicazione.field_data_pubblicazione_value,'T',' ') + INTERVAL (3600) SECOND) <= (NOW() + INTERVAL (3600) SECOND)) AND (node.type IN ('articolo')) AND (term_data.vid = '1') in \includes\database.mysql.inc on line 172.

user warning: Table '

.temp_vfs' doesn't exist query: SELECT node.nid, temp_vfs.score FROM node node INNER JOIN temp_vfs temp_vfs ON node.nid = temp_vfs.nid LEFT JOIN content_type_articolo node_data_field_data_pubblicazione ON node.vid = node_data_field_data_pubblicazione.vid LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_data term_data ON term_node.tid = term_data.tid WHERE (node.status = '1') AND (( REPLACE(node_data_field_data_pubblicazione.field_data_pubblicazione_value,'T',' ') + INTERVAL (3600) SECOND) <= (NOW() + INTERVAL (3600) SECOND)) AND (node.type IN ('articolo')) AND (term_data.vid = '1') LIMIT 0, 10 in \includes\database.mysql.inc on line 172.

Any ideas?

Many thanks in advance,
Alessandro

Comments

douggreen’s picture

You also need to install a patch to views 1 #143888. This last instruction accidentally got dropped from the 5.x-1.x-dev release notes. I've added this last instruction to the 5.x-2.x release notes. Sorry, and Thanks for pointing this out!

alex72rm’s picture

Status: Active » Fixed

Thx, it works great!

Uhm, when a new version of views module that integrate that patch?

Alessandro

douggreen’s picture

I wish I knew... I'm going to have to re-work the patch for Views 2.

Anonymous’s picture

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.