Your approach is impractical in any site with decent traffic. In that case having real time updates from a DB is the best way to bring your site down. What you need is to check the availability when people at items to carts and then again before the actual checkout. In addition you can update … Read more
I have faced similar issue while working for a client. The issue may cause due to following reasons. Check server configuration and server cache. ( This happens if you are using specialized wordpress hosting; the server admin configured some cache mechanism to increase performance) In this case you have to wait till the sever refresh … Read more
What you likely need is the function wp_insert_post(). In your backend (not the WordPress backend, just so we’re clear), you’ll need to do a minimal load of WordPress to allow wp_insert_post() to work. You can do this by define( ‘SHORTINT’, true ). Some additional reading on doing a minimal load of WordPress: Load minimum WordPress … Read more
As Chealion mentioned, there are several ways that your mysql could have been installed. Each of which will place your data dir and/or logs in different locations. The following command will give you (and us) a good indication of where to look. ps auxww|grep [m]ysqld # Putting brackets around the first char is a `grep`+`ps` … Read more
Yes, it is safe but always prefer a database backup before. You can also try the Minimise WordPress DB queries to clean more.
Brandoo isn’t (sadly) hosted by Azure at the moment. This plugin is written to be used by version 3.6. Newer versions make use of queries which will not work on SQL Server. That’s why you get those errors. So, you need to keep your version of wordpress at all costs till a newer version of … Read more
Yes, the 404 is because the local and remote server URLs are different. As a solution: You should set the local domain to be the same as the remote server In wp-config.php connect to the remote DB When you will need to access the remote server you’ll need to update the file hosts and comment … Read more
I did mysql> SHOW GLOBAL VARIABLES LIKE ‘PORT’; And that indicated that I was using port 3306 and that my search for the error continues.
You don’t need to write a custom SQL for this. You can always leverage WP’s get_post_custom() that returns array of all custom fields for a particular page or post. https://codex.wordpress.org/Function_Reference/get_post_custom
Moving your sites My recommendation would be to use the the duplicator plugin. Far and away the easiest method I’ve used to back-up, move, and restore sites from local to production or from one host to another. If the old site is WordPress – sounds like it is, you may want to consider creating a … Read more