First, thank you for this module. I see incredible potential for this.
Second, I am having trouble installing or re-installing the subform module.
Below is the error message i Received. I notice that if I try to cut and pase the CREATE TABLE SQL commands into PHP Admin's SQL query interface it also complains with the follwoing error:
Error
SQL query:
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;
MySQL said: Documentation
#1064 - 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 'DEFAULT CHARSET=utf8' at line 1
The following is what i got when i tried to re-install.
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 'DEFAULT CHARSET=utf8' at line 13 query: _create_relation_content_type -- -- 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 /home/content/s/a/r/sarvilive/html/includes/database.mysql.inc on line 120
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 'DEFAULT CHARSET=latin1' at line 15 query: subform_install -- -- 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 /home/content/s/a/r/sarvilive/html/includes/database.mysql.inc on line 120
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 'DEFAULT CHARSET=latin1' at line 5 query: subform_install 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 /home/content/s/a/r/sarvilive/html/includes/database.mysql.inc on line 120
Warning: Cannot modify header information - headers already sent by (output started at /home/content/s/a/r/sarvilive/html/includes/database.mysql.inc:120) in /home/content/s/a/r/sarvilive/html/includes/common.inc on line 266
Comments
Comment #1
MrTaco commentedi receive no such error in mysql 4.1.15, or in 5.0.22
what version are you using
Comment #2
sarvi commentedWeb Programming Languages
PHP 4.3.11
Databases
MySQL 4.0.24
Comment #3
sarvi commentedI just tried out the following and it works
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 )
) Type=MYISAM;
Any reason you think just plain "Type=MYISAM" wouldn't suffice. I notice that none of the other tables use "charset" not "ENGINE" strings.
Comment #4
yojoe commentedDo you have a database table prefix setup in your settings.php? If so, your problem is the same like: http://drupal.org/node/108576. The subform.install file currently does not respect table prefixes.
Comment #5
casey commented