Skip to main content
31
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
These steps are for Drupal 8 and 9.   Export your database Order here is...
Andrew Fletcher
Visual Studio Code (VS Code) allows you to manage extensions using the VS Code...
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
CKAN extensions - adding to your installation   Following the information on the CKAN site Use the CKAN create command to create an empty extension: Activate your CKAN virtual environment, for example: . /usr/lib/ckan/default/bin/activateThen check your location is cd /usr/lib/ckan/default/srcSo you can execute the create command ckan -c /etc/ckan/default/ckan.ini create -t ckanext ckanext-example_theme  Error – dev-requirements.txt However, when running this command the response...
Andrew Fletcher
Goal: Restrict content access through username and password entry on an Nginx...
Andrew Fletcher
Goal: I want to download a table list to a txt or csv file. Initially, as a root...
Andrew Fletcher
Reviewing CKAN extensions and listing the extensions that have been created /...
Andrew Fletcher
Location of the base templates cd...
Andrew Fletcher
Finding the issue with a server 500 error The Nginx error logs are showing too much detail.   Nginx logs and test There are no errors in the nginx log and sudo nginx -t looks fine sudo nginx -tResponse nginx: the configuration file /etc/nginx/nginx.conf syntax is ok nginx: configuration file /etc/nginx/nginx.conf test is successful  Are the services running? I'll start by doing a status check for  Nginx PostgreSQL jetty9 Supervisor Nginx sudo service nginx statusResponse ●...
Andrew Fletcher
Focusing on the ckan.ini file (/etc/ckan/default/ckan.ini).  When I run the...
Andrew Fletcher
Following the instructions on CKAN DataStore with a little...
Andrew Fletcher
Working through a CKAN installation on Ubuntu 20.04 User sees a server 500...
Andrew Fletcher
Before you can run CKAN for the first time, you need to run db init to...