upgrade – Fox’s Projects

Mastodon linkdump for when it pours.

Just a linkdump from my latest attempt to upgrade mastodon which went not so well in the end and had to roll back the software. Geez.

Clean all the qrappe:

https://peterbabic.dev/blog/cleaning-mastodon-media-attachments/
https://www.reddit.com/r/Mastodon/comments/14lfgt4/manually_deleting_media_cache/
https://www.reddit.com/r/Mastodon/comments/za3ke5/moving_my_mastodon_instance_and_my_cache_is_10gb/
https://docs.joinmastodon.org/admin/tootctl/#media-remove
https://ricard.dev/improving-mastodons-disk-usage/
https://github.com/mastodon/mastodon/discussions/25147
https://docs.joinmastodon.org/admin/tootctl/
https://www.yinfor.com/2023/11/mastodon-self-hosting-clean-media-storage-with-tootctl-command.html

fix all the qrappey errors:

https://stackoverflow.com/questions/70849182/could-not-open-library-vips-42-could-not-open-library-libvips-42-dylib
https://sebhastian.com/referenceerror-fetch-is-not-defined-javascript/
https://stackoverflow.com/questions/48433783/referenceerror-fetch-is-not-defined
https://nodejs.org/en/download

more links to come? i have no idea – the attempt must be repeated.

How to install PIP

From my notes, and a bit as a funny as our cat is named Pip.

pip the cat — Pip, after a trip to the vet

apt-get update &&
apt-get -y upgrade &&
apt-get install python-pip &&
pip install --upgrade pip

[Fixed] Cannot load from mysql.proc. The table is probably corrupted

Something spoopy was going on in my database. All was working fine, but it kept spewing out the following error:

Cannot load from mysql.proc. The table is probably corrupted

So this was fixed by going into the database terminal and entering:

mysql_upgrade -u root -p

Make sure you have the root/privileged password ready. Depending on how many databases you have and how large they are; it can take a bit of time. Have patience.

Terrible Invoice Ninja upgrade hack

Before some proc_get_status() error occurs:

Go here:

INVOICENINJAFOLDER/vendor/symfony/process/Process.php

Find:

$this->processInformation = proc_get_status($this->process);

Do: Comment it out
Do: Start upgrade

Done.

In-place upgrade of a Themelr template (Joomla)

How to Fix the error after updating to Joomla 3.9

If you updated to the latest version and the following error appears when you try to launch Themler please follow the instruction below:

Fatal error: require_once(): Failed opening required '[...]/administrator/includes/toolbar.php' (include_path='.:/usr/lib/php7.2') in [...]/templates/[theme_name]/app/index.php on line 25

Open theme folder on the server: www/Joomla_directory/templates;
open /app folder;
open index.php for editing in any html or text editor;
find the line
require_once JPATH_BASE . DS . 'includes' . DS . 'toolbar.php';
and replace it with the following line:
$prefix = version_compare(JVERSION, '3.9', '>=') ? 'sub' : ''; require_once JPATH_BASE . DS . 'includes' . DS . $prefix . 'toolbar.php';;
open /app/start folder;
open data.php file for editing and follow step 4;
open manifest.php file for editing and follow step 4;
start Themler.

Upgrade to PHP7.2

apt-get install apt-transport-https lsb-release ca-certificates

wget -O /etc/apt/trusted.gpg.d/php.gpg https://packages.sury.org/php/apt.gpg

sh -c 'echo "deb https://packages.sury.org/php/ $(lsb_release -sc) main" > /etc/apt/sources.list.d/php.list'

```
apt-get update
```

apt-get install php7.2-common libapache2-mod-php7.2 php7.2-cgi php7.2-cli php7.2-phpdbg php7.2-fpm libphp7.2-embed php7.2-dev php7.2-curl php7.2-gd php7.2-imap php7.2-interbase php7.2-intl php7.2-ldap php7.2-readline php7.2-odbc php7.2-pgsql php7.2-pspell php7.2-recode php7.2-tidy php7.2-xmlrpc php7.2 php7.2-json php-all-dev php7.2-sybase php7.2-sqlite3 php7.2-mysql php7.2-opcache php7.2-bz2 libapache2-mod-php7.2 php7.2-mbstring php7.2-pdo php7.2-dom php7.2-enchant php7.2-gmp php7.2-soap php7.2-zip

In case you need mcrypt:

apt-get -y install gcc make autoconf libc-dev pkg-config

```
apt-get -y install libmcrypt-dev
```
```
apt-get install php7.2-dev
```
```
pecl install mcrypt-1.0.1
```
When you see the prompt “libmcrypt prefix? [autodetect] :” -> Press [Enter] to autodetect
```
php -i | grep "mcrypt"
```

```
a2dismod php7.0
```
*or whatever version you are upgrading from)
```
a2enmod php7.2
```