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

learn more… | top users | synonyms

0
votes
1answer
20 views

Importing posts from old website to new conflicting post ID's?

I am wondering when I am importing posts from my old site into my new website, which has already some posts in it. Do the imported posts get a new ID or do they overrule the existing posts ID's?
0
votes
1answer
14 views

How to change the publishing date of each posts?

I need to set the publishing date of many posts with the post date (the creation date). I know that I can do it editing the single post and changing the Published on value but this procedure is ...
0
votes
1answer
19 views

How to pass username into form that sends data to database

I am trying to pass username to database through form: [insert_php] $current_user= wp_get_current_user(); $id= $current_user->user_login; [/insert_php] <input type="hidden" name="id" ...
0
votes
1answer
35 views

Is saving multiple options or saving multiple items in one option better?

I have added multiple fields to a custom taxonomy. I followed Pippin's tutorial. This method creates a single option per taxonomy item. The multiple fields are saved in taxonomy_id. I was not sure ...
0
votes
1answer
29 views

Is it possible to share WP database over Dropbox?

I'm developing WordPress themes on multiple machines right now: Windows & XAMPP, MAC + MAMP My themes are shared on Dropbox and are prefectly synced between all these machines (don't worry, ...
0
votes
1answer
17 views

Database of names with search engine

Hi I'm interested in creating website with a database of names and a search engine that finds matches for queries and displaying the full record for the relevant field. I would like to know how I ...
0
votes
1answer
30 views

$wpdb doesn't like to store arrays

I'm attempting to store an array that looks like the one below, into a cell in a database using the code below the sample array. Unfortunately, WordPress doesn't seem to want to save it, and ...
0
votes
1answer
25 views

Pulling values from a sepcific row in table

I'm trying to get the first and last name values for ONE person in a database where the meet certain conditions of being a team leader and having a specific project id. Because of this, it will always ...
0
votes
1answer
26 views

wpdb->insert adds too many rows

I have the following code in my functions.php $ar = array( 'price_content' => 'hello' ); $result = $wpdb->insert('hs_prices', $ar); // insert 'hello' into 'price_content' This should ...
0
votes
1answer
25 views

How are terms connected with posts in database?

In a multi-site environment, I have a special need to get post terms (on a custom taxonomy) without the expensive operation of "switching blogs". I thought I might write my own query to get terms ...
0
votes
1answer
32 views

Extra field in wp_post instead of postmeta

Is there any advantage in terms of query performance, if I add an extra fields in wp_posts table, instead of using postmeta? I have already searched for these reasons, but without success.
0
votes
1answer
540 views

Error establishing a database connection - when running multiple wordpress sites locally

Initially I was using MAMP and had only 1 wordpress site running locally on my Mac. I've set: document root to: documents/mywebsites/mysite1 In phpMyAdmin I created a DB called: mysite1 wp-config ...
0
votes
1answer
98 views

Display single post inside accordion based on form submission results

*Note - for full background see previous question here: http://bit.ly/1gaF673 Ok, so after fixing the problem above and a couple of issues that followed. My form submission returns the results I ...
0
votes
1answer
31 views

Cannot update custom database table row

I am trying to update a row in a custom database table by $wpdb->update();. In my opinion my code is right but for some reason my database row doesn't update. Can anyone help me with this? I want ...
0
votes
1answer
28 views

How to add data from wordpress tables to new database tables you have created

I'm just learning this database stuff and so I am a bit confused and was hoping someone could push me in the right direction. I have managed to create users in the wp_tables I have created in my ...
0
votes
1answer
82 views

How Do I Delete WordPress Posts Older Than 400 Days, From A WordPress Category

I have tried the following phpMyAdmin query in an effort to delete all posts, from wordpress category 378, that are over 400 days old. delete a,b,c,d FROM wp_posts a LEFT JOIN wp_term_relationships b ...
0
votes
1answer
58 views

How to set search query for joining two tables in sql?

What's the wrong with this query? SELECT l.company_name,DISTINCT c.sub_cat_name FROM tbl_listing l,tbl_sub_category c WHERE l.company_name LIKE '%cy%' and l.city_id='2' and l.area_id=23 ORDER BY ...
0
votes
1answer
81 views

How Do I Merge Categories With phpMyAdmin

I tried the following phpMyAdmin query to merge my category 112747 into my category 112748: UPDATE wp_term_relationships SET term_taxonomy_id = 112747 WHERE term_taxonomy_id = 112748; It did not ...
0
votes
1answer
70 views

single.php not pulling in any data from database

My single.php doesnt seem to be fulling any information through from the database for the current post. here is my single.php code: <?php get_header(); ?> <div class="main-container"> ...
0
votes
1answer
421 views

wpdb->insert multiple record at once

So after I have created the table 'settings-table' i want to add a couple of records to it. This is how I want to do it, not the best way, so I need a better way to do this because I will add more ...
0
votes
1answer
52 views

Searchable database of members using multiple criteria / filters

I'm very new to wp let's say that first! What I need is to create a site which will list a database of members of an organisation. Users will also be able to sign-up and add themselves to the ...
0
votes
1answer
26 views

Changing starting number of User ID

I've got a client who would like their online user registration to match their current database. Thus they'd like their wordpress sign ups to start with 00100, I can't seem to find a plugin that ...
0
votes
1answer
21 views

WP Posts Not Adding Up

My WP is hosted at Yahoo I am running WP 3.5.2 and the Posts Page does not add up All (4,356) | Published (629) | Sticky (1) | Drafts (265) | Private (88) WP seems to have an extra 3373 posts. I ...
0
votes
1answer
80 views

Using custom post types WordPress network

Working on a project I am setting up a WordPress network containing sites/blogs for small shops. I would like to use 2 custom post types in the following way: A location post type; The blog admin can ...
0
votes
1answer
52 views

Size article thumbnails and retrieve them directly from database

I've integrated the Wordpress database directly with my .NET application. What I want is to set the featured image of a post. This featured image must be maximum 800pixels wide, and automatically ...
0
votes
1answer
49 views

How to change images size after theme modification?

The images in the previous theme were using a height and width listed in the source html. The new theme will resize the images using percentages, so I need to remove all the height and width in the ...
0
votes
1answer
61 views

Getting data from a table using a query

I’m starting with WordPress and I have a lot of problems and doubts. I’m trying to display on a page data stored in a table of my database. I have a table named Customers (id, name, surname, phone). ...
0
votes
1answer
18 views

custom post type for custom talbe

Where would I start if I want to have a custom post created each time data was submitted from a form on the front page for non-logged in users? I have the script set up to send the data to a custom ...
0
votes
1answer
162 views

How to fetch records from database WordPress

index.php: <?php $new=$wpdb->query("select * from wp_posts where post_title='Auto Draft'"); $new1=mysql_fetch_row($new); echo $new1[0]; ?> How to fetch record from database? How ...
0
votes
1answer
129 views

Get content from other database table based on an ID and rewrite URL

I am currently using WordPress with SEO friendly permalinks. One page of my website is a special one though, let's call it http://example.org/locales. It is using a custom page template that loads ...
0
votes
1answer
62 views

Sub-domain or 2nd, temporary different domain?

I'm developing a Wordpress site for a website that already exists (that's not currently using Wordpress). The current website cannot be taken down until the new Wordpress site is ready to replace it. ...
0
votes
1answer
82 views

import (migration) user database to wp-users

I am having hard time for importing to user-meta and post-meta from my non-wp-tables. I am trying to do db migration from user table and post table to WordPress tables. So it might be user table ...
0
votes
1answer
86 views

Comments broken. All comments gone & no new comments can be made. Possible jetpack issue?

So, my client has two self hosted wordpress blogs- one long-existing and one new one that she just launched. She clicked on a jetpack activation link- meant to connect her new blog to it's ...
0
votes
1answer
95 views

Database location in Wordpress

I have created my website in WordPress and want to transfert it in my domain created with ipage. I am not able to locate the WordPress database. Can you help me? How is the format or extention of DB ...
0
votes
1answer
154 views

delete duplicate meta_value with same post_id

I've trying to cut down on the time to query a custom post type. After looking at the database and the wp_postmeta table, for some reason, there is some duplicate meta values for the same post_id and ...
0
votes
1answer
71 views

Copy site on same server?

I have a wordpress installation running in my root folder, and I want a copy in /en (including theme, posts and pages). I want a bilingual site and found the plugins too complicated for me - so I ...
0
votes
1answer
27 views

How to find an option in the database?

As far as I can tell, the plugin that I'm using is saving options to the wp_options file: ### New global settings container, will eventually be the only one! $cformsSettings = ...
0
votes
1answer
166 views

Displaying BLOB PDF File

I have some pdf files that are stored in the wordpress database as a blob and I need to display these files. The files are not linked to any posts directly. The code I have currently is: <div ...
0
votes
1answer
37 views

Working local with one database

We are working with GIT while development but keep sending each other database exports. I would like to use one database on a development server (as suggested to be the easiest solution on Keeping WP ...
0
votes
1answer
127 views

“Database error” with Posts 2 Posts plugin: conflict with nextGEN gallery plugin?

I'm using WP 3.6 and Posts 2 Posts plugin 1.6.2. I have one main CPT called 'participant' which is connected to 2 other CPTs called 'event' and 'group'. When viewing a particular 'participant' post, I ...
0
votes
1answer
50 views

Merging versions of wp_posts based on post_title

I have a live site and a backup/dev version of the site. For some reason (probably because I did an export from Moveable Type then moved everything from localhost to a live environment I had little ...
0
votes
1answer
27 views

Download stuff after filling fields?

is there a way to restrict a download, but if you fill your details get the file? I need to create a database with the names, mails, companies and phones for the people that want to download a ...
0
votes
1answer
58 views

Update references to pictures on website after moving to new URL

I moved my wordpress website to a new URL on the same server and managed to update most DB entries with the Velvet Blues Update URLs plugin. But the paths to my pictures, which are being used by the ...
0
votes
1answer
158 views

Second ezSQL initialization for MSSQL

We are trying to pull data from a second database into Wordpress. The secondary database is used internally to store data, and Wordpress (also only used internal) is partially used to display some of ...
0
votes
1answer
114 views

Where To Find bb_profile_data(); In bbPress?

I posted this same question on WP Forum, but it's completely dead. So, there is a great tutorial in this blog about showing post count in bbPress at this link. According to that article, to show ...
0
votes
1answer
137 views

Split WP_POST table based on post types

I was wondering if it's possible to get my posts from 2 databases depending on the post type. I'm using HyperDB but can't seem to get it to specify the database based on post type. I Basically need ...
0
votes
1answer
38 views

How do I find posts?

I am a new website administrator and I am having issues with posts not showing on dashboard. Posts All(21) Published (13) Pending (8). This is a listing site and the posts used to show up. Any ...
0
votes
1answer
124 views

WordPress database error Unknown column

I get this error in my database log: [05-May-2013 21:13:31 UTC] WordPress database error Unknown column 'region' in 'order clause' for query SELECT * FROM tmp1db_wpuf_customfields ORDER BY ...
0
votes
1answer
67 views

Print output of Table Creation

I am creating a few tables and I getting the following message: The plugin generated 440 characters of unexpected output during activation. If you notice “headers already sent” messages, ...
0
votes
1answer
133 views

Trying to post information from a remote database to wordpress page

I'm fairly new to Wordpress and looking for some help. Goal: I would like to stream data from my personal computer's Mysql database and display it on a webpage in my offsite Wordpress hosted site. ...