Drupalversion 7.21

The error occurs when i try to save the results.
error

Error code:
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'usr_web681_2.webform_last_download' doesn't exist: SELECT wld.* FROM {webform_last_download} wld WHERE (nid = :db_condition_placeholder_0) AND (uid = :db_condition_placeholder_1) ; Array ( [:db_condition_placeholder_0] => 127 [:db_condition_placeholder_1] => 67 ) in webform_download_last_download_info() (Zeile 1001 von /var/www/html/web681/html/drupal/sites/all/modules/webform/includes/webform.report.inc).

i already checked the update.php, no (database) updates pending.

CommentFileSizeAuthor
fibo.PNG8.11 KBfischerboot

Comments

fischerboot’s picture

fischerboot commented
Component: User interface » Code
Assigned: fischerboot » Unassigned
Category: support » bug
fischerboot’s picture

fischerboot commented
Status: Active » Closed (fixed)

Recreating the table fixed the problem. tor those of interest:

--
-- Table structure for table `webform_last_download`
--

DROP TABLE IF EXISTS `webform_last_download`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `webform_last_download` (
  `nid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The node identifier of a webform.',
  `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The user identifier.',
  `sid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The last downloaded submission number.',
  `requested` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Timestamp of last download request.',
  PRIMARY KEY (`nid`,`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores last submission number per user download.';
/*!40101 SET character_set_client = @saved_cs_client */;
zjoriz’s picture

zjoriz commented
Version: 7.x-3.8 » 7.x-3.19

I've got the same problem.
I'm guessing you found the 'creation code' for the table in the install files of the Webform Module?

Edit: I removed the module (completely) and reinstalled it after boosting the allocated memory as instructed here https://drupal.org/node/1050612. This worked for me. The idea is that the tables weren't created in the first run due to insufficient memory.