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

learn more… | top users | synonyms

0
votes
0answers
142 views

Get results from wordpress data custom table

Firstly i created a custom table into the wpdb : global $wpdb; $table_name = $wpdb->prefix . 'countdown_table'; $sql = ' `id` int(11) NOT NULL AUTO_INCREMENT, `styleName` varchar(255) ...
2
votes
1answer
1k views

Add Wordpress MU Network Admin via Database

I am working on getting a copy of a WordPress MU network up and running on my local machine for development purposes (using WordPress 3.2.1 at the moment). I need access to the network administration ...
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
54 views

Options table - where does my values go?

I just got my hand into wordpress and wp theme development. I know to create basic wordpress themes from scratch but I wondered how to get into custom theme options. My custom theme options (custom ...
0
votes
2answers
107 views

Multiple instance of data in plugin custom database table on plugin activation

I'm creating a plugin that adds some data to a custom table created by my plugin on plugin activations. I also created a settings page with a form that users can insert their own data to the ...
0
votes
1answer
25 views

Is it risky if I update all url in the database due to my site url changed?

Let's say I have a wordpress site on a subdomain. Initially, I created the site with "www." >>> www.mysite.mainsite.com Now, I'd like to change site url to only mysite.mainsite.com without www ...
0
votes
0answers
35 views

Use existing client information database in wordpress site

Our company's website is being completely redone, this time with wordpress. We have an existing client database where clients can log in and get the information they have permission to view. This ...
0
votes
1answer
81 views

What's the database relationship between a post and its attachments

I'm creating a custom import script to migrate CSV data into wordpress. Each post has a series of attachments that must come with it. Following chapter 14 (importing via a custom mysql script) in the ...
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
0answers
38 views

Any way to calculate distance between 2 addresses based on custom fields?

I'm working on a directory database theme, and I wonder if there is any way to calculate distance between 2 addresses or lat/long.... It can be a straight line calculation, and direction (bearing) ...
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
787 views

“MySQL server has gone away” since update to 3.8

I have a WordPress install on a dedicated server with decent memory (upwards of 8GB). The WordPress install includes many plugins - 50 active plugins. Most important to note is the WPML plugin to ...
2
votes
2answers
133 views

Why does dbDelta() not catch MysqlErrors?

From what I can see, dbDelta() is designed to suppress database errors that occur during its operation. Generally speaking, this seems to be the case, but New Relic is still reporting MysqlErrors ...
0
votes
0answers
45 views

Unable to replace text string across site

There is a text string (a little over 1000 characters with spaces) that needs to be replaced across the entire of my website. The text recurs over 300 times on my site, is identical, and was been ...
0
votes
1answer
276 views

$wpdb variable throw this error Call to a member function get_results() on a non-object in

I've this error "Call to a member function get_results() on a non-object in" from this code: require_once($_SERVER['DOCUMENT_ROOT'] . $folder . '/wp-config.php'); ...
0
votes
0answers
37 views

Preventing concurrent update of data

I have to implement the update of some metadata. An algorithm try alter some global variables in order to minimize a global error function. This algorithm is triggered by users who ratings each other. ...
2
votes
2answers
66 views

WordPress unresponsive after calling wp_update_comment()

In the admin panel's "Edit Comment" page, for some reason after I click "Update" the Edit page goes into infinite loop/loading (the spinner icon in the Google Chrome tab never stops spinning). My ...
0
votes
1answer
112 views

List of ways to access WordPress database?

I'm trying to get a complete understanding of how WordPress works with databases. I've read the documentation but I'm getting confused by all the different approaches available. So far my ...
0
votes
1answer
54 views

How to sort results from a custom database table

I've created a custom WordPress database table which I'm using to store 'likes'. The columns I have are: id post_id user_id I'm now trying to get an array of post IDs that a particular user has ...
2
votes
1answer
129 views

Best way to move live site local

I'm trying to move a big site that's currently live onto my local machine so I can edit locally. I'm using Wamp Server. I've tried using the Duplicator plugin but I'm getting several warnings and ...
3
votes
2answers
584 views

How is the data stored in the database?

I have years of experience with PHP and MySQL, but just starting to develop plugins for WordPress and need some help. Currently, I am working on a plugin that will add extra functionality to another ...
0
votes
1answer
489 views

Create page with custom php script and fetched data

I created WP page and I need to show a table with some information. This information is hold in a database (hosted on the same server). To be more detailed, I'll try to split my question. I'm new to ...
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
0answers
57 views

Get User data from external site

I would like to pull user data into a mobile app. I would create a simple login in the app and send the username and password to my wordpress site. The site would authenticate the user and return user ...
0
votes
1answer
29 views

Should I use an additional column in the DB?

I'm building a site for a client. They need a functionality where WordPress can tell if a logged in user has viewed a post in order that they might serve a notice or hide the original content. I ...
1
vote
3answers
2k views

How do I add indexes to Wordpress Database?

I got a message from Hostgator about my account being suspended because of the load it put on their servers. This is about the fifth time this has happened. I am on a shared server. And they said it ...
0
votes
0answers
4 views

Is it possible to use multiple sub domains using only one WordPress install [closed]

I'm helping a friend of mine with his website, he's an artist and he makes music and films. He wants to have 2 separate websites using sub domains e.g: music.example.com films.example.com I want ...
0
votes
0answers
23 views

Using one WordPress installation for two sub domains

I'm helping a friend of mine with his website. He's an artist and he's making music & films. he wants to have 2 separate website using subdomains. like this : music.hiswebsitename.com ...
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
42 views

No users table in WordPress's database

I am inside a database and there is no users table in it. Is it possible that the site running using WordPress has no users table? Please guide. Thanks.
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 ...
1
vote
0answers
19 views

Store partial database to an archive database time to time

As the community knows me that I'm not a PHP Developer by core, but trying to be one. With the company I'm working, I developed many WordPress powered News Portals, where- They publish at least 30 - ...
0
votes
2answers
39 views

When creating a metabox do you have to create DB fields for the data?

I'm just getting to grips with metaboxes for the first time and after reading up on them one of the main question i have is do you need to specify fields in the DB to store the data got input. i.e. if ...
1
vote
1answer
2k views

wpdb->insert multiple record at once

So after I have created the table 'settings-table' i want to add a couple of records to it. This is how I want to do it, not the best way, so I need a better way to do this because I will add more ...
0
votes
0answers
106 views

Manipulate database of WordPress site with my own scripts

I love WordPress as it provides plenty of great themes, good SEO and overall content management. But I'm not always happy with WordPress's original "Add post" and "Edit post" features as it required ...
0
votes
1answer
153 views

How to share User Database between Two Multisite Installations + More

My situation is a bit different to the other questions/answers I have read online here. Currently I have a Wordpress Multisite Installation on Server A. Server A is almost full in terms of ...
0
votes
1answer
24 views

Outputting query results

I am trying to make plugin, and i followed codex, i am not a OOP literate, hence i a blank. I tried to run this query $myrows = $wpdb->get_results( "SELECT question FROM wp_quiz" ); while i tried ...
0
votes
0answers
57 views

Possible to remove settings from wp_customize?

So, really basic setting here. function Ari_customize_register( $wp_customize ) { $wp_customize->add_setting('header_position', array()); $wp_customize->add_control('header_position', array( ...
0
votes
0answers
81 views

Is removing orphaned wp_postmeta records safe?

I am using woocommerce as a shopping cart on a wordpress site. Products and Product Variations are each stored as records in the wp_posts table. Each of these Variations have aprox. 15-20 associated ...
0
votes
1answer
205 views

How to create bulk page and content? [closed]

I am creating a website about cars. I want to have a page for each car, with subpages (i.e. Gallery, Specs, etc...) for each car page. I have the content on my hard drive for each car. Doing this ...
0
votes
0answers
26 views

Change Custom Menu Header Manually

I am working on a legacy site and typically don't work with Wordpress, so I'm crashing very hard into the WP world here. Basically, from what I can tell the site has these Custom Menus set up. I want ...
0
votes
1answer
73 views

How does Wordpress store data?

I have looked inside Wordpress database. Example: In wp_options table, option_name column, active_plugins row, its option_value is ...
0
votes
1answer
50 views

Images not showing after moving site

I've tried all the options suggested in other similar questions, and I'm stuck. My images are not showing after moving a site from my local machine to another server. I've searched the database, and ...
1
vote
1answer
68 views

How to prevent/delay MySQL connections when an object cache is used?

We are using an object cache backed by memcached, however I think that WordPress will still connect to MySQL on every page load, which shouldn't be needed if all queries can be handled by the object ...
0
votes
1answer
35 views

Function to get the name in database table from the comma separated string

I already created admin column in WP using this code: add_filter('manage_pages_columns', 'page_custom_cols', 10); function page_custom_cols($pages_columns, $post_type) { $pages_columns['user_group'] ...
0
votes
0answers
90 views

Convert from .htaccess to web.config?

When I convert to web.config. It shows an error: <rewrite> <!--This directive was not converted because it is not supported by IIS: RewriteBase /.--> <rules> <rule ...
0
votes
1answer
59 views

Help With a Large Wordpress Based MySQL Database on Shared Hosting

I have close to 500K posts in my WordPress database. The site is not yet live, I have the data on my local computer. I was reading about the WOrdpress' https://wordpress.org/plugins/hyperdb/ plugin ...
0
votes
2answers
910 views

How To Get Some Data From WordPress Database Using WordPress $wpdb Query?

I am trying to get some data from WordPress database tables in a plugin. For that, I am using the below code... global $wpdb; $findID = $wpdb->get_var("SELECT ID FROM wp_posts WHERE post_name = ...