New answers tagged

0

Same Problem here: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TABLE 564 WHERE `Non_unique` = 1' at line 1, query was: SHOW INDEXES FROM TABLE 564 WHERE `Non_unique` = 1


0

I'm getting the same error on my Magento 2.3 This is getting really annoying and happens to me a lot. www-data@579d4cdb05ab:~/html$ mag s:upgrade Cache cleared successfully File system cleanup: /var/www/html/generated/code/Composer /var/www/html/generated/code/Dotdigitalgroup /var/www/html/generated/code/MSP /var/www/html/generated/code/Magento /var/www/...


1

I have used FIND_IN_SET function to find particular Id and the Group_Contact to Merge it Again $collection = $this->_connectordetailsFactory->create()->getCollection(); $this->setCollection($collection); $collection->getSelect() ->columns('CONCAT((SELECT nametable.value FROM catalog_product_entity_varchar AS nametable LEFT JOIN ...


0

Use below code: <?php $objectManager = \Magento\Framework\App\ObjectManager::getInstance(); $productRepository = $objectManager->get('\Magento\Catalog\Model\ProductRepository'); $skuList = 'sku1, sku2, sku3, sku4'; $exlodeList = explode(',', $skuList); $productNamesArray = []; for($exlodeList as $sku) { $productObj = $productRepository->get(trim($...


1

Store your SKUs as an array like below. Loop the SKUs $values[] = array("finset"=>array($sku)); Then use the below filter $products->addAttributeToFilter('sku',$values);


0

after scanning my database searching a corrupt or bad configuration, i found the problem, in my case CUSTOMER_EAV_ATTRIBUTE_WEBSITE, IN THE MULTI-LINE_COUNT COLUMN there was set with number 2, consequently showing only two lines in the address, so i set the column for 4, and it makes show 4 lines address in front-end store. But still stay the Big question; ...


0

If we need to pass default value, then we need to check whether the default value is compatible with the type of field we are using is default Initializes the column with the specified default value. The default value should have the same datatype defined in xsi:type. so for having any int value as default use it like <column xsi:type="int" name=...


2

When there are any changes in the object of a database that the Magento 2 system has indexes for, a new trigger appears in the table with the _cl postfix if there is such a table. If there is no such table, a new one is generated. The mview.xml files are responsible for defining the data which changes will be tracked in the _cl (change log) table. For ...


0

I changed database connection in env.php and the changed DB had everything like Adam's answer, but, due to wrong configuration in env.php, it could not connect to store_website table. I missed to write the table prefix there. After correcting, deploy and cache flush fixed that error.


0

Not sure whether you're on Enterprise or Open-Source Magento you're on. ( That being said - I assume the steps below apply to both ) Note: The instructions below were executed and validated on a Magento (Enterprise) 2.3.5-p2 instance. . . . To update the # of Address lines displayed on the website: Login to Magento Admin UIX -> Stores -> Attributes : ...


0

create sandbox script <magento root>/sandbox/testAsyncGrid.php <?php ini_set('error_reporting', E_ALL | E_STRICT); ini_set('display_errors', true); ini_set('log_errors', true); set_time_limit(0); /* * Turn off output buffering */ while (ob_get_level()) { ob_end_clean(); } require_once '../app/bootstrap.php'; $bootstrap = \Magento\Framework\...


0

Upload the .sql database file on the cloud Crate empty database on mysql Open ssh Run command sudo mysql -u <DB_username> -p <databse_name> < /databse_file_path/databse_file.sql


0

Just follow: https://devdocs.magento.com/cloud/setup/first-time-setup-import-import.html And, For PHP: And increase default_socket_timeout in your php.ini For MariaDB ( so probably you have to change this one only) SELECT @@wait_timeout; SET GLOBAL wait_timeout=600; SELECT @@max_allowed_packet; SET GLOBAL max_allowed_packet=107374182 Then restart the ...


0

You will need to join review & review_detail tables. select r.review_id,sku,title,detail,nickname from review r inner join catalog_product_entity p on p.entity_id = r.entity_pk_value inner join review_detail d on d.review_id = r.review_id;


0

You can work with joins on below tables Tables catalog_product_entity entity_id sku review review_id entity_id --> product entity id review_detail review_id title detail nickname store_id --> if using multi store eav_attribute attribute_id entity_type_id --> usually is equal to 4 for product entity attribute_code --> find out attribute id ...


0

<?php namespace VendorName\Reviews\Model; use Magento\Catalog\Api\ProductRepositoryInterface; use Magento\Review\Model\ResourceModel\Review\Collection as ReviewCollection; class Results { /** * @var ReviewCollection */ private $reviewsCollection; /** * @var \Magento\Review\Model\ResourceModel\Review\CollectionFactory */ ...


0

Worked out our issue...... we had edited the config.php file directly. Which was suggested in a post here, but upon reading other posts, this is not a great idea and you should run commands to disable/enable modules, which we'll do from now on. Leaving this here in case others have the same issue in future. Limited information online on this it seems for the ...


0

Confirming the same issue at the Magento 2.4.0


0

Just run composer update once and then try with the setup:upgrade command


Top 50 recent answers are included