Version 2.0 completely breaks my web site
| Project: | webform report |
| Version: | 5.x-2.0 |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
If I install the 2.0 version of this module, all heck breaks loose with the site, and it generates errors on almost every page in the site of more or less this form:]
Not that this is on all KINDS of table in the site, not just this one. Disabling the module makes the site behave again.
Downgrading to version 1.4 also fixes the site, but it's fairly useless as we're using webform 2.1.3
Message Not unique table/alias: 'n' query: SELECT DISTINCT(node.nid), node.sticky AS node_sticky, node.created AS node_created_created, node_data_field_blogimage.field_blogimage_fid AS node_data_field_blogimage_field_blogimage_fid, node_data_field_blogimage.field_blogimage_title AS node_data_field_blogimage_field_blogimage_title, node_data_field_blogimage.field_blogimage_alt AS node_data_field_blogimage_field_blogimage_alt, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN content_type_blog node_data_field_blogimage ON node.vid = node_data_field_blogimage.vid INNER JOIN node_access na ON na.nid = node.nid LEFT JOIN node n ON node.nid = n.nid LEFT JOIN node n ON node.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'workflow_access') OR (na.gid = 0 AND na.realm = 'workflow_access_owner') OR (na.gid = 0 AND na.realm = 'og_public'))) AND ((n.moderate != 1)) AND (n.type <> 'webform_report') AND ( (node.status = '1') AND (node.type IN ('blog')) AND (node.promote = '1') AND (node.moderate = '0') ) ORDER BY node_sticky DESC, node_created_created DESC in /scratch/home/test.midpenmedia.org/public_html/drupal-5.10/includes/database.mysqli.inc on line 154.

#1
Hi Steve, did you run update.php after installing the new version? If so, what versions of Drupal and mysql are you running?
#2
Sorry it's taken me so long to respond - I've been in Denver for the Dem Convention.
Yes, ran update.php
Using PHP 5.2.5 and Mysql 5.0.45, Drupal 5.10
#3
Also note - I'm having the same problem with 2.1 -- note that this ONLY seems to cause problems for non-authenticated users. People who are logged in are fine.