Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

ALTER TABLE newsletter_subscribers Magento
 
t.mehdi
Jr. Member
 
Total Posts:  14
Joined:  2010-11-16
 

Hi,

I’m wondering if I could alter the table newsletter_subscriber in order to add a field.

Actually, I’m having a partnership with an other site which will ask theire clients if they wish to recieve my newsletter.

This partnership will work as follow :
My partner will run a file which will call
http://www.mysite.com/partners/membership.php?email=blabla@blala.bla&name;=blibilibli&last;=blobloblo

I would like to inject these email into my newsletter_subscriber table in magento database. The file I’m willing to add will containe the origine of the optin email so I can distinguish my sources.

Is Adding a field into this table likely to crash the site ?

 
Magento Community Magento Community
Magento Community
Magento Community
 
MagentoECG
Magento Team
 
Avatar
Total Posts:  189
Joined:  2011-02-25
Worldwide
 

Hi,

Addition of this field in table won\’t crash the site.
You can choose the way how to add this field, it depends on how you want to use this field in future.
Of course you can add this field by standard MySQL query, but the most recommended way is to create your own module where you will add this field in install script.
For more information you can read this article http://www.magentocommerce.com/wiki/5_-_modules_and_development/0_-_module_development_in_magento/custom_module_with_custom_database_table

<NS>

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top