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

learn more… | top users | synonyms

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 ...
1
vote
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
867 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
812 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
866 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
908 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
588 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
477 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
285 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
13k 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
708 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
771 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 ...
-1
votes
1answer
205 views

custom post types containing a collection of items

i have a custom post type products.How can i add a collection of items to that custom post type like this: Product A title description price option1 option2 option3 option n Option items can be 0-n ...
3
votes
1answer
3k views

Not sure the best way to save custom plugin data

Doing my first plugin with 3.1 Everything is great, but I need to store the data now. My data is sufficiently complex that it requires custom tables (as opposed to options). So now I am wondering ...
0
votes
2answers
1k views

Importing Direct to DB - GUID Question

I've got a CSV file of new posts which I'll be importing straight into the database. Is it safe to give a GUID of http://domain/?p=[n] where [n] is any number, as long as it's not a duplicate of an ...
0
votes
2answers
290 views

WordPress as a data-store?

I would like to use WordPress to not only run my site, but also to manage users, handle authentication, and read/write content via a client application, but I would like to avoid writing everything ...
0
votes
1answer
659 views

Getting and calculating averge value of custom fields of the same tag

So basically i got this custom field value which is stored in $postrating - and under the database field customfield1. I want to grab the value of that field for all posts that have the tag currently ...
3
votes
2answers
4k views

How to delete outdated, wrongly sized images in _wp_attachment_metadata?

I've got several custom image sizes for my blog. One of these is setup as add_image_size( 'slide', 640, 290, true );. These are used in a header slideshow. My problem is I've upped the dimensions of ...
0
votes
1answer
2k views

Allow front end users to add data to a custom post type

Hay Guys , I'm currently making a plugin so that the administrator can manage "Subscriptions" to the website. I have made a custom post type and activated it within WordPress and only allowed the ...
1
vote
2answers
156 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 ...
0
votes
2answers
812 views

Remove “%” from strings in serialized arrays in wp_postmeta

In the course of converting a blog from Blogger to WP and running a script to grab hot-linked images for hosting, I ended up with some funky images names like act%252Bapandas-210x290.png These ...
3
votes
2answers
1k views

Is it a bad practice to go directly to the mysql database while developing a plugin?

This is a sample of the Vote it Up plugin: //Run this to create an entry for a post in the voting system. Will check if the post exists. If it doesn't, it will create an entry. function ...
4
votes
3answers
10k views

insert data in database table from plugin with WP3.1

I am quite new in WP Plugin World. I am trying to develop a plugin in WP 3.1 when I am trying to insert data into my table named "wp_enam" in the following way: $wpdb->insert($wpdb->enam, ...
0
votes
3answers
4k views

How to get nav_menu_item_id and slug from wp database

Hi WordPress Experts please help me i want to get nav_menu_item_id and slug from wp database by given a page template like (store.php) this a page template and how we can get nave menu item id and ...
0
votes
1answer
1k views

Changing permalinks back to default ( ?p=123 )

I have a site with about 900 pages that I was using custom permalinks /%year%/%monthnum%/%postname%/ for. I have a custom nav menu with tons of items in it. This combination seems to be simply too ...
17
votes
3answers
4k views

Multiple developers / editors working on a site in progress

Background I'm nearing the final stages of constructing my first fairly large WordPress site, and I'm now encountering some friction. For the most part, the site was developed on my local machine and ...
1
vote
1answer
749 views

Is it possible to split database tables using HyperDB?

I'm looking for an answer from someone who's implemented HyperDB or has knowledge of it. I have a database which has just passed the 100mb mark a week or so ago, the problem is my host only allows ...
1
vote
3answers
628 views

Faulty restore of the database, encoding issue

I messed up the settings with W3 Total Cache (tried to import all the media to my library, didn't work out well, broke all my links to every picture). So I took my latest backup of the database, ...
4
votes
3answers
2k views

Moving Wordpress to new server: no posts found

I have a weird problem with moving a Wordpress installation to a new server (just the server changes, domain remains the same, I'm currently accessing the site on the new server via the same domain ...
0
votes
1answer
254 views

Only allow user to access a link once a year, based on their joining date

I am using Wordpress to run a membership site, and one of the features is that members can download a badge. However, they are only allowed to download the badge once per year, starting form the date ...
3
votes
2answers
1k views

Migrating data between local and development server

I've been working away at a medium-size WordPress site. So far I've just been hosting the site on my local machine and showing it to internal consultants over our local network. Things are working ...
10
votes
1answer
766 views

How do I make an HTML table from a database table?

is there a built-in wordpress function to make the HTML or should I use plain-old PHP?