mysql - Read For Learn

Better ads plugin has 500.000 entries in wp_postmeta

Try it like this: 1. Create backup. 2. Export the table to a sql file, open it in a text editor, select and delete unnecessary records (ex. by regexp), then import it back.

WP-DownloadManager – Query most download per week/month etc

Simple answer: No. Complex answer: After looking at the plugin’s source code, the downloads table used to store the stats is not structured such that you could just edit this single query to give you that kind of information. It would take a much more extensive rewrite of the plugin to handle your request. Possible … Read more

Call to undefined function get_user_meta() – trying to access data in MySQL from custom fields

For one thing, you don’t have to include wp-config or wp-db when you use wp-load. And as t31os says, single-quotes around variables will keep them from being interpreted by PHP. <?php include_once(‘wp-load.php’); ?> <!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”> <html xmlns=”http://www.w3.org/1999/xhtml”> <head> <meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″ /> <title>Untitled Document</title> <style type=”text/css”> /* styles … Read more

WordPress Post # of # filtered by category slug

You should use one of query functions – get_posts(), it allows to very flexibly configure set of posts to retrieve.

Migration: Copying database content to a different server

phpmyadmin as a plugin: WordPress › Portable phpMyAdmin « WordPress Plugins

Paypal Post IPN handeling nightmare

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

Site not responding error – taking long to load [closed]

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