In your install schema, this module installs the table with the name 'z_commentsubscribe', but it should be just 'comment_subscribe' since Drupal has built-in table prefixing and your install and uninstall functions request the schema 'comment_subscribe'.

Related code in commentsubscribe.install:

function comment_subscribe_schema() {
  $schema['z_commentsubscribe'] = array(...

function comment_subscribe_install() {
  // Create tables.
  drupal_install_schema('comment_subscribe');
}

Comments

dave reid’s picture

dave reid
he/him
Primary language English
Location Nebraska USA
commented

Well...nevermind about the drupal_install_schema() bit, it finds the correct schema. But still, your table names do not follow the Drupal SQL coding standard.

giorgio79’s picture

giorgio79 commented

On install I am getting isses that I think is related to this

user warning: Table 'mydbname.comments' doesn't exist query

The reason I dont have it is because I use a prefix for my drupal tables
myprefix_comments that I set during install

dave reid’s picture

dave reid
he/him
Primary language English
Location Nebraska USA
commented

@giorgio79 The prefix issue should be fixed in the 6.x-1.x release. See #289625: Flawed SQL statement warning when enabling the module.

dcaillibaud’s picture

dcaillibaud commented
Title: Incorrect schema name in comment_subscribe.install » {} forgotten in query line 112 of comment_subscribe.install

I've still th prefix pb with 6.x-1.2 (2008-Déc-24) version.

You've to change line 112 of comment_subscribe.install from
db_query("INSERT INTO z_nodesubscribe (nid, uid) select nid,uid from node");
to
db_query("INSERT INTO {z_nodesubscribe} (nid, uid) select nid,uid from {node}");

zyxware’s picture

zyxware commented
Assigned: Unassigned » zyxware
Status: Active » Closed (duplicate)

Marked as duplicate
Refer this thread http://drupal.org/node/289625

Regards
zyxware

zyxware’s picture

zyxware commented
Priority: Normal » Critical
Status: Closed (duplicate) » Closed (fixed)