On Duplicate Key Update same as insert
I’ve searched around but didn’t find if it’s possible. I’ve this MySQL query: INSERT INTO table (id,a,b,c,d,e,f,g) VALUES (1,2,3,4,5,6,7,8) Field id has a … Read more
MySQL
Delete post revisions on post publish
Is it possible to delete post/page revisions from the database when a post/page is published? 11/05/12 Answer: See the plugin below by bueltge … Read more
Migrating database / content of non-CMS site to WordPress
I have a non-CMS website which is fully build with PHP with a lot of content in it. I don’t want to add … Read more
How to fix “Incorrect string value” errors?
After noticing an application tended to discard random emails due to incorrect string value errors, I went though and switched many text columns … Read more
mysqli_real_connect() – authentication method unknown to the client Warnings
I keep getting the following warnings in my debug log: PHP Warning: mysqli_real_connect(): The server requested authentication method unknown to the client [mysql_old_password] … Read more
MySQL date format DD/MM/YYYY select query?
I’m a bit confused on how to order by date formats. For the format YYYY-MM-DD you would do this: …ORDER BY date DESC… … Read more
Is the outdated PHP mysql extension a requirement for WordPress 4.6?
I’m a bit puzzled when I after some time did another WordPress install. I’m using a standard Apache + PHP 7 combination (even … Read more
register_activation_hook isn’t adding table to DB
I’ve started my first plugin and I need to store values returned from an API call to a database. But before I do … Read more
Throw an error preventing a table update in a MySQL trigger
If I have a trigger before the update on a table, how can I throw an error that prevents the update on that … Read more
Using Echo in ShortCode – Stuck
After about 3 days of searching and tinkering, I’m stuck. I’m not a coder, but I like to try. I have a short … Read more