8 – Unable to get titles to show up as higher priority in search than content

I have a website I am working on that has a TON of content. The client has noticed that when searching for titles in the site search, it seems to prioritize the body content over the title.

So I changed the search index for titles to be fulltext with a boost of 13. With the rendered output set to a boost of 1. Then I reindexed and that didn’t fix it. I did a full rebuild of tracking information. Same problem.

I found this article: https://medium.com/@easternstandard/how-to-configure-drupal-8-text-search-to-return-better-more-intuitive-search-results-fe0a78136ad7

And followed the instructions there (pretty much what I had already done) and reindexed. Same issue.

An example of this is that we have an article about the response to covid where the phrase “response to covid” is part of the title. When I search for that phrase I do not see it in any of the first-page search results. It is set to show 20 items. In fact, the article in question doesn’t come up until result number 39. None of the prior articles seem to have covid in the title at all. Even searching with quotations makes no difference.

This is currently using the database search/index. I am tempted to implement Solr. But that is a whole-nother ball of wax and I am on a deadline right now.

We are running Drupal 8.9.9 and the Search API 8.x-1.18.

What can I do differently to make it value the title over the rendered content?

error – Something went wrong with processing the default view and we have restored the filter to its original state. Also unable to find products with no SKU

Magento 2.4.1

I’ve done a Migration from Magento 1.9.4.0 to 2.4.1. There is a total of 1750 products.

I went to:

  • Catalog –) Products, select 200 per page and was browsing by using the right arrow. It takes longer than expected for the next page of products to load and then when going from page 6 to page 7 of products (out of 9 total) – out of nowhere – there is a pop-up which says:

Attention Something went wrong.

If you click OK – you get the following Error on the page itself:

Something went wrong with processing the default view and we have
restored the filter to its original state.

When this happens, that specific user is corrupted somehow and you always get this Error when going into products.

I tried deleting all Cache and re-indexing but it doesn’t help nor does logging out and logging back in.

I found articles where they suspect not having SKUs on products may cause this and adding SKUs to those products might fix it. When searching for products with NO SKUs via SQL however, I always get the following Error:

#1146 – Table ‘database_name741.catalog_product_entity’ does not exist.

I am not that good with running SQL queries so I was just copying and pasting some from this article here:

https://gist.github.com/tegansnyder/8464261

Any idea what I can do to identify products with no SKU or how else to fix this problem?

MySQL InnoDB cluster admin unable to create database

I have set up a new InnoDB cluster and created a non-root admin user. I have also set up mysqlrouter on a seperate host.

To open a session I am using mysqlsh on the current primary member using the non-root admin user:

(root@srv-db-mysql-03 ~)# mysql --version
mysql  Ver 8.0.23 for Linux on x86_64 (MySQL Community Server - GPL)
(root@srv-db-mysql-03 ~)# mysqlsh icadmin@localhost

When switching to sql mode and checking the permissions of the icadmin user, I can see that it should be able to create a new database and also assign permissions:

 MySQL  localhost:33060+ ssl  SQL > show grants;
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Grants for icadmin@%                                                                                                                                                                                                                                                        |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| GRANT SELECT, RELOAD, SHUTDOWN, PROCESS, FILE, SUPER, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE USER ON *.* TO `icadmin`@`%` WITH GRANT OPTION                                                                                                                 |
| GRANT BACKUP_ADMIN,CLONE_ADMIN,PERSIST_RO_VARIABLES_ADMIN,REPLICATION_APPLIER,SYSTEM_VARIABLES_ADMIN ON *.* TO `icadmin`@`%` WITH GRANT OPTION                                                                                                                              |
| GRANT INSERT, UPDATE, DELETE ON `mysql`.* TO `icadmin`@`%` WITH GRANT OPTION                                                                                                                                                                                                |
| GRANT INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON `mysql_innodb_cluster_metadata`.* TO `icadmin`@`%` WITH GRANT OPTION          |
| GRANT INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON `mysql_innodb_cluster_metadata_bkp`.* TO `icadmin`@`%` WITH GRANT OPTION      |
| GRANT INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON `mysql_innodb_cluster_metadata_previous`.* TO `icadmin`@`%` WITH GRANT OPTION |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

However, when trying to add a new user for OpenNebula, I get the following error:

 MySQL  localhost:33060+ ssl  SQL > CREATE USER oneadmin@'%' IDENTIFIED BY 'password';
Query OK, 0 rows affected (0.0973 sec)
 MySQL  localhost:33060+ ssl  SQL > GRANT ALL PRIVILEGES ON opennebula.* TO oneadmin@'%';
ERROR: 1044: Access denied for user 'icadmin'@'%' to database 'opennebula'
 MySQL  localhost:33060+ ssl  SQL > create database opennebula;
ERROR: 1044: Access denied for user 'icadmin'@'%' to database 'opennebula'

This is my first time using a cluster, so maybe I am missing something. As far as I understand, I should manage the cluster through the router, this way I am always able to easily connect to the primary member. Since icadmin is my non-root cluster admin, I would assume that I should use this user for management purposes?

linux – Unable to Install gvim/dependency in local directory without super user permission

Wanted to install gvim in the local drives as I don’t have the root permission but it does install the GUI version [i.e. GVIM] of it.

Steps Followed:

  1. First I tried doing the ./configure process with just the –prefix to local directory and said no GUI related things are compiled. Then understood that by default GUI is disabled.

  2. Next in the src/Makefile I enabled the GUI option to use the GTK2 version of the GUI and also updated the prefix to include local directory. Then downloaded some packages called “gtk-vim-syntax” which contained some .vim files related to gtk2, gtk3, gnome etc. added that path to $PATH. Then first tried running the below configure option

    ./configure --prefix=/home/installed --with-features=huge --enable-gui=gtk2
    
  3. But still when I saw the configure terminal outputs it said no–enable-gui found, so no GUI enabled.

  4. Then when checked online they said, you need to first install vim-common packages and either vim-gtk or vim-gnome and everyone provide the option of sudo apt-install etc etc. but since I am not the root user I am unable to install that way. Is there anyplace where I can find those package and install them locally before I try to ./configure in the vim folder ?

Or is there any other way I can install the gvim and all its dependent files in the local directory and not as root user ? Why can’t they add some notes/info on how to install the dependencies locally as well in the README.

Kindly let me know if anyone had overcome this issue. Thanks in advance !

terminal – Unable to install git using homebrew

I am trying to install git using homebrew:

brew install git

Terminal reads:

==> Searching for similarly named formulae… Error: No similarly named formulae found. Error: No available formula or cask with the
name “git”.
==> Searching for a previously deleted formula (in the last month)… Error: No previously deleted formula found.
==> Searching taps on GitHub… Error: No formulae found in taps.

If I input brew doctor, I get the following:

Warning: Suspicious https://github.com/Homebrew/homebrew-core git
origin remote found. The current git origin is:
https://github.com/Homebrew/brew With a non-standard origin, Homebrew
won’t update properly. You can solve this by setting the origin
remote: git -C
“/usr/local/Homebrew/Library/Taps/homebrew/homebrew-core” remote
set-url origin https://github.com/Homebrew/homebrew-core

However, if i do git -C "/usr/local/Homebrew/Library/Taps/homebrew/homebrew-core" remote set-url origin https://github.com/Homebrew/homebrew-core, nothing changes and I get the same output with brew doctor

command line tools is installed:

xcode-select --install

xcode-select: error: command line tools are already installed, use
“Software Update” to install updates

I have tried reinstalling brew, brew update and brew cleanup

Any help would be greatly appreciated.

magento2 – unable to update extension from composer

I am trying to update one of my payment gateway extension through composer and the command is

composer update razorpay/update

But I am getting the below errors

Problem 1
– guzzlehttp/guzzle 7.2.0 requires php ^7.2.5 || ^8.0 -> your PHP version (7.1.33) does not satisfy that requirement.
– guzzlehttp/guzzle 7.1.1 requires php ^7.2.5 -> your PHP version (7.1.33) does not satisfy that requirement.
– guzzlehttp/guzzle 7.1.0 requires php ^7.2.5 -> your PHP version (7.1.33) does not satisfy that requirement.
– guzzlehttp/guzzle 7.0.1 requires php ^7.2.5 -> your PHP version (7.1.33) does not satisfy that requirement.
– guzzlehttp/guzzle 7.0.0 requires php ^7.2.5 -> your PHP version (7.1.33) does not satisfy that requirement.
– Conclusion: don’t install facebook/php-business-sdk 9.0.3
– Conclusion: don’t install facebook/php-business-sdk 9.0.2
– Conclusion: don’t install facebook/php-business-sdk 9.0.1
– Conclusion: remove guzzlehttp/guzzle 6.4.1
– Installation request for facebook/php-business-sdk ^9.0 -> satisfiable by facebook/php-business-sdk(9.0.0, 9.0.1, 9.0.2, 9.0.3).
– Conclusion: don’t install guzzlehttp/guzzle 6.4.1
– facebook/php-business-sdk 9.0.0 requires guzzlehttp/guzzle ^6.5 || ^7.0 -> satisfiable by guzzlehttp/guzzle(6.5.0, 6.5.1, 6.5.2, 6.5.3, 6.5.4, 6.5.5, 7.0.0, 7.0.1, 7.1.0, 7.1.1, 7.2.0).
– Can only install one of: guzzlehttp/guzzle(6.5.0, 6.4.1).
– Can only install one of: guzzlehttp/guzzle(6.5.1, 6.4.1).
– Can only install one of: guzzlehttp/guzzle(6.5.2, 6.4.1).
– Can only install one of: guzzlehttp/guzzle(6.5.3, 6.4.1).
– Can only install one of: guzzlehttp/guzzle(6.5.4, 6.4.1).
– Can only install one of: guzzlehttp/guzzle(6.5.5, 6.4.1).
– Installation request for guzzlehttp/guzzle (locked at 6.4.1) -> satisfiable by guzzlehttp/guzzle(6.4.1)

Previously I am trying to install the Facebook Pixel extension due to some technical issues we didn’t install.
After that when I am trying to install or update the extension I am getting the above error.

For reference please find the attached image.
enter image description here

modeling – Microcontrollerembedcode unable to connect to Arduino Yun

Hi Mathematica enthusiasts,

I am trying to follow this tutorial off Wolfram reference for microcontrollers

Real Time Data Acquisition

I have an Arduino Yun Rev2 hooked up exactly as it is from the reference link . Everything seems to be connecting and resulting as it should be until I reach…

Problem area

Which would indicate that I am missing something. I have the circuit hooked up exactly like the reference but Mathematica says

“MicrocontrollerEmbedCode::nopen: Could not open /dev/tty.usbmodem1411.”

What does this mean and what can I try to remedy this?

Blockquote

I am attempting to use this to model Simple Harmonic Motion with a spring mass system for a university presentation in April. Any insights or help would be greatly appreciated!

applications – Mac desktop says “Unable to download App” but the App is downloaded on the iOS device?

My desktop is now running MacOS 11.1 (Big Sur). I also have several iOS machines.

On my iPhone I successfully downloaded the iOS Axos app. On my desktop, I am now seeing this error:

enter image description here

This is confusing, because I did not attempt to download the app on the desktop, there is no Axos app for the desktop, the App Store says nothing about Axos, and I see no error on my iOS device (which successfully downloaded the Axos app.)

Any thoughts on how to clear this?

Bitcoin Core 0.21.0 Loading PSBT from file gets error: “unable to decode psbt….”

The Bitcoin Core GitHub text says to ask my question here. I also asked on reddit but maybe this is a better place.

I created a PSBT file from my online Bitcoin Core wallet. I transferred it to my offline PC to sign on that Bitcoin Core wallet but when I try to load the PSBT file into the wallet through the “Load PSBT through file…” option I immediately get the following error:

“unable to decode psbt. global unsigned tx key is more than one byte type: iostream error”

Any help would be very greatly appreciated.

If you need to know the steps I completed to get to this stage, here it is:

  1. Got my scriptPubKey and pubkey for my bitcoin address that I own and have bitcoin on and want to test my PSBT with. I used command: getaddressinfo to get this on my offline Bitcoin Core

  2. Created a new wallet on my online Bitcoin Core with “Disable private keys & blank wallet” checked off

  3. Imported the scriptPubKey and pubkey from step 1] into my online Bitcoin Core wallet. It says successful. Command used was: importmulti ‘[{“scriptPubKey” : “XXXXXXXXXXXXXXX”,”pubkeys” : [“XXXXXXXXXXXXXXX”],”timestamp” : “now”,”label” : “PSBT-test”, “watchonly”: true}]’

  4. Inputed my transaction details on the Bitcoin Core online watch-only wallet and generated the PSBT file.