How to Fix the 500 Internal Server Error in WordPress

In WordPress, the Internal Server Error or Error 500 is one of the most annoying errors because it does not return actual data about the underlying issue. It’s hard for beginners to eliminate it. There are many different reasons for Internal Server Errors. Download WP STAGING to avoid this and other errors in the future. … Continue reading “How to Fix the 500 Internal Server Error in WordPress”

Update procedures for Ubuntu Server, Nginx and MySql

These update procedures contain only essential information and best practices for updating a running ubuntu server and keeping the downtime low. Ubuntu 16.04.6 to Ubuntu 18.04 Backup – If you use a cloud hoster like digitalocean, create a snapshot. It’s recommended to power off the VM before creating the snapshot for keeping file integrity. If … Continue reading “Update procedures for Ubuntu Server, Nginx and MySql”

WPML error due to missing index: Table wp_options is filled up with multiple entries of wpml_translation_services

One of our users was running WP Staging Pro alongside WPML (inc. translation management) on a couple of websites. On one, in particular, pushing the staging to live site using WP Staging Pro immediately causes the wp_options table to fill up with entries with the wp_name of ‘wpml_translation_services‘. As soon as these were deleted, no … Continue reading “WPML error due to missing index: Table wp_options is filled up with multiple entries of wpml_translation_services”

Linux Commands Reference & Troubleshooting

We’ve published these commands for our developers for reference purposes. They are publicly visible as it might be helpful for other users as well: Ubuntu 18.04 – Login reloads the login prompt If you try to login to KDE and the login form reloads after entering correct credentials try the commands below: systemctl stop gdm.service … Continue reading “Linux Commands Reference & Troubleshooting”

Change Language Collation of all mySQL Database Tables

If the language collation of your production and staging site database server is different you can use the MySQL query below to create a new query that allows you to change the language collation of all database tables at once. SELECT CONCAT(“ALTER TABLE “, TABLE_SCHEMA, ‘.’, TABLE_NAME,” COLLATE latin1_general_ci;”) AS ExecuteTheString FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=”DATABASE_NAME” AND … Continue reading “Change Language Collation of all mySQL Database Tables”

MySQL Query: How to Delete all WooCommerce Orders

Use this MySQL query to delete all woocommerce orders at once from the MySQL command line. This can be useful if you want to delete all orders on your staging site and then import all orders again from the live site to make the staging site up to date before pushing it to the live … Continue reading “MySQL Query: How to Delete all WooCommerce Orders”

Revolution Slider X Theme Record not found

Did you install the X Theme by theme.co and got the message “Record not found” after installing the demo content or activating the slider revolution plugin? A bug causes this in the X Theme WordPress theme, which you can resolve very quickly. The reason for that issue is that X Theme expects at least one previously … Continue reading “Revolution Slider X Theme Record not found”

Where Are WooCommerce Products Stored In The WordPress Database?

Sometimes you add new WooCommerce products on your staging site and just want to add those new products to the live site without affecting other data like orders and transactions. Therefore you need to make sure to copy only the relevant tables which contain the WooCommerce products data. Products are located mainly in 2 tables: … Continue reading “Where Are WooCommerce Products Stored In The WordPress Database?”