WordPress - can´t login with the admin account after restoring MySQL DB

I've got a Wordpress blog hosted on Linode under Cherokee web server, but the performance has been problematic the last weeks and I'd like to give a chance to Nginx. So I've made a DB backup of...

MySQL Error: #1062 - Duplicate entry 'rewrite_rules' for key 2

I am trying to restore a WordPress MySQL DB from a recent backup since my site (wp-admin) became unusable after I changed the site_url incorrectly. I am trying to reinstall the entire site again...

Wordpress redirection problem after moving to a new server?

I've created a site using wordpress and i moved that from localhost to new server. The steps i've followed is just got backup of old db from localhost and uploaded them to the new server. Changed...

WordPress on EC2 Requires FTP Credentials to Install Plugins

I just installed WordPress 3.5.2 on an Amazon Linux AMI EC2 micro instance. When I tried to install the wp-db-backup plugin (Plugins -> Add New), I was prompted for a Hostname, FTP Username, FTP...

Error in WordPress import

I am changing my website hosting, so I made a backup for everything, themes, DB and used the Export utility in WP to export all posts, pages, etc. Now I am trying to import posts, pages, users in...

Auto delete published posts after a specific number of days in wordpress

I am planning to start a newspaper based website (daily edition newspaper). I am building the site on WP. Now, with demand of my clients, news items (WP posts in this case) need to be entirely...

Ajax in wordpress plugin working on apache but not nginx

I hate to ask this question here but I’ve exhausted all other resources. And I’ve searched everywhere but can’t find any help. I’m migrating my WordPress site from an Apache server to the...

Wordpress Transfer Broke CSS - Images + Links Work

I am having a rather weird problem transferring this website to its new server ( same domain name , new host ). The website is not loading the layout / css properly to display the page....

Enabling PHP's gzopen function on an AWS server

On a WordPress site I manage, I am attempting to run a full backup using a plugin called Updraft Plus. The backup will not proceed passed a table called wp_nm_mc_forms. The penultimate line of the...

Force multiple websites with NGinx, Varnish and dedicated IP's from non-www to www

I'm dealing with this for days and need help fellows! I hope somebody here han solve this: 3 Wordpress websites (3 dedicated IP's) I've used this Ansible playbook to deploy:...

Json_decode return NULL with a valid JSON after receiving the data with curl

Hi there i'm triyng to decode my recived JSON with json_decode() but return me a NULL everytime. foreach ($_data->response as $item){ $test[$item->plugin] =...

Updating Wordpress Password after migration causes login error

This is weird, probably a lack of knowledge about hashing but there is an issue I've seen in a couple of wordpress projects: After migrating a wordpress site from localhost to a commercial hosting...

How to handle upload folder in git & wordpress devlopment workflow

I am currently learning use git & wordpress development workflow: develop the wp site locally in mamp enviroment; push the local wp repo to the remote repo in my serve; use git hook to...

Restore WordPress site without DB backup?

I'm trying to restore a WordPress website for which I have the files backup, but I don't have a DB backup on hand. I managed to get the site up partially by restoring the backup in cPanel - all...

mysql error mysqli_real_connect()

I have a Wordpress site that started receiving an error when I hit the homepage. The error is: Warning: mysqli_real_connect(): (HY000/2002): Only one usage of each socket address...

How to ignore wildcard folder structures with gitignore

Example folder structure where / is wp-content/ / /plugins /plugins/akismet /plugins/gravityforms /plugins/woocommerce /plugins/woocommerce-call-for-price /plugins/woocommerce-dropdown-cart etc...

backup wordpress database using wp-cli

This is a basic question.. I am trying to write a very simple script to backup my wordpress database every hour.. #!/bin/sh # # This script do an hourly backup of WordPress DB # Set global...

In a Docker Compose multi-container application, how to prevent Postgres from running statements previously issued

I'm running a Scrapy project with an Item Pipeline which writes data to a PostgreSQL database. It is a Docker Compose multi-container application with the following docker-compose.yml: version:...

Ubuntu Server is randomly going down

I am having some trouble with my Digital Ocean's server which has a blog running on Wordpress. Randomly the server goes on 100% memory/processing and over 200MB/s Disk IO until the blog...

Gitignore: am I supposed to commit changes?

The question may seem absurd but I have a doubt. I'm not a git expert but I've use it every day for 5 years via the command-line so I'm pretty used to it. Here is the scenario I can't solve: A...

Jenkins: hudson.plugins.git.GitException: Command "git fetch --tags --progress origin returned status code 143:

I haven't been able to build a job in Jenkins because I get the "status code 143:" error in the Build log. According to this jenkins bug page, the error has to do with the repo taking longer than...

Using Wordpress with Git - which files should I ignore?

For the past 6 or so months I have been working on Laravel projects that are closer to web apps rather than full, content managed sites. Recently I've started a Wordpress project and there's...

java.sql.SQLSyntaxErrorException: user lacks privilege or object not found in ubuntu

I have found many similar questions on internet and tried many solutions but still can't get around this error even after 10 hours. So please give ANY suggestion before marking it as a duplicate....

How to make my project deploy automatically from dev to staging and manually to production in Jenkins using only a master git branch

I have around 30 Wordpress websites so the way Jenkins is configured is I have a Job for every website. The process of development is as follows (I don't know if it's optimal but this is how we...

How to determine where are the differences in the settings for two sites on same server?

I got VPS with NGINX 1.15.2 PHP-FPM 7.3.5 Maria DB 10.0.36 WordPress 5.2 There are two sites with same content and settings (second one is backup with no access from internet). Differences are...

How to have wp-cli commands work in a bash script from cron

I have a bash script with various WP-CLI commands to run a backup, check & optimize db tables, run a security vulnerability check, check available core, plugin, and theme updates, and then email...

Docker Compose: connect a WordPress container to a MySQL container?

I have an already running MySQL container that I use for several other containers. Now I'm trying to connect a wordpress container to it but I'm getting: Error establishing a database...

Wordpress + php + mysql High cpu usage

I'm load testing a production server using wordpress, php 7.2 and mysql Ver 15.1 Distrib 10.1.44-MariaDB, with 4 Core i7 CPUs and 10GB Ram running on ubuntu 18.04 LTS. The problem is even with a...

Can't select database Wordpress

I created AWS Lightsail instance for Wordpress 5.5. My backup of Wordpress had an older version (5.x) and I decided to delete all files inside /home/bitnami/apps/wordpress/htdocs to upload all...

WordPress & Docker dev/staging/live best workflow?

currently, I am working a lot with WordPress and for every project, my company wants different environments. So first of all we have our development environment which is running on our own server....