Magento 2.3.1 Search Bar Error – Unknown column ‘search_result.score’

Relatively new to Magento. Helped a friend migrate a site from M1 to M2. Using Porto Theme.

Search Bar seems to work (does auto querying as you type and makes suggestions) until you hit ‘Enter’ at that point you get the following error:

{“0”:”SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘search_result.score’ in ‘order clause’, query was: SELECT e., price_index.price, price_index.tax_class_id, price_index.final_price, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS minimal_price, price_index.min_price, price_index.max_price, price_index.tier_price, cat_index.position AS cat_index_position, stock_status_index.stock_status AS is_salable FROM catalog_product_entity AS e\n INNER JOIN catalog_product_index_price AS price_index ON price_index.entity_id = e.entity_id AND price_index.website_id = ‘1’ AND price_index.customer_group_id = 0\n INNER JOIN catalog_category_product_index_store1 AS cat_index ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(3, 4) AND cat_index.category_id=2\n INNER JOIN cataloginventory_stock_status AS stock_status_index ON e.entity_id = stock_status_index.product_id ORDER BY search_result.score desc\n LIMIT 24″,”1″:”#1 Magento\Framework\DB\Statement\Pdo\Mysql->_execute(array()) called at [vendor/magento/zendframework1/library/Zend/Db/Statement.php:303]\n#2 Zend_Db_Statement->execute(array()) called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:480]\n#3 Zend_Db_Adapter_Abstract->query(‘SELECT e., p...', array()) called at [vendor\/magento\/zendframework1\/library\/Zend\/Db\/Adapter\/Pdo\/Abstract.php:238]\n#4 Zend_Db_Adapter_Pdo_Abstract->query('SELECTe.*,p…’, array()) called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:542]\n#5 Magento\Framework\DB\Adapter\Pdo\Mysql->_query(‘SELECT e.*, `p…’, array()) called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:617]\n#6 Magento\Framework\DB\Adapter\Pdo\Mysql->query(&Magento\Framework\DB\Select#0000000027346819000000004114b559#, array()) called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:737]…

Switched back to Luma theme and still seeing the issue.

Been attempting to track down a solution and have exhausted my limited knowledge. Found the same issue here: Column not found: 1054 Unknown column 'search_result.score' in 'order clause'; but the suggestions there didn’t work for me.

It would appear that there is supposed to be a table named search_result and I can’t see in the mysql logs where the system has created or attempted to create a temporary table named ‘search_result’.

It looks to me like the sql is incorrect in that a relationship to search_result is never established in the query, but maybe that’s not needed.

Do any of you magento experts have any idea what I’m dealing with here? Can I change the query?

Error in creating customer using REST API Magento 2.3.1

I am following this document

https://devdocs.magento.com/guides/v2.3/rest/tutorials/orders/order-create-customer.html

REST Client: Postman

Verb: POST

URI: http://127.0.0.1/index.php/rest/V1/customers

Payload:

{     "customer": {         "email": "myeamil@yahoo.com",         "firstname": "Jane",         "lastname": "Doe",         "addresses": [{             "defaultShipping": true,             "defaultBilling": true,             "firstname": "Jane",             "lastname": "Doe",             "region": {                 "regionCode": "NY",                 "region": "New York",         "regionId":43             },             "postcode": "10755",             "street": ["123 Oak Ave"],             "city": "Purchase",             "telephone": "512-555-1111",             "countryId": "US"         }]     },   "password": "Password1" } 

Expected result: Customer should create

Actual Output:

> <b>Fatal error</b>:  Uncaught TypeError: Return value of > Magento\Eav\Model\Attribute\Data\Text::validateLength() must be of the > type array, boolean returned in > /var/www/html/vendor/magento/module-eav/Model/Attribute/Data/Text.php:160 >       > Stack trace:     > #0 /var/www/html/vendor/magento/module-eav/Model/Attribute/Data/Text.php(80):     > Magento\Eav\Model\Attribute\Data\Text-&gt;validateLength(Object(Magento\Customer\Model\Attribute),     > 'Default Store V...')     > #1 /var/www/html/vendor/magento/module-eav/Model/Validator/Attribute/Data.php(131):     > Magento\Eav\Model\Attribute\Data\Text-&gt;validateValue('Default Store     > V...')     > #2 /var/www/html/vendor/magento/framework/Validator/Constraint.php(54):     > Magento\Eav\Model\Validator\Attribute\Data-&gt;isValid(Object(Magento\Customer\Model\Customer\Interceptor))     > #3 /var/www/html/vendor/magento/framework/Validator.php(59): Magento\Framework\Validator\Constraint-&gt;isValid(Object(Magento\Customer\Model\Customer\Interceptor))     > #4 /var/www/html/vendor/magento/module-customer/Model/ResourceModel/Customer.php(172):     > Magento\Framework in     > <b>/var/www/html/vendor/magento/module-eav/Model/Attribute/Data/Text.php</b>     > on line <b>160</b> <br />     > {"messages":{"error":[{"code":500,"message":"Fatal Error: 'Uncaught     > TypeError: Return value of     > Magento\Eav\Model\Attribute\Data\Text::validateLength() must be     > of the type array, boolean returned in     > \/var\/www\/html\/vendor\/magento\/module-eav\/Model\/Attribute\/Data\/Text.php:160\nStack     > trace:\n#0     > \/var\/www\/html\/vendor\/magento\/module-eav\/Model\/Attribute\/Data\/Text.php(80):     > Magento\Eav\Model\Attribute\Data\Text->validateLength(Object(Magento\Customer\Model\Attribute),     > 'Default Store V...')\n#1     > \/var\/www\/html\/vendor\/magento\/module-eav\/Model\/Validator\/Attribute\/Data.php(131):     > Magento\Eav\Model\Attribute\Data\Text->validateValue('Default     > Store V...')\n#2     > \/var\/www\/html\/vendor\/magento\/framework\/Validator\/Constraint.php(54):     > Magento\Eav\Model\Validator\Attribute\Data->isValid(Object(Magento\Customer\Model\Customer\Interceptor))\n#3 \/var\/www\/html\/vendor\/magento\/framework\/Validator.php(59):     > Magento\Framework\Validator\Constraint->isValid(Object(Magento\Customer\Model\Customer\Interceptor))\n#4 \/var\/www\/html\/vendor\/magento\/module-customer\/Model\/ResourceModel\/Customer.php(172):     > Magento\Framework' in     > '\/var\/www\/html\/vendor\/magento\/module-eav\/Model\/Attribute\/Data\/Text.php'     > on line 160","trace":"Trace is not available."}]}} 

Where is the issue..!

Magento 2.3.1 php 7.2 upgrade Parameter must be an array or an object

Getting this error when trying to complete upgradeo of Mgaento 2.2.2 that was running on PHP7.1 to Magento 2.3.1 running on PHP 7.2

1 exception(s): Exception #0 (Exception): Warning: count(): Parameter must be an array or an object that implements Countable in /home/mytheme/public_html/app/design/frontend/Sm/topshop/Sm_Deals/templates/default.phtml on line 16

I managed to fix alot of errors with researching but stuck with this one.

$ start = ($ start <= 0 || $ start > count($ list)) ? 0 : $ start – 1;

Magento 2.3.1 php 7.2 upgrade Parameter must be an array or an object

Getting this error when trying to complete upgradeo of Mgaento 2.2.2 that was running on PHP7.1 to Magento 2.3.1 running on PHP 7.2

1 exception(s): Exception #0 (Exception): Warning: count(): Parameter must be an array or an object that implements Countable in /home/mytheme/public_html/app/design/frontend/Sm/topshop/Sm_Deals/templates/default.phtml on line 16

I managed to fix alot of errors with researching but stuck with this one.

$ start = ($ start <= 0 || $ start > count($ list)) ? 0 : $ start – 1;

Magento 2.3.1 import images with external link still not working

trying to pull image from external url during import but get:

"1. Imported resource (image) could not be downloaded from external resource due to timeout or access permissions in row(s): 2" 

here is the link… https://media.server.theshootingwarehouse.com/large/48217.jpg

I only have two products to test.. I exported products… edited the CSV to add the above url to the base_image column.

I have tried with and without https:// I get the same errror.. I am on M2 2.3.1

I want to enable captcha on guest checkout in Magento 2.3.1. I am using one step checkout

I want to enable captcha on guest checkout in Magento 2.3.1. I am using the one-step checkout.

I know that it is a simple question and you can follow this nice article to do that: https://www.mageplaza.com/kb/how-to-enable-customer-login-register-captcha-magento-2.html

However, I believe that there is something wrong with my Magento installation and it is not showing me “Check out as guest” option in form section inside Captcha.

Can I enable “Check out as guest” option manually using the command line or terminal or FTP?