* user warning: Table 'ezunkwe_drupal.drupalsimplenews_mail_spool' doesn't exist query: SELECT * FROM drupalsimplenews_mail_spool s WHERE s.status = 1 ORDER BY s.timestamp ASC LIMIT 0, 20 in /hsphere/local/home/ezunkwelle/4nwebsolutions.com/sites/all/modules/simplenews/simplenews.module on line 1479.
* user warning: Table 'ezunkwe_drupal.drupalsimplenews_mail_spool' doesn't exist query: DELETE FROM drupalsimplenews_mail_spool WHERE status = 2 AND timestamp <= 1214067146 in /hsphere/local/home/ezunkwelle/4nwebsolutions.com/sites/all/modules/simplenews/simplenews.module on line 1522.

The above is the error I received after installing Simplenews 6.x-1.0-beta2 and it also made it impossible for me submit content or carry out any other tasks except run cron. I can't even disable any module. What to do?

Comments

igbonine’s picture

igbonine commented
Title: Cannot carry out any task after installing news6.x-1.0 beta2 » Simplenews 6.x-1.0 beta2
Component: Miscellaneous » Code
sutharsan’s picture

sutharsan commented
Title: Simplenews 6.x-1.0 beta2 » Missing table after upgrade to beta2
Status: Active » Postponed (maintainer needs more info)

Always update after installing a new module version: yoursite.org/update.php This should solve you problem

Please use a meaning full title, describing the problem, question, fault message, etc.

capmex’s picture

capmex commented

Same issue when installing on a fresh drupal 6.2 installation:

user warning: Key column 'mcid' doesn't exist in table query: CREATE TABLE simplenews_mail_spool ( `msid` INT unsigned NOT NULL auto_increment, `mail` VARCHAR(255) NOT NULL DEFAULT '', `nid` INT NOT NULL DEFAULT 0, `vid` INT NOT NULL DEFAULT 0, `tid` INT NOT NULL DEFAULT 0, `status` TINYINT unsigned NOT NULL DEFAULT 0, `timestamp` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (mcid), INDEX tid (tid), INDEX status (status) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /var/www/capmexorg/includes/database.inc on line 509.

Note: The table simplenews_mail_spool was not created on the database.

sutharsan’s picture

sutharsan commented
Status: Postponed (maintainer needs more info) » Fixed

Different issue, same result.
The #3 is now fixed. Uninstall simplenews and install the 6.x-1.x-dev version.

CinemaSaville’s picture

CinemaSaville commented

I uninstalled beta3, and installed the 6.x-1.x dev version, and it still gave me this-

user warning: Table 'cinemasa_drpl1.simplenews_mail_spool' doesn't exist query: SELECT * FROM simplenews_mail_spool s WHERE s.status = 1 ORDER BY s.timestamp ASC LIMIT 0, 20 in /home/cinemasa/public_html/sites/all/modules/simplenews/simplenews.module on line 1479.
user warning: Table 'cinemasa_drpl1.simplenews_mail_spool' doesn't exist query: DELETE FROM simplenews_mail_spool WHERE status = 2 AND timestamp <= 1214186988 in /home/cinemasa/public_html/sites/all/modules/simplenews/simplenews.module on line 1522.

CinemaSaville’s picture

CinemaSaville commented

Reinstalled, installed again, looks like it's ok now.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.