I am developing an custom extension following this guide: http://tutorialsformagento.blogspot.in/2014/06/add-custom-fields-to-order-and-quote.html
Here is my config file:
<?xml version="1.0"?> <config> <modules> <VivasIndustries_Vshipping> <version>0.1.0</version> </VivasIndustries_Vshipping> </modules> <frontend> <routers> <!-- <vshipping> <use>standard</use> <args> <module>VivasIndustries_Vshipping</module> <frontName>party</frontName> </args> </vshipping>--> </routers> <layout> <updates> <vshipping> <file>vshipping.xml</file> </vshipping> </updates> </layout> </frontend> <adminhtml> <layout> <updates> <vshipping> <file>vivasindustries/vshipping.xml</file> </vshipping> </updates> </layout> </adminhtml> <global> <events> <checkout_type_onepage_save_order> <observers> <checkout> <type>singleton</type> <class>VivasIndustries_Vshipping_Model_Observer</class> <method>customDataSave</method> </checkout> </observers> </checkout_type_onepage_save_order> <sales_quote_save_before> <!-- Name of Event --> <observers> <save_before> <type>singleton</type> <class>VivasIndustries_Vshipping_Model_Observer</class> <!-- Over Model Class --> <method>saveQuoteBefore</method> <!-- name of function --> </save_before> </observers> </sales_quote_save_before> </events> <models> <sales> <rewrite> <order>VivasIndustries_Vshipping_Model_Sales_Order</order> </rewrite> </sales> <vshipping> <class>VivasIndustries_Vshipping_Model</class> <resourceModel>vshipping_resource</resourceModel> </vshipping> <vshipping_resource> <class>VivasIndustries_Vshipping_Model_Resource</class> </vshipping_resource> </models> <resources> <vshipping_setup> <setup> <module>VivasIndustries_Vshipping</module> </setup> <connection> <use>core_setup</use> </connection> </vshipping_setup> <vshipping_read> <connection> <use>core_read</use> </connection> </vshipping_read> <vshipping_write> <connection> <use>core_write</use> </connection> </vshipping_write> </resources> <blocks> <vshipping> <class>VivasIndustries_Vshipping_Block</class> </vshipping> </blocks> <helpers> <vshipping> <class>VivasIndustries_Vshipping_Helper</class> </vshipping> </helpers> </global> </config> Here is my: /sql/vshipping_setup/mysql4-install-1.0.0.php:
<?php /* @var $installer Mage_Core_Model_Resource_Setup */ require_once('app/Mage.php'); $installer = $this; $installer->startSetup(); Mage::app()->setCurrentStore(Mage::getModel('core/store')->load(Mage_Core_Model_App::ADMIN_STORE_ID)); $installer = new Mage_Sales_Model_Resource_Setup('core_setup'); $attribute = array( 'type' => 'varchar', 'backend_type' => 'varchar', 'frontend_input' => 'varchar', 'is_user_defined' => true, 'label' => 'Delivery Date', 'visible' => true, 'required' => false, 'user_defined' => false, 'default' => '0', 'comparable' => false, 'searchable' => false, 'filterable' => false ); $installer->addAttribute('order','vshipping_account_no',$attribute); $installer->addAttribute('quote','vshipping_account_no',$attribute); $installer->addAttribute('order','vshipping_phone_no',$attribute); $installer->addAttribute('quote','vshipping_phone_no',$attribute); $installer->addAttribute('order','vshipping_comment',$attribute); $installer->addAttribute('quote','vshipping_comment',$attribute); $installer->endSetup(); However when i export my whole database with PHPMyAdmin and i search for vshipping_account_no there is no result found.
It seems this sql installer is not creating this mysql changes.
Where is my mistake and how can i fix it ?
Thanks in advance!
