WordPress stores user generated content, along with other configurable information, in a a database (typically MySQL).
2
votes
2answers
673 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 ...
2
votes
1answer
568 views
Advice needed for importing custom field data and database structure
Looking for advice for the best method to accomplish the following.
I have a custom page template with several custom fields/taxonomy.
The data needed for these custom fields actually resides in ...
2
votes
2answers
267 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
1answer
51 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
1answer
52 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
247 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
96 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
91 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
67 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
182 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
252 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
346 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
307 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
144 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 ...
2
votes
1answer
138 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
2answers
467 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
69 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
1answer
44 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
393 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
422 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
451 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
43 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
509 views
remove missing image attachments
Best way to programatically remove attachments that are missing images?
I ask because after using a caching plugin, I have images that have been input in the database as attachments that don't ...
2
votes
0answers
61 views
Plugin development with unit tests
One of the things that my plugin does is creates a number of SQL tables as part of a versioning function (that is run under the admin_init hook as I couldn't find a better wordpress way of doing ...
2
votes
2answers
110 views
How might I retrieve a featured post image from an external WP site and display it as a link back?
I have two WP sites. I want to reach from one of them, into the other, and retrieve specific featured images for posts, and display them with a link to that post.
I am using this line (with the ...
2
votes
0answers
96 views
Plugin Not Working, But Only On GoDaddy Hosted site
I'm creating a plugin for a friend to log search terms on his site. It's very basic. It creates a new table to store terms entered in the search box. It converts the search term to lower case, ...
2
votes
1answer
116 views
BuddyPress: What's the use of wp_bp_xprofile_data table and how does it get updated?
I have a questions related to BuddyPress:
What's the use of wp_bp_xprofile_data table? How does the data in the table get updated?
And when any user updates his information - does the data in this ...
2
votes
2answers
193 views
Custom database or Custom Post Types?
I have been searching throughout the web for the best way to implement what I need but just cannot find a best solution as there always seems to be some drawback. I'd prefer to do it right the first ...
2
votes
0answers
222 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
2answers
125 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
2answers
210 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
0answers
599 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
161 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
1k 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
2answers
103 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
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
395 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 ...
1
vote
1answer
860 views
Update Option Stored in Multi-Dimensional Array
I have data in the wp_options table currently stored as a multi-dimensional array (profile_element_order):
...
1
vote
2answers
333 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
219 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.
...
1
vote
2answers
679 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 ...
1
vote
1answer
32 views
Is it possible to store visitors IPs in wp_postmeta table?
Or in any of the other 11 Wordpress tables. I also need to store: submission date, name, contact number in the same table.
What approach would be best? A custom table or using a standard table?
1
vote
1answer
261 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 ...
1
vote
2answers
100 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 ...
1
vote
2answers
65 views
Remove the deleted users avatar from list
Problem
Hi everyone, I have a bit of a problem. I have a function that outputs the avatars of users that follow me . It works great, but if the user is deleted the avatars remain visible as a blank ...
1
vote
3answers
816 views
Login in Wordpress using external database data
I have a WP site and also have a external DB (means not WP DB) with users. The insertion process at that table uses the same algorithm as WP uses. What I'm need to do here is login in WP but using ...
1
vote
3answers
1k 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 ...
1
vote
1answer
1k views
How to build a movie database with wordpress?
I'm looking for a plugin to build a movie database like Popcritics
The plugin would permits me to add custom info (like CustomPress can do) about a movie.
Ultimately, the plugin could permit users ...
1
vote
2answers
353 views
What's the most efficient database method to add and query usermeta?
What's the most efficient way - concerning the database - to add and query extra usermeta fields to a profile?
I need to add four additional fields of numeric and text data to a user profile and then ...
1
vote
1answer
36 views
Separate table or usermeta
We are creating custom fields for users like annual income, gender, city, country, etc. There are about 10 odd new fields. We will be importing approx. 30,000 records for each user in a month through ...
