Download & Extend

Install file doesn't respect database table prefixes

Project:Subform
Version:4.7.x-0.30
Component:Code
Category:bug report
Priority:critical
Assigned:Unassigned
Status:closed (fixed)

Issue Summary

Subform module does not install correctly, when your drupal installation is configured to use database table prefixes.

In settings.php of your drupal installation you can define a prefix, that is used for all drupal tables. db_query() takes care of the prefix automatically, but you have to put every table name in curly braces: {table_name}. (See http://drupal.org/node/22795 for more info).

So please update "subform.install" file and put every table name in curly braces like:

CREATE TABLE IF NOT EXISTS {node_relation_instances} (
                `node_one` int(10) NOT NULL default '0',
                `node_two` int(10) NOT NULL default '0',
                `type` int(10) unsigned NOT NULL default '0',
                `id` int(10) unsigned NOT NULL auto_increment,
                PRIMARY KEY  (`id`),
                KEY `node_one` (`node_one`,`node_two`,`type`)
              ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Comments

#1

Well, I just found out, that fixing the subform.install file isn't sufficient. You have to fix subform.module too, by putting every database table name in curly braces.

#2

CHARSET=latin1; is wrong, too. Should be utf-8.

#3

Status:active» closed (fixed)
nobody click here