Magento EE upgrade from 2.2.9 to 2.3.4 issue

I have upgraded Magento from 2.2.9 to 2.3.4 using composer. And run the setup: upgrade, then I got getting below error. SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (#sql-27b_17e, CONSTRAINT QUOTE_ITEM_PARENT_ITEM_ID_QUOTE_ITEM_ITEM_ID FOREIGN KEY (parent_item_id) REFERENCES quote_item (item_id) ON DELETE CASCADE), query was: ALTER TABLE quote_item…

Fatal error: Uncaught Error: Call to a member function select() on null.Magento2

<?php $connection = $this->getConnection(); $select = $connection->select(); $select = $model->getCollection() ->select() ->count() ->from($this->getDbPrefix() . ‘name_table’, ‘*’) ->where(‘result’, ‘ likes%’); return (int)$objectManager->fetchOne($select); ?> I want SELECT COUNT (*) FROM name_table WHERE result LIKE ‘likes%’ to be executed, and a numeric value is displayed on the page.How do I do it? I’m a beginner. I’ll be very…

Fatal error: Uncaught Error: Call to a member function select() on null.Magento2

<?php $connection = $this->getConnection(); $select = $connection->select(); $select = $model->getCollection() ->select() ->count() ->from($this->getDbPrefix() . ‘name_table’, ‘*’) ->where(‘result’, ‘ likes%’); return (int)$objectManager->fetchOne($select); ?> I want SELECT COUNT (*) FROM name_table WHERE result LIKE ‘likes%’ to be executed, and a numeric value is displayed on the page.How do I do it? I’m a beginner. I’ll be very…

Fatal error: Uncaught Error: Call to a member function select() on null.Magento2

<?php $connection = $this->getConnection(); $select = $connection->select(); $select = $model->getCollection() ->select() ->count() ->from($this->getDbPrefix() . ‘name_table’, ‘*’) ->where(‘result’, ‘ likes%’); return (int)$objectManager->fetchOne($select); ?> I want SELECT COUNT (*) FROM name_table WHERE result LIKE ‘likes%’ to be executed, and a numeric value is displayed on the page.How do I do it? I’m a beginner. I’ll be very…

magento 2 how to set quantity 0 to 1 on listing page (category page)

<input type=”number” name=”qty” id=”qty” maxlength=”12″ placeholder=”1″ value=”<?php /* @escapeNotVerified */ echo $block->getProductDefaultQty() * 1 ?>” title=”<?php /* @escapeNotVerified */ echo __(‘Qty’) ?>” class=”input-text qty form-control” data-validate=”<?php echo $block->escapeHtml(json_encode($block->getQuantityValidators())) ?>” /> I have changed quantity from admin panel 0 to 1 it’s working on the product page but it’s not working on the category page please…

Circular dependency issue in magento 2after adding code in posts_form.xml file which is giving trouble? [closed]

Background Information: This is Amasty’s BlogPro Extension in that in Posts section when we click on Add new post or Edit post then the posts_form.xml design is seen Path: app/code/Ranosys/Rblog/view/adminhtml/ui_component/posts_form.xml Code: <field name=”featured_post_thumbnail_file”> <argument name=”data” xsi:type=”array”> <item name=”config” xsi:type=”array”> <item name=”label” xsi:type=”string”>Featured Post Image</item> <item name=”formElement” xsi:type=”string”>fileUploader</item> <item name=”elementTmpl” xsi:type=”string”>ui/form/element/uploader/uploader</item> <item name=”previewTmpl” xsi:type=”string”>Amasty_Blog/form/image-preview</item> <item name=”maxFileSize”…

Circular dependency issue in magento 2after adding code in posts_form.xml file which is giving trouble? [closed]

Background Information: This is Amasty’s BlogPro Extension in that in Posts section when we click on Add new post or Edit post then the posts_form.xml design is seen Path: app/code/Ranosys/Rblog/view/adminhtml/ui_component/posts_form.xml Code: <field name=”featured_post_thumbnail_file”> <argument name=”data” xsi:type=”array”> <item name=”config” xsi:type=”array”> <item name=”label” xsi:type=”string”>Featured Post Image</item> <item name=”formElement” xsi:type=”string”>fileUploader</item> <item name=”elementTmpl” xsi:type=”string”>ui/form/element/uploader/uploader</item> <item name=”previewTmpl” xsi:type=”string”>Amasty_Blog/form/image-preview</item> <item name=”maxFileSize”…