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

learn more… | top users | synonyms

0
votes
1answer
24 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 = ...
1
vote
2answers
68 views

Optimising a big Wordpress site

I'm looking at optimising a rather large site I've been adding to and adding to. The database has become pretty big (maybe 100,000 posts) and it has started slowing down somewhat and giving me "Mysql ...
0
votes
0answers
68 views

Submit password to Ushahidi Platform using gform_after_submission

OK basically I run Wordpress as CMS and Ushahidi for collecting information from different area. All I want is a registration form that send data to 2 different platform. I used Gravity Form ...
0
votes
1answer
104 views

Creating Tables in WordPress Database

I'm planning to make a database for my wordpress website. It is to store (and retrieve) information about the products the members want to sell. As far as i understand, i have to make the tables in ...
0
votes
1answer
98 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 ...
3
votes
1answer
85 views

Can I explicitly specify ENGINE=InnoDB in Wordpress?

I converted all my tables to InnoDB, but the MySQL server (which I can't access, as I'm on shared hosting) has MyISAM as the default, so every new table that Wordpress creates (e.g. when I add a new ...
0
votes
2answers
201 views

Safest way to bulk delete post revisions

One of my clients is on a rather large blog in terms of number of posts and traffic. I'm trying to get her database down to a manageable size, and one thing that's bulking up is literally tens of ...
0
votes
0answers
35 views

Calling update_user_meta inside of another function doesn't work

I have a function that does updates a db outside of wordpress and then I'd like it to take that information and update the user_meta table in wordpress. The print statement prints all the appropriate ...
1
vote
0answers
130 views

Wordpress running SQL query to update database from form

Basically I want to take information in from a form and use a separate php page to update the database. so here is the original wordpress php page (add_person.php): <?php /* Template Name: ...
0
votes
0answers
47 views

I broke database after reuploading local version - what exactly happened? Database error

The site was already working but since I wanted to change the website more and my Internet is not good right now, I decided to download the whole wp folder to local drive, and export database. I set ...
0
votes
1answer
88 views

Is altering a default WordPress database table update safe?

I want to add some table columns to the wp_terms table. Is it safe to use the dbDelta function with a modified CREATE-MySQL query for this? Or will I run into problems in the long turn? Is it update ...
0
votes
0answers
82 views

Passing user first and last names from external db to WordPress user first and last names using session variables?

This may be a little convoluted, but here it goes. I don't let users register on WordPress to access my member site. I have an outside registration/login system set up and want to continue using ...
0
votes
2answers
91 views

Share WordPress Database

Does the WordPress installation has to use an exclusive database? I'm building a website with custom pages, that access a MySQL database. But the site will also have a WordPress installation. Can I ...
1
vote
1answer
726 views

How to create database table, add data, update and delete using wpdb via plugins?

I am just starting out to create plugins with database. I know to create a custom database when activating the plugin. I just want to know whether we can create tables at the front end like adding the ...
0
votes
0answers
24 views

What are the minimum database privileges to run WP? [duplicate]

In my current installation, the DB user has been granted full privileges. I am pretty sure that not all of them are required to run WP, but I am not sure which privileges are definitely needed. ...
0
votes
1answer
33 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
284 views

Post data in wp-admin to external database

I am trying to make a private form to submit data into an external database so that I can later pull from the database and display the records on a page. So far I have been trying to create a plugin ...
0
votes
0answers
48 views

Update members data daily by a function

I use a function to update data (likes, +1, views, point, posts..v.v.) for all members on site Once Daily. So it may be can not run with >2000 members and >5000 posts. Only display a blank page. The ...
0
votes
1answer
109 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 ...
1
vote
0answers
129 views

Create custom column in post table in wordpress

I want to add two custom field to table wp_posts, and that I need for my plugin. now to enable these fields I have changed core file of wordpress wordpress/wp-admin/post.php $data = compact( array( ...
0
votes
1answer
112 views

Database Update Required - Update from command-line

I just did upgrade my wordpress subtree of my website to the 3.6 branch and now the site tells me that I need to upgrade my database as well: Database Update Required Nothing special so far, ...
0
votes
0answers
99 views

Import Excel (or csv) Table with user-data as subscribers to wordpress

i have a tough problem. From an existing database with user-data I need to transfer those users as subscribers to my wordpress database. My user-profiles have various additional custom fields that I ...
0
votes
1answer
43 views

Having problem creating local instance of wordpress site

I am trying to make a copy of a wordpress site on my webhost on my local computer. I am using EasyPHP. I downloaded all of the files within content and added them to a folder within ...
0
votes
0answers
262 views

How I Save Value Created In My Dynamic Custom Meta Box Form

So, I have successfully created my dynamic custom meta box that can add and remove form field using jquery, but I have no idea on how to save its entered data and retrieve it in the front end. Have ...
0
votes
0answers
31 views

Automatic add record after refreshing page

I have on page only this code: get_header(); global $title; global $wpdb; global $current_user; if ( 0 == $current_user->ID ) { } else { } ...
4
votes
0answers
200 views

WordPress database error: [Query was empty] [closed]

I'm using $wpdb to connect to a different database than my WordPress one like this: $newdb = new wpdb(DB_NEW_USER, DB_NEW_PASSWORD, DB_NEW_NAME, DB_NEW_HOST); I need to insert multiple rows into ...
0
votes
1answer
42 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
91 views

How do I convert all custom_field php timestamps in the database to js timestamps?

For the past year, we've been storing date-time values into a custom field _date using strtotime(). There are about 100 PHP date-time stamps in our database from over the past year. I would really ...
1
vote
2answers
514 views

Installed domain-based Multisite but can't access wp-admin (redirect loop)

I've installed a domain-based Multisite on my server, and everything works including each of the subdomains. Here I should explain that I imported a Database that was on my Local Mac, and then changed ...
0
votes
0answers
22 views

signup to one site and get access to all affiliate sites

Currently i am using WP network for my multi-site blog, but i am a tutorial site just like Tuts+ (not that much good, but a little). I want to know the performance issues regarding 1. single WP ...
0
votes
1answer
101 views

Accidentally deleted active_plugins portion of the wp_options DB table

Ok, so I'm pretty sure I'm screwed here, because I do not have a database backup, but I figured I'd ask just in case. Within PhpMyAdmin, I meant to just go to the wp_options table and empty out ...
0
votes
0answers
109 views

WordPress 3.6 generating empty database

I wanted to migrate my local WordPress i use for theme development to 3.6, but the generated tables in the database are empty. WordPress creates all tables, but only wp_options is being filled, but ...
0
votes
1answer
38 views

Changing database links has no effect

So I just moved my website from localhost (127.0.0.1/wordpress) to a server. I followed many tutorials and I managed to get the site going. The home page loads, the content is there, however, subpages ...
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 ...
2
votes
1answer
744 views

Database sync between local and production

I was watching Mark Jaquith's presentation at WCSF 2013 recently and in the Q&A Mark mentioned something about rsync - after a quick Google I can see this is done via SSH - my question is this: is ...
4
votes
2answers
100 views

Presentation vs Content in WP DB-Tables

Presentation vs Content in WP DB-Tables Is there a clean separation between the WP tables involved with presentation vs content? I would like to take my time working up presentation changes, such ...
0
votes
1answer
157 views

A change in URL slug in database returns 404, how can I do auto-redirect?

I have a huge blog with over 10K posts and a lot of posts with some adult keywords in titles, urls, content and tags. I am trying to remove all adult ones with "search and replace" plugin. It works ...
1
vote
1answer
61 views

Can't update old posts 3.5.2

Background: I'm working on a customers site that I haven't build myself. The site works pretty ok, when I got it the wp_header and wp_footer was missing and the javascript files were all linked to ...
1
vote
1answer
26 views

For best DB performance should I serialize all theme options together or by type?

If my theme has a lot of options is it better to store all options in one database entry, or to use a databse entry for each group of options? IE would I name all options like this ...
2
votes
1answer
67 views

$wpdb->update has finished saving trigger?

I have a custom table that I am updating via wp_ajax action. I am inserting a row and inserting all of the values other than id which is an AUTO_INCREMENT. I have an ajax response that creates a new ...
0
votes
1answer
33 views

Wordpress SQL - How to Check for Category?

I'm using the following SQL (wrapped in php) to find posts in a wordpress database: $sql = " SELECT p.* FROM {$wpdb->prefix}most_popular mp INNER JOIN ...
0
votes
1answer
162 views

Query multiple tables at once?

I want to query all of the posts in my WordPress multi-site set-up looking for a certain string. This is only being done in Sequel Pro (on the command line) for my own inquisitive purposes but there ...
0
votes
1answer
53 views

Is it good practice to import/export a blog to test a redesign?

I am working on redesigning a fairly high profile blog. I suggested the best way to do that, rather than mockups, is to just upload their wordpress export to a new WP install on domain. That way ...
0
votes
1answer
26 views

Using class id from array for query

I'm using Event Calendar 3. Since there seems to be no easy way of querying all upcoming events as posts, I tried it this way, getting the IDs from the DB and querying the posts from that: <?php ...
0
votes
1answer
20 views

Copying blog from root to /folder (Not moving)

Here is the scenario - I want to COPY (not move) the blog from www.domain_name.com/ to www.domain_name.com/folder... I want to keep the copy in root folder intact but run the same blog on subdomain ...
0
votes
0answers
151 views

theme option, jquery isotope set different element size for each post

I use jquery isotope to display posts and custom posts. I want to add in the admin panel, options that allow to choose isotope element sizes. For example, in this panel, I will show all posts and a ...
0
votes
0answers
19 views

Wordpress database tables crashing frequntly

For my site www.placementmantra.in, I am experiencing twice-daily table crashes, mainly wp_posts. I tried disabling all plugins, but the problem persists. Any suggestions?
2
votes
1answer
162 views

how to show database content in wordpress post

I'm a beginner for WordPress. I have a database app written in PHP and MySQL and I need to convert it to WordPress and also I what to post the database rows info by shortcode were id="x" like: ...
0
votes
2answers
686 views

Inserting into data into external DB using WPDB

I'm trying to work with an external db in Wordpress for the first time and can't seem to get it to insert the data into the DB. Here's what I have: <?php global $wpdb; $url = ...
0
votes
0answers
44 views

Getting deleted users in database

I am using the database that is being used by a WordPress site. I am trying to get all the users from wp_users table with SQL query. But there is also previously deleted users in wp_users table. I ...