I am getting the following error messages from mail edit once installed:

user warning: Table 'mtb0817708294056.mail_edit_registry' doesn't exist query: SELECT * FROM mail_edit_registry in /home/content/m/t/b/mtboxsupport/html/modules/mail_edit/mail_edit.module on line 212.
user warning: Table 'mtb0817708294056.mail_edit_registry' doesn't exist query: INSERT INTO mail_edit_registry (id, module, mailkey, description) VALUES ('user_register_admin_created', 'user', 'register_admin_created', ' Welcome message for user created by the admin') in /home/content/m/t/b/mtboxsupport/html/modules/mail_edit/mail_edit.module on line 223.
user warning: Table 'mtb0817708294056.mail_edit_registry' doesn't exist query: INSERT INTO mail_edit_registry (id, module, mailkey, description) VALUES ('user_register_no_approval_required', 'user', 'register_no_approval_required', ' Welcome message when user self-registers') in /home/content/m/t/b/mtboxsupport/html/modules/mail_edit/mail_edit.module on line 223.
user warning: Table 'mtb0817708294056.mail_edit_registry' doesn't exist query: INSERT INTO mail_edit_registry (id, module, mailkey, description) VALUES ('user_register_pending_approval', 'user', 'register_pending_approval', ' Welcome message, user pending admin approval') in /home/content/m/t/b/mtboxsupport/html/modules/mail_edit/mail_edit.module on line 223.
user warning: Table 'mtb0817708294056.mail_edit_registry' doesn't exist query: INSERT INTO mail_edit_registry (id, module, mailkey, description) VALUES ('user_password_reset', 'user', 'password_reset', ' Password recovery request') in /home/content/m/t/b/mtboxsupport/html/modules/mail_edit/mail_edit.module on line 223.
user warning: Table 'mtb0817708294056.mail_edit_registry' doesn't exist query: INSERT INTO mail_edit_registry (id, module, mailkey, description) VALUES ('user_status_activated', 'user', 'status_activated', ' Account activated') in /home/content/m/t/b/mtboxsupport/html/modules/mail_edit/mail_edit.module on line 223.
user warning: Table 'mtb0817708294056.mail_edit_registry' doesn't exist query: INSERT INTO mail_edit_registry (id, module, mailkey, description) VALUES ('user_status_blocked', 'user', 'status_blocked', ' Account blocked') in /home/content/m/t/b/mtboxsupport/html/modules/mail_edit/mail_edit.module on line 223.
user warning: Table 'mtb0817708294056.mail_edit_registry' doesn't exist query: INSERT INTO mail_edit_registry (id, module, mailkey, description) VALUES ('user_status_deleted', 'user', 'status_deleted', ' Account deleted') in /home/content/m/t/b/mtboxsupport/html/modules/mail_edit/mail_edit.module on line 223.
user warning: Table 'mtb0817708294056.mail_edit_registry' doesn't exist query: INSERT INTO mail_edit_registry (id, module, mailkey, description) VALUES ('subscriptions_content_0', 'subscriptions_content', '0', 'subscriptions-digest') in /home/content/m/t/b/mtboxsupport/html/modules/mail_edit/mail_edit.module on line 223.
user warning: Table 'mtb0817708294056.mail_edit_registry' doesn't exist query: INSERT INTO mail_edit_registry (id, module, mailkey, description) VALUES ('subscriptions_content_1', 'subscriptions_content', '1', 'subscriptions-node-nid') in /home/content/m/t/b/mtboxsupport/html/modules/mail_edit/mail_edit.module on line 223.
user warning: Table 'mtb0817708294056.mail_edit_registry' doesn't exist query: INSERT INTO mail_edit_registry (id, module, mailkey, description) VALUES ('subscriptions_content_2', 'subscriptions_content', '2', 'subscriptions-node-tid') in /home/content/m/t/b/mtboxsupport/html/modules/mail_edit/mail_edit.module on line 223.
user warning: Table 'mtb0817708294056.mail_edit_registry' doesn't exist query: INSERT INTO mail_edit_registry (id, module, mailkey, description) VALUES ('subscriptions_content_3', 'subscriptions_content', '3', 'subscriptions-node-type-blog') in /home/content/m/t/b/mtboxsupport/html/modules/mail_edit/mail_edit.module on line 223.
user warning: Table 'mtb0817708294056.mail_edit_registry' doesn't exist query: INSERT INTO mail_edit_registry (id, module, mailkey, description) VALUES ('subscriptions_content_4', 'subscriptions_content', '4', 'subscriptions-node-type-poll') in /home/content/m/t/b/mtboxsupport/html/modules/mail_edit/mail_edit.module on line 223.
user warning: Table 'mtb0817708294056.mail_edit_registry' doesn't exist query: INSERT INTO mail_edit_registry (id, module, mailkey, description) VALUES ('subscriptions_content_5', 'subscriptions_content', '5', 'subscriptions-node-type-page') in /home/content/m/t/b/mtboxsupport/html/modules/mail_edit/mail_edit.module on line 223.
user warning: Table 'mtb0817708294056.mail_edit_registry' doesn't exist query: INSERT INTO mail_edit_registry (id, module, mailkey, description) VALUES ('subscriptions_content_6', 'subscriptions_content', '6', 'subscriptions-node-type-story') in /home/content/m/t/b/mtboxsupport/html/modules/mail_edit/mail_edit.module on line 223.
user warning: Unknown column 'language' in 'field list' query: SELECT DISTINCT(language) FROM mail_edit ORDER BY language ASC in /home/content/m/t/b/mtboxsupport/html/modules/mail_edit/mail_edit.module on line 239.
user warning: Table 'mtb0817708294056.mail_edit_registry' doesn't exist query: SELECT * FROM mail_edit_registry in /home/content/m/t/b/mtboxsupport/html/modules/mail_edit/mail_edit.module on line 251.
warning: Invalid argument supplied for foreach() in /home/content/m/t/b/mtboxsupport/html/modules/mail_edit/mail_edit.module on line 260.
user warning: Unknown column 'id' in 'order clause' query: SELECT * FROM mail_edit ORDER BY id ASC in /home/content/m/t/b/mtboxsupport/html/modules/mail_edit/mail_edit.module on line 264.

CommentFileSizeAuthor
#7 mail_edit_schema.patch1.04 KBchiddicks
#7 mail_edit.install.txt (remove .txt to use)1.98 KBchiddicks

Comments

litwol’s picture

litwol commented

oi crap i forgot to write install schema for mail_edit_registry table. will fix asap.

litwol’s picture

litwol commented
Assigned: Unassigned » litwol
Category: bug » task
Priority: Normal » Critical
Status: Active » Needs work
mtboxtech’s picture

mtboxtech commented

Thanks!

TwoWolves’s picture

TwoWolves commented

I just installed this and get the same error. Could you just post DDL so I can whack it in?

litwol’s picture

litwol commented

here is the query that generated the missing table. its 4 am right now and i just got home so i hope you guys dont mind that this is all i provide you :-p. if some one files a patch with schema install for this table i will commit it.

CREATE TABLE IF NOT EXISTS `mail_edit_registry` (
`id` varchar(255) NOT NULL,
`module` varchar(255) NOT NULL,
`mailkey` varchar(255) NOT NULL,
`description` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

TwoWolves’s picture

TwoWolves commented

This is great, thanks - much appreciated. I'm v.new to drupal but I'll see about it when I find my feet.

chiddicks’s picture

chiddicks commented
Assigned: litwol » chiddicks
Status: Needs work » Needs review
StatusFileSize
new mail_edit.install.txt (remove .txt to use)1.98 KB
new mail_edit_schema.patch1.04 KB

Here's the patch, and the mail_edit.install file with the schema update. Thanks for your work on this.

litwol’s picture

litwol commented
Status: Needs review » Fixed

Thank you for the patch: http://drupal.org/cvs?commit=126638

mtboxtech’s picture

mtboxtech commented

pardon my stupidity but how do i apply this patch and schema?

litwol’s picture

litwol commented

@mtboxtech:
dont bother applying the patch. chiddicks was kind enough to provide the actual install file "mail_edit.install.txt (remove .txt to use)"

right click on "mail_edit.install.txt (remove .txt to use)" and save as over your current mail_edit.install file. make sure that after you save the file the file name still remains mail_edit.install (without the .txt extension).

I've commited the change and you will be able to download a working module within 12 hours (thats how often packaging script runs)

let me know if you have more questions.

mtboxtech’s picture

mtboxtech commented

thx

mtboxtech’s picture

mtboxtech commented

bummer. i still get the same warning message that i was getting before.

EDIT: this is weird. i just uploaded the module to another test drupal ground that i have and the module works on that install. is there some "remnants" hanging around on my site that isn't working. if so how would i clean up.

litwol’s picture

litwol commented

mtboxtech: you must disable the module. then go to module uninstall (tab on top of modules page) then select mail_edit for uninstall. that will remove any schema information from your drupal install.

than enable the module again to install the new schema.

mtboxtech’s picture

mtboxtech commented

thanks for the helping a "noob" works like a champ now!!!

Anonymous’s picture

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

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