Hi,
I recently updated my webform module to 5.x-2.0. After updating all the table webform_submitted_data was empty.
I allready had data in this table (I have a backup of it). My users need this data displaying on the internet and I would like to know how to integrate the data from my backup to the new structure of this table.
The old table is as follows:
CREATE TABLE `webform_submitted_data` (
`nid` int(10) unsigned NOT NULL default '0',
`sid` int(10) unsigned NOT NULL default '0',
`cid` int(10) unsigned NOT NULL default '0',
`no` int(10) unsigned NOT NULL default '0',
`data` longtext,
PRIMARY KEY (`nid`,`sid`,`cid`,`no`),
KEY `sid` (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
And the new one:
CREATE TABLE `webform_submitted_data` (
`nid` int(10) unsigned NOT NULL default '0',
`sid` int(10) unsigned NOT NULL default '0',
`cid` smallint(5) unsigned NOT NULL default '0',
`no` tinyint(4) NOT NULL default '0',
`data` longtext,
PRIMARY KEY (`sid`,`cid`,`no`),
KEY `nid` (`nid`),
KEY `sid_nid` (`sid`,`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
I tried to import the old data to the new table but as the structure isn't the same; I have an error from Mysql.
The rows 'cid' and 'no' are completely different.
What to do?
Comments
Comment #1
quicksketchPruning the issue queue. Sorry you weren't able to receive a response to this problem.