Skip to main content
66
results
Andrew Fletcher
Recently I came across this piece of gold when dealing with databases, particularly relational ones like MySQL, managing transactions efficiently is crucial to ensure data integrity and consistency. In MySQL, transactions are used to group several SQL commands into a single unit that either completely succeeds or completely fails, ensuring that a database remains in a consistent state. Managing transactions efficiently in databases like MySQL is crucial for ensuring data integrity and...
Andrew Fletcher
A growing list of commands I've used and what they do in no specific order sudo...
Andrew Fletcher
When Solr is displaying results on the site, first step is to log in the server...
Andrew Fletcher
To resolve the CVE-2022-48624 vulnerability on Ubuntu using Nginx, it's crucial...
Andrew Fletcher
In many terminal text editors, you use find command as reference in Terminal...
Andrew Fletcher
Having updated Solr, re-indexing wasn't working. The error in the logs was Drupal\search_api_solr\SearchApiSolrException while indexing item entity:node/2386:en: Solr endpoint http://127.0.0.1:8983/ bad request (code: 400, body: Exception writing document id 36lk64-related_projects-entity:node/2386:en to the index; possible analysis error: cannot change field "tm_X3b_en_body" from index options=DOCS_AND_FREQS_AND_POSITIONS to inconsistent index options=DOCS_AND_FREQS_AND_POSITIONS_AND_OFFSETS,...
Andrew Fletcher
On an Ubuntu 20.02 system with Nginx, you can utilize the following commands to...
Andrew Fletcher
Cleaning out or clearing data in Solr can be done in a few different ways,...
Andrew Fletcher
In an environment that is running Ubuntu 20.02 Nginx Solr   The default...
Andrew Fletcher
You can perform the following steps: Check Apache Modules Apache Struts 2 is...
Andrew Fletcher
These steps are for Drupal 8 and 9.   Export your database Order here is important.  First you want to clear all the Drupal caches.  Then export / dump the db the sql database to a file in your home directory. drush cr drush sql-dump > path/to/your/file/ourpout/sql-dump-file-name.sqlor drush sql-dump --extra-dump=--no-tablespaces --result-file=../sql/db-2022-12-07.sqlWithout having to manually set the date drush sql-dump --extra-dump=--no-tablespaces...
Andrew Fletcher
To use OpenAI to summarise text from a PDF using Python 3.11.6, you'll first...
Andrew Fletcher
Permission error Traceback (most recent call last): File...
Andrew Fletcher
To set an environment variable on Ubuntu, can be achieved via a few options....
Andrew Fletcher
Whilst installing Python 3.11.6 and running the command 'sudo make altinstall',...