magento2 – I created a data fix, configuration: the upgrade never ends

I created a data fix after running the installation: the upgrade does the job but never completes the installation upgrade command.

View post on

View post on

the Data patch itself looks like this

setAreaCode('frontend') ;
        $this->searchCriteriaBuilder = $searchCriteriaBuilder;
        $this->_productRepositoryInterface = $productRepositoryInterface;
        $this->attributeRepository = $attributeRepository;
        $this->collectionFactory = $collectionFactory;

     * @inheritDoc
    public static function getDependencies()
        return ();

     * @inheritDoc
    public function getAliases()
        return ();
    public function apply()
          //$searchCriteria = $this->searchCriteriaBuilder->addFilter('manufacturer','LG')->create();

        $productcollection = $this->collectionFactory->create()->addAttributeToSelect('manufacturer','LG')->load();
        foreach ($productcollection as $product) {
            try {
            } catch (StateException $e) {



I tried to use return after the end of foreach but nothing happened.

Theme – Upgrade to Drupal 8, custom theme using no referenced CSS file

I update a theme from Drupal 7 to Drupal 8. I reference .css files in mytheme.library.yml which do not seem to be attracted to the site.

I watched online and even copied coding examples and replaced the names appropriately. However, I don't see their application or reference to a .css file, in the source code or the development tools.

If these files appear to be correct, then any direction to what could be causing this will be appreciated. If these are permissions, let me know which permissions SHOULD be!

I have cleared the cache hundreds of times after each change, and I am using incognito mode, so I know that this is not a browser or site caching issue .

Thank you.

Content of sites / all / themes / mytheme /

name: MyTheme
type: theme
description: My theme.
core: 8.x
base theme: bootstrap
logo: logo.png


  navigation: 'Navigation'
  header: 'Top Bar'
  highlighted: 'Highlighted'
  help: 'Help'
  content: 'Content'
  sub_content: 'Sub-content'
  sidebar_first: 'Primary'
  sidebar_second: 'Secondary'
  footer: 'Footer'
  page_top: 'Page top'
  page_bottom: 'Page bottom'
  footer_firstcolumn: 'Footer first column'
  footer_secondcolumn: 'Footer second column'

  - mytheme/global-assets

Content of sites / all / themes / mytheme / mytheme.library.yml

  version: VERSION
      css/main.css: {}
      css/bootstrap.css: {}
    js/main.js: {}
    js/bootstrap.min.js: {}
    js/enquire.min.js: {}
    js/jquery.main.js: {}

Any help or guidance would be appreciated.

Thank you

Oops! Upgrade from Fusion Drive to SSD without interrupting the fusion first

I replaced my merge drive with a 1TB SSD but I did not break the merge first. I'm using an iMac (27 inch, late 2013) i5 3.2 GHz with 8 GB of RAM with Catalina 10.15.3

I am attaching a photo of my device tree in diskutil.enter description of image here

Is there a way to make the 128 GB PCI flash the operating system and what is generally called "Macintosh HD" and the entire 1 TB SSD to be the "Macintosh HDD – Data "
Would I be manually creating a merge reader via the terminal of the two SSDs?

macos – Upgrade My Mac Os X Without Losing Data

I currently have mac os x 10.7.3, i downloaded OS X El Capitan but i did not install it, i am afraid of losing data. Will I really lose data if I install it? And if so, is there a way to update my mac os without losing data?
And thank you very much.

magento2 – Data upgrade .. SQLSTATE[HY093]: Invalid parameter number: the parameter was not defined, the request was: INSERT IN

when i run an insert sql command in "UpgradeData.php", this gives me this error, can someone tell me where the problem is here?

 if(version_compare($context->getVersion(), '1.0.2', '<')) {
            $query = "INSERT INTO authorization_rule(role_id,resource_id,permission) VALUES (:role_id,:ressource_id,:permission)";


                    ':role_id' => 5,
                    ':resource_id' => 'Magento_Sales::unhold',
                    //':priviliges' => null,
                    ':permission' => 'deny'
                    ':role_id' => 3,
                    ':resource_id' => 'Magento_Sales::unhold',
                    //':priviliges' => null,
                    ':permission' => 'deny'


the error is:

SQLSTATE (HY093): Invalid parameter number: the parameter was not defined, the request was: INSERT INTO authorization_rule (role_id, resource_id, permission) VALUES (: role_id ,: resource_id ,: permission)

Can I upgrade the resolution of a camera without getting a new camera body?

No, unless you are filming in medium format with a replaceable digital back, no. The sensor is the notch of the camera and is not replaceable.

I don't know if it's doable at all, but maybe use a longer lens and take panoramic photos to get higher resolution?

magento2 – Magento Upgrade 2.2.10 to 2.3.3 Obtain the violation of the php bin / magento setup integrity constraint: upgrade

I went from magento 2.2.10 to magento 2.3.3

after running

php bin/magento setup:upgrade

I have this error

SQLSTATE (23000): Violation of integrity constraint: 1452 Unable to add or update a child row: a foreign key constraint fails (db_amit. # Sql-14b6_7ed, CONSTRAINT CAT_PRD_ENTT_DEC_ENTT_ID_CAT_PRD_ENTT_ENTTID_ID entity ) REFERENCES_CENT_ID: ALTER TABLE catalog_product_entity_decimal UPDATE eav_attribute REFERENCES (attribute_id) ON CASCADE DELETE COLUMN decimal value (20, 6) NULL COMMENT "value", ADD CONSTRAINT CAT_PRD_ENTT_DEC_ATTR_ID_EAV_ATTR_ATTR_ID FOREIGN KEY (attribute_id), ADD CONSTRAINT CAT_PRD_ENTT_DEC_ENTT_ID_CAT_PRD_ENTT_ENTT_ID FOREIGN KEY (entity_id) REFERENCES catalog_product_entity (entity_id ) ON DELETE CASCADE, ADD CONSTRAINT CATALOG_PRODUCT_ENTITY_DECIMAL_STORE_ID_STORE_STORE_ID FOREIGN KEY (store_id) REFERENCES store (store_id) ON DELETE CASCADE

gui design – Data upgrade user interface suggestions

I'm here looking for design suggestions and ideas if anyone can help me please, Basically I'm working on a screen that should display a lot of defined data by levels. Let's say we have a city with its data and for each city, we have cities with its data and each city, we have schools with each data and for each school, we have lists on different categories Teachers, students, classes, rules, opening hours, equipment. My problem is that we have a lot of data, such a city can have 100 cities and a city can have 100 schools and each list inside the school can have 20 entries. I was thinking of using the slides (idea link), but with that number of components, the screen will be overloaded. Any ideas or suggestions?

IPhone X iOS upgrade failed, now in recovery mode

Steps leading to iPhone X in recovery mode

  • Phone runs out of battery and dies
  • Phone charged and left alone
  • Presumably that automatically tried to update to 13.3.1
  • After a while (10-15 minutes), I saw that it was stuck on the Apple logo with a black screen
  • Forced restart
  • I'm still stuck
  • Put in recovery mode
  • Connected to PC and attempted to update via iTunes
  • Thanks to the iTunes update has started, seen on the iPhone the Apple logo and bar indicating that it is loading
  • About 15% of this iTunes bar displays error 14

I have tried different tools, even one which SHOULD fix it but didn't do it.

Attempt to update to iOS 13

Copy the media files (image, videos) from the iPhone (there are no backups) so that I can do a factory reset.