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

learn more… | top users | synonyms

0
votes
3answers
4k views

How to delete all records from or empty a custom database table?

I can't seem to find a simple reliable way to do this - perhaps?: // delete row ## global $wpdb; $delete = $wpdb->query( $wpdb->prepare( "DELETE * FROM `wp_table_name`" ) ); ...
0
votes
1answer
89 views

Sub-domain or 2nd, temporary different domain?

I'm developing a Wordpress site for a website that already exists (that's not currently using Wordpress). The current website cannot be taken down until the new Wordpress site is ready to replace it. ...
0
votes
2answers
4k views

Synchronizing Two WordPress Sites Content

I've googled a lot, and I do have found answers at WordPress SE and at stackoverflow.com. However, the answers are somewhat incomplete or doesn't work at all. Here I'll explain my problem in detail, ...
0
votes
1answer
160 views

Is altering a default WordPress database table update safe?

I want to add some table columns to the wp_terms table. Is it safe to use the dbDelta function with a modified CREATE-MySQL query for this? Or will I run into problems in the long turn? Is it update ...
0
votes
1answer
47 views

Changing database links has no effect

So I just moved my website from localhost (127.0.0.1/wordpress) to a server. I followed many tutorials and I managed to get the site going. The home page loads, the content is there, however, subpages ...
0
votes
1answer
357 views

Hook to be used when creating a database table

I read the Codex and some other tutorials describing the process of creating a new table for WordPress. I thing that the steps are pretty straightforward; however, I'm encountering a small problem. ...
0
votes
1answer
387 views

Handling large N data in WordPress

I realize that this also pertains to PHP and MySQL in general, but the context and operation is within WordPress. Introduction I am currently developing a plugin that creates and saves data about ...
0
votes
2answers
170 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 ...
0
votes
1answer
262 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 ...
0
votes
1answer
216 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 ...
0
votes
2answers
3k 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
1answer
101 views

Proper approach to moving complete site from one domain to another AND preserve widgets

I consider myself fairly versed in this matter, however I've recently had a rash of issues when moving sites. I am able to successfully move the site, edit wp-config.php, move the database, etc. ...
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
989 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 ...