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 “unique index”, so there can’t be two of them. Now if the same id is already present in the database, I’d like to update it. But do I really have to specify … Read more
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 I want to do this on a site with 5,000 posts and 125,000 comments; it’s on a VPS and can handle the wp_posts table size – before I deleted all revisions, the … Read more
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 my posts manually in WordPress, because that’s a pain in the ass (I am talking about 5000 posts)… So my question would be: how do I do this? Is it even possible … Read more
After noticing an application tended to discard random emails due to incorrect string value errors, I went though and switched many text columns to use the utf8 column charset and the default column collate (utf8_general_ci) so that it would accept them. This fixed most of the errors, and made the application stop getting sql errors … Read more
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] in /wp-includes/wp-db.php on line 1379 PHP Warning: mysqli_real_connect(): (HY000/2054): The server requested authentication method unknown to the client in /wp-includes/wp-db.php on line 1379 PHP Deprecated: mysql_connect(): The mysql extension is deprecated and … Read more
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… How would you order by DD/MM/YYYY? This isn’t working: SELECT * FROM $table ORDER BY DATE_FORMAT(Date, ‘%Y%m%d’) DESC LIMIT 14 8 Answers 8
I’m a bit puzzled when I after some time did another WordPress install. I’m using a standard Apache + PHP 7 combination (even under version control) and after checking out 4.6.1 of WordPress (the tagged version from the Github SVN mirror, the official Git-ified version) the installer greets me in the second step with the … Read more
I’ve started my first plugin and I need to store values returned from an API call to a database. But before I do that, I need to be able to make a database table. I have the following code in a file that is required of the main plugin file: register_activation_hook(__FILE__, ‘PLUGIN_activation’); function PLUGIN_activation() { … Read more
If I have a trigger before the update on a table, how can I throw an error that prevents the update on that table? 7 Answers 7
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 code that gets a horoscope from a table in my WordPress database (I created the table). However, I have since discovered that short codes don’t allow “echo” or “print” to show the … Read more