Tagged Questions

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

learn more… | top users | synonyms

1
vote
1answer
13 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
15 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 ...
0
votes
1answer
34 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 ...
2
votes
0answers
43 views

Is there a way to improve or optimize this query_posts query? It's very slow

I have a fairly large database - 113,299 rows in wp_posts and 216,0649 rows in wp_postmeta. There is one custom query that I run after a post is added or edited, which appears in MySQL's slow-log ...
0
votes
1answer
35 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
29 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
0answers
16 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
25 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 ...
0
votes
0answers
3 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
12 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
20 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
19 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
0answers
9 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
15 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 ...
0
votes
1answer
27 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
0answers
23 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
14 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
0answers
25 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
20 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
12 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
25 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
21 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
9 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
2answers
50 views

Storing textbox values in Database

I am new to WordPress but I am good with PHP programmings, if I wanted to get value from the textbox and store it in the database in WordPress can I do? for ex form1.html <form name="form" ...
0
votes
1answer
32 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 ...
1
vote
1answer
24 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
28 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 ...
0
votes
1answer
22 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
17 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
37 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
65 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 = ...
0
votes
0answers
13 views

Why is wordpress trying to re-install itself?

I ran out of space on my MySQL server so I got a bigger disk and moved the files to the new disk, restarted MySQL and things were fine. But I went to my sites and now wordpress is acting like its ...
0
votes
1answer
14 views

Where should I put this custom data?

My client needs to store food nutrient data in his site's database. I have food name, calories, protein, fat, carb, fiber and other data to store for many food items. I'm a developer but new to WP. ...
0
votes
0answers
11 views

What's the point of wp_blog_versions?

The documentation says about wp_blog_versions: The current database version status of each site is maintained in the wp_blogs_versions table and is updated as each site is upgraded. but what's ...
0
votes
2answers
34 views

dbDelta SQL Query Not Working

I know the specifics of using dbDelta and I've read the documentation (http://codex.wordpress.org/Creating_Tables_with_Plugins), read other answers to the question I'm asking, but I'm just not seeing ...
0
votes
1answer
50 views

How To Make Connection To WordPress Data Base In A Plugin?

I am learning Plugins and I am trying to connect WordPress database wp-config.php in my Plugin PHP code. Currently for checking my code, I used the below connection and it is working fine. Now I ...
3
votes
1answer
45 views

wp_options table value

I am trying to understand a wordpress behaviour. When I add a tag in the admin panel mysql does a sequence of queries. Essentially: update wp_terms update wp_term_taxonomy and udate wp_options with ...
0
votes
0answers
10 views

saving and retrieving data

I been following some tutorials on how to create wordpress plugin, but i did not understand how to save data into a table, from admin e.g asking some questions and then on the front end displaying it ...
1
vote
1answer
50 views

Wordpress database import: Row size too large

I've done a dump of my Wordpress database using Windows's command prompt: mysqldump -u username -p databasename > filename.sql Then, on a different server, imported it using: mysql -u username ...
0
votes
0answers
20 views

Theme options not being sent to Database

Currently working on a little project for a theme, doing this so i can learn the in's and out's of wordpress. So far i've got to the point of adding sections, and fields within those sections. ...
0
votes
0answers
25 views

Custom Post Types and Posts are mixed

I need help with a problem related with CPT and WP Database. I have a wordpress install with bbPress and a custom post type called Destinos. The problem is that when I´m looking for the forums, or ...
0
votes
1answer
27 views

How to Determine a Post's Last Edited Date?

I'm writing a little extract script to do a DB pull. I've been asked to get all restaurant posts (custom post type) that are among the 1000 top hit, OR have been added or edited in the last 3 years. ...
0
votes
0answers
26 views

Restoring .sql backup results in “Error establishing a database connection”

I'm trying to get the database dump (.sql) of a remote site to work with my local setup. Sort of like migrating from remote to local. I've already ftp-ed the site itself, but having problems ...
0
votes
1answer
34 views

How can I retrieve data from alternate database using wpdb class?

I'm attempting to retrieve data from a separate WordPress installation on the same server. I'm able to use the wpdb class to successfully connect to the alternate database and get results, however, I ...
0
votes
1answer
23 views

How to save information related to post in database?

I created a post-to-email plugin and I need to save something in the database when the post is sent so I don't allow users to send it twice. How do I save this in the database? And how can I retrieve ...
0
votes
2answers
70 views

Wacky taxonomy in wordpress

I have my main site, www.whatsthatbug.com, and a test site, test.whatsthatbug.com. They are identical as far as I can tell - same version of wordpress, same plugins at the same versions, same theme ...
0
votes
2answers
36 views

Storing user submitted forms [closed]

I was wondering what's the best way to create a form which can only be seen by registered users. The main idea I'd like to achieve here is for users to log in and gain access to a page where there's ...
0
votes
1answer
37 views

Advanced SELECT query with condtional statements

I am having trouble understanding the proper way to write an advanced select query. I have the following the code here. if (!empty($_GET['3321body_type'])) { $bt = $_GET['3321body_type']; ...
0
votes
1answer
15 views

Updating options into the wp database performance

I have a question about the performance of my plugin. On the settings page of my plugin I have about 20 options the user can change (checkboxes, dropdown and normal text inputs). Currently I just ...
0
votes
1answer
26 views

Is there any way to recover deleted menu from database sql backup

i accidently deleted my main menu but i have a .sql database backup file and i want to recover my menu from this file. Is it possible? Thanks.