After adding some fields to the participant node, I get the following errors (that I can reproduce accesing to "Manage fields" tab in the participant node type edit):

* user warning: Table 'efejotape_iEycod.connect_data' doesn't exist query: SELECT pid FROM connect_data WHERE nid = 0 in web_path/public_html/includes/database.mysql.inc on line 174.
* warning: Invalid argument supplied for foreach() in web_path/public_html/modules/node/node.module on line 561.
* warning: implode() [function.implode]: Invalid arguments passed in web_path//public_html/modules/node/node.module on line 565.
* 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 '' at line 1 query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM i1sx_node n INNER JOIN i1sx_users u ON u.uid = n.uid INNER JOIN i1sx_node_revisions r ON r.vid = n.vid WHERE in web_path/public_html/includes/database.mysql.inc on line 174.

When I look to the database I see a prefix to all tables, ieyc_ so there must be something wrong in the query which doesn't take the prefixes.

Also, when I use the participant node (adding a signature), I get this error:

user warning: Table 'efejotape_iEycod.connect_data' doesn't exist query: SELECT pid FROM connect_data WHERE nid = 3 in web_path/public_html/jruiza/drupal5/includes/database.mysql.inc on line 174.

Please help I should get this working for tomorrow :-)

Comments

steve.m’s picture

steve.m commented
Assigned: Unassigned » steve.m
Status: Active » Needs review

As per an email discussion, there are a couple of places where connect doesn't properly use {} around table names.

I am shortly going to switch over to developing using the Drupal contrib CVS repository (instead of my own SVN site), but until I get the new code committed, here is one user's solution:

>Bug 1:
>
>connect.module:
>
>Line 547: $sql = 'SELECT pid FROM connect_data WHERE nid = %d';
>
>Correction
>
>$sql = 'SELECT pid FROM {connect_data} WHERE nid = %d';
>
>Bug 2:
>
>connect_blocks.php
>
>Line 19: $sql = "SELECT nid FROM node WHERE type IN ($types);";
>
>I have changed the hardcoded "node" for my table name. Perhaps something
>like {node} could be used.

steve.m’s picture

steve.m commented
Status: Needs review » Fixed

fixed in dev

Status: Fixed » Closed (fixed)

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