Hello all!

I recently decided to give version 2.x a try and had enough issues that I want to get back to version 1.x

I previously had 6.x-1.x-dev on my server, then I upgraded to 2.x

I uninstalled (or unchecked it from modules, then deleted) then installed 1.x

Upon attempting this I have received various SQL related errors which basically state that xxxx.mailhandler table doesn't exist. For example.

user warning: Table 'chatsite.mailhandler' doesn't exist query: SELECT mid, mail, domain, port, name, pass, security, replies, fromheader, commands, sigseparator, enabled, folder, imap, mime, mailto, delete_after_read, extraimap, format, authentication FROM mailhandler in /web/sites/all/modules/mailhandler/mailhandler.module on line 285

I'm afraid my lack of experience in PHP and SQL is biting my in the tush.

I don't have any sacred configuration in regards to the mailhandler to save. Is there any way to clean out all of the mailhandler settings and start totally fresh?

My best guess so far is that somehow it is detecting the previous install of 1.x and it isn't going through the full install process.

Any help would be wonderful.

Cheers
Gord

Comments

danepowell’s picture

danepowell commented

Just FYI, downgrading any Drupal module is pretty much never supported or a good idea. A better idea is to take a backup of your site, try out the newer version of the module, and if it doesn't work, restore the backup. Or, if make a development copy of your site and test on that.

Yes, it sounds like the mailhandler table never got created when you enabled 1.x. I'm guessing you can fix this by disabling and uninstalling Mailhandler, then deleting the mailhandler entry from the system table, and finally re-enabling Mailhandler.

I would appreciate hearing what issues you were having with 2.x. Have you already posted other support requests regarding those?

gbestwick’s picture

gbestwick commented

Hello!

When you say the system table, what are you referering to? I'm guessing this may be the key.

Cheers.

danepowell’s picture

danepowell commented

I mean the database table named "system". So you'd need to run a MySQL query like "DELETE FROM system WHERE name = mailhandler", or use phpMyAdmin to edit the table and delete the row for mailhandler.

danepowell’s picture

danepowell commented
Status: Active » Postponed (maintainer needs more info)

Did you have a chance to try that? Also I'd still like to know what issues you had with 2.x, so that I can improve it...

Renee S’s picture

Renee S commented

I have this error on a fresh install of 2.x beta.

User warning: Table 'drupal6_dev.mailhandler' doesn't exist query: mailcomment_mailbox_list
/* Admin : mailcomment_mailbox_list */ SELECT mid, mail FROM mailhandler ORDER BY mail in _db_query() (line 148 of/drupal/includes/database.mysql.inc).

UPDATE: Ok, this is an error in the mailcomment module, it's using the wrong table-name. Will submit a patch over there.

danepowell’s picture

danepowell commented
Status: Postponed (maintainer needs more info) » Active

Oh. Weird. I will have to look into that. I am trying to make time to do a sweeping review of Mailhandler/Mailcomment issues and roll beta2.

danepowell’s picture

danepowell commented
Component: Miscellaneous » Mailhandler
Status: Active » Closed (won't fix)

Sorry, 6.x-1.x is no longer a supported release. Please try upgrading to 6.x-2.x and reopen if still an issue.