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

learn more… | top users | synonyms

1
vote
1answer
438 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
10k 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
697 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
817 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
62 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
258 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
859 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
2k 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
595 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
296 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
302 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
301 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
345 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
264 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
41 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
248 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
357 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 ...
0
votes
1answer
186 views

Add Default Wordpress Formatting To Data From External SQL Tables?

I have a number of external SQL tables that have data in exactly the way I want and I would like to use them to populate various wordpress posts with shortcodes. The problem is that I don't ...
0
votes
2answers
95 views

Your thoughts on the interaction with one custom database table from WP?

Short version: Step 1/ i am using contact form 7 to collect some user data and i insert the data into a custom database table. Step 2/ only the custom table needs to be altered/updated. In fact at ...
0
votes
1answer
254 views

Custom Post Type or Custom Tables

I am in the process of writing a plugin that allows end-users to submit a form that includes customer information. Upon submission, I am notified that a new customer has submitted the request form. ...
1
vote
1answer
355 views

Saving into post_excerpt or post_content

When importing a feed into a custom post type does it make any difference if I store the feed description in the post_excerpt field versus the post_content field? Is there some processing that gets ...
1
vote
0answers
114 views

Multisite 404 on pages - rewrite error breaks database

After updating my reading settings on my multisites, I get 404 errors on all my pages. The only way to fix the issue is by reverting the database to previous version, that is the only way it can be ...
0
votes
1answer
92 views

DB access blocked when initializing WP externally

I have an odd problem I'm hoping the group can help with. The problem is this: I have a few situations where I load the Wordpress environment without the overhead of the GUI (details) I am able to ...
4
votes
7answers
4k views

How to move existing Wordpress wp-content folder along with database to new server and new domain name?

Running WP 3.5.1 on a LEMP stack (over at Linode) ... I have a wp-content folder for a WP site along with a full backup of the database. The URL of the site was something like: ...
0
votes
1answer
794 views

Get value form wordpress database

I'm sorry if this ambiguous but I'll try my best I have the following php code from a WordPress Plugin $url = 'http://mydomain.com/'.$ListingID.'/'; I need to define a value for $ListingID The ...
2
votes
1answer
90 views

What is the easiest way to implement cascading database upgrade for my plugin?

Lets assume following situation: I develop a plugin. The plugin requires custom database table to store some kind of information. From month to month I release new versions of my plugin. Different ...
0
votes
1answer
541 views

How to back-up a database on IIS

I've been having trouble finding a good tutorial on how to back-up a WordPress database using IIS as the web server. I installed WordPress using IIS's web platform installer and now I can't even find ...
2
votes
2answers
700 views

The plugin generated x characters of unexpected output, $wpdb not defined

I've written a simple Wordpress plugin to create a new database table. The new table ought to be created when the plugin is activated. When I try to activate the plugin, I get the following error: ...
4
votes
3answers
829 views

How might I retrieve a featured post image from an external WP site and display it as a link back?

I have two WP sites. I want to reach from one of them, into the other, and retrieve specific featured images for posts, and display them with a link to that post. I am using this line (with the ...
0
votes
1answer
141 views

Saving zero as meta value

I have a meta_key called "_ordre" and each time I create a new custom post, a new meta_value is set for that meta_key. The thing is, when I set the value of '_ordre' to 0, the meta_value is not saved ...
3
votes
4answers
2k views

How to run Two Wordpress blogs with different themes and with single database and same content

How do you run two Wordpress blogs with different themes using one database where the content remains the same in both sites? The issue that I am getting is at the Domain mapping in both blogs.
1
vote
1answer
245 views

How can I create a Bible search engine via WordPress? [closed]

I have some translations of Bible in Turkish language. But, they are as of books. (Matthew, Mark, Luke, John... ) I uploaded them into a website which is being managed by a wordpress software. ...
0
votes
1answer
87 views

Accessing + retrieving custom database in WordPress

I am looking for something really simple(?). I am using WordPress as a CMS. I created a new page in which I added a form (questionnaire). Inside WordPress' database (the same database in which all ...
0
votes
1answer
155 views

Change taxonomy slug in database

I am using Events Calendar Pro and due to a bug multiple Venue taxonomies were created. For example, I have museum, museum-2, etc. I would like to delete the duplicates but assign the event associated ...
3
votes
1answer
240 views

Plugin Not Working, But Only On GoDaddy Hosted site

I'm creating a plugin for a friend to log search terms on his site. It's very basic. It creates a new table to store terms entered in the search box. It converts the search term to lower case, ...
3
votes
1answer
890 views

Wordpress admin never finishes saving page on site with large page count

I have a Wordpress install with a very large amount of pages (a few hundred thousand), and over time it has gotten to the point where editing a page takes an extremely long amount of time. It would ...
11
votes
3answers
26k views

How do I show data from gravity forms in my template? [closed]

Preface I've installed gravity forms, created a form and users are submitting data to my site. What I want to do is show the data users are submitting to my site on one of my pages. I know there's ...
1
vote
1answer
241 views

Migrating from PDO using SQLite to clean new install using MySQL

I've been using PDO plugin for wordpress and SQLite database. It does not work as expected so I want to use MySQL database, but without PDO for Wordpress since I cannot trust that plugin anymore, It ...
0
votes
1answer
127 views

Inserting into WP DB

I had initially asked a question based on my code (which has since been removed), I need some help/guidance in creating a plugin. Scenario: I have created a custom post type (CPT), now I need to ...
0
votes
1answer
2k views

$wpdb error (Call to a member function insert() on a non-object)

I have very few knowledge on oo php and databases, and I am simply trying to insert data in my wp_pagesvisites table but I am having some trouble with this error message. This is my script: ...
-1
votes
4answers
671 views

Insert into db with foreach problem

I have no idea why this foreach it`s not running. When i post the article, only inserts once. Should make it at much as needed. Do you see any problem? $array_produse = array(); for($i=1; $i<=8; ...
1
vote
1answer
2k views

How to update BuddyPress xprofile fields programmatically? [closed]

I update user info using wp_update_user function. I also need to update the table wp_bp_xprofile_data. Is there any function, where I can update data on wp_bp_xprofile_data table?
3
votes
1answer
521 views

BuddyPress: What's the use of wp_bp_xprofile_data table and how does it get updated? [closed]

I have a questions related to BuddyPress: What's the use of wp_bp_xprofile_data table? How does the data in the table get updated? And when any user updates his information - does the data in this ...
2
votes
2answers
210 views

Relationship between performance and database size

What's the relationship between performance and database size in WordPress? Does a bigger DB mean that my site will be slower? My DB size is currently 360mb. I also noticed that I have some tables ...
5
votes
1answer
170 views

Performance Gains of Relational DB Setup

Our team is working on the 3rd of large WP sites for a client, and contrary to most "typical" WordPress setups, our projects are generally experience lots of requests, data pulls, and general content ...