Your error message means that $wpdb in your code is currently pointing to a null pointer. Either WP is not loaded, or you’re missing a simple global $wpdb; statement, or both. If you need to load WP, include wp-load.php. Or better, in your JS, use ajaxurl: url = ajaxurl + ‘?action=youraction’ alongside (assuming the above … Read more
This removes the posts and all associated post meta data: DELETE a,b,c FROM `wp_posts` a LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id) LEFT JOIN wp_postmeta c ON (a.ID = c.post_id) WHERE a.post_author=”0″; Replace the 0 with the ID number for the post_author you wish to remove.
Hi @Anjum: I think the function get_nav_menu_id_by_page_template()is what you are looking for? You can place the code for this function in your theme’s functions.php file, or in a .php for a plugin you are writing: function get_nav_menu_id_by_page_template($template) { static $nav_menu_id; if (!isset($nav_menu_id)) { global $wpdb; $sql = <<<SQL SELECT menu.post_id AS menu_id FROM {$wpdb->postmeta} AS … Read more
Short answer: yes The GUID field is meant to represent a globally unique identifier for the post. In WordPress we just happen to use the URL. The GUID field should never be thought of as an actual URL, though … just an identifier for the post. In reality, the GUID field could contain anything that’s … Read more
-First, try contacting the hosting provider if the database server is online / if they have any other problem at their end, or they made any changes to your account, or if there are any limitations/restrictions, etc . double check your wp-config.php file settings for the database name, database username and database password. This is … Read more
I don’t think so. You will need to do something like this (untested): add_action(“wp_login”, “my_login_function”); function my_login_function($username){ $userdata = get_user_by(‘login’, $username); $n = get_user_meta($userdata->ID, “my_login_counter”, true); if (! is_numeric($n)) $n = 0; $n = intval($n) + 1; update_user_meta($userdata->ID, “my_login_counter”, $n); }
Make sure to protect your file directories, don’t make them writable by you only! Red up: http://codex.wordpress.org/Hardening_WordPress And download: http://wordpress.org/extend/plugins/wp-security-scan/
Error establishing a database connection means a bad password, DB user, DB name or server location (usually localhost) in wp-config.php. Simple as that. Check and check again. Editing wp-config.php « WordPress Codex
For the record, I will never encourage developers to use custom database tables. Yes, they’re easy to use, but you lose 100% of the data abstraction provided by WordPress. add_option()/update_option()/get_option() are basic key-value functions. They store data in a MySQL LONGTEXT field. LONGTEXT can store over 4 million characters … so a 10000+ character option … Read more
I suspect either the culprit is one of the plugins or the theme you are using. so, try: -deactivating ALL plugins temporarily to narrow down the problem. If the problem goes away, activate them individually (one-by-one) to find the problematic plugin. If you don’t have access to your admin area, try deactivating plugins manually via … Read more