Install file doesn't respect database table prefixes
yojoe - January 11, 2007 - 16:01
| Project: | Subform |
| Version: | 4.7.x-0.30 |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
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;
#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
is wrong, too. Should be
utf-8.