developer resources
Codebales holds an ever growing number of solutions to problems that we have experienced in our day to day code writing
Selected filter
43
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
•
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
•
In an environment that is running
Ubuntu 20.02
Nginx
Solr
The default...
Andrew Fletcher
•
These steps are for Drupal 8 and 9.
Export your database
Order here is...
Andrew Fletcher
•
In Vim, following is an outline of the vi(m) functions you can utilise whilst in command mode - yes they are case sensitive
action
outcome
a
change to insert mode (after cursor)
A
change to insert mode (at end of line)
dd
delete one line
G
go to end of the file
1G
go to top of the file
i
change to insert mode (before cursor)
J
merge next line with this one
p
paste deleted or yanked text after cursor
P
paste deleted or yanked text before cursor
r
replace one...
Andrew Fletcher
•
Adding an SSL wildcard certificate to an Ubuntu server involves several steps....
Andrew Fletcher
•
When logging into Ubuntu server you will see a response similar to
Welcome to...
Andrew Fletcher
•
Forcing https and www or non-www is a process that I was a custom to through...
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 user I tried using drush
drush sql-dump --tables-list=media_field_data > db-list.sqlOf course as a root user and Drush set-up not as root. failed with
Command 'drush' not found, did you mean:
command 'rush' from deb rush (1.8+dfsg-1.1)My bad.
Changing the user away from root and running the command again
drush sql-dump --tables-list=media_field_data > db-list.sqlProduced a permission error
bash:...
Andrew Fletcher
•
Finding the issue with a server 500 error
The Nginx error logs are showing too...
Andrew Fletcher
•
Focusing on the ckan.ini file (/etc/ckan/default/ckan.ini). When I run the...
Andrew Fletcher
•
Listen in on the ports being used on your server. To do so, run the...
Andrew Fletcher
•
Error with Nginx
When running an Nginx test, the following response was being...