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

learn more… | top users | synonyms

0
votes
2answers
94 views

Is database deleted on clicking “reinstall” button in Wordpress updates?

I have a blog made with WordPress. If I click "Re-install" button present in WordPress updates page, will all the database be dropped and created again? Will my posts be deleted?
1
vote
1answer
52 views

Is it possible to create Custom Post plug-in?

I understand that Wordpress allows you to create Custom Post Types with Custom Fields, but is it possible to create a custom Plug-In that creates and maintains its own Custom Post type (outside of ...
0
votes
1answer
37 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 ...
1
vote
1answer
34 views

Is the wordpress user-model changed in wpmu?

I'm running wpmu on heroku using a postgres extension. It works great, but I have a plugin that needs to get the userId based on the e-mail-adress. This is how it does it: $sql = 'SELECT id FROM ' . ...
0
votes
1answer
122 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 ...
1
vote
1answer
313 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 ...
0
votes
0answers
95 views

Using Zoho Creator Database inside Wordpress Frame

Our agency network has an existing Wordpress-based website, and we would like to use Zoho Creator sort of like an intranet which is accessed through the Wordpress site. Basically, something along the ...
0
votes
1answer
345 views

Insert data in custom table during new post creation

I want to in insert data in my custom db table when creating a post. Suppose there are three categories (php, wordpress & jquery). When i create a post in wordpress, i want to insert post id and ...
0
votes
2answers
39 views

What is the best way to store a few fields?

I'm researching what it would take to develop a custom Wordpress plugin. The plugin is a pretty small one. We just need to persist 2 fields of integer information. It's a pretty basic progress bar ...
2
votes
1answer
100 views

Filter WordPress posts by between parameter

How to filter WordPress posts by a taxonomy and between parameter? Consider a mobile website with "memory size" taxonomy, I need to show posts that have more than 256 mb memory and less than 768 mb. ...
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
0answers
622 views

Host does not allow remote connection, so how do I transfer data to my WordPress site?

I spent the last week trying to get my PHP code on my website to connect to my remote "personal" computer to display some data on a webpage. I just found out today from my web host (ipage) "our ...
0
votes
0answers
328 views

Install WordPress with SQL database

I am very new to WordPress. I didn't even know it existed until I had to do it for my work. So I started in with a WAMP server with WordPress. That worked fine until we needed multiple sites with ...
1
vote
2answers
518 views

Error establishing database connection - high traffic?

I have a WordPress 3.5.1 site that's getting a little bit of traffic (80 concurrent visitors, ~5 clicks/pageviews per second). The site runs fine until it spikes to ~85 visitors. There are usually 4 ...
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. ...
0
votes
0answers
45 views

Create hundreds of users with just ID in phpMyAdmin

I'm trying to do the same as this post. But I have a problem with the insert records into your wp_users table containing all the ID's of the members you want to import Right now, I have 3 ...
0
votes
0answers
138 views

Custom query on Wordpress custom table

I am working with a custom table where some values will be inserted or updated if they already exists, I have checked and rechecked the syntax and it seems to be working fine, if I run the same query ...
1
vote
2answers
126 views

Where to store custom tagging data associated with a custom post type

My application allows users to add tags to an image (similar to facebook). Each tag can consist of up to 8 attributes and there is currently no limit on the amount of tags a user can add. At the ...
1
vote
1answer
609 views

Extend the wp_users table

I'd like to to extend the wp_users table in my WordPress' database. Why? I want people to add more information about themselves when they sing up at my website. I know how to extend it, but I'm ...
0
votes
1answer
32 views

Check in function on custom page

I have a website about places and attractions in my country. Each place/attraction is a different custom post. On this page, i would like to add a button with the value "Check In" and if clicked by a ...
0
votes
3answers
127 views

Fetch a single row from a custom table for to a given ID

When I want to get a single row from a custom table of my WordPress database by providing a username through function call, it does not work. When I mention the username in where clause of the query, ...
0
votes
1answer
173 views

Hook to be used when creating a database table

I read the Codex and some other tutorials describing the process of creating a new table for WordPress. I thing that the steps are pretty straightforward; however, I'm encountering a small problem. ...
0
votes
2answers
841 views

MySQL Syntax Error upon restoring database from backup

Performed a bad import to my Wordpress install and decided to restore from the mqSQL backup (full export) I had made minutes earlier. Dropped all tables in the database and then did an import from my ...
1
vote
1answer
89 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?
0
votes
0answers
49 views

MySQL Engine vs. Charset

I am attempting to have my plugin create a new table. I am fairly new to SQL. I have found two different method for creating tables: Method I $table_name = $wpdb->prefix . 'cool_table'; $sql = ...
0
votes
1answer
183 views

Creating Database Table vs. Adding MetaData to Post & User

I am creating some event functionality for my wordpress site. Each event will have a set of tickets associated with it. A user who is purchased at least one ticket will additionally have a set of ...
0
votes
1answer
473 views

PHP variable in WordPress database query

When running the following code : $voucher = 'MK0186'; $is_in_database = $wpdb->get_results( "SELECT * FROM my_codes_table WHERE code =" . $voucher ); I get : WordPress database error: [Unknown ...
0
votes
1answer
54 views

Database create or redirect

I am working on a site ABC.com, I have only access to the root folder. I am planning to install wordpress. I need to somehow create a database without any cPanel. or the second option that comes in ...
0
votes
0answers
181 views

How to add drop down sub menu from database fields in the particular menu slug

I am creating a menu(not in admin panel) in wordpress, and I want to add drop down menu from my database table fields in a particular menu slug? How can I achieve that, using code? I found the ...
2
votes
2answers
208 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 ...
0
votes
1answer
160 views

Query specific posts per user selections from dropdown menus

This may be a little different than most people do. I'm trying to show certain posts that are determined by 4 different "categories." I have a large database table full of "products" (I'm using the WP ...
0
votes
1answer
201 views

Import custom database into wp and keep the post id

Hello guys I have a project where I need to import an old database to wp but I need a solution to keep the old id's as posts id so i can make the links look the same as the old website in this way we ...
1
vote
2answers
184 views

Getting all the users who have author privilege

Can anyone tell me how to get all the users who have author privileges by querying the DB in WordPress and order them by number of posts written by them. I use the following query to get all the ...
3
votes
4answers
565 views

How many users can WordPress handle?

I want to design a member login site in WP but I have a doubt that is WordPress can handle more than 40000 users on same database? I am not sure about this so I am stooping my work here. So please ...
0
votes
1answer
39 views

Recommended Post Structure for DB Storage

I'm trying to write a plugin that would help my local little league manage their league, and though I've read the New Table vs Post Meta question, it's still a bit unclear and I'm hoping someone here ...
0
votes
1answer
56 views

Locking one blog of many in a multi user/blog Wordpress installation

I have a multi user /wordpress installation that is working fine. One of the blogs running on that multi user /wordpress installation will never be updated again but I want it there for historic ...
0
votes
1answer
353 views

Merging two wp_posts tables while avoiding duplicates

Is there a simple way to merge two wp_posts tables while avoiding duplicates?
0
votes
1answer
55 views

How safe is it to delete old posts edits to save database space?

After this question: http://wordpress.stackexchange.com/a/93902/27148 There is an answer that suggests deleting past edits directly from database, which would be nice, because I could create ...
-3
votes
1answer
85 views

Restrict users viewing post using age on database [closed]

Is there a way to have a birthday field on database then use the age to restrict viewing posts?
0
votes
1answer
172 views

accessing wordpress serialized data outside wp

I've never worked with serialized data... I need a little help with how to load "text" widgets title and content in php script outside wordpress... my script just connects to database (including ...
0
votes
1answer
75 views

“sufficient permissions” error for admin after duplicating WP database to new install

I recently copied the tables from a live WP install to a dev site for that same site. I've changed all the prefixes, the site/WP URLs, and the salt values. I can successfully log into the new dev ...
4
votes
1answer
126 views

Where can I find the database changes between WordPress versions?

Given vX and vX+1, how do I find the difference between each versions database schema?
0
votes
1answer
29 views

What is best for saving lot of extra detail of user?

In my site i need to store 200 extra data for each user. Now i know about the user meta option. But is it a good way to save 200extra field for each user? Or should i create an extra table in the ...
0
votes
1answer
72 views

Get the url of attachments from the post?

I used the following code to get the images attached to a post $current_id = get_the_ID(); $rows = $wpdb->get_results("select guid from $wpdb->posts where post_parent = $current_id"); ...
0
votes
1answer
59 views

Specify strict 'order by' in WordPress query

I have a custom post type called Employees where an employee's name is the post_title of each post. I am trying to figure out how I would sort the post_title column by last name. So for instance, if ...
0
votes
2answers
281 views

Import External XML

I don't know where to start with this one. I would like to create custom post type which will list properties on clients website. I would like those properties being feed from another ...
1
vote
1answer
353 views

Lost administrator privileges and can't find a fix

WordPress 3.5.1 Web Host: Windows Azure Cloud Database Host: Cleardb Web Server: IIS 7.5 I've built a custom child theme that runs on the Genesis Framework and it has multiple custom post types ...
0
votes
1answer
50 views

Designing a custom post type with a minimum number of meta fields

I am new to PHP, mySQL and scripting in general. I'm trying to design a WP custom post type which would be like a point on a timeline or an item on a resume. I'm having trouble designing the structure ...
1
vote
1answer
5k views

Insert data in database using form

I am writing a simple plugin that create a table with name "newsletter" in database and provide a shortcode to put a registration form in pages. the form contain "name" and "email". i have problem ...
0
votes
3answers
537 views

Insert Extra fields added in the front end registration form to DB

I have added some extra fields like first_name,middle name,last_name etc into the custom registration form. I want to add those details int the DB also. Now only username,email,Display name and ...