I am trying to upgrade my module table by using the upgrade script. I am getting the error Base table or view not found. Please, check below the config.xml file, install script and upgrade script code:
Config.xml
<?xml version="1.0"?>
<config>
<modules>
<Tandem_OenologistUser>
<version>0.0.2</version>
</Tandem_OenologistUser>
</modules>
<frontend>
<routers>
<oenologist>
<use>standard</use>
<args>
<module>Tandem_OenologistUser</module>
<frontName>oenologist</frontName>
</args>
</oenologist>
</routers>
<layout>
<updates>
<oenologist>
<file>oenologist.xml</file>
</oenologist>
</updates>
</layout>
</frontend>
<global>
<blocks>
<tandem_oenologistuser_adminhtml>
<class>Tandem_OenologistUser_Block_Adminhtml</class>
</tandem_oenologistuser_adminhtml>
</blocks>
<helpers>
<tandem_oenologistuser>
<class>Tandem_OenologistUser_Helper</class>
</tandem_oenologistuser>
</helpers>
<models>
<tandem_oenologistuser>
<class>Tandem_OenologistUser_Model</class>
<resourceModel>tandem_oenologistuser_resource</resourceModel>
</tandem_oenologistuser>
<tandem_oenologistuser_resource>
<class>Tandem_OenologistUser_Model_Resource</class>
<entities>
<oenologist>
<table>tandem_oenologistuser_oenologist</table>
</oenologist>
</entities>
</tandem_oenologistuser_resource>
</models>
<resources>
<tandem_oenologistuser_setup>
<setup>
<module>Tandem_OenologistUser</module>
<class>Mage_Core_Model_Resource_Setup</class>
</setup>
<connection>
<use>core_setup</use>
</connection>
</tandem_oenologistuser_setup>
</resources>
</global>
<admin>
<routers>
<tandem_oenologistuser_admin>
<use>admin</use>
<args>
<module>Tandem_OenologistUser_Adminhtml</module>
<frontName>oenologist-user-admin</frontName>
</args>
</tandem_oenologistuser_admin>
</routers>
</admin>
install-0.0.1.php
<?php
$this->startSetup();
$table = new Varien_Db_Ddl_Table();
$table->setName($this->getTable('tandem_oenologistuser_oenologist'));
$table->addColumn(
'entity_id',
Varien_Db_Ddl_Table::TYPE_INTEGER,
10,
array(
'auto_increment' => true,
'unsigned' => true,
'nullable'=> false,
'primary' => true
)
);
$table->addColumn(
'created_at',
Varien_Db_Ddl_Table::TYPE_DATETIME,
null,
array(
'nullable' => false,
)
);
$table->addColumn(
'updated_at',
Varien_Db_Ddl_Table::TYPE_DATETIME,
null,
array(
'nullable' => false,
)
);
$table->addColumn(
'name',
Varien_Db_Ddl_Table::TYPE_VARCHAR,
255,
array(
'nullable' => false,
)
);
$table->addColumn(
'email',
Varien_Db_Ddl_Table::TYPE_VARCHAR,
255,
array(
'nullable' => false,
)
);
$table->addColumn(
'url_key',
Varien_Db_Ddl_Table::TYPE_VARCHAR,
255,
array(
'nullable' => false,
)
);
$table->addColumn(
'description',
Varien_Db_Ddl_Table::TYPE_TEXT,
null,
array(
'nullable' => false,
)
);
$table->addColumn(
'visibility',
Varien_Db_Ddl_Table::TYPE_BOOLEAN,
null,
array(
'nullable' => false,
)
);
$table->addColumn(
'customer_id',
Varien_Db_Ddl_Table::TYPE_VARCHAR,
255,
array(
'nullable' => false,
)
);
$table->addColumn(
'instagramid',
Varien_Db_Ddl_Table::TYPE_VARCHAR,
500,
array(
'nullable' => false,
)
);
$table->addColumn(
'facebookid',
Varien_Db_Ddl_Table::TYPE_VARCHAR,
500,
array(
'nullable' => false,
)
);
$table->addColumn(
'twitterid',
Varien_Db_Ddl_Table::TYPE_VARCHAR,
500,
array(
'nullable' => false,
)
);
$table->setOption('type', 'InnoDB');
$table->setOption('charset', 'utf8');
$this->getConnection()->createTable($table);
$this->endSetup();
upgrade-0.0.1-0.0.2.php*
$installer = $this;
$connection = $installer->getConnection();
$installer->startSetup();
$installer->getConnection()
->addColumn($installer->getTable('tandem_oenologistuser/oenologist'),
'customer_id', Varien_Db_Ddl_Table::TYPE_VARCHAR, 255,
array(
'nullable' => true,
'default' => null,
'comment' => 'customer id'
)
)
->addColumn($installer->getTable('tandem_oenologistuser/oenologist'),
'instagramtoken', Varien_Db_Ddl_Table::TYPE_VARCHAR, 500,
array(
'nullable' => true,
'default' => null,
'comment' => 'instagram oauth token'
)
)
->addColumn($installer->getTable('tandem_oenologistuser/oenologist'),
'facebooktoken', Varien_Db_Ddl_Table::TYPE_VARCHAR, 500,
array(
'nullable' => true,
'default' => null,
'comment' => 'facebook oauth token'
)
)
->addColumn($installer->getTable('tandem_oenologistuser/oenologist'),
'twittertoken', Varien_Db_Ddl_Table::TYPE_VARCHAR, 500,
array(
'nullable' => true,
'default' => null,
'comment' => 'twitter oauth token'
)
);
$installer->endSetup();
Table is present in database. Can I add columns manually?