WordPress stores user generated content, along with other configurable information, in a a database (typically MySQL).
0
votes
1answer
110 views
pull data from a remote wordpress database
I am trying to pull some data from a remote wordpress database. Here is the code I have:
$server = "my server code";
$user = "my username";
$password = "my password";
$db = "mydb";
$con = ...
1
vote
1answer
85 views
How to use custom taxonomies to reference complex relationships?
I'm working on a site that will in part house information on products that many people have worked on in different roles. I'd like for people, the projects they've worked on, and their roles in the ...
0
votes
1answer
35 views
Plugin: database creation
Can someone tell me what's wrong with this function?
function xattachments_db_install() {
global $wpdb;
$xattachments_db_version = "1.0";
$table_name = $wpdb->prefix ."xattachments";
...
14
votes
6answers
10k views
Using wpdb to connect to a separate database
I want to connect wpdb to another database. How do I create the instance and pass it the database name/username/password?
Thanks
0
votes
2answers
105 views
Subscribe to author?
Basically, I want to follow the author by other WordPress users. Whenever an author posts new post subscribed users need to get notification by email.
If it's not already there, I can create a plugin ...
1
vote
1answer
121 views
Merging Wordpress posts from different databases
I have development and production versions of my website (on the same hosting). I want to easily synchronize the content between these versions. On the production website, content is updated daily.
...
1
vote
2answers
176 views
How to delete custom field “suggestions” from dropdown list
When you use a standard custom field in WP you have to write the name of the cusotm fields the first time.
The second time you use a custom field it sticks to the custom fields dropdown list. But, ...
-1
votes
2answers
232 views
PHP Call to External Database
I am using the Sleek child theme from Studio Press and want to do a PHP call to this external database for it to display just like this link: http://www.escort332.org/tuskegeecadets.php . The Theme ...
2
votes
0answers
223 views
comment_post_ID 0 (cannot remove from dashboard)
Ran across something a bit odd that I haven't seen before. A client has a pretty active blog and uses Akismet (paid) to protect against spam. At least once a day, they're reporting a spam comment that ...
2
votes
1answer
141 views
Add Wordpress MU Network Admin via Database
I am working on getting a copy of a WordPress MU network up and running on my local machine for development purposes (using WordPress 3.2.1 at the moment). I need access to the network administration ...
1
vote
2answers
67 views
Remove the deleted users avatar from list
Problem
Hi everyone, I have a bit of a problem. I have a function that outputs the avatars of users that follow me . It works great, but if the user is deleted the avatars remain visible as a blank ...
0
votes
1answer
184 views
Save number of Facebook likes to database
I have a custom post type called Neighborhoods, which stores information about various neighborhoods of a city. Each neighborhood also has a Facebook page. What I'd like to do is for each ...
0
votes
1answer
83 views
Export / import Wordpress database
Is there a proper way of exporting and importing a big WordPress MySQL database to a new database?
When I tried to do that in the standard way I run into 2 issues:
All widgets disappeared and I had ...
1
vote
0answers
30 views
Backup another database with BackUpWordPress plugin
Is there any possibilities to add another database which is connected to other wordpress plugin?
My site is using two database: main wordpress db and additional db for plugin data. The Backup includes ...
0
votes
0answers
47 views
What is a good database backup? [closed]
I am transfering my site to another site (different server and domain) and would like to export my previous database. I am following these steps. When exporting my database the first time. I had a ...
0
votes
2answers
94 views
How and where is wordpress adding mySQL content to database?
I am currently following this steps to change server and domain for my website. I have been exporting and importing mySQL from one data base to the other. I am about to delete the mySQL content of the ...
0
votes
2answers
90 views
Wordpress page title repeated in SOME pages
I have created a Wordpress site and titles were working just fine. Then, some time and plugins installed later, I noticed that in SOME pages I get the title repeated 2 times.
Example of wrong page ...
1
vote
1answer
51 views
Why does WordPress rely on an fully qualified site_url with a 15-step plan for moving a site?
From the Moving WordPress codex page (emphasis mine):
When your domain name or URLs change there are additional concerns. The files
and database can be moved, however references to the old ...
3
votes
3answers
1k views
Moving Wordpress to new server: no posts found
I have a weird problem with moving a Wordpress installation to a new server (just the server changes, domain remains the same, I'm currently accessing the site on the new server via the same domain ...
0
votes
1answer
54 views
Does WordPress cache get_user_meta() results?
If I call get_user_meta() to retrieve a value, does WordPress cache the value? If I call get_user_meta() to retrieve the same value, does WordPress have to query the database again or is it stored in ...
4
votes
2answers
1k views
Get posts by menu ID
I'm a little stuck here. I have a menu in Wordpress with some posts in it.
What I would like is to retrieve all the posts as objects.
I think I'm pretty close, but the SQL query doesn't seem to work ...
0
votes
4answers
675 views
Can two domains use the same database?
I want to change a current site that already has a fairly robust database. Before I do, I want to test a few different layouts to make a decision. Instead of using the original site, I am thinking ...
2
votes
3answers
204 views
Best way to import users, post and categories from an external database
I need to migrate an existing website to WordPress. This website already has a basic database containing users and posts (with a category), but it also has a high number of records so it's not ...
2
votes
1answer
394 views
WP 3.4 has missing photo data
I just updated to WP3.4 and discovered that previously available images are no longer "found" by the system. By this I mean that all the image files remain online and accessible, but WP has lost ...
0
votes
1answer
69 views
why there are so many posts whoes post_type is revision? will these records waste too much database space?
from the following data we may know there are only 30 records which are meaningful, and there are 92 records of revision post_type which can not be shown on the blog.
so will these records waste too ...
1
vote
3answers
831 views
Login in Wordpress using external database data
I have a WP site and also have a external DB (means not WP DB) with users. The insertion process at that table uses the same algorithm as WP uses. What I'm need to do here is login in WP but using ...
4
votes
2answers
362 views
Count & Display Database Queries
I'm looking for an solution how I can count and display all queries in a WordPress site.
Does anybody know, if there is an good plugin?
Otherwise it would be an solution to check the queries on the ...
1
vote
1answer
65 views
Are there any scripts, classes, and/or functions built-in to WP for a plugin to export/import its saved data from wp_options?
In WordPress, are there any supported 'script plugins', Classes, and/or a WordPress function that will allow a plugin to use to export/import its own data from the database to a txt/json file? A way ...
0
votes
1answer
322 views
Front-end update_post_meta with ajax
as written in title I'm trying to update a post_meta using Ajax.
Actually I'm a complete newbie to Ajax and how it works so, if it is possible, I would appreciate if someone could 'take me by hand' ...
0
votes
2answers
567 views
Database migration issues - Error #1046 No database selected
i need to get my clients website online and have been able to figure everything out except of course the most crucial part which is the database upload. i can't figure out what i'm doing wrong since ...
-1
votes
1answer
109 views
Simple subscribe widget form
Im looking over internet for some simple solution of email subscription widget but no luck.
Or they are too complicated and paid, or they are relaying on some external email functions.
Im no ...
3
votes
1answer
128 views
How is custom menu hierarchy output handled?
I'm looking to pass custom nav_menus through an RSS feed so I can grab them on other sites to create the same custom menu on multiple sites.
What I can't figure out by looking through the database is ...
4
votes
2answers
2k views
WooCommerce with thousands of products - site is very slow - optimize db queries?
So far I've got around 8,000 products in my WooCommerce and the product page on the front end takes several seconds to load, even after caching.
My VPS host says that I should have multiple ...
0
votes
2answers
782 views
Getting “Error Establishing a Database Connection” on localhost in new Mac OSX Lion environment
I just got a new Macbook Air and I've been manually migrating my files and code over from my old Macbook (instead of using Migration Assistant, to avoid bringing cruft).
I had several sites running ...
0
votes
0answers
6 views
What would make a MySQL database create tables in a different collation other than its default? [duplicate]
Possible Duplicate:
Using wpdb to connect to a separate database
am adding tables to a Wordpress database on my localhost and it is changing my collation from utf8_general_ci to ...
0
votes
1answer
102 views
How to use remote db tables in current config? [duplicate]
Possible Duplicate:
Shared Members between two different wordpress installations with different databases
For example I have 2 different wordpress installations with different domains and ...
1
vote
5answers
286 views
Moving WP from local server to live, error establishing a db connection
Not sure what's going on here 'cos I've done it already a couple of times and it always worked. Basically I'm moving a testing site from my local machine (MAMP) to a live server by:
zipping the ...
2
votes
2answers
253 views
Shared Members between two different wordpress installations with different databases
I have two wordpress installations with same host with different folders. Each installation uses its own database. I mean, database are separated. I am not using one database for two wordpress ...
0
votes
2answers
358 views
Wordpress Settings Lost After Site Migration
I've done my fair share of migrating Wordpress sites, but today I am completely and utterly stumped. I've worked for many hours on this, and I cannot find a solution. I hope someone here can help.
I ...
2
votes
1answer
70 views
Importing Multiple DB to one MU database
I have three databases associated with three different WP sites. I set up one MU site, with one database. How should I import each of the three databases?
2
votes
2answers
95 views
The revisions table in my database is at 70% capacity and growing. What should I do?
I installed the Wordpress System Health Plugin and it says that the revisions table in my database is at 70% capacity with 994 rows. I don't fully understand what this means. I anticipate that my ...
0
votes
1answer
1k views
How can I check email exists via a jquery keyup()?
I have setup a jQuery keyup delay function to check the email typed into an input field.
It works fine after testing with an alert('Key pressed!');
But I want it to say, for example, 'Yes this ...
6
votes
2answers
303 views
How can I make a WordPress database portable and url independent?
Issue
I am about to embark on some WordPress development in a multi person team environment. (3 or more people working on the same codebase at a time, each developing locally)
With other CMSes we ...
1
vote
4answers
270 views
Migration: Copying database content to a different server
I'm migrating our WordPress site from one server to another. I need some hint on how to deploy a database dump (which I have) from the original server to the new one. There is no phpmyadmin (at least ...
0
votes
2answers
101 views
Widget queries even when there are no sidebars?
I'm trying to reduce my database queries. I don't have any sidebars or widgets set but I noticed the following query
SELECT option_value FROM wp_options WHERE option_name = 'widget_pages' LIMIT 1
...
0
votes
1answer
197 views
Integrating Custom Database with Wordpress
I Have a Wordpress Site with few users who are my college students
They Registered using their RollNumbers/HallTicket Numbers as their usernames in Wordpress site
Now I Have Another Database with ...
1
vote
2answers
249 views
Bootstrapping Wordpress MultiSite Outsite of Wordpress - No $wpdb
I'm working on a plugin for a system to use Wordpress as the authentication backend, so that I can use my existing Wordpress users in another application. The plugin works great when running in single ...
0
votes
1answer
286 views
Check if post id exist in table than only update instead of inserting new row
I am trying to add simple view counter for my advert and everything seems works fine with below code but only it is inserting each time new row on post "Update". What I want if the post id is exists ...
1
vote
1answer
196 views
WP_Query Performance Issues with meta_query
I'm working on a custom template for a new theme that uses a WP_Query instance to select posts from 2 post types with 2 custom fields that are NOT empty. Depending on the section of the site, a ...
1
vote
1answer
31 views
Building an email signup form. Where should the information be saved in the DB?
I would like to try build a simple plugin that collects and stores the name and email address of the person who filled in the form. I realize there are probably dozens of plugins out there that do ...
