When i activate for the first time the subfom.module in the admin/modules, I get theses messages (on a french PHP) :
=========================
Installing subform
Generating relation content type
Generating relation instances table
Subform module installed tables successfully.
The configuration options have been saved.
=========================
user warning: Erreur de syntaxe pr賠de 'DEFAULT CHARSET=utf8' ࠬa ligne 13 query: -- -- Table structure for table `node_content_relation_type` -- CREATE TABLE IF NOT EXISTS node_content_relation_type ( vid int(10) unsigned NOT NULL default '0', nid int(10) unsigned NOT NULL default '0', field_type_one_cn varchar(128) NOT NULL default '', field_type_two_cn varchar(128) NOT NULL default '', field_type_one_cardinality_value int(11) NOT NULL default '0', field_type_two_cardinality_value int(11) NOT NULL default '0', PRIMARY KEY (vid) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; in /tests/includes/database.mysql.inc on line 121.
user warning: Erreur de syntaxe pr賠de 'DEFAULT CHARSET=latin1' ࠬa ligne 15 query: -- -- Table structure for table `node_relation_instances` -- -- Creation: Nov 30, 2006 at 08:40 AM -- Last update: Nov 30, 2006 at 12:08 PM -- 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; in /tests/includes/database.mysql.inc on line 121.
user warning: Erreur de syntaxe pr賠de 'DEFAULT CHARSET=latin1' ࠬa ligne 5 query: CREATE TABLE IF NOT EXISTS `subform_dummy` ( `nid` int(10) unsigned NOT NULL default '0', `dummy` varchar(5) NOT NULL default 'dummy', PRIMARY KEY (`nid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; in /tests/includes/database.mysql.inc on line 121.
======================================================
I think the "ENGINE=MyISAM DEFAULT CHARSET=latin1" clause for creation of table in the subform.install is not support in the MySql system of my FAI...
Versions list:
PHP 5.0.4
MySql 4.0.23
Drupal 4.7.4
content.module,v 1.56.2.39 2007/01/09 14:53:45
views.module,v 1.159.2.32 2007/01/22 02:13:01
and :
subform.module, v0.30 for drupal 4.7
I try to change the subform.install and cancel the clause in ""ENGINE=MyISAM..." in the CREATE TABLE lines but whith no sucess...
Can you help me ?
Comments
Comment #1
ericg commentedsorry that I can't be more helpful other than to say that this is a known issue with the subform module. at this point it requires mysql 4.1 or higher. I'm not sure if just fixing the create statements in the install file is enough, there might be queries in the module that make use of things not in 4.0
Comment #2
derieppe commentedIssue out of date.