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

learn more… | top users | synonyms

0
votes
0answers
12 views

wordpress database error

I write code to extract peice from website with curl. this should be refresh page to get price. I want store data in the wordpress database with foreach. when I refreshing page but give this ...
0
votes
0answers
12 views

White screen of death after failing on plugin install [on hold]

I've tried to install the W3 cache plugin but during the activation it started to file because of permissions. I changed the permissions to make W3 cache plugin working. After I run the plugin test ...
0
votes
0answers
3 views

Partial text search custom taxonomy

I am trying to do an autocomplete field that interrogates the database finding a custom taxonomy but can't seems to figure out how to achieve this. Would i need a custom query?
0
votes
1answer
10 views

Website displays old version of page

So I'm working on a website for a company and everytime I edit a page/post I have to manually go in to the database and remove the old versions (which isn't something that I'd like to do since it's ...
0
votes
1answer
17 views

Populate a select box with data stored in the database?

I know generally how to add custom fields to the user profile page. However, I need to add a custom select box to the profile page that is populated with all the schools in the state. (Our users will ...
0
votes
1answer
13 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
3answers
69 views
+50

Why are no posts showing despite my apparently correct DB restoration?

I restored a backup to MySQL using the phpMyAdmin Import feature. When I browse the DB in phpMyAdmin, I see that my posts are there. But in Wordpress, I only see the default out-of-the-box welcome ...
1
vote
1answer
47 views

$wpdb->get_results leaking memory

I have developed a wordpress plugin that reads large custom xml files and imports the information as custom post types and a lot of post meta information. So I am calling a lot of database ...
0
votes
1answer
21 views

Opinion on Best Database Move Option [on hold]

I am moving a lot of my sites from one server to another. They are on a shared host, and was wondering how many votes these two options would get, and which one you all think is the best option. ...
0
votes
1answer
20 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>". ...
-3
votes
0answers
31 views

Too many users? [closed]

I'm setting up a website and importing users from a csv with a plugin. This import process and everything works fine until I reach 13.000 users or so, then the wp-admin section stops working at all. ...
0
votes
1answer
14 views

Import live site to local setup without access to live site

I am working with a client to update a current wordpress site. I do not have access to the actual Wordpress install because they are behind a VPN that I'm not able to get behind for various reasons. ...
0
votes
0answers
31 views

Insert Custom Registration fields in Database

I am newbie to WP and working on login and registration forms. Recently I have integrated custom registration form following this tutorial. I managed to add validations and user can register but some ...
0
votes
1answer
26 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
2answers
20 views

Looking for suggestions on creating simple database (Help!!)

I'm working on creating a basic database for a theatre and really need some suggestions as the best way to approach this. Each production from this theatre will have its own page. The page should ...
0
votes
2answers
61 views

Woocommerce - Check product stock availability from external database

I have an external database (not a Wordpress one) where my client's stock is managed and I need to check the product availability considering this database, not the wordpress' one. My inicial idea is ...
0
votes
3answers
51 views

Execute a function every hour in the background

I'm in kind of a weird situation (for me) My client has a website that runs on a custom CMS He wants an online site that loads some data from the existing database. This is an external MSSQL database ...
0
votes
1answer
17 views

using same mysql user with many databases

As we know that in order to connect WP with database we should to define mysql username and password in wp-config.php, so at that point i have a question regarding security or ( some sort of ...
0
votes
1answer
20 views

Backing up Wordpress database and files

I've tried a few third party plugins for backing up my site, with some working well and others not so much, so I'm trying out backing up the site manually. Is there anything I'm missing here or is ...
-2
votes
0answers
20 views

Database connection question

I am new to WordPress and I wondered if it would be possible for me to develop my website using WordPress. I need to be able to implement a feature where users log in and a table is displayed ...
0
votes
1answer
51 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 ...
1
vote
1answer
71 views

Retrieve featured image (thumbnail) url from multiple posts with one query

I have a list of post ids and need to get all the standard data plus the thumbnail of the posts. As there will be several hundred posts i need an efficient way to retrieve the data, just looping over ...
1
vote
1answer
26 views

Add action on delete comments?

I add some input fields to the comment form, and than this new data is stored on commentmeta table. When a comment is deleted, the data on commentmeta is still there. How can I delete these data ...
0
votes
0answers
23 views

MySQL 1005 ErrNo 1 - “can't create table” when importing DB backup into phpmyadmin?

I have been developing a WordPress site locally using the following mysql version: LOCAL DATABASE SERVER: Server: Localhost via UNIX socket Server type: MySQL Server version: 5.5.40-0ubuntu0.14.04.1 ...
1
vote
0answers
22 views

delete duplicate comments

I found a solution for this a long time ago. Here is the code: <?php require_once('wp-config.php'); global $wpdb, $comment_content, $comments,$comment_ID; # First select all comments $query = ...
1
vote
1answer
22 views

WordPress Local And Live Site

I have a local WordPress install that I am using to test a new theme out. When I initial set up the local site I was able to import my database and media content. However that was a few months ago. ...
0
votes
0answers
14 views

Serialized Data Being Cut Off?

I have two separate installations of WP on two servers. They're both the exact same website. In my CPT's meta, I have a field that's a very long piece of serialized data. On one server the full data ...
0
votes
1answer
31 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 ...
1
vote
0answers
8 views

localize elements in database

I want to localize my website with .mo files. Now, while it's pretty easy to scan existing php files and add the relative translation, it's not clear to me how to localize the elements in the db. I ...
0
votes
1answer
21 views

How do i get value from wp_postmeta?

I am trying to get a specific value from wp_postmeta, I'm aware about meta_key and meta_value. Problem is Meta value stores lots of values and i want specific value. Here's the value in the ...
0
votes
0answers
37 views

Handling Massive Amounts of Data in a Wordpress Plugin

I've been working on my own version of a Youtube Post Importer plugin for Wordpress and I've run into a bit of a wall. I'm using the 3rd version of the Youtube Data API seen here ...
0
votes
0answers
22 views

wp_update_post set value to null

Is it possible to set a field to NULL using wp_update_post? I'm trying the following: wp_update_post( array( 'ID' => $future_orphan_id, 'post_parent' ...
0
votes
0answers
58 views

two wordpress sites, two themes, one database, same content

I am doing research about wordpress and there are many interesting stuff to learn, i browse the wordpress forum and i found a post about duplicating site.. or multisite.. I am not sure exactly how it ...
1
vote
1answer
101 views

Maintenance holding page while migrating website

I was hoping someone might be able to help me with the right procedure for establishing a holding page while migrating a local WP site to an already live server. I know there are lots of maintenance ...
0
votes
0answers
9 views

Will be the posts over writen according to the posts' ID when I import from an old site using XML file?

I have a site now and it has 350 posts. (Let's call is New site) I have another site which has 500 posts (Let's call is Old site) Now I am in a need of importing the all posts (500) from my old site ...
0
votes
0answers
15 views

WP DB Location for “Next Post to Create” Index Value

I have a malformed DB (no mystery here, I deleted some data directly rather than through the WP admin interface). I've deleted all posts and meta for 400+ but when I create a new post, the sequencing ...
0
votes
0answers
15 views

Editable form with database

I want to create a profile page in which user will give title and description for it.this title should be visible in list on same page by clicking on it associated description should get open for ...
0
votes
0answers
29 views

Wordpress + Postgresql

I’ve painted myself into a corner. I hired someone to build a database with all kinds of cool search features and such. The programmer wasn't aware that my site is built on Wordpress. He wrote his ...
0
votes
0answers
12 views

Adding searchable tables [duplicate]

I have a table not included in Wordpress tables' schema, and I want the option to include this table so that any search in the Wordpress search field will search and yield results from this table as ...
0
votes
0answers
22 views

Global Signup/Login in two wordpress site some like similar to stackoverflow?

I have two different wordpress installation at two different server one at mydomain.com and other at subdomain.mydomain.com having different database. My question is how I implement global ...
0
votes
0answers
21 views

Backend - Categories and Menus conflicts

I'm having a big problem with my WP instance which is frustrating. Every time I add a new Category ( a simple default category with no custom posts or taxonomies ) it adds, as expected, that new ...
2
votes
1answer
36 views

Should I be able to run two different “close” code versions of wordpress with the same DB

A concrete example - I am upgrading to 4.1 from 4.0, the upgrade was successful but I discovered that a plugin broke. Can I just revert the code. The real live issue I am facing is having two ...
0
votes
0answers
27 views

Should I store multiple data in a single wp_post field

I hope this is the right place to ask this question. I have chosen to work in a Wordpress environment so this should apply here. I have to design an application that will store hundreds of thousands ...
0
votes
0answers
11 views

Custom table in my plugin print UTF-8 (מוברש) charsets and not hebrew

i have created custom table in wordpress db to use my plugins needs. i have campaigns with hebrew names, this saved to column (varchar(100) utf8_unicode_ci ) in the DB i dont see hebrew but this: ...
0
votes
1answer
31 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 ...
1
vote
2answers
32 views

wpdb custom post_type problem

I want to use custom post type in my custom SQL query, but, when I add the custom post type im my query, I get no results. Where's my probelm ? This is the code I've tried $top5_ov_performance = ...
0
votes
3answers
26 views

Manage 3 Layers Of Information (CTP - Posts - Then Maybe Metadata?)

I'm building an app that I'd like to use WP as a backend for. There are three layers of data that I have to manage: Meeting Type Individual Meeting (Many of these in each Meeting Type) Persons ...
0
votes
1answer
22 views

How to select particular month post from table and update the post status using MySQL?

I would like to change the post status for particular month via MySQL command Using SSH...Can you anyone tell me how to do this via SSH. I have number of post more than 40,000 posts, each month i'm ...
0
votes
0answers
36 views

Simple email input store in database

I'm trying to build a really simple form to store email adresses in the wp database for future newsletter purposes. What I have is just a single email input: <form method="POST"> <input ...
0
votes
2answers
65 views

How to count number of records found in a database table?

I am new to wordpress development & tried to learning plugin development.I have created a custom table from which i want to show the number of records found.I have tried the below code but it ...