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

learn more… | top users | synonyms

5
votes
1answer
211 views

Should I use Transients with W3 Total Cache APC Caching? [closed]

Should I use Transients in my queries like this? <?php if ( ! $my_paged = absint( get_query_var( 'paged' ) ) ) $my_paged = 1; if ( ! $my_query = get_transient( "567recent_$my_paged" ) ) { ...
1
vote
1answer
518 views

Clean database from unused tables

I used to have many plugins installed on one of my sites, and after deleting most of them, I still have a database full of extra tables, I am sure most of them are unused. How do I clean them off?
1
vote
2answers
468 views

Form that sends data to an admin panel and can export it

Is there a way to have a form submit data to a admin control panel where the data is stored and can be rectified there? Could it also be able to export the data as excel for example?
0
votes
3answers
428 views

Migrated to Namecheap, now Trouble with Database & wp-config [closed]

I have been using a free web host while I set up my WP site. Now that it's all done I went and bought hosting from Namecheap. I uploaded the site and WordPress and everything seems to look fine, but ...
7
votes
2answers
491 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
1answer
250 views

One post carries 30 postmeta values, is this too much?

I have some data saved as post meta, occasionally some plugins may save an extra piece. Now I installed bbpress, it saves at least 10 pieces of post meta. Adding them together, there are nearly 35 ...
1
vote
1answer
810 views

WPML tables not deleted when removing multisite subsite, need help clearing up my sql-file! [on hold]

I´m building a WP Multisite for a client that wants a multilingual site. Before choosing WP Multisite, I bought and tried out WPML. However that plugin didn't fit for the job so I deleted it and got a ...
3
votes
2answers
1k views

Custom Post Type with Input fields to seperate table on database.

At the moment I'm using a custom post type called 'locations' I would like to be able to put input fields into the custom post type that would store the information such as ( address, type, phone ...
1
vote
2answers
494 views

Selecting all posts from the children of a particular parent taxonomy

I've created a custom post type (minerals) with a custom taxonomy (location) which supports hierarchies. What I am trying to do is create a return according to the parent location of the mineral post ...
0
votes
1answer
204 views

database not responding on localhost

I'm trying to work on an existing WordPress site on my Mac using MAMP. I've setup a new database using phpMyAdmin and imported the tables from the backup of the online version. I pasted this into ...
0
votes
2answers
293 views

Add custom php database code above <head>

I have a non plugin script that has it's own database and I want to use it with Wordpress. How can I add custom php code that connects to this separate database in my wordpress pages? It needs to go ...
1
vote
2answers
100 views

How to organise this data within WordPress

I have a dilemma in how the data in this scenario should be organised, as well as queried. The main elements in the scenario are the following: Competition Team Player Each player plays for one ...
0
votes
1answer
126 views

Trying to edit a WP site locally using MAMP

I'm new to WordPress. A friend asked me to redesign his WP blog and I've installed it on my Mac using MAMP. I went through the database setup and imported the site's existing DB and added the tables. ...
0
votes
1answer
263 views

How to create metabox that can be queried in the database?

So I've been working on created a catalog based off of wordpress's metabox functionality with a custom post type, but now as it comes time to start searching the database to return specific data sets, ...
3
votes
1answer
906 views

Default Wordpress settings API data sanitization

It looks to me that when saving data to the database via the settings API Wordpress sanitizes data by default. By that I mean that if I look at the raw settings options in the database they have (at ...
4
votes
1answer
334 views

find a random blogid across my multisite network that has at least one post published

I need to find a random blog across my multisite network that has at least one post published of a certain post_type, and return its blogid as a variable so I can use it in a switch_to_blog() call. I ...
1
vote
1answer
115 views

Using WPDB to output raw XML fails because of wp-blog-header.php

I'm coding a plugin. One particular file of this plugin is supposed to pull data from the plugin's custom DB table, and output it with minimal processing as raw XML. The problem is, to get the WPDB ...
0
votes
1answer
739 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
1answer
86 views

Adding columns to core tables

I was just wondering if there is a compelling reason to not let a plugin add columns to a core WordPress database table, such as wp_term_taxonomy. I could always create a separate table and join it to ...
0
votes
1answer
107 views

Wordpress and Unity high scores table

I am trying to figure out what is going to be my best route to go in this choice. I have a Unity game I have integrated with Wordpress but I need to send and receive the high scores of the game in the ...
1
vote
1answer
86 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 ...
2
votes
2answers
425 views

Database slowdown after update to 3.4.1

I own a wordpress installation, and Updated to 3.4.1. After the upgrade, I got a very strange slowdown to my wordpress. After all, I used the define('SAVEQUERIES', true); in my wp-config.php with ...
3
votes
1answer
279 views

How to use custom database tables for custom post types?

I need to use an existing database table as a Custom Post Type (CPT) to integrate it with wordpress. I've considered @boone-gorges thoughts here (should I?) and have decided, Yes, I need to use a ...
0
votes
1answer
79 views

Questions about MU database schema and how to list all blogs

What is the best way of retrieving a list of all blogs and their URLs in a MU network? Can I find them somewhere in the database? I'm also confused about the database schema. I have two different ...
4
votes
2answers
4k views

where is permalink info stored in database?

I see that I can edit permalink information in wp-admin page > settings > permalinks. However, where is that information actually stored in the database?
3
votes
2answers
466 views

Sharing database for collaborative development

Is there a straightforward way to share/sync multiple WP instances with a single database? I work collaboratively with several developers on custom themed sites. We use git to keep our files in order ...
1
vote
0answers
291 views

Easiest Way to Authenticate WP Users Using an External DB?

I have been looking for the best/easiest way to share users on a WP blog (in a subfolder) with the MAIN site's user database so that people do not have to register/log in on the WP blog when already ...
0
votes
2answers
364 views

How can I improve the performance of this query_posts loop?

I created a WordPress page template to build a customised XML feed for certain WordPress posts on my site. Specifically, the page template renders XML and only includes certain custom post types and ...
2
votes
2answers
480 views

Using Disqus, how to stop storing comments in wp database?

I'm using disqus comments system, but it keeps storing the comments in the wordpress database as well. Is there way to disable option to store comments in wordpress database because I don't see any ...
2
votes
1answer
2k views

Insert query inserts 2 entries, should insert 1

I've written a small posts by views plugin, well at least started one. My tables are set up but when they are updated the code adds 2 entries into my table when a post is loaded and views are ...
0
votes
2answers
773 views

/wp-admin/install.php redirecting to 123-reg

This is my first time installing wordpress via FTP, and the first time to an existing host and domain (I normally use EvoHosting, since it's automatic) I've gotten to the stage where I'm heading to ...
1
vote
2answers
3k views

clean wp_options table unused rows

In my Wordpress Blog site i have installed too much plugin and remove also many plugins. In database table "wp_options" size increases approx 13MB and there are many rows which are unused at this ...
0
votes
1answer
622 views

Adding custom field and querying from post table

I've been trying to figure this out for a while now. So I'm trying to add a custom field call "counter" to every single post. I try simply inserting the field "counter" to the post table. Every time a ...
0
votes
1answer
117 views

Say I have a tech blog, how best would I store technical specs for a phone, if i use custom post types

I've been playing around with WordPress for a couple of months now and when a client requests that he/she be allowed to modify, add content without my intervention, my defacto standard is WordPress. ...
0
votes
1answer
162 views

Create database on installation

I'm working on a custom wordpress plugin, but I can't seem to figure out how to create the database when installing the plugin. (Or when updating) When searching around this is what I came up with, ...
0
votes
2answers
875 views

Error establishing a database connection when migrating site to localhost

I'm wanting to make a version of my blog on my home computer that I can work on offline. I set up LAMP on my computer (running Ubuntu) and copied all of my files from my server (000 Webhost) with ...
0
votes
1answer
196 views

After moving my site from a dev subdomain, to root, all my custom meta data is gone

I just movde my site from a dev subdomain, to the root. I have extensive amounts of data saved in custom meta fields which I created with the WpAlchemy class. All of this data is not appearing in ...
5
votes
1answer
204 views

How can I safely increase the character limit for post passwords?

When I want to protect a post on one of my blogs, I like to use a passphrase instead of a password (albeit purely for the sake of creativity, not security — they're stored plainly anyway). However, ...
0
votes
2answers
2k 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 ...
2
votes
1answer
583 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 ...
4
votes
2answers
11k views

How to get the post publish date outside the loop?

I need to pull out the post publish date in order to make the post post auto expire. The thing is I can't get the right publish date. Here is my code: global $wpdb; $post_ids = ...
1
vote
1answer
146 views

Organize WordPress site, so it can maintain with huge database

Intro: Hello, I am making coupon website and I need an advise. So, the structure at the moment is like this: Coupons ( posts ) Categories of coupons ( categories ) Shops ( tags ) In the near ...
0
votes
2answers
2k views

How to Query Database for posts with certain Taxonomy Term

I want to write a select query to return data on only posts which have are associated with the taxonomy term food-and-beverage SELECT wp_postmeta . * , wp_posts.post_name FROM wp_posts, wp_postmeta, ...
1
vote
2answers
1k views

How to initialize $wpdb?

I have a .php page in the theme root to check the data of one CUSTOM form. After receiving this data I need to do a query in a custom mysql table, so I need $wpdb, but I can't use it directly (or ...
0
votes
1answer
101 views

Making my plugin create a page?

I have created a plugin that creates a table in the database and allows users to add an Item to the table. I would like each item to also create a page for its self so that when the items are listed I ...
0
votes
3answers
79 views

Wordpress : Explain Plugins & Theme string value in database

i have installed wordpress and i i have installed couple of plugins and i have got two themes already came with wordpress. What i am asking about today is : what does the Plugins & Theme string ...
0
votes
1answer
94 views

What is the correct/safe way to delete all comments?

We've inherited a WordPress (3.3.2) site that has 13k pending comments, all of which are spam. To delete all these comments is it sufficient and safe enough to do: DELETE FROM wp_comments; DELETE ...
0
votes
2answers
775 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
2answers
109 views

I have a table I created, how do I make a form for a user to filter the data?

I have created a table, I now need to filter the data from that table when someone selects options from a form. Whats a good way to do that?
0
votes
1answer
123 views

Secure way to use name_save_pre?

I created a custom post where I need to change the post name regarding to the custom field and taxonomy values. This is how I did it: add_filter('name_save_pre', 'save_name'); function ...