Magento：使用Observers为Newsletter添加自定义字段

Question

First... I'm new to this so bear with me.

I'm trying to make a module which adds custom field to newsletter using observers.

I made a column in "newsletter_subscribers" table (mysql4-install-0.1.0.php)

$installer = $this;
$installer->startSetup();

$installer->run("
  ALTER TABLE {$this->getTable('newsletter_subscriber')}
    ADD (user_name VARCHAR(50) NOT NULL);
 ");

$installer->endSetup();

Then i modified config.xml for observer

<events>
   <newsletter_subscriber_save_before>
      <observers>
         <My_Newsletter>
            <type>model</type>
            <class>Newsletter_Observer</class>
            <method>newsletterSubscriberSaveBefore</method>
         </My_Newsletter>
      </observers>
   </newsletter_subscriber_save_before>
</events>

Then made an observer.php

class My_Newsletter_Model_Observer
{
    public function newsletterSubscriberSaveBefore(Varien_Event_Observer $observer)
    {
        $subscriber = $observer->getEvent()->getSubscriber();
        $name = Mage::app()->getRequest()->getParam('subscriber_name');

        $subscriber->setSubscriberName($name);

        return $this;
    }
}

So my questions is. What did i miss? It doesn't work. I know I'm missing something important.

Answer 1

You specify ADD (user_name VARCHAR(50) NOT NULL);

That means your code should be:

 $subscriber->setUserName($name);