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

learn more… | top users | synonyms

0
votes
2answers
490 views

storing database in version control

I am using a version control system to manage my wordpress code (git). What is the betst way to store the database information into version control? I want to go to my staging machine, run git pull ...
3
votes
2answers
341 views

$wpdb won't insert NULL into table column

When i try something like this $status = NULL; $wpdb->update( 'table', array( 'status' => $status, ), array( 'id' ...
3
votes
4answers
580 views

How many users can WordPress handle?

I want to design a member login site in WP but I have a doubt that is WordPress can handle more than 40000 users on same database? I am not sure about this so I am stooping my work here. So please ...
3
votes
2answers
473 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 ...
3
votes
2answers
499 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, ...
3
votes
1answer
1k views

How to convert regular categories to custom taxonomy?

I have a big list of categories/subcategories (around 60 in all). It now makes sense that instead of these categories being available to any post type's category list, these categories should be moved ...
2
votes
1answer
54 views

Text snippets shared across posts

I'd like to add a "fast facts" section to a wordpress site - an area in the sidebar where snippets of text are rotated. Where is the best place to store things like this? Widgets don't really allow ...
2
votes
2answers
718 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?
2
votes
1answer
225 views

What Is The Difference Between suppress_errors() And hide_errors() in $wpdb?

What is the difference between the suppress_errors() function and the hide_errors() functionin wpdb class? What is the use of each function?
1
vote
1answer
239 views

Hello dolly type plugin that allows people to add their own

I am making a plugin that shows a random joke on a custom 404 page via shortcode and it is basically near enough the same as the default hello dolly plugin, where the jokes are hardcoded into the ...
1
vote
1answer
284 views

How do I write this SQL statement for Posts written in last 24 hours?

Someone gave me this SQL code to count the number of posts (of post_type 'mixtapes') in the last 7 days. I tried to convert it to 'in the last 24 hours' as well, but it's giving the wrong number. ...
1
vote
1answer
1k views

Accessing WordPress MySQL Database via Data Connection in Visual Studio 2010 using C#

So I've Googled and followed countless tutorials, read documentation on MySQL, Visual Studio, WordPress, and Plesk. I try to leave posting on this site as the final option and it seems it has come to ...
1
vote
1answer
356 views

Migrating WPMS from apache to IIS7 causes Database Error

// Be sure to read the updates at the bottom I have a large multisite installation hosted on XAMPP on an XP 2003 server and am trying to move it from XAMPP/Apache to a new Windows 2008 server with ...
1
vote
1answer
964 views

Use Custom Database with Custom Post Type

I decided to ask this question as searching online left me really overwhelmed and not knowing which direction to take. I am about to tackle a project that has its own custom database (finished e-r ...
1
vote
4answers
4k views

After server migration only the homepage works

I have recently changed hosting of my WordPress site to VPS.net. I have moved all of my files and imported the database. Everything appeared to be fine until I clicked a link and noticed that all of ...
1
vote
1answer
938 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 ...
1
vote
1answer
190 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 ...
1
vote
2answers
985 views

Custom Taxonomies Incorrectly Counting Revisions?

(Moderator's note: The original title was "The count of my custom taxonomy is incorrect; it's counting revisions") Has anybody run into this before? I've added two custom taxonomies, and the count ...
0
votes
0answers
69 views

Would manually deleting the dumping data fix a “#1062 - Duplicate entry '1' for key 'PRIMARY'” phpMyAdmin error?

I'm new to PHP! I'm trying to import an SQL database file into myPhpAdmin for a WordPress I'm migrating, but I keep getting this error message: SQL query: `-- -- Dumping data for table ...
0
votes
2answers
36 views

Database custom table issues - incorrect result displayed

First things first: I've spent most of today going over these forums; the stackoverflow forums; the php.net manual; and a bunch of random sites I found through Google Search - so, if I've missed the ...
0
votes
1answer
517 views

“MySQL server has gone away” since update to 3.8

I have a WordPress install on a dedicated server with decent memory (upwards of 8GB). The WordPress install includes many plugins - 50 active plugins. Most important to note is the WPML plugin to ...
0
votes
0answers
231 views

insert data from form to custom table

I have a custom form set up on a custom page template. I need the submitted data to be saved in custom table. What am I missing since this isn't send the data? The code I'm using: ...
0
votes
1answer
62 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
1answer
96 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
40 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
178 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
2answers
120 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
1k views

How To Find Out Wordpress Category Table in MYSQL?

I know WordPress stores all post data in 'wp_posts' table. But here WordPress not define any category id or reference related with it. Please let me know, how 'wp_posts' table find out exact ...
0
votes
1answer
95 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
809 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 ...