Used drush to install mailhandler which of course, installed 6.x-1.11.

Figured out what I needed to do (make it work with feeds) needed 6.x-2.0-rc1, so I disabled 6.x-1.11 and deleted it, uploaded and enabled 6.x-2.0-rc1.

Got this error when i go to 'admin/build/mailhandler':
Table 'sitedb.mailhandler_mailbox' doesn't exist [warning] query: SELECT * FROM mailhandler_mailbox t__0 database.mysqli.inc:147

Ran cron and update, still get same error.

I thought maybe I needed to delete the mailbox I made in the previous version first, so I disabled 6.x-2.0-rc1, reinstalled 6.x-1.11 and deleted mailbox, reinstalled 6.x-2.0-rc1, same error.

Disabled 6.x-2.0-rc1, installed 6.x-2.x-dev, clicked update and cron, same error. Please help thank you. I have access to phpmyadmin maybe I can be provided with create table code instead?

Comments

danepowell’s picture

danepowell commented

I can recreate your issue up to initially getting the error when visiting 'admin/build/mailhandler', which makes sense- there was a major schema update between 6.x-1.x and 6.x-2.x that requires running update.php. However, once you run update.php without errors I can't see any reason why this would occur.

Using phpMyAdmin can you please tell me whether the tables 'mailhandler' and/or 'mailhandler_mailbox' exist, and whether they are empty? Can you also tell me what schema_version is listed for mailhandler in the 'system' table?

ghmercado’s picture

ghmercado commented

ive still got 6.x-2.x-dev installed but only mailhandler enabled. I then checked phpmyadmin and I only had a mailhandler table, no mailhandler_mailbox.

I activated the mailhandler default module, checked phpmyadmin, and it still only had a mailhandler table and no mailhandler_mailbox table.

Mailhandler table in phpmyadmin has 20 columns. Schema version in systems table is '6001'.

danepowell’s picture

danepowell commented

I think you don't actually have 6.x-2.x installed, or you are not running update.php correctly. When you go to update.php, and click 'select updates' on the second page, is there anything listed for Mailhandler? If not, there is something wrong with your codebase, like two copies of Mailhandler or something like that...

I may regret saying this, because I know Drupal can do some pretty insane things sometimes- but there's simply no way for you to have Mailhandler 6.x-2.x properly installed, your schema version to be 6001, and no updates or errors when you run update.php.

ive still got 6.x-2.x-dev installed but only mailhandler enabled
Can you explain what you mean by this?

ghmercado’s picture

ghmercado commented

as suspected it was just an update issue that didn't push through all the way. My caching may have been involved, or it may not, like you said it can get pretty bizarre.

thanks so much am hyped to start using mailhandler + feeds to map fields and start emailing stuff to my site!

danepowell’s picture

danepowell commented
Status: Active » Fixed

Glad you figured it out

Status: Fixed » Closed (fixed)

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

rshannon’s picture

rshannon commented
Version: 6.x-2.x-dev » 6.x-2.4
Component: Code » Mailhandler
Status: Closed (fixed) » Active

I have a similar problem, except it's the mailhandler table that's reported missing (and is) in a fresh install of 6.x-2.4. The system table shows mailhander schema ver. 6210. Table mailhandler_mailboxes does exist.

FWIW, the missing table warning error appears when going to config for Listhandler 6.x-1.0 (schema 6000) and has not appeared anywhere else -- yet.

I have run update.php, of course, and turned off and cleared caching. I also tried updating ctools to 6.x-1.x-1.x-dev per recommendation in mailhandler's README.txt, but still no joy.

danepowell’s picture

danepowell commented
Status: Active » Closed (fixed)

rshannon, please see the issue that you already opened: #1458088: Not compatible with Mailhandler 6.x-2.x