Reviews not transfering

I was able to migrate all our data, and despite the reviews being enabled and showing in the admin panel they did not transfer. 

12 answers

Profile photo of Mall Staff 184060.00 $tone January 11, 2018
Public

Hi there,

I was able to migrate all our data, and despite the reviews being enabled and showing in the admin panel they did not transfer. 

Kindly provide me more information about that, that issue happened on all or some your products? Kindly provide me more information about your instance as followings:
+ Admin credentials and site URL
+ SSH credentials and web root path of your instance
+ Specify me product’s SKU of the product with issue as you mentioned
I will check further and reply you more later.
Regards,
Mall.

#1
Profile photo of Mall Staff 184060.00 $tone January 11, 2018
Public

Hi there,
I have checked in your back-end and i see the issue as you mentioned.
I need to check further in your databases now. Please provide me more the phpMyadmin credentials of your M1 and M2 databases.
Also, kindly re-check I couldn’t connect to your server via ssh you are provided: http://i.prntscr.com/GI_800eMRCKVelKZYOTRCA.png
Regards,
Mall.
 

#3
Profile photo of Mall Staff 184060.00 $tone January 17, 2018
Public

Hi there,
I have checked further in your M1’s database and I see the root of issue because all in 65 review_details has store_id = 1 but you didn’t select the Store view which has store_id = 1 to migrate in the step #2 of our tool. You could see more below screenshots:
All 65 review details has store_id = 1: http://i.prntscr.com/MGUAcZt0QFCsLZECAlFeVw.png
You have not select the store view which has store_id =1 to migrate: 
https://prnt.sc/i1hv07
http://i.prntscr.com/LO0kKx8xQ8OKKwaTvFigPQ.png
Regards,
Mall.

#7
Profile photo of dirtbound 50.00 $tone January 18, 2018
Public

Ok I see what you are saying, how do you recommend fixing that? When I go in and select the store id 1 and then try to run the script just sits and nothing happens. 
 

#8
Profile photo of Mall Staff 184060.00 $tone January 19, 2018
Public

Hi there,

 how do you recommend fixing that? When I go in and select the store id 1 and then try to run the script just sits and nothing happens. 

Let’s try with steps as followings:
+ Step 1: Resetting the step #2 and select all Stores, Store views in this step
+ Step 2: Run delta migration update in step #2, #8 by run CLI command:
php -f bin/ubdatamigration run --step=2 --mode=update
php -f bin/ubdatamigration run --step=8 --mode=update
Or, you could do delta migration with update mode in all steps by use CLI command:
php -f bin/ubdatamigration run --mode=update
Other case, you should reset in all steps: #8,#7,#6,#5,#4,#3,#2 of our tool and redo migration in these steps again.
Regards,
Mall.

#9
Profile photo of dirtbound 50.00 $tone January 19, 2018
Public

Alright, I tried running the update from the command line and I get an error. 
 
#11 {main}[dbinc@atlantis public_html]$ php -f bin/ubdatamigration run --step=2 --mode=update
Processing in step #2……Error: Call to a member function getErrors() on null in /home/dbinc/public_html/pub/ub-tool/protected/controllers/Step2Controller.php:369
Stack trace:
#0 /home/dbinc/public_html/pub/ub-tool/protected/controllers/Step2Controller.php(145): Step2Controller->_migrateWebsites(Array, Array)
#1 /home/dbinc/public_html/pub/ub-tool/protected/commands/RunCommand.php(58): Step2Controller->actionRun()
#2 /home/dbinc/public_html/pub/ub-tool/protected/commands/RunCommand.php(28): RunCommand->_migrateData(Object(Step2Controller))
#3 [internal function]: RunCommand->actionIndex(Object(Step2Controller), false, ‘update’)
#4 /home/dbinc/public_html/pub/ub-tool/yii-1.1.19/console/CConsoleCommand.php(172): ReflectionMethod->invokeArgs(Object(RunCommand), Array)
#5 /home/dbinc/public_html/pub/ub-tool/yii-1.1.19/console/CConsoleCommandRunner.php(71): CConsoleCommand->run(Array)
#6 /home/dbinc/public_html/pub/ub-tool/yii-1.1.19/console/CConsoleApplication.php(92): CConsoleCommandRunner->run(Array)
#7 /home/dbinc/public_html/pub/ub-tool/yii-1.1.19/base/CApplication.php(185): CConsoleApplication->processRequest()
#8 /home/dbinc/public_html/pub/ub-tool/yii-1.1.19/yiic.php(33): CApplication->run()
#9 /home/dbinc/public_html/pub/ub-tool/protected/ubdatamigration_cli.php(5): require_once(‘/home/dbinc/pub…’)
#10 /home/dbinc/public_html/bin/ubdatamigration(4): require_once(‘/home/dbinc/pub…’)

#10
Profile photo of Mall Staff 184060.00 $tone January 19, 2018
Public

Hi there,

#11 {main}[dbinc@atlantis public_html]$ php -f bin/ubdatamigration run --step=2 --mode=update
Processing in step #2……Error: Call to a member function getErrors() on null in 

So, please do reset in all steps with steps as my reply #9.
Regards,
Mall.

#11
Profile photo of dirtbound 50.00 $tone January 19, 2018
Public

 Alright, well I was able to get it working after doing the above and then some database updates. For some reason, the reviews were not working on the store we wanted so we went into the review_entity_summary table and review_storeand changed the store id to the one we are using and then they started to work again. 
I think this might have been due to the fact that we already had a “website” set up for our theme design before we ran the import script. If we had done the migration and then the theme I believe this would have been a non-issue as far as getting them to show on the website view we are using. 
Looks like we are about to go live now and delta migration is working again also. 

#12

Please login or Register to Submit Answer

Written By

Comments