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

quicksketch’s picture

Status: Active » Closed (fixed)

Pruning the issue queue. Sorry you weren't able to receive a response to this problem.