Questions tagged [database]
WordPress stores user generated content, along with other configurable information, in a database (typically MySQL).
174
questions
104
votes
6answers
149k views
Using wpdb to connect to a separate database
I want to connect wpdb to another database. How do I create the instance and pass it the database name/username/password?
Thanks
37
votes
4answers
14k views
Database synchronization between dev/staging and production
I have a problem with WordPress database synchronization between development and production and I am wondering how other people solving it. I am aware about this question but it doesn't really cover ...
59
votes
5answers
71k 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 ...
5
votes
1answer
930 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(
...
7
votes
1answer
1k views
What are these entries in the database? Looks similar to JSON
So I have been wondering for a while now what these entries are and what they do, also what the format of them are. They look similar to JSON but are definitely not JSON.
a:1:{s:12:"jetlocations";a:...
48
votes
5answers
37k 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 ...
43
votes
1answer
10k views
Should I use custom post types or a custom database tables for plugin development?
I'm fairly new to writing wordpress plugins, but I've jumped in the deep end already and I want to make sure I'm doing it "right" on my upcoming big project.
I'm going to be heavily extending ...
32
votes
5answers
26k 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 new
...
14
votes
4answers
2k views
Ignoring initial articles (like 'a', 'an' or 'the') when sorting queries?
I'm currently trying to output a list of music titles and would like to have the sorting ignore (but still display) the initial article of the title.
For example if I had a list of bands it will be ...
11
votes
5answers
33k 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 ...
9
votes
6answers
10k 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 ...
10
votes
7answers
24k views
Site stuck in "Database Update Required" loop
I just updated to 3.1.3 and now when I go to the admin I get the "Database Update Required" /wp-admin/upgrade.php screen. I click 'Upgrade Now' and it says it's done, but then trying to access ...
4
votes
1answer
13k views
wp_posts - guid update
Hello and please excuse if this has been answered before but we really need to make sure.
We have developed a website under a domain of ours and then moved it to the live site of the client. We have ...
6
votes
3answers
7k views
Database connection close
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?
21
votes
1answer
58k views
Wordpress default menu in database
There are 3 menus in my wordpress(3.5) now.
Main menu (default from wp)
Footer menu (default from wp)
Test menu
Now I have kept test menu as default.
Where does Wordpress store this thing?
I want ...
27
votes
1answer
72k 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 category?...
7
votes
5answers
28k views
Wordpress Database lost auto increment
After rolling back a Wordpress database to a backup version it seems that all the tables lost their auto_increment on the primary key columns. I read on another post this could be to do with InnoDB ...
0
votes
2answers
5k views
Multiple WP install with same users database
I am creating a e-commerce website. I am using woocommerce with some cool extensions I bought. I need to make 2 websites, but store the users database (purchases, subscription purchases, etc) as well ...
5
votes
1answer
408 views
When is it appropriate to create a new table in the WordPress database?
For a client we'll need 29,000 terms (all the highschool's in the US) and each term needs 6 meta items (address, phone...). My initial thought was to store the term meta information as suggested in ...
3
votes
2answers
2k 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 ...
4
votes
2answers
637 views
Organizing WP Pages based on old website database
I'm moving existing data involving paintings from an old host that didn't use WordPress to a new host that does.
With the old site, data was stored in a database so that each painting had its own ...
1
vote
1answer
2k views
Accessing two databases
I have two databases on my server, and wanted to know is there a way to access both databases from wordpress? My thought is adding the second set of credentials to the wp-config.php.
23
votes
3answers
69k 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?
8
votes
1answer
3k views
WP Multisite: load content from site X on site Y
I'm running a WP multisite-network on my professional website (http://mydomain.com). I'd like to play around with jQuery Mobile and deliver a different website and web experience to mobile users, so I ...
0
votes
2answers
326 views
Multiple Domains and Subdomains Using Multisite Installation
I have the following domains/subdomains. They are all related to each other, yet they must be on different domains/subdomains
example.com
www.example.com (redirects to example.com)
sub1.example.com
...
35
votes
4answers
15k views
Keeping WP database synced across multiple developers using git
I'm working on improving my git workflow as it applies to my WordPress development projects. Often, when developing a content management system, I'll create a development server (like http://dev....
10
votes
2answers
1k views
Is there a plugin that will override the "Error establishing a database connection" message? [closed]
My provider's database server recently had some downtime and my site was displaying the classic "Error establishing a database connection" message for about an hour.
I knew what the problem was but ...
15
votes
6answers
68k views
Will it break my site if I delete all transient records in wp_options table?
My site currently has an outrageous 500k+ transient records in the wp_options table.
This causes the table to be crashed frequently and so be my site.
I thought transient records will all expired ...
34
votes
1answer
11k views
When is the 'post_content_filtered' column in database cleared by WordPress?
Some WordPress plugins (although very few) use the post_content_filtered column in database to save some data related to a post.
For example, Markdown on Save stores the markdown version of a post ...
14
votes
3answers
855 views
Performance of my permalink structure?
I have read the discussion on the performance of different permalinks on the wp hackers mailinglist, THIS forum and around Google.
I could however not really deduce if the permalink structure I have ...
12
votes
4answers
23k views
DB connection error after copying a WordPress Multisite instance to a second location
Here's my setup. I have a Multisite instance running at http://example.com, and I want to do development and staging. Moving an existing Multisite instance of WP onto localhost is a nightmare, so I'm ...
14
votes
1answer
2k views
Fastest way (least amount of steps) to locally import a remote database using WP-CLI
I'd like to automate the task of importing a remote database using the WP-CLI.
The current process is to ssh to the server, and run an export to file using WP-CLI, copy the file to a local directory ...
6
votes
2answers
9k 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 ...
15
votes
3answers
8k views
Why WordPress choose data serialization over json_encode?
In my little age with WordPress, I've seen WordPress itself and its friendly plugins are using PHP serialize() in storing data into db in many cases. But in a recent search I found a serious community ...
6
votes
1answer
89k views
Insert data in database using form
I am writing a simple plugin that create a table with name "newsletter" in database and provide a shortcode to put a registration form in pages.
the form contain "name" and "email".
i have problem ...
3
votes
2answers
17k views
Connect to remote database using Localhost install
I will be designing and developing a website for a client but want to allow the client to add content while I am working on the design and development of the site so that it is pretty mich done by the ...
2
votes
2answers
575 views
Efficiency on displaying random authors based on large database
I'm trying to display a list of 5 authors randomly. Here are some solutions I had found:
https://stackoverflow.com/questions/5502609/get-authors-randomly
https://wordpress.stackexchange.com/a/91326/...
1
vote
3answers
3k 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 ...
11
votes
2answers
8k views
Where is the old post permalink slug stored?
I published an article with permalink slug:
http://domain.com/writing
Then after publishing, I changed the permalink slug to writing-lorem. Now, whenever I visit /writing, it redirects to /writing-...
9
votes
1answer
679 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 ...
5
votes
1answer
435 views
Writing a plugin that notify my friends of new post that mentions(@) them
For example, I write a new post with content "Today I'm happy, because I finally met the girl that @David told me about bla blah..." Once the post is published, there should be an email notification ...
3
votes
2answers
4k 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 `...
3
votes
1answer
2k views
Can I store my custom comment_type into wp_comments table?
I'm developing a system where a post can have multiple replies/feedbacks. As of now I's storing each of the comments as a serialized postmeta. But just today I figured out that I can use the existing ...
-1
votes
1answer
66 views
Retrieving and Displaying Data From a Table
At the moment, I have created a code that retrieves data from the database and displays it. However, for some reason, I cannot see the files I want to retrieve on my page. My goal is that the data ...
2
votes
4answers
1k 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 ...
0
votes
1answer
3k views
save new data to wp_options non-post form
I have a form on my front-page. It sends the entered address to Google API and returns the JSON to wp_options. That works fine. I am using update_option to do that, so it rewrites the meta_key each ...
0
votes
1answer
1k views
Bulk Update of Custom Post Type Post Status through SQL
The following code updates the post status of standard wordpress posts to 'Archived'.
UPDATE wp_posts SET post_status = 'Archived' WHERE post_status != 'static';
How can I make this only affect ...
0
votes
2answers
3k views
Connecting to external oracle database
So I'm trying to connect to an external db in order to access/update information located on a different non-wordpress database (oracle).
I tried constructing a new wpdb object (as suggested by many ...
29
votes
4answers
58k views
WPDB Insert or if exists Update
I'm not crazy familiar with WPDB or SQL in general but I have a custom table for my project and I'm trying to assign some metadata to it. What I'd "like" to happen is if a row exists, update it and if ...
22
votes
3answers
66k views
How do I show data from gravity forms in my template? [closed]
Preface
I've installed gravity forms, created a form and users are submitting data to my site.
What I want to do is show the data users are submitting to my site on one of my pages.
I know there's the ...
