warning message
| Project: | Mail Editor |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | task |
| Priority: | critical |
| Assigned: | chiddicks |
| Status: | closed |
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.
#1
oi crap i forgot to write install schema for mail_edit_registry table. will fix asap.
#2
#3
Thanks!
#4
I just installed this and get the same error. Could you just post DDL so I can whack it in?
#5
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;
#6
This is great, thanks - much appreciated. I'm v.new to drupal but I'll see about it when I find my feet.
#7
Here's the patch, and the mail_edit.install file with the schema update. Thanks for your work on this.
#8
Thank you for the patch: http://drupal.org/cvs?commit=126638
#9
pardon my stupidity but how do i apply this patch and schema?
#10
@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.
#11
thx
#12
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.
#13
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.
#14
thanks for the helping a "noob" works like a champ now!!!
#15
Automatically closed -- issue fixed for two weeks with no activity.