Installation Error

I have a fresh install of m2 and am trying install your module via the terminal, please see the results below.
 
 
 
[root@server dd]# composer require ubertheme/module-ubdatamigration
Using version ^1.0 for ubertheme/module-ubdatamigration
./composer.json has been updated
Loading composer repositories with package information
Updating dependencies (including require-dev)
Your requirements could not be resolved to an installable set of packages.
  Problem 1
    -- Conclusion: don’t install ubertheme/module-ubdatamigration v1.0.4
    -- Conclusion: don’t install ubertheme/module-ubdatamigration v1.0.3
    -- Conclusion: don’t install ubertheme/module-ubdatamigration v1.0.2
    -- Conclusion: don’t install ubertheme/module-ubdatamigration v1.0.1
    -- Conclusion: don’t install ubertheme/module-ubdatamigration v1.0.0|remove magento/framework 100.1.7
    -- Conclusion: don’t install ubertheme/module-ubdatamigration v1.0.0|don’t install magento/framework 100.1.7
    -- Installation request for ubertheme/module-ubdatamigration ^1.0 -> satisfiable by ubertheme/module-ubdatamigration[v1.0.0, v1.0.1, v1.0.2, v1.0.3, v1.0.4].
    -- ubertheme/module-ubdatamigration v1.0.0 requires magento/framework 100.0.* -> satisfiable by magento/framework[100.0.2, 100.0.3, 100.0.4, 100.0.5, 100.0.6, 100.0.7, 100.0.8, 100.0.9, 100.0.10, 100.0.11, 100.0.12, 100.0.13, 100.0.14, 100.0.15, 100.0.16, 100.0.17].
    -- Can only install one of: magento/framework[100.1.7, 100.0.2].
    -- Can only install one of: magento/framework[100.1.7, 100.0.3].
    -- Can only install one of: magento/framework[100.1.7, 100.0.4].
    -- Can only install one of: magento/framework[100.1.7, 100.0.5].
    -- Can only install one of: magento/framework[100.1.7, 100.0.6].
    -- Can only install one of: magento/framework[100.1.7, 100.0.7].
    -- Can only install one of: magento/framework[100.1.7, 100.0.8].
    -- Can only install one of: magento/framework[100.1.7, 100.0.9].
    -- Can only install one of: magento/framework[100.1.7, 100.0.10].
    -- Can only install one of: magento/framework[100.1.7, 100.0.11].
    -- Can only install one of: magento/framework[100.1.7, 100.0.12].
    -- Can only install one of: magento/framework[100.1.7, 100.0.13].
    -- Can only install one of: magento/framework[100.1.7, 100.0.14].
    -- Can only install one of: magento/framework[100.1.7, 100.0.15].
    -- Can only install one of: magento/framework[100.1.7, 100.0.16].
    -- Can only install one of: magento/framework[100.1.7, 100.0.17].
    -- Installation request for magento/framework (locked at 100.1.7) -> satisfiable by magento/framework[100.1.7].
Installation failed, reverting ./composer.json to its original content.

9 answers

Profile photo of Mall Staff 184060.00 $tone June 22, 2017
Public

Hi movieprodw2,
Where did you follow install guide of our tool? Our tool was not public via composer. Kindly re-try with steps as bellow:
Step 1: Install a new Magento2 fresh instance.
Step 2: Extract the your downloaded package of our tool and then follow full steps to install our tool in the Readme.html file
Step 3: Once done, you can start migrate your data as our guide.
Regards,
Mall.

#1
Profile photo of Sarah 300.00 $tone June 23, 2017
Public

Hi movieprodw2,
Please follow the steps Mall mentioned in the previous reply. Should you have any additional question, please submit a new ticket, our team will help you out. 
Best Regards,
Sarah

#3
Profile photo of Mall Staff 184060.00 $tone July 12, 2017
Public

Hi there,

 How about this one?
2017/07/11 20:13:54 [info] [ub_data_migration] Continue running step #7
2017/07/11 20:13:55 [error] [ub_data_migration] CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘AND order_item_id = 16625 LIMIT 1’ at line 1

Seem your database has some bad data in the sales data section. Kindly enable debug mode of our tool by steps as indicated in Readme.html and rerun data migration in the step #7 and provide me detail of error message which you see. I will check further and help you out.
Regards,
Mall.

#4
Profile photo of Mall Staff 184060.00 $tone July 12, 2017
Public

Hi there,

Message: CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘AND order_item_id = 16757 LIMIT 1’ at line 1. The SQL statement executed was: SELECT * FROM `sales_creditmemo_item` `t` WHERE parent_id = 2 AND product_id =  AND order_item_id = 16757 LIMIT 1

That because your database has some records with bad data in the table named sales_creditmemo_item. To handle that, kindly do steps as bellow:
Step 1: Download the php file at HERE
Step 2: Upload replace downloaded file to the file at: pub/ub-tool/protected/controllers/Step7Controller.php
Step 3: Once done, you can continue with data migration in the step #7
And tell me know how it goes.
Regards,
Mall.

#5
Profile photo of Mall Staff 184060.00 $tone July 12, 2017
Public

Hi there,

…………………………………………………………….PHP Error[2]: include(Varien_Object.php): failed to open stream: No such file or directory
    in file /home/asleep20/public_html/public/pub/ub-tool/yii/YiiBase.php at line 432
#0 /home/asleep20/public_html/public/pub/ub-tool/yii/YiiBase.php(432): include()
#1 unknown(0): autoload()
#2 unknown(0): spl_autoload_call()
#3 /home/asleep20/public_html/public/pub/ub-tool/protected/controllers/Step7Controller.php(1760): unserialize()

That seem your database has one more case with bad data in the sales data section. I need a closer look to detect the root of that issue.
Kindly provide me the admin credentials, ssh credentials and web root path of your Magento2. I will check further and reply you more later.
 
Regards,
Mall.

#6
Profile photo of Mall Staff 184060.00 $tone July 18, 2017
Public

Hi there,

still get the same error

 

Processing in step #7……………………………………………………………………PHP Error[2]: include(Varien_Object.php): failed to open stream: No such file or directory

    in file /home/asleep20/public_html/public/pub/ub-tool/yii/YiiBase.php at line 432

#0 /home/asleep20/public_html/public/pub/ub-tool/yii/YiiBase.php(432): include()

#1 unknown(0): autoload()

#2 unknown(0): spl_autoload_call()

#3 /home/asleep20/public_html/public/pub/ub-tool/protected/controllers/Step7Controller.php(1760): unserialize()

Kindly pause all your activities at your end. I will check further your instance and reply you more later.
 
Regards,
Mall.

#8
Profile photo of Mall Staff 184060.00 $tone July 18, 2017
Public

Hi there,
I have checked more in your instance and i see the root of the issue is here: http://i.prntscr.com/qlSYVhYPTFut512_QeJw4w.png
And here is view from your Magento1 database: http://i.prntscr.com/6jlSlk8fSVSp2FvtyHsB0g.png
That because your database has some records with bad data in value of the product_options field in the the table named sales_flat_order_item 
To solve that issue, you could run following SQL in your Magento1 database to clean that records:

Update sales_flat_order_item Set product_options = null Where product_options Like '%Varien_Object%';

Once done, you can continue with data migration in the step #7 with our tool.
Regards,
Mall.

#9

Please login or Register to Submit Answer

Written By

Comments