Is it safe to convert tables from MyISAM to InnoDB?
Is it safe to convert tables from MyISAM to InnoDB?
database
Make WordPress Search for Both Main Domain and Subdomain
Make WordPress Search for Both Main Domain and Subdomain
Database error Deadlock found when trying to get lock; try restarting
Database error Deadlock found when trying to get lock; try restarting
WordPress site uses MyISAM, should I switch to InnoDB necessary?
You should have switched to InnoDB at some point in the past decade, but now is as good a time as you are going to find. 🙂 mysqldump will work the same way. MyISAM could not be backed up while the database is running either. Databases generally cannot be backed up by running using a … Read more
Importing New Posts from Live Site into Local Dev Site
Have you considered to use REST API to bridge the two environments? Basically you need to hit the posts endpoint https://example.com/wp-json/wp/v2/posts using the after argument that permit to limit response to posts published after a given ISO8601 compliant date. With the response you can insert new posts and sync the two installation. More detail about … Read more
Storing Email Account Passwords for SMTP Mailing for a WordPress Plugin
Storing Email Account Passwords for SMTP Mailing for a WordPress Plugin
Saving data from block editor to the database
I’ve found a solution using Ajax with native Javascript as follows: // Filename send2server.js const sendToServer = function() { /* Prepare the object to be sent: ********************************************************************/ var params = new FormData(); params.append(‘action’, ‘update_sql’); // update_sql is implemented in PHP (see below) params.append(‘quoteAtt’, props.attributes.quoteAtt); // The actual data /* Create the Ajax connection object: ****************************************************************/ … Read more
Version upgrade: can my plugin filter the SQL statements issued during a database upgrade?
Version upgrade: can my plugin filter the SQL statements issued during a database upgrade?
Recent comments from my blogs only
There’s a different posts and comments table per site, so not really. That said, you can and should keep track of blog ids they’ve commented on in a user meta to speed things up in the first round, and cache the formatted result in a separate usermeta to speed things up in subsequent rounds. These … Read more
Instead of submiting an entire post, is there any way to submit a lite-post or a simple message?
The code you posted is about the same one WordPress uses to insert posts in to the database so it’s not really saving anything. But i would suggest you use Custom Post type and only allow a few or as much as needed objects to it : ‘title’ ‘author’ ‘excerpt’ ‘custom-fields’ ‘comments’ (assuming you want … Read more