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

learn more… | top users | synonyms

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
23 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' ...
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 ...
1
vote
1answer
2k 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 ...
2
votes
3answers
658 views

How to export/import theme customizer settings?

I am wondering if it is possible to export theme customizer settings(theme_mods) to be imported into another install of the same theme. I know that the settings are saved into the database so I am ...
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

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
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
2answers
72 views

Delete tables from database when deleting plugin

I created a plugin and want to add a function to delete my tables from the database when a user deletes my plugin. I created a function that deletes tables from the DB when a user deactivates my ...
0
votes
0answers
30 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 ...
1
vote
1answer
37 views

No results found from a $wpdb->get_results() query when trying to join more than one meta key query

That title was a real mouthful. I have a custom post type called work with three custom taxonomies called work-client, work-type, and work-service. I'm using Advanced Custom Fields to make a nice ...
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 ...
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
13 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
5answers
2k views

Multisite database upgrade SSL error

I have upgraded my Multisite setup WordPress to 3.6.1. And after that, when I do Network Upgrade > Database Upgrade it's showing: Warning! Problem updating http://www.example.com/site1. Your ...
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 ...
3
votes
2answers
14k views

Connect to database using wordpress wp-config file

How can I connect to the database using the wp-config.php file ? I'm trying to make a script more Wordpress friendly, and I need to connect to the database, but without installing the script as a ...
0
votes
1answer
23 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
67 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 ...
0
votes
0answers
28 views

Creating a custom Search Form that links to a custom database?

I'm kinda new in Wordpress and I'm still learning as I go along. Currently, I'm trying to create something like this I have a custom set of database in the server in mysql with a table. The ...
7
votes
1answer
111 views

Reset Post IDs to less than 64bit integer

I have been running Wordpress for many years and have about 26000 posts. At some point my post ids have exceeded a 32bit integer and I am now locked into using Wordpress on a 64 bit system. I am ...
0
votes
0answers
12 views

How to print out database content like declared in DB_CHARSET?

Ok i created some table with Romanian names "CREATE TABLE `wp_drzava` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `Kod` varchar(2) NOT NULL, `Naziv` varchar(100) NOT NULL, `NazivSrb` varchar(100) ...
0
votes
1answer
11 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
2answers
137 views

Insert Query not working in the form

Many people has asked the same question, I have read those things and mine is different, I am trying to insert some values inside the database from the form but it's not getting inserted I have a ...
1
vote
2answers
78 views

Creating table with plugin is not working

After reading many question and answers and many had asked the same question I have been following the same instruction as the people instructed but my bad it's not working I have used ...
0
votes
0answers
19 views

Unable to create custom table , register_activation_hook from class

Cannot create the table , what am i missing class em_db { public function em_events_custom_table() { global $wpdb; $table_name = $wpdb->prefix . "em_events_db"; ...
0
votes
0answers
53 views

Get id from database

I need this ID to delete users from table. My plugin crate new table in DB when he is activate. All this code is in main.php, and in second.php i have only form that display my results.. and i include ...
0
votes
1answer
39 views

Is there a maximum amount of pages for a multi-page post?

I will publish 2 books (encyclopedia) on my site, each with over 4000 pages. My plan is to put each book into a multipage post using the <!--nextpage--> tag. 1. Can Wordpress handle such a ...
1
vote
1answer
130 views

What's faster? One big query, or several smaller ones?

I'm working on an app that will require a query, via Ajax, for a bunch of posts in random order. Something like this: $query = new WP_Query( array( 'posts_per_page' => 50, 'orderby' => 'rand' ...
0
votes
0answers
14 views

Comments disappeared but showing in database

This morning I published an article under which several comments were placed. I could read them and everything worked fine. Then all of the sudden, the number of comments were still showing on the ...
3
votes
3answers
8k views

WooCommerce with thousands of products - site is very slow - optimize db queries? [closed]

So far I've got around 8,000 products in my WooCommerce and the product page on the front end takes several seconds to load, even after caching. My VPS host says that I should have multiple ...
3
votes
3answers
2k views

How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?

Normally, a MySQL database can be exported and imported using these simple SSH commands: Export: mysqldump -u USERNAME -p DATABASE_NAME > filename.sql Import: mysql -u USERNAME -p ...
3
votes
1answer
124 views

Improve or optimize a very slow query

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
28 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
0answers
10 views

No Database Backup

I'm looking for a way to recover as much as I can from a poorly backed up Wordpress website. The website owner didn't renew their hosting and lost the site. This was the first and last Wordpress ...
0
votes
2answers
40 views

Custom Wordpress Table wpdb

running into issues querying a custom table and getting results. As of Wordpress 3.9, I can no longer run mysql_query(), and have to use $wpdb->query(); So keeping that in mind: Old Code: <?php ...
0
votes
0answers
25 views

Delete entry from DB

i created plugin and now i want to add delete button, that user can delete one entry from DB table.. Here is my code i form.. function showresult(){ ?> <form method="post" ...
0
votes
1answer
24 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
0answers
14 views

Force reindexing of plugins in Multisite

I have a Wordpress multisite installation and am developing it on localhost. However if I install a plugin in development, deploy the files and check multisite plugins section in Wordpress admin, it's ...
0
votes
1answer
1k views

$wpdb error (Call to a member function insert() on a non-object)

I have very few knowledge on oo php and databases, and I am simply trying to insert data in my wp_pagesvisites table but I am having some trouble with this error message. This is my script: ...
0
votes
0answers
35 views

How to clean tables after plugins are uninstalled

A number of plugins which I use earlier are not uninstalled and there tables are still there. I don't know the table names created by those plugins. Is there a way to automatically delete (via a ...
0
votes
1answer
46 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
53 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
0answers
44 views

Insert data to DB

I create plugin and that plugin, when is activate, create new table in DB.. Now i need to insert some data like (firstname, lastname..) in that table.. Here is my form : <form name="cool_form" ...
2
votes
1answer
193 views

What are these entries in the database? Looks similar to JSON

So I have been wondering for a while now what these entries are and what they do, also what the format of them are. They look similar to JSON but are definitely not JSON. ...