Upgrade script not working - SQLSTATE[42000]

Question

However when I run an upgrade script to add this column I get this Error:

Error in file: "..................sql/test123_bannerslider_setup/upgrade-0.0.1-0.0.2.php" - SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'devx'@'localhost' for table 'test123_bannerslider_bannerslider'";i:1;s:1259:"#0 ..................../app/code/core/Mage/Core/Model/Resource/Setup.php(644): Mage::exception('Mage_Core', 'Error in file: ...')

<?php
$table = $this;
$table->startSetup();
$table->getConnection()
    ->addColumn(
        $table->getTable('test123_bannerslider/bannerslider'),
        'topheadline',
        Varien_Db_Ddl_Table::TYPE_VARCHAR,
        255,
        array(
            'nullable' => true
        )
    );
$this->endSetup();

My file structure:

->sql
-->test123_bannerslider_setup
--->install-0.0.1.php
--->upgrade-0.0.1-0.0.2.php

Update:

SOLUTION

Finally I change my code to SQL and now it works:

<?php
$table = $this;
$table->startSetup();

$table->run("
ALTER TABLE test123_bannerslider_bannerslider
  ADD COLUMN `topheadline` VARCHAR(255) NULL;
");

$table->endSetup();

user55776 · Accepted Answer · 2017-08-25 08:00:06Z

0

Check in database what name of table and add getTable('table_name')

$table->getTable('test123_bannerslider/bannerslider'),

Or Try

    $installer = $this;

    $connection = $installer->getConnection();

    $installer->startSetup();


    // add column to sales_flat_quote_address tabe
    $connection->addColumn($this->getTable('table_name'),   'topheadline', "varchar(255) NULL");
    $installer->endSetup();

answered Aug 25, 2017 at 8:00

user55776

I do not why but finally this work: <?php $table = $this; $table->startSetup(); $table->run(" ALTER TABLE test123_bannerslider_bannerslider ADD COLUMN topheadline VARCHAR(255) NULL; "); $table->endSetup();

Lehtis
– Lehtis

2017-08-25 08:19:41 +00:00
Commented Aug 25, 2017 at 8:19

Add a comment |

Teja Bhagavan Kollepara · Accepted Answer · 2017-08-25 08:05:33Z

0

It seems like your mysql user 'devx' has not sufffient permissioin to alter/modify the tables on current database.

Please assign sufffient permission to mysql user 'devx'.

Or

your database is full.

Thus MySQL cannot add more rows to your log tables.

Check your database size and limit. Please remove some space.

edited Aug 25, 2017 at 8:05

Teja Bhagavan Kollepara

3,8275 gold badges34 silver badges69 bronze badges

answered Aug 25, 2017 at 7:32

Padhiyar Gaurang

7866 silver badges19 bronze badges

Thanks but that was not the problem

Lehtis
– Lehtis

2017-08-25 08:19:17 +00:00
Commented Aug 25, 2017 at 8:19

Add a comment |

Stack Exchange Network

Upgrade script not working - SQLSTATE[42000]

SOLUTION

2 Answers 2

Your Answer

Hot Network Questions

Upgrade script not working - SQLSTATE[42000]

SOLUTION

2 Answers 2

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions