Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

All Questions

Tagged with
0
votes
0answers
24 views

Copying a Magento 2 Site to New Domain 'Remembers' Old Site

I have copied a Magento 2 site from a test domain (testing.mytest.co.uk) to a live domain (mylive.co.uk). It has come time to upgrade the Magento version (2.2.5 to 2.2.6) and I receive the following ...
2
votes
0answers
15 views

Increasing character limit for database tables

I have recently upgraded a copy of my site from 2.2.5 to version 2.3. All appeared to work correctly however I have encountered issues with a third party extension for a payment gateway. The ...
0
votes
2answers
313 views

Magento 2 module error after version upgrade

I was recently trying to upgrade our Magento from 2.2.5 to Magento 2.2.7. I thought I succeeded but we're currently getting the following error: There has been an error processing your request ...
1
vote
0answers
122 views

How Do I Merge Two Separate Magento Databases

Problem I am trying to combine two Magento version 1 stores from separate domains. My goal is to combine the two existing sites into one so that it can be hosted on a new domain and after all the ...
2
votes
0answers
264 views

Magento 2 Table missing catalogrule_product_replica

My magento version is 2.2.2 I tried to upgrade my version into 2.2.5CE But it shows an error SQLSTATE[42S02]: Base table or view not found: 1932 Table 'amsi_shopmgnto.catalogrule_product_replica'...
0
votes
1answer
105 views

Magento 2 - How can I change product visibility value using plugin afterSave or beforeSave method?

I have created a plugin and I want to change product visibility value on product save but it's not working. ProductAfterSave.php namespace Vendor\Module\Plugin; class ProductAfterSave { public ...
2
votes
2answers
709 views

Column not found: 1054 Unknown column 'at_status_default.value'

I'm actually kind of desperate.I tried many times to update my Community Edition from 2.2.1 to 2.2.5, always failing due to what I guess is a database inconsistency.After the update procedure - done ...
2
votes
1answer
57 views

Magento 1.9.3.8 removing redundant tables

Over the last few days I have been carefully analysing my database and noticed some tables, which I believe are from previous versions. Searching my 1.9.3.8 code base to analyse the scripts, I cannot ...
7
votes
4answers
594 views

Upgrading Magento 2.1.9 to Magento 2.2.2 is very slow

We are trying to upgrade a Magento 2.1.9 site to Magento 2.2.2 We have more than 130k products and the process seems to be stuck for more than 3 hours on, Upgrading data.. Module 'Magento_Backend': ...
1
vote
1answer
100 views

How do you update Magento2 version without any downtime of the website?

How do you update Magento2 version without any downtime of the website? If updating from the command line, at point of di:compile, the website is down during this period. If updating from Web Setup ...
1
vote
1answer
38 views

Optimal way to upgrade stores

Dear community I currently upgrade my magento store manually, by replacing my files with the newer versions files manually using FTP (coda). Has got me through many upgrades but is rather long ...
0
votes
1answer
24 views

Magento 1: How can I restore the relationship between simpleproduct and configurable product?

Is there a way to set the link between the simple products and the configurable product via script or database? Some relations were lost during a DB repair. (There is only one backup of the ...
2
votes
1answer
718 views

Magento_Integration schema: current version - 2.2.0, required version - 2.0.1

Using 2.1.5, I'm getting an error message saying: "Magento_Integration schema: current version - 2.2.0, required version - 2.0.1" I've tried setup:update and setup:db-data:upgrade. The site was ...
3
votes
2answers
252 views

Force DB Schema Update

Is there a way to trigger a DB schema update? I've just copied the live DB which is 1.8 to a development host which has 1.9.3.3 installed. The frontend is displaying correctly but I can't get into /...
2
votes
1answer
122 views

how to solve problem on checkout page after upgrading magento 1x to magento 2x

Next Exception: Report ID: webapi-5942548a83c3a; Message: SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name '', query was: INSERT INTO `` () VALUES () in /opt/lampp/htdocs/...
1
vote
1answer
69 views

MySQL Queries for v1.7 to v1.9 upgrade process

I'm tasked with upgrading our Magento installation from v1.7 to v1.9, using this article as a guide. The upgrade works fine, but its not very compatible with our development and deployment process. ...
0
votes
1answer
351 views

Magento 2 Custom install script won't work

I am trying to create installation script that make a record to cms_page table. So i created the next directory /app/code/Magento/Page/ Here is my /etc/module.xml <?xml version="1.0"?> <...
6
votes
1answer
15k views

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db.design_config_grid_flat' doesn't exist

I just upgraded to Magento 2.1.3 and I'm getting the following error message when I go to the design configuration section: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db....
1
vote
2answers
2k views

How to add new column to existing module table? [duplicate]

How can I add a new column to existing Magento core table via install script? (without using pure SQL) $installer = $this; $installer->startSetup(); $installer->getConnection() ->addColumn($...
3
votes
4answers
2k views

Error on login after update to 1.9.3

This is the error, can anyone help me with a solution to this? There has been an error processing your request SQLSTATE[42S22]: Column not found: 1054 Unknown column '...
0
votes
1answer
473 views

Error in file: “…sql/log_setup/mysql4-upgrade-1.6.1.0-1.6.1.1.php” after upgrading from 1.9.1.0 to 1.9.2.4

I used the same software installer (Softaculous) that I actually used to install Magento in the first place. Now - Softaculous upgraded my Magento 1.9.1.0 to Magento 1.9.2.4. The upgrade was done ...
1
vote
1answer
755 views

How to update table (adding new column) in Magento mysql4 setup script

Since couple of weeks I'm trying to understand Magento, it's structure, mechanisms and I'm stuck on scripts creating for example additional columns in tables. In my config.xml script I have: <?xml ...
0
votes
1answer
64 views

Import existing Magento1.9.0.1 DB to the new Magento 1.9.2.4

we have a Magento 1.9.0.1 single store application,also we have customer, category and product in this version, my client like to develop the with Magento 1.9.2.4 with new theme,also he wants to use ...
0
votes
0answers
622 views

Magento 2.1 upgrade error: Table 'sequence_salesrule' already exists

I upgraded to Magento 2.1 and now I'm getting the following error doing bin/magento setup:upgrade: $ bin/magento setup:upgrade --keep-generated Cache cleared successfully [...skip...] Module '...
1
vote
2answers
131 views

How to upgrade database field in magento?

I have try to add new column in magento database. but its not working using mysql4-upgrade-0.1.0-0.1.1 : C:\xampp\htdocs\Surabhi\app\code\local\Surabhi\Employee\sql\employee_setup\mysql4-install-0.1.0-...
3
votes
1answer
5k views

MySQL error and possible duplicates running bin/magento setup:upgrade after renaming module

I've renamed a custom module from MagicPack_magicheader to MagicPack_Magicheader and trying to now update by running setup:upgrade. I get the following error: [Zend_Db_Statement_Exception] ...
0
votes
2answers
138 views

Orders disappeared

I have upgraded my magento 1.3.2.4 to 1.7 but when I go to Sales --> Orders, it shows blank, and my lifetime sales and so forth is displayed as 0. Now iv'e checked the sales_flat_order table, and it ...
0
votes
1answer
755 views

Base tables already exist

Hi guys I have been trying hard to upgrade a magento 1.3.2.4 to magento 1.7 but it is not playing ball: it keeps saying that the base tables already exists. In particular these are: index_event, ...
2
votes
1answer
382 views

What is the proper way to run an UpgradeSchema.php file in Magento 2?

In Magento 1, you updated a database schema (add a table, column, etc.) by creating an upgrade_v[Previous]_v[Current].php file, change the version number in the config.xml, and Magento would look in ...
0
votes
1answer
56 views

Update products

I need to update a product into magento. I have write this: function aggiornamento_prodotto ($cod_art,$data_inserimento,$attivo,$setTaxClassId,$prezzo_listino,$descrizione_estesa,$descrizione ...
2
votes
3answers
2k views

After update i got strange error

I just updated my Magento to 1.9.2 and there is the error log file: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds ...
1
vote
1answer
66 views

how to install magento on customized sample database?

Is There any way to install magento with some Copy of production database? Exactly like installing Magento with sample data i want to Customize my current database (in used with old magento version 1....
0
votes
1answer
29 views

Importing Products to New Magento Installation - Help

I have a second Magento store which for some reason will not upgrade to the latest version of Magento. It's currently version 1.8.1 but I want to upgrade to 1.9.2. We have tried numerous times but ...
2
votes
1answer
1k views

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'SUM((IFNULL(main_table.base_total_invoiced, 0) - IFNULL(main_table.base_tax_invoiced, 0)

I had this error message showing after I tried to upgrade the Magento 1.9.1 cm_redisSession from the magento connect interface: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'SUM((IFNULL(...
3
votes
1answer
1k views

DataFlow Export Duplicate SKUs in SKU Field

I use the DataFlow Import/Export on a daily basis for updating product information. Last week we upgraded to the new 1.9.2 from 1.9.1 and besides the many other issues this upgrade has caused, now I ...
6
votes
1answer
2k views

Magento community edition 1.9.1 to 1.9.2 upgrade?

At what point does the database upgrade happen? If I unzip the downloaded magento image over my current installation, will that also upgrades database changes if any?
1
vote
0answers
40 views

password error after upgrade to 1.9.1 [duplicate]

I have upgraded a local install of magento 1.6 to 1.9 the magento install is on a windows server so I can't run mage script. I upgraded manually by copy and paste the magento 1.9.1 system files ...
2
votes
0answers
719 views

“There was a problem with reindexing process” after upgrade? [closed]

I'm facing a problem with reindexing Product Prices after upgrading magento. Previously I used the magento 1.7.0.2 version. It was working fine in live. Then for upgradation purpose, I installed the ...
2
votes
1answer
1k views

Magento 1.9.0.1 to 1.9.1.1 upgrade fails, existing tables

I tried to upgrade from 1.9.0 to 1.9.1 a long time ago. Unfortunatly there were some bugs in 1.9.1 which forced me to go back to 1.9.0. Today I tried to upgrade from 1.9.0 to 1.9.1.1 which failed (...
1
vote
1answer
793 views

Migrate products, sales and customer data to upgraded Magento dev site

I am in the process of upgrading my Magento website. I have started with a clean slate and done a fresh install of Magento 1.9.1 on a dev URL. I imported my current LIVE database and performed the ...
0
votes
1answer
126 views

Sync Prod. DB to Upgraded Staging. 1.8.1 to 1.9.1

I am in the process of Upgrading my Store from 1.8.1 to 1.9.1. While I can upgrade to 1.9.1, the process along with testing might take about a week. As this is all done in a Staging Environment, ...
2
votes
1answer
339 views

Importing 1.7 orders into 1.9

I am currently working on a new website design and planning to upgrade our current shop. The main bases will be the old database, but on "moving day" I want to import the latest orders/stock values ...
0
votes
1answer
358 views

After Magento upgrade from 1.4 to 1.8 - “Recoverable Errors”

I'm seeing a lot of "Recoverable Errors" in my system.log file after an upgrade from 1.4 to 1.8. For example: 2014-09-17T21:57:08+00:00 ERR (3): Recoverable Error: Argument 1 passed to ...
7
votes
3answers
19k views

MySQL error while importing database

I want to upgrade Magento. Therefor I first want to transfer the live production system to a development workspace. I am trying to import the production database into a clean database. But I can't get ...
0
votes
1answer
238 views

Live upgrade attempt and I get a table error 'coupon_aggregated_updated' doesn't exist

I was able to upgrade on my local no problem, but now I am trying on the server and I get this error? I looked at the ugpraded db and I don't have that table. Error in file: "app/code/core/Mage/...
12
votes
1answer
936 views

Does the Magento Database Upgrade happen in a “transaction”?

We have this issue atm: A client gets his shop upgraded from CE 1.4 to CE 1.8. The file-upgrade went well, and the database upgrade went also well on our development machine. When we try to upgrade ...
1
vote
4answers
245 views

Upgrading Magento From Version 1.6.2 to 1.7

Im currently running 1.6.2 now for about a year, this is from day one introductory into magento, so over the year I have gained more knowledge with magento, and I would like to move over to new ...
2
votes
2answers
893 views

What is stopping my Magento Database upgrading

We currently are working on 2 Magento sites, one is Enterprise 1.11 and one is Enterprise 1.13, if we take too long testing out all out modifications in 1.13 then we plan on getting a security patch ...
1
vote
3answers
2k views

Moving Products from 1.4 to 1.7 - dilemma

I've to move a lot of products from an old Magento site (v. 1.4) to a new one (1.7) with fresh new theme with new modules it's also a multisite, infact there' already a lot of stuff I configured in ...
2
votes
1answer
688 views

Is it upgrade safe to add custom address attributes

currently i am developing a Magento extension, that needs to add several custom attributes to customer address. I've found several tutorials on the topic that describe precisely what i need to build ...