Hi there,

I am new to this module. I have installed it on Drupal 5.2. I created a template and added two addresses. Then I got this error and about a minute later, the test email was delivered.

* user warning: Unknown column 'data' in 'field list' query: INSERT INTO mailout_list_addresses (email, name, html, list_id, data) VALUES ('info@mysite.com', 'info@mysite.com', 1, 3, 'a:0:{}') in /home/ahafrica/public_html/drupal/includes/database.mysql.inc on line 172.
* user warning: Unknown column 'data' in 'field list' query: INSERT INTO mailout_list_addresses (email, name, html, list_id, data) VALUES ('myname@gmail.com', 'myname@gmail.com', 1, 3, 'a:0:{}') in /home/ahafrica/public_html/drupal/includes/database.mysql.inc on line 172.

Comments

ratinakage’s picture

ratinakage commented

My appologies. No test email was ever recieved. The names were not added to the list.

saccard’s picture

saccard commented
Title: Problem adding addresses to mailing list » Missing Field

I had the same problem with a new installation of mailout (Version RC2) on a fresh drupal. Maybe this is a bug in the installation-script of the module? In the table mailout_list_adresses was no field "data" created. I looked on another mailout installation in a second drupal (this was Mailout RC1!). This installation worked fine, no field was missing. So, I added the missing field with phpmyadmin and the bug was gone.

Just create a new field at the end of the table mailout_list_adresses named "data", with type "TEXT", Collation "utf8_general_ci", and set Null to "Not Null". Save the new field and that's it.

ratinakage’s picture

ratinakage commented

Cool. It worked!

Thanks...

sime’s picture

sime
any/any
Location Melbourne
commented

Yeah, sorry about the hassle, this is fixed in dev version.

An alternative fix for those who've installed RC2 is to go into the system table and change the 'version' of mailout to 3 and then run update.php

seeoneomen’s picture

seeoneomen commented

I have added a data field per the instructions above and continue to get the error message:

warning: Invalid argument supplied for for each() in /home1/mysite/public_html/community/sites/all/modules/mailout/mailout.module on line 693.

I also ran update.php and selected 3 from Mailout options, this failed to update.

I am running Mailout 1.1.2.1.

The error started occurring after I defined the subscribe block and made it visible.

Anyone know the fix?

Thanks.

sonjan’s picture

sonjan commented

Same here as #5. Who can help? #2 did not solve it...

jadowd’s picture

jadowd commented

I think its odd that this was never addressed... but I did this, based on the structure of the data column on the users table and it works.

alter table mailout_list_addresses add column data longtext after html;

thanks!

sime’s picture

sime
any/any
Location Melbourne
commented
Status: Active » Fixed

All issues described here are fixed in DRUPAL-5 branch, #5 will be fixed in RC3

Status: Fixed » Closed (fixed)

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