WordPress stores user generated content, along with other configurable information, in a a database (typically MySQL).

learn more… | top users | synonyms

0
votes
4answers
14k views

Custom form that store input in database

I have never used WordPress before, but have done a lot of programming. But what is the normal way of making customs forms? I need to create a form where a user fill some input fields and on submit ...
4
votes
2answers
614 views

Does dbDelta delete columns as well?

I created a table using the dbDelta function and then removed a few columns and added a few. The new columns did get created but the old columns did not get deleted from the table. Is there a ...
0
votes
1answer
109 views

Using custom tables for old posts

I have a site with about 24,000 posts and 200 posts daily and the database will get huge soon. So I plan to transfer the old posts to custom tables to reduce the database load. There's no need to show ...
4
votes
1answer
402 views

What is the advantage of the wp_options design pattern?

As we all know, a design pattern that is used frequently in Wordpress' DB code is the idea of persisting data for a particular object (blog/post/comment), indexed with a particular name or key. We ...
0
votes
1answer
77 views

Make Database query only when option is updated

Below is a DB query I am using to retrieve values and place them in a WP_List_Table. Values are currently being added by add_option, then those values are converted into a custom database table ...
0
votes
1answer
70 views

How do I find users by password?

I need to add a passkey to each user, so I decided to just giving the user password that value and use WP functionality to store it/retrieve it. So now I need to find what user that password belongs ...
0
votes
1answer
162 views

Filtering a Database Query

In a WP_List_Table example I'm using, I am seeing how to make a general query to the wp_options table in the Wordpress database. For example, $query = "SELECT * FROM $wpdb->options"; I also see ...
1
vote
2answers
271 views

SSO system between 2 WordPress installs on different servers

This is essentially a repeat of this question, but it has not been answered. I am trying to create an SSO system between two separate WordPress installs that are on different servers using different ...
3
votes
1answer
520 views

$wpdb->prepare() warning in WordPress 3.5

I am receiving this warning when I try to run a database query: Warning: Missing argument 2 for wpdb::prepare() The offending query is: $result = $wpdb->get_var( $wpdb->prepare( ...
0
votes
2answers
2k views

Theme Activation, Create Database Tables

I have been tasked with creating a theme that will be a base to list the site owners ebay store products. I have fleshed most of the project out in plain old php to get everything working as regards ...
1
vote
2answers
2k views

Two WordPress sites sharing the same content

My question is this: Is it possible to have two separate installations of WP with two separate domains sharing the same content? Scenario: User on http://A.mysite.com publishes a post. ...
1
vote
1answer
238 views

Maintain user profile data in a non-Wordpress database

I have an existing MySQL database (not Wordpress) containing user profile information. I am looking for a way to allow these users to log in to a Wordpress site and edit their profile. It is most ...
1
vote
2answers
900 views

Prevent Data Resubmission On Page refresh

UPDATED FOR CLARIFICATION I've got this rating plugin that keeps submitting & duplicating the rating data on page refresh. When a user wants to add a rating, they have to click a button that ...
3
votes
3answers
2k views

How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?

Normally, a MySQL database can be exported and imported using these simple SSH commands: Export: mysqldump -u USERNAME -p DATABASE_NAME > filename.sql Import: mysql -u USERNAME -p ...
0
votes
1answer
104 views

Will adding & modifying default Wordpress table index break future Wordpress update

I've some specific use case for certain default wordrpess tables, which I need to add a few indexes to certain columns to improve performance. I'm wondering will adding these indexes break future ...
-1
votes
1answer
324 views

WordPress: Interact with Database Query Data and Login

I'm relatively new to Wordpress thats why I'm asking this question. I need something to start in order not to waste a lot of time. I want to connect a mobile device with the wordpress database. The ...
1
vote
1answer
182 views

Importing Data from a Non-WordPress database, into WP

I'm migrating data from a totally different database style into WP. The main issue I'm trying to wrap my head around is how to import any meta data, given that WP uses a key value pair style for meta ...
0
votes
1answer
449 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
442 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
82 views

Is there a full explanation on how to share a database with two Wordpress sites on same server?

I have read that you can have two wordpress database tables (using different table prefixes) to share the same database. I understand the concept but does any know of or can anyone provide an outline ...
0
votes
1answer
49 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"; ...
2
votes
2answers
909 views

WordPress Database Charset/Collate

Is there an easy way of getting the charset and collation of the DB tables in WordPress without resorting to SQL queries?
3
votes
2answers
603 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
vote
1answer
684 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
131 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
529 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 ...
2
votes
1answer
956 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 ...
2
votes
1answer
2k views

Check if post of title already exists

I'm writing a plugin that takes an xml feed and posts it into WordPress using wp-cron Everything is working dandy, except it keeps adding the same posts over again. So, I'm working on a system to ...
0
votes
1answer
163 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 ...
2
votes
0answers
35 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
2answers
164 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
130 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
102 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 ...
0
votes
1answer
163 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 ...
2
votes
0answers
337 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
3answers
722 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 ...
0
votes
2answers
502 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 ...
3
votes
3answers
362 views

How do I save data from submitted form from widget

I'm 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. I'm not a ...
3
votes
1answer
382 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 ...
5
votes
2answers
2k 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 ...
0
votes
1answer
256 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 ...
3
votes
2answers
851 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 ...
1
vote
5answers
1k 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
1answer
115 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?
3
votes
3answers
8k views

WooCommerce with thousands of products - site is very slow - optimize db queries? [closed]

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 ...
2
votes
2answers
275 views

What is an efficient way to query based on post_meta?

The problem I am having is when I allow users to filter posts it overpowers the database and things run extremely slow. I am unsure what the best way to query posts using meta values is. My site has a ...
1
vote
1answer
4k 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 ...
0
votes
2answers
358 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
371 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 ...
0
votes
1answer
1k 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 ...