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

learn more… | top users | synonyms

1
vote
1answer
47 views

Does auto_load to 'no' in wp_options improve performance

I am trying to improve the performance of a wordpress based blog. I am looking at wp_options table and am thinking to set the column auto_load to 'no'. Does it have any side-effect on the site ...
1
vote
1answer
173 views

Query Wordpress database by registered date and role

I would like to get the display name and email address for all users who have registered to my multisite today with the role of subscriber. It needs to be an SQL query as it's used outside of the WP ...
1
vote
1answer
182 views

MS Access to manage WordPress Database

Now I don't believe this is practical or possible without a large amount of development. My client's old site used MS Access to manage the user's profiles on his old website. His new site uses ...
1
vote
1answer
273 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( ...
1
vote
1answer
161 views

How to use default WP form elements to interact with custom DB table?

I know about the use of Custom Post Types, but in this case I do need to use a custom database table (FYI: it's a table that is IP-based shared with another non-WP website). In wp-admin, I'd like to ...
1
vote
1answer
202 views

Importing Data from a Non-WordPress database, into WP

I'm migrating data from a totally different database style into WP. The main issue I'm trying to wrap my head around is how to import any meta data, given that WP uses a key value pair style for meta ...
1
vote
1answer
398 views

Wordpress choose wrong database

I have 2 databases. When I include the database connection (with a include('filename.php');) wordpress acts really strange. I can't login, the wordpress username and password is right but it tries to ...
1
vote
1answer
56 views

cross-site custom menu

i have a multisite whice i want to separate because its unneccery as two of my sites are on the same DATABASE and all i need is actually the dynamic custom menus which i have built in the main site(to ...
1
vote
1answer
73 views

how to migrate wpmu from one host to the other?

this issus is different fromm How to migrate wordpress users from one blog to another since i am using WPMU, i have backup the database, and then import it to the other host, also i have changed the ...
1
vote
1answer
100 views

page not updating with database

I have code which updates the database fine, but the page doesn't update correctly! I have to refresh the page a second time for it to update correctly. Here is the code below ...
0
votes
1answer
29 views

WordPress and SQL - Update and Insert from another table if column value doesn't exist

Stuck with some mysql for my wordpress site. All within 1 DB. I am attempting to update wp_options table from wp_2_options (Multisite). They both have option_name (unique_key) and option_value ...
0
votes
1answer
29 views

live site do not update after importing sql database

My live website is not updating after importing sql database from wamp local server until last time all went perfect but last night I was not able to see the changes live made in local. what I did: ...
0
votes
1answer
19 views

Transforming an wp_options database array into a javascript obect?

In my WP code I grab my options information as such $options = get_option("kaipo_plugin_options"); The array that I print out looks as follows ...
0
votes
1answer
17 views

Sending WordPress database information to cross domain the safe way?

I want to send my options and WP_user database information to my AWS server from my WP site's database. I heard using PHP'cURL is not recommended. I want a safe solution so please aid me in the right ...
0
votes
1answer
32 views

Media library images “missing” after migrating them using SQL

I am migrating a lot of posts from an old site to a new site, and these posts have a lot of Advanced Custom Field "relationship" data attached to them. Because of this, I want to keep all of the ids ...
0
votes
1answer
30 views

Use Tags to Query Associated Multiple Posts and Get The Average Of Custom Field Values

I have created a custom post type named “Rating” that I’m using to add customer rating sections to my website. Each rating post has the ability to have a: Title Comment section Featured Photo ...
0
votes
1answer
33 views

How to connect remote database in wordpress?

I have already wordpress website. i want split my existing database into two parts and store into remote database. So how can i set up remote database connection for existing wordpress ? If its not ...
0
votes
1answer
56 views

Sharing users across multiple sites, each on their own database

I have read many solutions out there for sharing users and checked out the other posts on here, but can't find specifically what I'm after, as they all talk about users on the same database. ...
0
votes
1answer
16 views

Split posts between databases

My client requested quite a specific solution for his WP based wordpress (single site, not multisite). Basically what he wants is, let's say after 1000 posts new database should be created (with 5 ...
0
votes
1answer
16 views

What Wordpress file is saving new users to database

I need to know, what Wordpress php file is saving new users to database. I can't find it, but I need to modify new users usernames before it's added to DB. Thank you!
0
votes
1answer
25 views

Converting Posts to Pages

So my site backend had issues and my hosting company had fixed it up for me. In doing that, they inadvertently made all my pages, posts. I'm looking at the database that hosts this and there is a ...
0
votes
1answer
19 views

Add several fields from different tables to post, fields per post are in same row of table

I like to add 4 or 5 extra fillout boxes to the adminpage of my post... For example, under the actual page box, I would like to add the following fields: Name position publications freetext Here ...
0
votes
1answer
82 views

Creating a search form and displaying results

Im trying to create a plugin for a site where the user can see a table of orders from customers in the Wordpress dashboard, It's a custom db but I'm using the wp-list-table, I've wrecked my brain for ...
0
votes
1answer
28 views

Widgets with *internal* links do not display after database migration

I am using Grunt to dump my local db, search and replace URLs in it (and account for serialization by using grunt-peach based on Peach), send it to my staging server, then import it into my staging ...
0
votes
1answer
78 views

Image thumbnails not available post migration, but still accessible via direct URL - DB issue

To start with, I'll just clarify that this appears to be a different issue to the numerous migration ones already covered. In short, I've migrated my site to a new domain (both in root, no directory ...
0
votes
1answer
26 views

How can I work on a database along side a client?

I was wondering what the best way would be to work on a database locally while a client is placing content into the database externally. My initial thought was to connect remotely to the database but ...
0
votes
1answer
28 views

Write mysql credentials in plugin

I've to create a custom plugin to print data from a database different from the wordpress one. I'm using wpdb. Is it fine, from a security point, to write database credantials in the plugin files in ...
0
votes
1answer
47 views

Doubt using $wpbd->get_col for a single column

$table = $wpdb->prefix . 'posts'; foreach ( $wpdb->get_col( "DESC " . $table, 0 ) as $column ){//get all columns from wp_posts echo "<div><p>". ...
0
votes
1answer
47 views

fastest replacement DB

What's the best database setup for WordPress for speed and lots of posts (hundred thousands of rows in posts and post_meta tables)? While I can cache as much as I can and optimize my queries/PHP as ...
0
votes
1answer
591 views

Retrieve and display data from custom db table in admin area?

So, i'm having a bit of an issue with a plugin i'm developing, I wonder if anyone can shed any light on the situation, as many, MANY searches have come back with zero help. :-/ Basically, my plugin ...
0
votes
1answer
68 views

MySql Database In WordPress Multisite

I have a multi-site installation. It's a fresh installation, and currently all the sites use the same database. What would you recommend among these and why? Pros and Cons of using the same? Option 1 ...
0
votes
1answer
69 views

Updating ACF field with external data

For our articles on our Wordpress site, we would like to display article analytics that are collected weekly for each manuscript. We have these native custom fields for each post: Article Views PDF ...
0
votes
1answer
16 views

Create Pages for database content

i added a custom table to the wordpress database with a list of names and a description. I wrote a custom function to display all the names in a table. Now i want to have an extra page for every name ...
0
votes
1answer
47 views

Local host to server import problem

I made my site at local host using WordPress 3.6. I have a backup of the database, but when I try to import it to the live site using WordPress 4.1, I receive the following error: Sorry, there ...
0
votes
1answer
29 views

Wordpress dbdelta a semicolon

I have a query, something like this $drzava ="CREATE TABLE IF NOT EXISTS`wp_drzava` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `Kod` varchar(2) NOT NULL, `Naziv` varchar(100) NOT NULL, ...
0
votes
1answer
95 views

Insert double entry in DB

I created plugin and my plugin create new Table in DB. My problem is when user type something in field firstname, lastname... and click on button Submit, that go to my table and that is ok.. but then ...
0
votes
1answer
232 views

How do I properly update the Wordpress database password?

A site that I manage was recently compromised and I am going through the steps to harden and re-secure the site. I would like to change the MySql database password and want to make sure I do not take ...
0
votes
1answer
36 views

I moved my site to another server, wp admin works so does the front page, but posts don't work

Pretty much summed up everything in the title. I can see the posts in wp admin, but when I hit the "View" link they return a 404 not found. Do you have any idea why this is happening? As a note: I ...
0
votes
1answer
141 views

importing data into wordpress db

Hi I am currently using wordpress 4.0 multisite(bitnami multisite stack) and am using WPMU directory plugin to create business reviews directory. Have some custom fields created using custompress ...
0
votes
1answer
42 views

How to fetch results from database

I'm attempting to customize a wordpress theme. I've added custom field cp_job with form submission. This indicates if the ad is either Buyer(Buying services) or Seller(selling services), which is now ...
0
votes
1answer
64 views

How to have WP Search widget index dynamically generated content?

I'm working on an adoption site and the company has a database that contains all their adoptive families. I have a page that contains a small line of shortcode which pulls every family within the ...
0
votes
1answer
31 views

Which is less DB intensive in the loop: custom taxonomies or meta fields?

If I'm checking for a certain variable for each post in the loop, is it less DB intensive to specify that variable using custom taxonomies or meta fields?
0
votes
1answer
143 views

Migrating Multisite - Database error, missing wp_blogs table

I am trying to duplicate my WordPress multisite on local with Xampp, but I get error. This are the steps I follow(I will use example instead of my website name): Copy all WordPress 4.0 files to ...
0
votes
1answer
54 views

How to write to wp-users table

I'm trying to modify a login plugin to make new users to to enter the display name to show on the site when they register. I know that the display name is located in the wp-users table of the ...
0
votes
1answer
602 views

Inserting data into custom tables

I am trying to create custom input tables to send data into custom tables on the wp database. I cannot get my script to do anything. The user will enter a type of liquor, like vodka or whiskey, ...
0
votes
1answer
86 views

WordPress Theme Migration Local to Live Assets Not Loading

I have a fully working custom WordPress theme built off underscores served up locally via MAMP. Normally when migrating to a live server, I move over the wp-content directory and the .sql file, ...
0
votes
1answer
45 views

Wordpress sync with phpbb

How can i sync the wordpress database users with phpbb database users so i can log on each one with the same user at any time and if there`s no user created for the wordpress to log in with the phpbb ...
0
votes
1answer
100 views

Importing posts from old website to new conflicting post ID's?

I am wondering when I am importing posts from my old site into my new website, which has already some posts in it. Do the imported posts get a new ID or do they overrule the existing posts ID's?
0
votes
1answer
158 views

How to pass username into form that sends data to database

I am trying to pass username to database through form: [insert_php] $current_user= wp_get_current_user(); $id= $current_user->user_login; [/insert_php] <input type="hidden" name="id" ...
0
votes
1answer
44 views

Is saving multiple options or saving multiple items in one option better?

I have added multiple fields to a custom taxonomy. I followed Pippin's tutorial. This method creates a single option per taxonomy item. The multiple fields are saved in taxonomy_id. I was not sure ...