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

learn more… | top users | synonyms

2
votes
2answers
13k views

Connect to database using wordpress wp-config file

How can I connect to the database using the wp-config.php file ? I'm trying to make a script more Wordpress friendly, and I need to connect to the database, but without installing the script as a ...
2
votes
2answers
830 views

Where are wordpress custom types stored?

Where are custom types stored? Because when a custom type is created, in wp_posts, the post type is set to the <new_custom_post_type>. But where are the details of the new custom post type ...
2
votes
2answers
305 views

Is a direct or import approach safer for migration into WordPress?

We're in the process of migrating a site from an existing CMS system into WordPress. The existing CMS system has no direct integration tools with WordPress. I'm looking into the option of creating ...
2
votes
2answers
44 views

WordPress unresponsive after calling wp_update_comment()

In the admin panel's "Edit Comment" page, for some reason after I click "Update" the Edit page goes into infinite loop/loading (the spinner icon in the Google Chrome tab never stops spinning). My ...
2
votes
1answer
22 views

Subscribers to posts

Consider each post to be topic of conversation, and comments a conversation. For now it is fine. I created a post type called conversation. Now I want to list all the conversations a user is in. How ...
2
votes
1answer
201 views

Is $wpdb->prepare escaping to much? How to use it properly?

Im pretty much confused by $wpdb->prepare. I want to use it to sanitize user input but it turned out that it destroys the query. I cannot imagine that this is how it's intended to work but I can't ...
2
votes
1answer
1k views

Database sync between local and production

I was watching Mark Jaquith's presentation at WCSF 2013 recently and in the Q&A Mark mentioned something about rsync - after a quick Google I can see this is done via SSH - my question is this: is ...
2
votes
1answer
90 views

$wpdb->update has finished saving trigger?

I have a custom table that I am updating via wp_ajax action. I am inserting a row and inserting all of the values other than id which is an AUTO_INCREMENT. I have an ajax response that creates a new ...
2
votes
1answer
334 views

how to show database content in wordpress post

I'm a beginner for WordPress. I have a database app written in PHP and MySQL and I need to convert it to WordPress and also I what to post the database rows info by shortcode were id="x" like: ...
2
votes
2answers
909 views

How to modify post content before writing to database?

Hi~ I'm back again and I'm trying to add another function to the script I was working on a plugin that notify my friends of new post that mentions(@) them. Now I want to change the plain text of my ...
2
votes
1answer
89 views

What is the easiest way to implement cascading database upgrade for my plugin?

Lets assume following situation: I develop a plugin. The plugin requires custom database table to store some kind of information. From month to month I release new versions of my plugin. Different ...
2
votes
2answers
613 views

The plugin generated x characters of unexpected output, $wpdb not defined

I've written a simple Wordpress plugin to create a new database table. The new table ought to be created when the plugin is activated. When I try to activate the plugin, I get the following error: ...
2
votes
1answer
130 views

Wordpress database growing dramatically in size despite adding no new content

I have an old Wordpress site that I no longer maintain but keep online anyway. I have a cron job setup on the server that backs up the Wordpress database once a month. I am noticing a continuing ...
2
votes
2answers
813 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 ...
2
votes
2answers
144 views

Is it possible to import a wordpress backup from a single site in to a multi-site configuration?

I have a local development server with WordPress installed (my desktop Linux Mint 12 box). I'd like to use multi-site WordPress to manage my different client projects through one install, but I have a ...
2
votes
2answers
515 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
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?
2
votes
1answer
75 views

How wordpress accesses its own database

Hi I'm just curious as to how Wordpress accesses it's own database, meaning that when I look into an admin page like link-manager.php or class-wp-list-table.php I don't see any occurences of $wpdb. ...
2
votes
2answers
408 views

How is the data stored in the database?

I have years of experience with PHP and MySQL, but just starting to develop plugins for WordPress and need some help. Currently, I am working on a plugin that will add extra functionality to another ...
2
votes
2answers
221 views

Tons of Twitter rows in my database

I have 264,307 "http" (post_type = http) rows in my wp_posts table. 99% of those have them have this post_title: GET http://twitter.com/statuses/user_timeline/@xcentric.json?count=100 and "error" ...
2
votes
1answer
379 views

How to create Sub Sub domain Multi User blogs?

Hi to all I would like to create a big Wordpress network with this structure: sitename.com (Main website) cat1.sitename.com (sub website) cat11.cat1.sitename.com (sub-sub website) ...
2
votes
1answer
506 views

Split a database will improve performance?

Hi to all I'm running a Wordpress MS installation and I would like to move a couple of heavy "sub" blogs on a different DB, will it encrease my performances? Actually I'm on a dedicated server with ...
2
votes
3answers
352 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 ...
2
votes
1answer
18 views

Weird issue with database migration and SSL links

I want to move my database to my another mirror server (for testing & stuff). My original one is using SSL and I am forcing it to do so. When I migrate with DB Migrate plugin, the non-ssl server ...
2
votes
1answer
299 views

Has anyone tried putting PHP ActiveRecord on Wordpress?

I have worked with Ruby on Rails and I was looking for some code that did something close to the wonderfull RoR's ActiveRecord. I stepped by this site. Its PHP-ActiveRecord! I found it amazing, and ...
2
votes
2answers
71 views

Why does dbDelta() not catch MysqlErrors?

From what I can see, dbDelta() is designed to suppress database errors that occur during its operation. Generally speaking, this seems to be the case, but New Relic is still reporting MysqlErrors ...
2
votes
1answer
84 views

Is there a shortcut to change bulk BMP images to JPG images in a site?

Images in WordPress posts, as I understand, are uploaded manually. They are uploaded by default to uploads folder. A client of mine reported that, in one of his site, he uploaded all the images in BMP ...
2
votes
1answer
626 views

Ajax with jQuery UI dialog not working

I am trying to update my custom database table when changes are made in a dialog box. The script for the dialog box and ajax call is as follows - jQuery(document).ready(function($){ $("td > ...
2
votes
2answers
196 views

js Conflict in admin panel - I guess it's from the core WP installation

A client's site: causing serious js conflict or js loading disabilities, is under custody. Activating DEBUG, Deactivating all Plugins, and Activating Default theme "T13" found that, still the problem ...
2
votes
1answer
894 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 ...
2
votes
1answer
2k views

Check if post of title already exists

I'm writing a plugin that takes an xml feed and posts it into WordPress using wp-cron Everything is working dandy, except it keeps adding the same posts over again. So, I'm working on a system to ...
2
votes
1answer
111 views

Importing Multiple DB to one MU database

I have three databases associated with three different WP sites. I set up one MU site, with one database. How should I import each of the three databases?
2
votes
2answers
272 views

What is an efficient way to query based on post_meta?

The problem I am having is when I allow users to filter posts it overpowers the database and things run extremely slow. I am unsure what the best way to query posts using meta values is. My site has a ...
2
votes
1answer
59 views

How to log database changes during an upgrade?

I have Wordpress installed in a classical LAMP configuration. Is there any way to, in a protected environment (like staging), automatically log all database changes (i.e. drop indexes or alter tables) ...
2
votes
1answer
590 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 ...
2
votes
1answer
939 views

How to edit/delete single row items in a table on my own menu page

I have successfully created a wp-LINKS-list-table that displays the output of WP's core "Links" table in the WP Dashboard, and I have it displaying on a menu page I created. Step 1 accomplished! ...
2
votes
2answers
1k views

Have multiple local wordpress installs share a wp-content folder and database

On my local machine, I have multiple wordpress versions installed so I can test the themes and plugins I develop. I was wondering if I could somehow create a central wp-content folder and database, ...
2
votes
1answer
49 views

Leader board for game on homepage

I've built a simple game which is housed on my homepage. I'd like to create a leader board (a small results table) which displays the top three 3 scores. How would i insert/retrieve the score data ...
2
votes
2answers
555 views

How to export/import theme customizer settings?

I am wondering if it is possible to export theme customizer settings(theme_mods) to be imported into another install of the same theme. I know that the settings are saved into the database so I am ...
2
votes
0answers
35 views

Backup another database with BackUpWordPress plugin

Is there any possibilities to add another database which is connected to other wordpress plugin? My site is using two database: main wordpress db and additional db for plugin data. The Backup includes ...
2
votes
0answers
332 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 ...
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 ...
2
votes
1answer
238 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
4answers
3k 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( ) ...
1
vote
1answer
256 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
2answers
1k views

what to do when your WordPress database is too large?

Well I have asked this question in WP Forums, StackOverflow, and GoDaddy community as well, but nothing worked out. Hoping something is in here. I used 2 separated subdomains for my blog and site ...
1
vote
2answers
131 views

How do I reset a self-hosted Wordpress URL?

i was using a wordpress install on an ubuntu server virtual machine. At first the adapter was host-only at an address of 192.168.55.55. The host had this on a vboxnet0 subnet. i changed to bridged ...
1
vote
2answers
9k views

Using Dynamic Data Pulled from a MySQL Table in a WordPress Page

I'd like to pull data from a mySQL database and put it in some tables in a WP page. I'm using WP 3.1.1. Imagine that I've got a table of sales figures that I want to pull from a mySQL database and ...
1
vote
3answers
2k 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 ...
1
vote
4answers
460 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 ...