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

learn more… | top users | synonyms

0
votes
1answer
94 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
173 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
82 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
367 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
455 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
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
718 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
858 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
268 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
909 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
611 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
299 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
310 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
315 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
369 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
268 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
250 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
359 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
190 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
259 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
358 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
115 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
94 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
829 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
571 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
704 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
845 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
146 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
247 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
156 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
243 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
911 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 ...
13
votes
3answers
27k 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
250 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 ...