In the views branch, when I try to use "Wysiwyg ImageUpload: imagecache" as one of the views fields, I get the following errors:

* user warning: Unknown column 'wysiwyg_imageupload_entity.vid' in 'on clause' query: SELECT COUNT(*) FROM (SELECT node.nid AS nid FROM node node LEFT JOIN wysiwyg_imageupload_entity wysiwyg_imageupload_entity ON node.vid = wysiwyg_imageupload_entity.vid WHERE (node.status <> 0 OR (node.uid = 1 AND 1 <> 0) OR 1 = 1) AND (node.type in ('review')) ) count_alias in /home/gamegam2/public_html/sites/all/modules/views/includes/view.inc on line 745.
* user warning: Unknown column 'wysiwyg_imageupload_entity.vid' in 'on clause' query: SELECT node.nid AS nid, node.title AS node_title, wysiwyg_imageupload_entity.imagecache AS wysiwyg_imageupload_entity_imagecache FROM node node LEFT JOIN wysiwyg_imageupload_entity wysiwyg_imageupload_entity ON node.vid = wysiwyg_imageupload_entity.vid WHERE (node.status <> 0 OR (node.uid = 1 AND 1 <> 0) OR 1 = 1) AND (node.type in ('review')) ORDER BY node_title ASC LIMIT 0, 10 in /home/gamegam2/public_html/sites/all/modules/views/includes/view.inc on line 771.

I looked and in fact there is no vid column in that table. It only exists in the wysiwyg_imageupload_entity_revision table. The schema in the views branch also does not have it.

Comments

baraban’s picture

baraban commented

I cleared both wysiwyg_imageupload tables and added a vid column to the wysiwyg_imageupload_entity to mirror that in the wysiwyg_imageupload_entity_revision table. Then I re-added the WYSIWYG pictures to the nodes. I looked in the wysiwyg_imageupload_entity table to see if vid column gets populated - it did not. I then manually duplicated the contents of the vid column from wysiwyg_imageupload_entity_revision to wysiwyg_imageupload_entity. This rendered each node twice in the views, creating lightbox links with numbers and file name for the image filter and the word "display" for the imagecache filter in one of the renderings and without the filename and the word display in the other. So, the solution to this problem is not a simple join of wysiwyg_imageupload_entity and wysiwyg_imageupload_entity_revision tables on iid.

eugenmayer’s picture

eugenmayer commented

thanks for the investigation barbaran. I hope daniel could have a look on this.

baraban’s picture

baraban commented

Sounds like it isn't going to happen any time soon. Oh well, so close and yet so far from a real working solution...

eugenmayer’s picture

eugenmayer commented
Category: bug » feature

Well Daniel told me, he will look into it as soon as possible. Please be patient :)
As it is not released yet, its still a feature request

baraban’s picture

baraban commented

I see that 2.1 is out without views support. Is there still hope that this will make it into 2.2? what is the time-line on that?

eugenmayer’s picture

eugenmayer commented

@5: 2.1 is a patch release and probably 2.2 will also be only a patch release. I think it is realistic for 2.3, maybe 2 or 3 weeks. It all comes down to the time dereine has to help with that task

If people test more and provide issues i think it would go into the release even earlier.

eugenmayer’s picture

eugenmayer commented
Version: 6.x-2.0 » 6.x-2.2
Status: Active » Fixed

that one is already fixed. Views support will come with 2.4, not 2.3. Yet to buggy

Status: Fixed » Closed (fixed)

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