Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [database]

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

0
votes
0answers
3 views

Multiple WordPress sites with different theme and plugin sharing the same content

I want run Multiple Wordpress websites with different theme and plugin using one database where the content remains the same in all websites. site.com - Main site site.com - Should use 1.site.com ...
1
vote
2answers
46 views

Does a core update 4.9.8 → 5.0 involve a database update (migration)?

And where do I (reliably) look for this kind of information? I find myself googling for 'wordpress changelog' on every other update... Background: usually I use a "skeletal" WP installation (seperate ...
0
votes
1answer
14 views

Delete all drafts?

This is a common query to delete all post revisions: DELETE a,b,c FROM wp_posts a LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id) LEFT JOIN wp_postmeta c ON (a.ID = c.post_id) WHERE a....
0
votes
0answers
10 views

Woocommerce import products with serialized data

I am creating a Woocommerce shop that makes use of the official Measurement Price Calculator. This plugin seems to store its data serialized in the database as when I export a spreadsheet of products ...
0
votes
1answer
11 views

getting the values of hidden inputs to use them in a php mysql query

Im trying to update a value in the database, to do this I pass the values of the input an ID to another hidden inputs and submit the form via jquery, the values are set in the hidden input (tested). ...
0
votes
0answers
12 views

update value in database on button click, using a dropdown menu

I am getting the users via $wpdb, then I display the values id,name and mg_nobility in a table that has a dropdown menu to select the nobility and a submit button. how can I get the id of the row that ...
1
vote
1answer
26 views

Show content from database

This is my first post on Wordpress StackExchange, so please be gentle. I’ve been working with WordPress for some time but more as a front-end developer and not too much back end dev. I have a ...
0
votes
1answer
24 views

how to encyrpt DB_PASSWORD in wp-config

Recently moved my wordpress site to another hosting provider and after importing my database I had issues establishing a database connection. I edited wp-config file and entered my DB_PASSWORD to re-...
0
votes
0answers
16 views

WooCommerce database upgrade behaviour

I've noticed a strange issue on one of the sites I manage with WooCommerce database upgrades, for the last couple of releases. Here's the upgrade path the WooCommerce plugin has been through on this ...
-1
votes
1answer
18 views

how can i display data from another plugin in a new plugin? [on hold]

I have the following problem. I have a plugin: Event Calendar installed in WordPress. When I add an event, the data in WordPress is stored in the database (table: wp_posts). My task is to create a new ...
0
votes
0answers
16 views

Display posts with datas of custom database table

I think the title is not very explicit, but I don't know how to name it ! Well, I'm totally stuck on a question: To make it simple, I work on a site referencing places and their information. These ...
0
votes
0answers
18 views

Updated WP database breaks UTF-8 foreign letter encoding

I migrated WP site and got it working correctly, after I updated the site to the latest version (from 3.5 -> 4.9.8) I needed to let WP update the database, and after that all of my Swedish letters ...
1
vote
0answers
32 views

Exporting revisions

How do you export revisions for posts? I cloned a site with it's complete Wordpress DB 4 months ago. After the clone revisions have been made to the existing posts and new posts has been added to ...
0
votes
1answer
20 views

Restore Old Database Over Newer WP & Plugin Files

We're migrating our server to a new updated server. The hosting company is using rsync to copy stuff over. They did the first sync of everything a few weeks ago and we've been testing things and ...
0
votes
1answer
21 views

WordPress 'repairing database' in a constant error loop?

WordPress in a constant error loop. When I try to log in I'm told to repair the databases. Here is the sequence Error reports: "One or more database tables are unavailable. The database may need to ...
0
votes
1answer
22 views

get_option() does unserialize and don't remove \

When i update_option() with special caracter, for exemple BARCA D'AREGOS the serialize option puts save like that BARCA D\'AREGOS on database. If i do get_option() the display value is BARCA D\'AREGOS....
0
votes
0answers
16 views

How to pull list of all Yoast keywords that I have entered into all posts?

I find the need to make one list of all keywords in one spot. Rather than going into my hundreds of posts and manually making a list, I figure there would be a functionality to find this or a way to ...
0
votes
0answers
19 views

AJAX is not submitting data to database

I have a quiz application which stores user scores to a variable. There is a blueprint object for every user that looks like this: function User (theName, theEmail) { this.name = theName; this....
0
votes
1answer
31 views

Any possible way to make $wpdb->get_results() return anything else than array?

So I'm using $wpdb->get_results() to query my database and then make AJAX call from JS file. The problem is that I need to get the value itself, like a string, instead of array, but as much as I ...
0
votes
0answers
13 views

AJAX request returns back Array0 to console

I'm making an AJAX request in wordpress for the first time and I'm trying to access my custom made table to retrieve single name (string) or multiple names. It all works without the errors, except for ...
0
votes
0answers
14 views

How to grab data from input and store it into custom table in database?

Question asked million times and answered, but still not working for me for the simplest form. My code looks like this right now: <?php if (!empty($_POST)) { global $wpdb; $...
0
votes
1answer
11 views

Choosing http or https during manual installation of WordPress and database

When you manually install WordPress, somewhere during the process it asks you to select weather your site uses http or https. Why is this? What does it matter? How will your choice translate to ...
0
votes
0answers
10 views

Transferring site data from current theme to a different theme

Hope you all are good. My queries are: 1- How can I transfer site data from current theme to a different theme? 2- Will the new theme adopt the data or make a mess? 3- Should I consider manual data ...
0
votes
1answer
16 views

Undo WooCommerce CSV import

I've done a CSV import through the WooCommerce import function. Unfortunately, there's something what went wrong. By now, almost all products don't show any data as it has somehow been overwritten. I'...
0
votes
0answers
32 views

WC Database version keeps reverting to 2.6.4 after upgrade

I keep getting this error on my dashboard after performing a WC DB upgrade: WooCommerce data update – We need to update your store database to the latest version. Run the updater After I perform the ...
0
votes
0answers
19 views

WooCommerce and Redis

I'm using Redis (installed with the Redis Object Cache plugin) in conjunction with WooCommerce. The problem is that (only with the Redis plugin) I can not make any orders, because the sites hangs ...
0
votes
1answer
21 views

HELP $q=mysql_query($sel) or die(mysql_error()) HELP

My website is crashing on this line of code. It happened after we updated to the latest version of WordPress. It hadn't been updated for the previous 5 years. So its not surprising. I'm new to ...
0
votes
1answer
34 views

Update all published posts at once

I know this question has been asked a few times but I can't find one with an adequate answer. I need to run through all my posts and update them as in -> go to the edit screen a press Update - as ...
0
votes
0answers
9 views

Migration of Craft Website Database to WordPress

I have a website built on Craft CMS and need it migrated it across to a WordPress enviroment, the problem lies with the website having 2000+ pages. Is it possible that the Craft Database can be ...
0
votes
1answer
24 views

Displaying posts on a page that have been assigned a value in a database

I have a wordpress site with a bunch of posts that I need to display on a page, depending on their value in a database. To be more specific, out of 20 posts I would only want to display the posts on ...
0
votes
0answers
15 views

What charset/collate should we set for our custom database table?

I've seen this nice topic, but my question might be slightly different. Is it good practice to set your custom DB table (i.e. for plugin, which saves utf8 text) charset explicitly , like: CREATE ...
0
votes
0answers
12 views

Displaying images in WordPress without storing image data in database

I am working on a site with more than 10.000 products that are stored as a custom post type. The products are imported each week with a custom import script that places the right information on the ...
0
votes
1answer
9 views

User saved through Wordpress backend does not show up in database table users

I am troubleshooting WordPress installation. When I save the user through the user interface in Wordpress, the newly created user does not show up in the user table in the database. The strange thing ...
0
votes
0answers
44 views

WooCommerce Price Not Showing on Product Page

I have more than 1000 variations for my single product.The issue is when i select that atttribute,the price is not displaying.in some cases it hangs up and endings up displaying nothing.its creating a ...
0
votes
0answers
12 views

Wordpress Plugin (Want to create table but also insert some data into custom database?)

I'm working on creating a plugin, my first, but I'm wanting to create a few tables, but one in particular I would like to add some information too in order to pre-load on the plugin install. I can't ...
0
votes
1answer
30 views

DB Query not working in Plugin

I am working on a plugin. And I want to create a table via the plugin. So I am trying execute following SQL Query. global $wpdb; $createSQL = " CREATE TABLE `". $wpdb->prefix ."...
0
votes
0answers
56 views

How to find why my pages has Redirects

I try to find why my pages have Redirects. I installed Better HTTP Redirects 1.2.2 and enabled debug mode so it shows redirects process I use WordPress 4.9.8 and before upgrading my WordPress I ...
0
votes
1answer
11 views

Duplicate database to roll back theme & content changes

I am going to update site to a new custom theme and it will take a few days to get all the work done. Can I duplicate a wp database in phpMYadmin, so i have wp-db1 and wp-db2. Then I can change wp-...
0
votes
0answers
25 views

Custom post type - Huge DB - $query->set

I display some custom tables (backend) for my custom posts type. I have created many upstream filters, let's take the following example : First custom post type : bank_accounts Second custom post ...
0
votes
0answers
11 views

How to map data on CSV to web pages?

Like Contact information, descriptions, budget, prices, other numbers, on a CSV or spreadsheet, how to link it to WordPress web page? I'm using cpanel, WordPress, Tablepress plugin, elementor page ...
0
votes
0answers
13 views

Updating Posts table in database without overwriting user generated content

I'm trying to come up with a local development workflow for wordpress that actually works. I'm pretty new to this whole thing but I'm surprised this is so complicated. So far I've been using Git and ...
0
votes
0answers
24 views

Lost connection to MySQL server during query?

I am very curious to know if anyone has seen this error, know what is generating this errors, and if so, how to remove it? It is happening while trying to query a woo commerce product in the serch ...
0
votes
3answers
51 views

WordPress credentials not matched

Ok, I'm at wit's end with Wordpress. This is the fifth time I've tried installing it and it flat out is not working. When I install it, it shows one of the themes, but the default welcome post doesn'...
0
votes
0answers
7 views

Is there any service that I can automatically get an updated mysql in my local machine from online?

This is how I do to keep my local machine and my online version of Wordpress php files same as that of each other. Git to repository (either bitbucket or GitHub) Set a deployment service to the ...
0
votes
0answers
8 views

Multisite Search by custom taxonomy

With multisite, each blog has its own table. I want to create a plugin that will add custom taxonomies to all blogs. I know how to do this. Then I want to create a query to return all posts for a ...
0
votes
0answers
34 views

Automatically restore the last backups for demo purpose

let me explain what I want to achieve: I will use my site to be a demo for my premium themes for ThemeForest to allow anyone to add, edit posts and comments, Now I want a way to automatically restore ...
1
vote
0answers
16 views

How to remove traces from widget during uninstallation

I have a small plugin, which registers a custom widget and now I am wondering how to remove all traces of this widget when the plugin is removed through the administration. If I look in the database ...
0
votes
0answers
19 views

How to clean out old/unused pages?

We've got a WordPress site that has been running for over 10 years and is closing in on 1,000 pages. We know there are quite a few pages that haven't been accessed in a long time and we'd like to get ...
1
vote
0answers
17 views

Create a database for each site created in multisite?

I am running a multisite network and I want to be able have each new subsite to have it's own database instead of 1 big database. Is there a way to make it whenever I create a new subsite it should ...
0
votes
1answer
20 views

Alter the cost of products using phpmyadmin sql query

What is the SQL query can i use in phpmyadmin to alter(update) the listed products cost in woocommerce. EX: I want to add or subtract $100 from all the listed products.