Views fusion error (ORDER)

it does work, but it was applying only with offset. I've rerolled it.

hm, there seems to be a bug with ORDER statements. Which sorts do you have added to which view? (primary vs fused)

hm, strange.
I wasn't able to reproduce it. You have a sort on the primary view only, but none on the secondary - but the query contains one!?

Have you installed the latest modules? (views fusion 1.2 and the latest views 1.6 beta)
If so, try simplifying your views step by step, remove fields except of the node title and filter except from the node type filter - and try the view after removing each field/filter.
If you get it working that way, which is the last one you removed?

you are using it right - but you have to fuse them by using the reverse order node reference (of the order type).

Then start with two basic views, just showing the node title and filtering for the types (one for style and one for order).
Fuse them with the style view as primary view - once that is working start adding further filters, fields and the sort criteria to your views.

hm, have you deleted the used nodereference?
Try removing the fusion and add it again.

Hi Fago,

I have the same error and maybe you could understand the problem. I have two views, let say 'project' and 'updates' where we put what is going on in the project. 'updates' has a nodereference to the project title. I'd like to build a views with the list of the projects with the last 'updates' of the project. I fused the views, project being primary and 'updates' is the secondary, using the nodereference reversed.

The result is the list of the project with the first update. So I added a sort criteria with the creationtime of the update. This is when I have the error. Looking to the SQL query error (I attached the text, sorry this is in french), I found that there is an error: the prefix isrepeated twice : "v19node.created AS v19v19node_created_created" I think this may be the problem.

What do you think.

Thank you so much for this plugin anyway, this is just what I need, except for this bug :)

As a follow up, I succeeded in finding a work around to the prefixe issue in the views_fusion.module and the error dissappeared. I have still no success to just fuse the last update in the project tables but this is another story

I'm having trouble getting this to work? I have two nodes:

Client Group

Instance of Client Group
- nodereference to a single "Client Group"

I set up two views with only the node titles and filtered by each content type. Tried to create a fused view by:

Primary View = Client Group
Fused with view = Instance of Client Group
Using = Nodereference reverse direction

Nothing shows up? Also in the table of the fused view, the "using" column is blank? Any ideas what I'm dong wrong? I did apply the nodereference patch from June 7th.

not sure if related but i suspect

i have very odd behavious with fused views (but also union views) - i get data showing and then after refresh it disappears

for fused case the primary content is always there; for instance if i go to module admin and do a save fused data shows; but on refresh it disappears..

i think (at least with 4.7) that doing a module submit causes cache dumping.. i have also seen that if i continually (i.e on every page) dump certain entries from cache (like imagecahce entry) that this problem goes away.. although for some reason doing this breaks my block admin

if i were to guess - and i am trying very hard to bring this out in the open.. i thnik the drupal 5 caching system is messed up... searching the issues on various modules and many issues like this one are starting to show up.. and people are trying to track down the issue in their module.. but i think something in core is messed up here

btw i am using latest of cck/views and dr 5.3 and also using the noderefernce module for fusing.. although.. as i have said.. i get similar disappearing data in views that arent fused.. but in both cases dumping imagecahce cache entry fixed them

Same problem

user warning: Unknown column 'v12term_data_weight' in 'order clause' query: SELECT DISTINCT(node.nid), users.name AS users_name, users.uid AS users_uid, node_data_field_user_name.field_user_name_uid AS node_data_field_user_name_field_user_name_uid, workflow_states.state AS workflow_states_state, node_data_field_training_event_instance.field_training_event_instance_nid AS node_data_field_training_event_instance_field_training_event_instance_nid, v12node.nid AS v12node_nid, v12term_data.weight AS v12v12term_data_weight, v12term_data.name AS v12v12term_data_name FROM node node INNER JOIN users users ON node.uid = users.uid LEFT JOIN content_type_registration node_data_field_user_name ON node.vid = node_data_field_user_name.vid LEFT JOIN workflow_node workflow_node ON node.nid = workflow_node.nid LEFT JOIN workflow_states workflow_states ON workflow_node.sid = workflow_states.sid LEFT JOIN content_type_registration node_data_field_training_event_instance ON node.vid = node_data_field_training_event_instance.vid INNER JOIN nodefamily nodefamily_parent ON node.nid = nodefamily_parent.parent_nid LEFT JOIN node v12node ON nodefamily_parent.child_nid = v12node.nid LEFT JOIN term_node v12term_node ON v12node.nid = v12term_node.nid LEFT JOIN term_data v12term_data ON v12term_node.tid = v12term_data.tid WHERE (node.type IN ('registration')) AND (v12node.type IN ('training_event')) ORDER BY v12term_data_weight ASC, v12term_data_name ASC LIMIT 0, 100 in /home/capcore/www/core2/drupal-5.2/includes/database.mysql.inc on line 172.