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

learn more… | top users | synonyms

10
votes
1answer
765 views

How do I make an HTML table from a database table?

is there a built-in wordpress function to make the HTML or should I use plain-old PHP?
6
votes
2answers
7k views

Checking if Database Table exists

I read the wordpress codex and professional wordpress. It seems both use something like if($wpdb->get_var("SHOW TABLES LIKE '$table_name'") != $table_name) { to determine if the table exists. Is ...
0
votes
3answers
649 views

Site does not work right, pages not showing up, even for root admin

I have a problem. My database server isn't working right. On a wiki, it gives an error, and on my wordpress site, the pages don't show up. I am wondering if WordPress caches the DB data in any way, ...
1
vote
1answer
1k views

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

I am trying to access data from some custom fileds in my MySQL db so that I can add them to a webpage that will be printed out. The data is held in a column called "paypal_user" and I need to access ...
2
votes
1answer
2k views

Split WP install between 2 databases?

Is it possible for Wordpress to work from two databases? The reason I ask is that we're approaching our 100mb limit for database size on our host (1and1) but have up to 100 databases, so what I was ...
0
votes
1answer
495 views

Wordpress and MySQL: trying to print data using PHP from user_meta custom field data

I have some custom user_meta fields in my MySQL database. The data is stored in my DB as follows: the meta_key is called "paypal_user" and the info is stored in the meta_value column as: ...
0
votes
2answers
145 views

Need help restoring my Wordpress blog

I installed wp-cache to help with site speed. Shortly afterward, I was unable to access the site. Included below are the browser errors I receive. The site is hosted by GoDaddy. I asked them to ...
1
vote
4answers
5k views

Export wordpress table to excel

I have created PHP scripts before to export a database table to .xls format like this: $select = "SELECT * FROM tracking"; $export = mysql_query ( $select ) or die ( "Sql error : " . mysql_error( ) ...
10
votes
2answers
7k views

Wordpress Database Slow - should I switch to InnoDB?

I have a WordPress site with well over 10k posts, and things are starting to get very slow whenever I am adding and editing posts. Pages load nice and fast for users, along with the admin lists of ...
2
votes
3answers
370 views

WP Database Error (Windows Server 2008 & SQL Server)

I have a WP site up and running for my wife and she attempted to install a text widget that linked to her Twitter account (she says HTML was taken from Twitter.com). I am not sure exactly what she ...
0
votes
1answer
692 views

Is there an easy way of exporting posts with their category already asigned and pictures from localhost?

Every time I export a database using the Export Tool in wp-admin. There are two things left out: The category 'checked' (I have to do that all over again every time I export the posts). Also I can't ...
1
vote
3answers
3k views

How to retrieve the value stored in a multi-dimensional array and SUM the entries?

I'm trying to retrieve multidimensional values stored in user_meta where the meta key is my_posts and the meta_value is a:3:{i:0;s:2:"23";i:1;s:2:"20";i:2;s:1:"9";} Somewhere in the admin page ...
0
votes
3answers
954 views

How to find if a post with custom_field == X exists?

I need to find if a post with a custom field X equal to Y exists in a wordpress installation. Should I do it with a simple sql query or is there something build in that can help me achieve it?
0
votes
1answer
895 views

Connect to another WP install and grab post based on custom field

This is the set up: Two separate wordpress installs on two separate domains (not multi-site) This is what I want to do Query the posts from database one based on custom field and display them on the ...
31
votes
6answers
24k views

Why is my database import losing text widget data?

I've created a site in WordPress on our development machine. In the theme we're using there are numerous widget zones to display text in (sidebar and front page). I've used simple Text widgets in all ...
0
votes
3answers
1k views

What is the fastest way to generate a unique id number when registering a user

I have a client who wants to register users and give them a unique ID number when they complete registration. (Kind of a member number sort of thing) Can I just setup the WP member table to start id ...
0
votes
2answers
927 views

Have working sql query… trying to adjust it to use $wpdb

So I have this code that queries a custom plugin generated table in the wp database. It works perfectly as is. But I'm trying to adjust it to use $wpdb instead of the $con function I have set up. ...
2
votes
1answer
4k views

How to close wpdb connection?

Is there any method to close connection similar to mysql_close() for wpdb in wordpress? Is it not necessary to close connection for global wpdb?
0
votes
1answer
254 views

I've got a theme I can't update and won't let go

I created a custom theme for a client a while back and then it sorta mysteriously broke several months later by reverting to an early version that had a few links to my website hard coded into it. I ...
1
vote
1answer
294 views

In what part of the Wordpress core does the users table and usermeta table get joined?

I have been trying to work out just where in the massive jungle of Wordpress include classes the usermeta table is joined onto the users table and if so, how does it work? The one confusing thing ...
2
votes
2answers
2k views

Updating Wordpress - the best approach (updating wp core, plugins and db)

What is the best approach (steps) to update Wordpress when I have to update all of the following: wp core plugins database I came across this post http://codex.wordpress.org/Updating_WordPress ...
4
votes
3answers
937 views

Performance tips for a large user base [closed]

I’m preparing a site with many users (100.000+). Since the output depends on the current user’s relation to some custom post types and taxonomies a static cache won’t help much. Besides using a ...
0
votes
1answer
2k views

Database structure cheatsheet

I am trying to create a custom search page for a site I developed, but I lack the information needed to create the custom sql queries. Are there any useful resources you guys might know of?
1
vote
2answers
214 views

Critical error in final stage of website launch - URLs are BROKEN!

We developed the wordpress site here: wwww.kirschfamilycomputerservices.com/sam/wheresthefairness ^^ URL does not exist now. When the website was done, we transferred the database & theme over ...
4
votes
2answers
3k views

Displaying content from one WP site on separate WP site

I have two totally separate WP websites setup. Different domains, different databases. I manage both of them and they are both hosted on a dedicated server. I am trying to include some basic ...
0
votes
2answers
810 views

Best/Correct way to add an option to a category

I'm currently writing my first plugin, which will let the site admin/editor use a different image as a background/header for each post/page, and I would also like to have defaults for each category. ...
1
vote
3answers
984 views

Output custom content not from the posts table?

It would be best if I started out be explaining the situation: A while ago I created a Property/Real Estate management system using PHP and MySQL. It works great and I have a lot of customers using ...
0
votes
5answers
1k views

I have a 1300 line excel spreadsheet that needs to get into a wordpress site ASAP - Looking for ideas

I have an excel spreadsheet that needs to get on a WP site PDQ and IE is choking on it. I tried making an html table, but it's huge. I looked into some kind a database plugin that would let me ...
6
votes
1answer
754 views

Would switching to InnoDB from MyISAM improve performance of comments table?

A site I've built gets lots of comments in a short space of time - so perhaps 100 comments might be left in 5 or 10 minutes. This seems to cause a pretty heavy load on the database, especially when ...
0
votes
2answers
1k views

What are the additional fields in wp_comments used for?

I'm working on a rather odd implementation that stretches the limits of WP a little - its a healthcare site where patients are a custom post type and procedure requests related to each patient are ...
7
votes
4answers
27k views

How to integrate custom database table in Wordpress and using Wordpress functions

I'm on Wordpress 3.0.4 and I'm having a hard time deciding which way to go. The following is my problem: I have a mysql database table widgets, with about 10 properties like id, size, color etc. ...
24
votes
4answers
24k views

MySQL Database User: Which Privileges are needed?

The short installation instruction for WordPress ("5 Minutes") state that: Create a database for WordPress on your web server, as well as a MySQL user who has all privileges for accessing and ...
8
votes
4answers
5k views

Are There Any Plans for Wordpress to Support Databases Other Than MySQL?

I've long wished Wordpress would support SQL Server, but it would also really amazing if it supported MongoDB (for example.) My question is are there any plans to do so, at all? Is the core ...
2
votes
4answers
599 views

Long option names fail silently?

This was really driving me crazy. I was debugging some code with code-generated transient names and they were failing like crazy for no apparent reason. After much much pain and experimentation I ...
-3
votes
3answers
167 views

Server database problem

i just transferred my website from shared server to VPS, but then it is not starting, when i inquired with the VPS technical support then they emailed me something this, which i am not ...
6
votes
2answers
2k views

Default table collation on plugin activation?

I'm following this to make my plugin auto-create a table when the plugin is activated, but what happens is that while all the tables (the whole db) are utf8_general_ci, the newly created table is ...
1
vote
4answers
474 views

Looking for a subscriber list management system

Is there any plugin that enables the creation of forms and has a smart tool for subscribers (not site visitors who registered) database management? I'm looking for a plugin that does that for a long ...
3
votes
2answers
3k views

Transient RSS feeds in wp_options not removed automatically?

I just noticed 55.000 entries(!) in my wp_options table. I had not been there for a while. So I ran: delete from `wp_options` where `option_name` like '_transient_timeout_rss%' delete from ...
0
votes
2answers
245 views

Best host for running large mem and processor intensive WordPress sites?

I host a number of WordPress sites, some of which have VERY large databases. I've gone through several popular web hosts though no joy yet. Any suggestions.
0
votes
3answers
349 views

Problems with moving my Wordpress site to another domain/server

I'm having problems moving a wordpress site from one domain to another. I've searched the site but couldn find a useful answer for my situation. Here's what i did: I made a backup of the website. ...
6
votes
3answers
1k views

Resetting comment count

Recently, I had to move to another domain and had to recreate all my MySQL tables on the enw server. I noticed that for some posts, the number of comments is doubled. Example - ...
0
votes
3answers
439 views

Uknown meta entries in wp_postmeta

I'm working on a site that has been running for few years and had different maintainers so it's kind of a mess. What I found weird is a lot of entries in wp_postmeta where all the keys are numeric and ...
18
votes
4answers
12k views

Post meta vs separate database tables

When developing plugins that requires data storage, what's the pros and cons of using one method or another ? The explanation given in the codex is not detailed: Before jumping in with a whole ...
1
vote
2answers
256 views

greatest() function returns undefined property

I'm using the mysql GREATEST() function to compare two table fields and display in a loop either one with the highest integer value. The 2 fields consist of vote scores for posts: UP or DOWN. ...
2
votes
1answer
4k views

Safe way to find last inserted id in a table?

Is it safe to use $wpdb->insert_id; to find the id of a last updated row id just after an update? ex: $sql = $wpdb->insert($table_name, $arrayWithDataToInsert, array('%s','%s')); ...
2
votes
1answer
210 views

WP database error for comments_popup_link()

I'm using the comments_popup_link() function to show the number of comments for each post in a loop. <?php if (have_posts()) : while (have_posts()) : the_post(); ?> <?php if ( ...
1
vote
1answer
371 views

Fastest way to get the comment and ping total count for a post

I'm making my own comment template (like this) and I need to know how can I get the comment and ping count for the current post, maybe using a fast database query or something like that? Note that I ...
0
votes
1answer
775 views

SQL error with custom query

I'm trying to create a custom post query for sorting posts that have been voted "thumbs up". I'm joining my custom "wp_post_votes" table (which stores the number of votes each post received) with ...
0
votes
2answers
1k views

Custom query_posts() parameter

I'm adding voting features to a theme. Visitors can vote posts Up or Down. I created a table for storing number of votes for each post and that works fine. Now I'm trying to sort posts by their votes. ...
1
vote
1answer
195 views

Prevent WordPress from loading comments

I'm displaying the comments for a post my way, using $comm = get_comments() and then passing $comm to wp_list_comments() (this is the reason why). How to disable WordPress from loading comments from ...