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

learn more… | top users | synonyms

0
votes
1answer
656 views

How to display content from external db with relevant urls

I am working on a website that needs to display information about electronic resources which is stored in an external database. This information will be presented three different ways (alphabetical ...
0
votes
3answers
654 views

change the year on all of my custom post types?

I need to change the published year on all of a custom post type from 2010, to 2011. What is the quickest way to do it? I have 200 entries, so manual would take hours!!
1
vote
1answer
659 views

Share DB tables between two blogs on the same WP Multisite installation

Is it possible for two separate blogs running on the same multisite installation to share tables in the database? By default, Wordpress adds the blog ID to the table prefix for all of the associated ...
0
votes
3answers
464 views

Using the same database on another Subdomain

Hi i am currently replacing my blog run on wordpress with another neat theme. I tried the preview template feature and everything is fine, just that i don't trust everything so easily when it comes ...
0
votes
2answers
355 views

Moving an entire wordpress site from one domain to a new domain and database

I have done all the steps requiered to import the dump.sql file to new database, and copiey the entire content from the old domain over to the new one. When i login to mydomain/wp-admin, i'm ...
1
vote
1answer
452 views

WordPress 'comment counts' got messed up, because of a plugin - DISQUS

I use wordpress and disqus plugin, when user add comment, after few minute, disqus agent will update wordpress database (wp_posts,wp_comments …etc),but when administrator delete comment, disqus will ...
6
votes
3answers
7k 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 ...
1
vote
2answers
2k views

“Error establishing a database connection” - Intermittent error on GoDaddy

After transferring a working WordPress site to GoDaddy hosting, we've begun getting "Error establishing a database connection" errors on all pages- first intermittently, and now consistently. It's ...
0
votes
2answers
229 views

Need help fixing sql syntax error after WP 3.2 upgrade

I'm using a plugin that failed after upgrade to wp3.2. The error log shows: WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server ...
0
votes
1answer
639 views

Getting WordPress to work inside a rails 3 application

I am migrating an existing WordPress blog into a subdirectory of a new rails 3 app (deployed on Apache2 / Ubuntu 10). I have PHP/MySQL installed, and I have a standard rails app folder structure in ...
6
votes
2answers
354 views

Does wpdb add considerable overhead on queries with large result sets?

I am working on backup-related plugin and from some research of existing plugins - they seem to favor using PHP's mysql_* functions, rather than $wpdb. Is $wpdb overhead considerable enough that it ...
2
votes
2answers
126 views

The revisions table in my database is at 70% capacity and growing. What should I do?

I installed the Wordpress System Health Plugin and it says that the revisions table in my database is at 70% capacity with 994 rows. I don't fully understand what this means. I anticipate that my ...
2
votes
2answers
217 views

How to diagnose and keep in check encoding issues?

What we have for a project is: multiple sites (production, test, local development); migrated by multiple methods (PHPMyAdmin, Navicat, BackupBuddy); And the issue we are having is that while ...
1
vote
2answers
145 views

All text disappeared (seems to be a database problem)

I have an issue with text in my posts. The site is http://2buntu.com. As I don't own the server, I cannot get direct access to some things. I don't know what caused it but I think it was a plugin I ...
4
votes
1answer
294 views

What is the most secure way to store post meta data in WP?

Sony's recent security "holes" showed how unsafe it can be to store data unencrypted. As some of you may know, I 'm working on re-releasing the free CRM theme Driftwood. What is the most secure way ...
0
votes
1answer
925 views

Switching database on the fly

I have read here about switching the current wp database on the fly using $wpdb->select('database_name'); Once done, I understand that i will have to issue the same statement to the original ...
1
vote
1answer
2k views

Insert post in another database

I have developed a custom script that uses wp_insert_post to create new posts, however i'd like to use similar code to create the same data in another wp database. Could be this done on the fly before ...
6
votes
2answers
791 views

Custom Post Types, or completely custom?

I'm currently in the process of redeveloping my website. I've decided to use WordPress as its CMS, rather than coding everything from scratch. It's a fishkeeping website, consisting of species ...
1
vote
1answer
42 views

Instead of submiting an entire post, is there any way to submit a lite-post or a simple message?

I was wondering if there is a way or a plugin to post something like twitter update messages instead of a post. Something like http://p2demo.wordpress.com/ but better, where a user will post update ...
3
votes
1answer
1k views

importing data from non-wordpress mysql db

I have created an import file to get the articles from a non-wordpress db and bring them in as posts in wordpress, I am not sure how to bring over the thumbnail image into my custom field I defined as ...
4
votes
2answers
3k views

Get posts by menu ID

I'm a little stuck here. I have a menu in Wordpress with some posts in it. What I would like is to retrieve all the posts as objects. I think I'm pretty close, but the SQL query doesn't seem to work ...
4
votes
6answers
10k 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 ...
2
votes
2answers
2k 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 (...
0
votes
1answer
3k views

Saving data to database and exporting to excel

I'm creating a form in a blog for users to register their emails so I can send a newsletter later but I don't want to use any newsletter plugin for that. I'd like to save the emails and than export ...
1
vote
2answers
2k views

Image upload appearing as broken images following server move

I've got the horrible task of moving a site from one hosting server to another and had no end of problems for DNS issues to temporary domain issues and FTP issues. However I've managed to install a ...
1
vote
3answers
113 views

How can I transition a site from using the Beta Tester plugin to a “normal” install?

I'm currently using the WordPress Beta Tester plugin on a site. Is there a "best" way to transition the site to a "normal" WordPress install? The plugin includes this notice: Please note: Once you ...
2
votes
1answer
68 views

prefix table and plugins

I changed my prefix of my tables from the wp_ to something else for security reasons and good practice etc. I was curious most of new plugins installed take on the new prefix but I have one that ...
1
vote
2answers
871 views

Wordpress doesn't show all posts in database

I have around 140 post in database but wordpress admin page shows just 50 post. How could I let wordpress shows all the posts in database? Thanks
1
vote
1answer
4k views

How to Mirror WordPress database from Remote server to Local server

Before I embark on this tutorial from the WordPress Codex on mirroring a WordPress database from a remote server to a local one. I'd like to get some feedback from SE users who have successfully ...
1
vote
2answers
38 views

What is this in my tables

Cleaning up my databases and I found this in my main table atpp_options perhaps from a plugin, anyone have any idea what it might be?
1
vote
2answers
829 views

delete post meta from db, even if does not exist?

it is not the first i see that we "delete" a post meta even if it does not exist : example : $count = get_post_meta($postID, $count_key, true); if($count==''){ $count = 0; ...
0
votes
2answers
872 views

Share users across multiple sites on same database, but with different domains

I am trying to implement a single sign-on solution between a Wordpress and a non-WP site, under different domains. I am aiming to setup a ghost WP install on the non_WP site domain, to be able to load ...
0
votes
2answers
84 views

Switched server & domain name, now custom post types won't save

I had the site on oldsite.com but was using the database at newsite.com, everything was working great. I moved the site to newsite.com, now when I try adding a new post using a custom post type, it ...
0
votes
1answer
373 views

Anyone know why wordpress converts some html entities to their numeric equivalents?

Does anyone know why wordpress converts some html entities to their numeric equivalents? I've found that in some posts, where a non-breaking space   entity would be appropriate, wordpress ...
0
votes
1answer
102 views

Your ideas on my though “delete or move all of the posts in a specific category when 3 days are passed”

I need to clean up my database and I think that a way to do and keep it that way is by deleting all posts that have 3 days of life. One good thing is that those posts I want to delete are in a ...
0
votes
1answer
916 views

How to use multiple check-box values to work in a function and insert values in database

I am working on a custom theme where there is option to upload images . I have certain check-boxes in the form which the users select as per where the image has to go. My form code is as follows : &...
0
votes
1answer
597 views

How do i edit the plugin files in DataBase via phpMyAdmin?

I need guidance to edit the WordPress plugin and theme files via phpmyadmin If I want to edit a particular plugin file or remove a plugin completely from database, I could able to find them ,but I ...
0
votes
1answer
487 views

How Can I Always Display A Particular Post First Using WP_Query?

My apologies if this question has already been asked somewhere else, I searched but couldn't find anything. I am working on a tours website, there will be individual package pages that show some text, ...
0
votes
1answer
286 views

Advantages of dbDelta

I understand its advantage for something which will be released in public, but does it do any good for a developer by saving efforts as the code evolves over time? Like right now, I am hardcoding the ...
0
votes
4answers
1k views

Can two domains use the same database?

I want to change a current site that already has a fairly robust database. Before I do, I want to test a few different layouts to make a decision. Instead of using the original site, I am thinking ...
2
votes
2answers
14k 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 ...
0
votes
1answer
143 views

Change the default data installed when setting up WordPress

Is there documentation somewhere on how to change the default data that is entered into the WordPress database when setting up a new database? I want to change the default category and add a couple ...
3
votes
1answer
198 views

Custom post type or just use custom fields

I am turning a restaurants website into a wordpress website to allow for the customer to take over content changes. The restaurant has a menu that has categories like Baskets with different types. For ...
3
votes
1answer
2k 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 ...
0
votes
1answer
52 views

Functions file mods and CPU

Will adding code similar to what I've pasted below to the functions.php theme file slow down a Wordpress site or effect CPU? (Thank You) function remove_menu_items() { global $menu; $restricted = ...
2
votes
1answer
719 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 ...
0
votes
1answer
141 views

More than one WordPress site using the same database - how to disable plugin for one site?

I am going to have two WordPress websites running off the same database, so that they both have the same products set (each post is a product) but they have different homepages, about us pages, etc. ...
0
votes
1answer
404 views

Help on conditional statement to accompany wp_insert_post function please?

I'm trying to programatically insert posts from an external MySQL database as posts on my wordpress blog, I've got something that works, but there is no way of wordpress checking to see if the post ...
0
votes
1answer
781 views

Why images are disappearing on WordPress web site?

I had this problem on 2 web sites (different versions of WP, different web hosts, different plugins), once in a while some images are disappearing from media library. Is it plugin-related issue, ...
1
vote
6answers
13k 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 ...