I have a custom module that I need to update adding a couple of columns in one of the tables. The task is very easy but for some reason Magento is adding a prefix on my table name. Let me show you.

My upgrade script is as follows:

$installer = $this;
$installer->getTable('invent_feedbanners/imagen'), 'inicia', Varien_Db_Ddl_Table::TYPE_DATETIME, null, array(
    ), 'Inicia');

$installer->getTable('invent_feedbanners/imagen'), 'termina', Varien_Db_Ddl_Table::TYPE_DATETIME, null, array(
    ), 'Termina');

When the upgrade runs Magento reports an error like this: - SQLSTATE[42S02]: Base table or view not found: 1146 Table '255.invent_feedbanners_imagen' doesn't exist"

The name of the table is invent_feedbanners_imagen. Where does the 255 name comes from??. My installation doesnt have any prefix.

This has been breaking my head for the last 5 hours. I'm stuck on this. If somebody could help me I will appreciate it alot.

Kind Regards!

  • can you paste the config.xml of your module? Commented Feb 18, 2015 at 10:17
  • I think '255' is your magento DB name!!!!
    – SIBHI S
    Commented Feb 18, 2015 at 11:09

1 Answer 1


I have no clue why you do this, but the method addColumn accepts other parameters:

public function addColumn($tableName, $columnName, $definition, $schemaName = null);

Therefore it should be:

        'type' => Varien_Db_Ddl_Table::TYPE_DATETIME,
        'comment' => 'Termina'

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.