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

learn more… | top users | synonyms

0
votes
1answer
367 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
828 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
572 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
453 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
284 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
2answers
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
660 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
402 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
724 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
11k 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
204 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
285 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
645 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
155 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
793 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
3k 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 ...
15
votes
3answers
3k 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
724 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
597 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
253 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
759 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?
5
votes
2answers
6k views

Checking if Database Table exists

I read the wordpress codex and professional wordpress. It seems both use something like if($wpdb->get_var("SHOW TABLES LIKE '$table_name'") != $table_name) { to determine if the table exists. Is ...
0
votes
3answers
627 views

Site does not work right, pages not showing up, even for root admin

I have a problem. My database server isn't working right. On a wiki, it gives an error, and on my wordpress site, the pages don't show up. I am wondering if WordPress caches the DB data in any way, ...
1
vote
1answer
1k views

Call to undefined function get_user_meta() - trying to access data in MySQL from custom fields

I am trying to access data from some custom fileds in my MySQL db so that I can add them to a webpage that will be printed out. The data is held in a column called "paypal_user" and I need to access ...
2
votes
1answer
2k views

Split WP install between 2 databases?

Is it possible for Wordpress to work from two databases? The reason I ask is that we're approaching our 100mb limit for database size on our host (1and1) but have up to 100 databases, so what I was ...
0
votes
1answer
491 views

Wordpress and MySQL: trying to print data using PHP from user_meta custom field data

I have some custom user_meta fields in my MySQL database. The data is stored in my DB as follows: the meta_key is called "paypal_user" and the info is stored in the meta_value column as: ...
0
votes
2answers
144 views

Need help restoring my Wordpress blog

I installed wp-cache to help with site speed. Shortly afterward, I was unable to access the site. Included below are the browser errors I receive. The site is hosted by GoDaddy. I asked them to ...
1
vote
4answers
4k 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( ) ...
10
votes
2answers
6k views

Wordpress Database Slow - should I switch to InnoDB?

I have a WordPress site with well over 10k posts, and things are starting to get very slow whenever I am adding and editing posts. Pages load nice and fast for users, along with the admin lists of ...
2
votes
3answers
367 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 ...
0
votes
1answer
636 views

Is there an easy way of exporting posts with their category already asigned and pictures from localhost?

Every time I export a database using the Export Tool in wp-admin. There are two things left out: The category 'checked' (I have to do that all over again every time I export the posts). Also I can't ...
1
vote
3answers
3k 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 ...
0
votes
3answers
912 views

How to find if a post with custom_field == X exists?

I need to find if a post with a custom field X equal to Y exists in a wordpress installation. Should I do it with a simple sql query or is there something build in that can help me achieve it?
0
votes
1answer
889 views

Connect to another WP install and grab post based on custom field

This is the set up: Two separate wordpress installs on two separate domains (not multi-site) This is what I want to do Query the posts from database one based on custom field and display them on the ...