If you are unable to retrieve the posts through the Database so you can check the tables, try doing a Google Search for the posts. Type the page URL into the Google Search and look for a cached version. This is definitely not the optimal way to recover the posts, but will work in a … Read more
phpmyadmin as a plugin: WordPress › Portable phpMyAdmin « WordPress Plugins
I ended up using kind of a hack. I made a hidden field that was populated with the user ID. I then used this to update metas and what not on a successful IPN and or successful payment. Ie: add_filter(“gform_paypal_post_ipn”, “update_order_status”, 10, 4); function update_order_status($ipn_post, $entry, $config, $cancel){ // if the IPN was canceled, don’t … Read more
You shouldn’t be blindly changing configs in my.cnf. Use rackerhacker/MySQLTuner-perl · GitHub to test and check your my.cnf configs. It will give suggestions for memory allocations and all other aspects of MySQL tuning. You also should configure httpd.conf for high loads. See Apache Performance Tuning – Apache HTTP Server
there are 2 very popular form plugins Gravity Forms – extremely customisable and saves all data to your database (Commercial) Contact Form 7 – also saves everything to your database and easy to use (Free) Both send the data to the Admin panel so you can review inside WordPress. I know that Gravity Forms has … Read more
After a lot of searching and asking people who are far more clued up than myself, I have concluded that this is impossible mainly because it requires two concurrent DB connections. In the end, my SSO solution was to build a more traditional SSO system that creates users in the remote site using the user … Read more
I found out what is wrong. The tutorial says to remove all double quotes ” and replace them with spaces or backticks `, but some values in the mentioned tables have double quotes around them. This one for example: INSERT INTO “wp_usermeta” VALUES(14,1,’wp_capabilities’,’a:1:{s:13:”administrator”;s:1:”1″;}’); So replacing that with backticks causes malfunction. Replace only double quotes around … Read more
if ( !$value ) evaluates to TRUE when the value is 0. Alternative: if ( ! isset ( $_POST[‘_ordre’] ) ) return delete_post_meta( $post_id, ‘_ordre’ ); update_post_meta( $post_id, ‘_ordre’, $_POST[‘_ordre’] ); You don’t need add_post_meta(), the call to update_post_meta() will do that automatically.
DISCLAIMER : Not a WordPress Developer, Just a MySQL DBA For a given table, say link_url mysql> show create table wp_links\G *************************** 1. row *************************** Table: wp_links Create Table: CREATE TABLE `wp_links` ( `link_id` bigint(20) unsigned NOT NULL auto_increment, `link_url` varchar(255) NOT NULL default ”, `link_name` varchar(255) NOT NULL default ”, `link_image` varchar(255) NOT NULL … Read more
WordPress plugin overloading with tmp tables