All my backslashes are gone in WordPress. Yikes.

Discovered that my most recent conversion from SQLite to MySQL seems to have screwed up my backslashes in all my posts that have backslashes. This is bad because my code snippets should not be copy & pasted and run at face value unless you verify the code!  It could seriously break shit. Ugh.  This is going to be a PITA to go and fix 500 posts.   It might be quicker to try to fix the SQLite DB file and try another conversion.  This isn't the first time I've noticed this problem.  Continue reading →

#sqlite, #wordpress

WordPress SQLite to MySQL Migration Complete

Just finished migrating my website from SQLite to MySQL. What a rush. (lol) It was actually not as bad as I thought. A lot of sed, grep and other sorcery involved; especially in transforming of SQLite statements to MySQL. Some quick commands I used: sqlite techish.db .dump > production_2018-08-23.dump.sql I found that it used quotes for tables and column names, so I had to remove those first and foremost. sed -i '/INSERT INTO/,/VALUES (/s/"//g' production_2018-08-23.dump.sql Next Continue reading →

#sqlite, #wordpress

WordPress Unauthorized Password Reset Vulnerability (CVE-2017-8259)

A vulnerability reported to WordPress in July 2016 was publicly released recently and identified as CVE-2017-8259.  The vulnerability could allow an attacker to gain unauthorized access to a victim's WordPress account. Continue reading →

#apache, #wordpress

From Linux Install to WordPress

A typical installation of Debian 8.x (Jessie) precedes this where I only select base system and ssh server options during operating system installation. After installation, this is a typical configuration to get me up and running. These are my notes. Continue reading →

#nginx, #wordpress

WordPress 4.7.2 is Available for Update

This article was posted more than 1 year ago. Please keep in mind that the information on this page may be outdated, insecure, or just plain wrong today.

Security vulnerabilities are addressed in WordPress 4.7.2. An XSS and SQL injection vulnerability (wp_query()) were discovered and have been patched.
Update your sites.

#wordpress