Recognition

Posts

6 Posts
  • Published Question

    Managed MySQL database error: Unknown column in 'where clause'

    Hello, I am using OpenLiteSpeed WordPress 1-Click from the marketplace and a Managed MySQL 8 Database. There's a specific and well known plugin I need to run the website: Easy Digital Downloads. On a fresh install, wi...
    0 By PSNick DigitalOcean Managed MySQL Database OpenLiteSpeed WordPress 1-Click WordPress
  • Published Question

    Managed MySQL: Failed to create table

    Hello, I'm using Managed MySQL and the OpenLiteSpeed WordPress 1-Click image. Enabling some css or js options in the bundled LSCache plugin shows the following error: Failed to create table cssjs! SQL: CREATE TABLE I...
    Accepted Answer: Hi, What if you directly run CREATE TABLE IF NOT EXISTS `wp_litespeed_cssjs` (`id` bigint(20) NOT NULL AUTO_INCREMENT, `hash_name` varchar(60) NOT NULL COMMENT "hash.filetype", `src` text NOT NULL COMMENT "full url ...
    2 By PSNick DigitalOcean Managed MySQL Database OpenLiteSpeed WordPress 1-Click Databases
  • Published Answer

    OpenLiteSpeed WordPress + Managed Redis. Connection Test: Failed

    It looks like redis-cli doesn’t support SSL, so you need to take a few extra steps: sudo apt update sudo apt install redis...
    Accepted Answer: It looks like redis-cli doesn’t support SSL, so you need to take a few extra steps: sudo apt update sudo apt install redis...
    By PSNick
  • Published Question

    OpenLiteSpeed WordPress + Managed Redis. Connection Test: Failed

    Hello, I have created a droplet using the OpenLiteSpeed WordPress 1-Click image. I have also created a Managed Redis DB to use for object cache, however I am unable to connect the bundled LSCache WordPress plugin to t...
    Accepted Answer: It looks like redis-cli doesn't support SSL, so you need to take a few extra steps: ``` sudo apt update sudo apt install redis-tools stunnel4 sudo nano /etc/default/stunnel4 Add the following line: ENABLED=1 sudo nano...
    2 By PSNick OpenLiteSpeed WordPress 1-Click DigitalOcean Managed Redis
  • Published Question

    Recovery for Managed MySQL + Redis

    Hello, I'll soon start an e-commerce website for digital files based on WordPress and EDD and thought the ideal setup would be: OpenLiteSpeed Wordpress (from the marketplace) Managed MySQL Managed Redis Spaces for the...
    Accepted Answer: Hi there @PSNick, This sounds like a solid setup, I like it! It also gives you the chance to, later on, scale up your webserver to multiple web servers and add a load balancer. Regarding, the MySQL restore, I would re...
    1 By PSNick OpenLiteSpeed WordPress 1-Click DigitalOcean Managed MySQL Database DigitalOcean Managed Redis
  • Published Question

    "Cannot open display" error on a GIMP batch script.

    Hello, For an application I need to run simple batch scripts using GIMP. Once the command is executed, the error I get is: Cannot open display: It seems that even using the --no-interface flag it requires a display...
    1 By PSNick Ubuntu