"User warning: table xxxx doesn't exist" (after module installation)

Posted by hoyt on November 19, 2008 at 12:17am

Issue Summary

Mailhandler

When trying to configure Mailhandler, I get the following message:

user warning: Table 'lynnhavenpier.mailhandler' doesn't exist query: SELECT * FROM mailhandler ORDER BY mail in /var/www/drupal/sites/all/modules/mailhandler/mailhandler.admin.inc on line 283.

I found http://drupal.org/node/78280 and tried changing permissions, then disabled and re-enabled Mailhandler with identical results.

In http://drupal.org/node/52752 the link to http://drupal.org/node/17473 results in an "Access Denied" error. Later instructions in 52752 mention creating the database from a text file, but I don't find any text file in the Mailhandler directory and nothing in the README.txt file is useful.

Mandriva 2009.0
Linux Kernel 2.6.27.4-desktop-2mnb
Apache 2.2.9
PHP 5.2.6
Drupal 6.6 installed in /var/www/drupal
Mailhandler-6.x-1.0 installed in /var/www/drupal/sites/all/modules

So, I'm stumped. Any advice?

Comments

#1

Posted by Dave Reid on November 19, 2008 at 1:15am

Project:	Drupal core	» Mailhandler
Version:	6.6	» 6.x-1.x-dev
Component:	other	» Code

Not a Drupal core bug. Moving to the Mailhandler issue queue.

#2

Posted by Dave Reid on November 19, 2008 at 1:17am

Version:

6.x-1.x-dev

» 6.x-1.0

Also please note that the latest version of Mailhandler is 6.x-1.5. You're using quite an old version that may have had bugs fixed. Upgrade to the latest release and seem if the problem persists.

#3

Posted by hoyt on November 19, 2008 at 2:31am

The version # was a typo; it was actually 6.x-1.4, but I updated to 6.x-1.5.

Still the same problem:

user warning: Table 'lynnhavenpier.mailhandler' doesn't exist query: SELECT * FROM mailhandler ORDER BY mail in /var/www/drupal/sites/all/modules/mailhandler/mailhandler.admin.inc on line 287.

I thought I'd work on another module, Fast Gallery, and am getting the same error message:

user warning: Table 'lynnhavenpier.fast_gallery' doesn't exist query: SELECT gid,path,gid FROM fast_gallery in /var/www/drupal/sites/all/modules/fast_gallery/fast_gallery.class.php on line 293.

So it may not be Mailhandler . . .

I don't really know anything about mysql, but it seems that I'm not creating the database tables?

OK, I stopped and re-started mysqld and httpd and I'm not getting the messages any more. Problem seems solved for me. Thanks.

#4

Posted by z.stolar on November 19, 2008 at 6:56am

Status:

active

» closed (fixed)

Not a mailhandler bug. Closing.

#5

Posted by mentor on August 17, 2009 at 2:06pm

Version:	6.x-1.0	» 6.x-1.8
Status:	closed (fixed)	» active

I am getting a very similar error. I suspect I could resolve this by manually importing mailhandler.mysql (this had to be done with listhandler), but this file doesn't seem to exist. Perhaps this is not a mailhandler bug, as dismissed twice above, but how about making a version of mailhandler.mysql available?

Here is the error:

user warning: Table 'xxxx.mailhandler' doesn't exist query: SELECT * FROM mailhandler WHERE enabled = 1 ORDER BY mail in /home/xxx/modules/mailhandler/mailhandler.module on line 14.

#6

Posted by Ian Ward on October 13, 2009 at 9:20pm