Skip to main content
53
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
  Continuing on from the Drupal 9 to Drupal 10 upgrade outline written...
Andrew Fletcher
To run a SQL command using Drush, use the following sql-query command drush...
Andrew Fletcher
Drush open_basedir restriction error PHP Warning: include(): open_basedir...
Andrew Fletcher
These steps are for Drupal 8 and 9.   Export your database Order here is...
Andrew Fletcher
Update Ubuntu 20.04 To begin update the server using the command sudo apt update && sudo apt upgrade -yFor more details about this process see How To Update All Packages Linux.   PHP version Check the current PHP version using php -vThe response I had was PHP 7.4.3 (cli) (built: Nov 2 2022 09:53:44) ( NTS ) Copyright (c) The PHP Group Zend Engine v3.4.0, Copyright (c) Zend Technologies with Zend OPcache v7.4.3, Copyright (c), by Zend Technologies  Install...
Andrew Fletcher
  Install the CKAN package Begin by cleaning up your server environment....
Andrew Fletcher
If you're planning to create extensions, generating CKAN from source is the...
Andrew Fletcher
Resources - changing Drush Type Version Drush (current) 11.6.0 Drush...
Andrew Fletcher
CKAN extensions - adding to your installation   Following the information...
Andrew Fletcher
Goal: Restrict content access through username and password entry on an Nginx server. 1: Apache Utilities Package First, update your server’s package index: sudo apt updateCheck if the utilities package exists in your environment by executing the command dpkg --get-selections | grep apacheResponse: apache2-utils install libapache-pom-java installSo it exists.  But what do you do if it doesn't exist? How come I need to install apache-utils?  To restrict access you will be using...
Andrew Fletcher
How to set the Private file path in Drupal using the following steps: Create a...
Andrew Fletcher
Using Composer to Manage Projects and if required their dependencies In this...
Andrew Fletcher
Goal: I want to download a table list to a txt or csv file. Initially, as a root...
Andrew Fletcher
If your Composer project doesn't have Drush listed as a dependency, you can...