A message from our CEO about the future of Stack Overflow and Stack Exchange. Read now.

Questions tagged [upgradeschema]

The tag has no usage guidance.

14 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
0answers
165 views

Magento integration test conflict with new customer eav attribute

I tried to run my integration test using bin/magento dev:tests:run integration but i always got an error like this: Module 'Company_CutomerExtraAttribute': Upgrading data... [Magento\Framework\...
2
votes
1answer
2k views

magento 2 UpgradeSchema not working

I have already created a table with name tutorial_simplenews.I want to add new column to that table.my code is below. <?php /** * Copyright © 2013-2017 Magento, Inc. All rights reserved. * See ...
1
vote
0answers
23 views

Magento 2 - Update foreign key default to null in UpgradeSchema

I created a foreign key in install schema for my custom table like this: $custom_table->addColumn( 'customer_id', \Magento\Framework\DB\Ddl\Table::TYPE_INTEGER, null, ['nullable' =&...
1
vote
0answers
38 views

Magento2 - how to automatically create UpgradeData, UpgradeSchema based on existing table(s)

Who knows is there any tools, modules or whatever to convert existing table dump and structure into UpgradeData, UpgradeSchema? Why? For example you created complicated settings stored in DB and you ...
1
vote
1answer
102 views

Magento 2.1.7 custom module UpgradeSchema not adding column

I'm not able to add new column to existing table UpgradeSchema.php: namespace Company\Module\Setup; use Magento\Framework\Setup\UpgradeSchemaInterface; use Magento\Framework\Setup\...
1
vote
0answers
234 views

Custom attribute not updated in Magento 2

I am new to Magento 2. We have created a custom module in Magento 2. We have successfully created a custom attribute in that module and created installdata.php file in the custom module. My problem ...
1
vote
0answers
167 views

Magento 2 : UpgradeSchema write mysql trigger

I am trying to add mysql trigger using the upgradeschema in magento 2 but I am getting the "Cannot execute multiple queries". Below is my trigger DELIMITER $$ CREATE TRIGGER ...
0
votes
0answers
66 views

Upgrade schema script is not working with magento 2.1.3?

I have upgraded my magento version from 2.1.6 to 2.3.1. There is a custom module which is using upgradeschema but in magento 2.3.1. this is not working. Could anyone help me with this ?
0
votes
0answers
34 views

URL field for Google Structured Data

What is the solution to add markup for product URL or even home page url? I tried many combinations calling product url, specifying url directly... Still Google structured data tool does not recognize ...
0
votes
0answers
42 views

Facing error when upgrading schema in magento2

Installing schema... Upgrading schema... SQLSTATE[42S02]: Base table or view not found: 1146 Table 'st_m2_225_21082018.sentence_sentence' doesn't exist, query was: DESCRIBE SENTENCE_SENTENCE <?php ...
0
votes
1answer
42 views

Warning when upgrade scripts?

if (version_compare($context->getVersion(), '1.1.10', '<=')) { $installer = $setup; $installer->startSetup(); // Get tutorial_simplenews table ...
0
votes
1answer
276 views

Magento 2: UpgradeData duplicates static blocks when I try to update them

My code looks like this: /** * @var \Magento\Cms\Model\BlockFactory */ private $_blockFactory; ... $this->_blockFactory ->setStoreId(0) ->load('some-identifier', '...
0
votes
1answer
50 views

Base Table or View not found after adding Category EAV

Ive tried to add my custom category eav attribute but after setup:upgrade and setup:di:compile I get the following error: 2 exception(s): Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42S02]: ...
0
votes
1answer
27 views

SchemaUpdate is not executed after running setup script

I am trying to run some Setup\UpgradeSchema.php lines. I run: php bin/magento setup:upgrade And my module code is not executed. My Setup\UpgradeSchema.php looks more or less like this: if (...