I aim to use TW to relate nodes with custom table data, when i first add "node" as the base table, and also select the "Provide default view" checkbox (and provide a distinct name for that view) I get the following message:

Added table default.node to the Table Wizard.

but also get the following warnings/errors:

# warning: Illegal offset type in E:\workspace\eclipse\php\lcph\sites\all\modules\views\includes\query.inc on line 96.
# warning: class_exists() expects parameter 1 to be string, array given in E:\workspace\eclipse\php\lcph\sites\all\modules\views\includes\handlers.inc on line 17.
# warning: class_exists() expects parameter 1 to be string, array given in E:\workspace\eclipse\php\lcph\sites\all\modules\views\includes\handlers.inc on line 37.

... and follows on....

# warning: Illegal offset type in isset or empty in E:\workspace\eclipse\php\lcph\sites\all\modules\views\includes\handlers.inc on line 120.
# warning: class_exists() expects parameter 1 to be string, array given in E:\workspace\eclipse\php\lcph\sites\all\modules\views\includes\handlers.inc on line 81.
# warning: class_exists() expects parameter 1 to be string, array given in E:\workspace\eclipse\php\lcph\sites\all\modules\views\includes\handlers.inc on line 17.
# warning: class_exists() expects parameter 1 to be string, array given in E:\workspace\eclipse\php\lcph\sites\all\modules\views\includes\handlers.inc on line 37.
# warning: Illegal offset type in isset or empty in E:\workspace\eclipse\php\lcph\sites\all\modules\views\includes\handlers.inc on line 120.
# warning: class_exists() expects parameter 1 to be string, array given in E:\workspace\eclipse\php\lcph\sites\all\modules\views\includes\handlers.inc on line 81.
# warning: class_exists() expects parameter 1 to be string, array given in E:\workspace\eclipse\php\lcph\sites\all\modules\views\includes\handlers.inc on line 17.
# warning: class_exists() expects parameter 1 to be string, array given in E:\workspace\eclipse\php\lcph\sites\all\modules\views\includes\handlers.inc on line 37.
# warning: Illegal offset type in isset or empty in E:\workspace\eclipse\php\lcph\sites\all\modules\views\includes\handlers.inc on line 120.
# warning: class_exists() expects parameter 1 to be string, array given in E:\workspace\eclipse\php\lcph\sites\all\modules\views\includes\handlers.inc on line 81.
# user warning: 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 'FROM node node LEFT JOIN og_uid og_uid ON node.nid = og_uid.nid WHERE (node.t' at line 2 query: SELECT FROM node node LEFT JOIN og_uid og_uid ON node.nid = og_uid.nid WHERE (node.type IN ('consorcio')) AND (og_uid.uid = 1) in E:\workspace\eclipse\php\lcph\sites\all\modules\views\includes\view.inc on line 769.

Nevertheless I see the new node table and its corresponding view added, even clicking over the view link will show the raw node table data. Editing the view is possible but i get errors in most of the fields, e.g.

Error: handler for node > nid doesn't exist!

previewing data from editing page seems to work as well.

Maybe I have forgotten to copy some handling code in my custom module?

I´m using

Views 6.x-2.8
Schema 6.x-1.7
TW 6.x-1.x-dev
OG 6.x-2.0

Thanks in advance for any help.

CommentFileSizeAuthor
#3 view_problem.jpg33.78 KBCountzero

Comments

Rosamunda’s picture

Rosamunda commented

subscribing

mikeryan’s picture

mikeryan
he/him
Primary language English
Location Pittsfield, MA, USA
commented

Yes, I can reproduce this. I doubt this can be made to work (at least, not easily), we probably should disallow trying to provide a default view for the node table.

But, your purpose is to create a view combining the node table with custom table data, as you say. There's no reason to make a default view of the node table itself - just add the node table as-is, then create relationships with your data.

Countzero’s picture

Countzero commented
StatusFileSize
new view_problem.jpg33.78 KB

Hello and thanks for your work.

Simply adding any node table, with or without the default view option checked messes up the View interface completely (see screenshot).

At this stage, it's impossible to create any node based View, which is really a problem ...

mikeryan’s picture

mikeryan
he/him
Primary language English
Location Pittsfield, MA, USA
commented
Status: Active » Closed (duplicate)

Don't know why I didn't mark it duplicate originally:

#617142: Horrible collisions of death when adding a table w/ same name as Drupal table or existing view