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

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
24 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
23 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
32 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
18 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
37 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
41 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
32 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
16k 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
41 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
43 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
113 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
47 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
117 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
17 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
12 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
309 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
97 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
26 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
62 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
votes
1answer
43 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
142 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
16 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
9k 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
153 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
32 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
56 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
30 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
25 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
15 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
42 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
59 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
69 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
55 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
197 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. ...
0
votes
0answers
122 views

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

I'd like to add data to my custom wordpress table of my plugin, here is my code: <?php global $wpdb; $data = $_POST['name']; $wpdb->insert('ct_data' , array( 'name' => $data ), array( "%s" ...
0
votes
1answer
147 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, ...
15
votes
4answers
8k views

Post meta vs separate database tables

When developing plugins that requires data storage, what's the pros and cons of using one method or another ? The explanation given in the codex is not detailed: Before jumping in with a whole ...
0
votes
0answers
53 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
26 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
32 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
76 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
24 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
25 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
52 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 ...