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

learn more… | top users | synonyms

1
vote
1answer
1k 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
34 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
316 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
258 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. ...
1
vote
2answers
2k views

MySQL Syntax Error upon restoring database from backup [closed]

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
125 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
57 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
232 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
934 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
68 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
291 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 ...
3
votes
2answers
301 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
209 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
293 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
389 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 ...
4
votes
5answers
1k 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
42 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
60 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
624 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
58 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
103 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
230 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
98 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
183 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
31 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
85 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
66 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
388 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
466 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
51 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
11k 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
742 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 ...
1
vote
1answer
911 views

Where would I find Custom menu attributes in the database?

In what table would I find the title of a custom menu in MySQL for Wordpress 3.5.x?
0
votes
2answers
65 views

Most efficient way of deleting post

I have a cron job set to remove a (sometimes large) number of posts from my database. Of course, I also need to remove all associated data such as custom fields. This is the function I'm currently ...
0
votes
1answer
279 views

SymmetricDS in dev + prod workflow?

Has anyone leveraged SymmetricDS in their development and production efforts so as to keep the environments synchronized? We have a number of WordPress sites that need to be kept in synch. In our ...
0
votes
1answer
85 views

WordPress Multisite platform for different city for single db

I have One WordPress Multisite installation. myplatform.com (Main platform) have custom post list for different city say city1, city2 & city3. Now What I want is on city1.myplatform.com (city1 ...
1
vote
1answer
963 views

Large database causes slow load

I have a 2GB WordPress database (using InnoDB Storage Engine) and I noticed my site loads slow when I press the publish button right after I selected a featured image in the media library. I had a ...
0
votes
1answer
3k views

wp_posts - guid update

Hello and please excuse if this has been answered before but we really need to make sure. We have developed a website under a domain of ours and then moved it to the live site of the client. We have ...
0
votes
1answer
647 views

Get a custom table to an array

How can I take my table I created like this: global $wpdb; //Get all the wordpress database stuff $table_prefix = $wpdb->base_prefix; //Get the global prefix for all sites (on a multisite ...
0
votes
1answer
43 views

Problem with menu categories doubling up when updating database?

I imported a database from a website to my localhost and the menu categories started doubling up. The wordpress dashboard is also missing my custom post types. How can I solve this?
-1
votes
1answer
303 views

Theme Options - localhost to new url

Im having this issue that happens to me each time i work on a website. On every project i start working locally and once im done i export my Database and search replace all localhost url's to the ...
0
votes
1answer
316 views

Fixing YARPP plugin FULLTEXT MySQL indexing

I just found out that the Yet Another Related Posts plugin (YARPP) uses FULLTEXT indexes on the wp-posts table, which greatly slows down sites with a large amount of posts. Can I can just delete the ...
2
votes
1answer
1k views

How to increase the character limit for post name of 200?

I have post name in Thai which uses UTF-8 character. Many of them encode into super long in ASCII e.g. วิธีการหลีกเลี่ยงข้อผิดพลาดทั้ง-8-ในชีวิตการแต่งงาน I've changed the type of "post_name" using ...
0
votes
1answer
337 views

How to modify post content?

I still haven't figured this out yet. Is this the right way? I tried $_POST['content'] = "nothing" and $_POST['content'] = 0 neither work for me. I'm using following way function changeContent() { ...
1
vote
1answer
388 views

Has parent field in the table wp_term_taxonomy has term_id or term_taxonomy_id

I have created a category "Book" with a sub category "comics", to check how wordpress is maintaining the hierarchy structure. When i check the table "wp_term_taxonomy", I found that such term with a ...
0
votes
1answer
282 views

How can I restrict php mail() to only send me one email after a db error

I'm in the process of customizing dp-error.php. I'm using the mail() function to alert me when there's a database connection problem on my website. The trouble is, what if 1000 people visit my website ...
1
vote
1answer
42 views

How to store an extra (surrogate) ID when creating a post with wp_insert_post?

I am generating posts based on rows from a table on an existing database. If a row in the database gets updated I will have to update the respective post. The proble is that I have to find the post ...
2
votes
2answers
1k views

How to modify post content before writing to database?

Hi~ I'm back again and I'm trying to add another function to the script I was working on a plugin that notify my friends of new post that mentions(@) them. Now I want to change the plain text of my ...
0
votes
1answer
254 views

Select From wpdb - Author/User Directory page

I am working on a wordpress site where I have created a directory page(authors.php) that lists all users and certain author meta. It works fine however I am trying to figure out how to only show ...
4
votes
1answer
362 views

Writing a plugin that notify my friends of new post that mentions(@) them

For example, I write a new post with content "Today I'm happy, because I finally met the girl that @David told me about bla blah..." Once the post is published, there should be an email notification ...