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

learn more… | top users | synonyms

0
votes
3answers
2k 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
187 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
33 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 ...
0
votes
1answer
3k 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 ...
2
votes
1answer
1k 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
177 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 ...
1
vote
0answers
80 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
66 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
1answer
149 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
22 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
355 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
72 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 https://developers....
0
votes
0answers
639 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
380 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
25 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
1k 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
33 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
43 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
71 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
1answer
189 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
176 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
41 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
130 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
172 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
3k 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 ...
7
votes
1answer
137 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 ...
1
vote
1answer
158 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
50 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
233 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
7k 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
539 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 dbDelta($sql)...
0
votes
0answers
745 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 ...
1
vote
1answer
312 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' );...
-1
votes
1answer
72 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 ...
0
votes
1answer
71 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
2answers
237 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
35 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
41 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
233 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
1k 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
0answers
115 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
0answers
80 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" ...
0
votes
2answers
4k 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 ...
2
votes
1answer
294 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. a:1:{s:12:"jetlocations";a:...
0
votes
3answers
1k views

Reset/Reorder posts ID in the MySQL wp_posts table

I have a Wordpress site that is considerably popular. I am in the process of optimizing the site before adding other plugins such as the WPML plugin which I suspect will be using custom post types. ...
1
vote
1answer
1k views

Select data from database and list it in Loop (Wordpress)

your Answear helped me but i stuck again. here is what i have done now : <?PHP define( 'WP_USE_THEMES', false ); get_header(); global $wpdb; $sql = "SELECT vehicle_id, manufacturer, series, ...
0
votes
0answers
928 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) ...
0
votes
1answer
69 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
122 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 ...