Version 2.0 completely breaks my web site

Steve Hanson - August 20, 2008 - 17:32
Project:webform report
Version:5.x-2.0
Component:Code
Category:bug report
Priority:critical
Assigned:Unassigned
Status:active
Description

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

klance - August 21, 2008 - 14:14

Hi Steve, did you run update.php after installing the new version? If so, what versions of Drupal and mysql are you running?

#2

Steve Hanson - September 3, 2008 - 19:48

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

Steve Hanson - October 1, 2008 - 23:35

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.

 
 

Drupal is a registered trademark of Dries Buytaert.