Skip to content

Error Running Script #4

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Open
drinkingsouls opened this issue May 21, 2020 · 2 comments
Open

Error Running Script #4

drinkingsouls opened this issue May 21, 2020 · 2 comments

Comments

@drinkingsouls
Copy link

Hi,
This script would be hugely helpful to me if I could get it working.
I've setup the script in public_html of my Magento 2.
Magento 1 database prefix is mage_
Magento 2 database prefix is dac_

I've updated the script as so for all the arrays, for example:

array( 'name' => 'mage_cataloginventory_stock_item', 'id' => 'item_id', 'destination' => 'dac_cataloginventory_stock_item' ),

I get the error_log PHP Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/designacake2020/public_html/delta_migration_script-master/delta_migration_script-master/script.php``

I know there must be something obvious I'm doing wrong?
Thank you.

@MoMannn
Copy link
Owner

MoMannn commented May 22, 2020

It looks like a part of the script does not return a result but a false (meaning an sql statement failed).
https://stackoverflow.com/questions/11347971/mysqli-fetch-assoc-expects-parameter-1-to-be-mysqli-result-boolean-given
https://css-tricks.com/forums/topic/mysqli_fetch_assoc-expects-parameter-1-to-be-mysqli_result-error/

I'm guessing there may be a mistake with the array or something similar. Check the second link and maybe change the code (while statement) to check for errors.

Also feel free to make a pull request to update the code afterwards if you find mistakes.

@drinkingsouls
Copy link
Author

I did find these links from the Delta Migration topic but I wasn't able to figuire out where I was going wrong. I think that I am making the database connection but it's obviously not returning anything. My php knowledge is pretty basic. This would be a life saver if I could figure it out!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants