Questions tagged [database]
WordPress stores user generated content, along with other configurable information, in a database (typically MySQL).
2,557 questions
0
votes
0
answers
18
views
Why can't Softaculous connect to database? [closed]
I used the Duplicator WordPress plugin to migrate a WordPress site to a new host and the site itself is working as expected. I'd like to be able to use Softaculous to quickly update plugins, themes, ...
- 1
1
vote
1
answer
168
views
Error of 'P404 Migration skipped. Already completed.' on error_log file
Error_log files of two websites, https://saahm.net/error_log and https://ochim.com/error_log have the very frequent repetitive errors (P404 Migration skipped. Already completed.) like every second, ...
- 11
0
votes
0
answers
9
views
WP_Options tabel randomly increasing in size indefinetly
I have a problem with my wordpress page (woocommerce store, woodmart parent theme), where the wp_options table in my database gains almost 50MB in size, in what I thought was approximently every 10 ...
0
votes
2
answers
26
views
I need to downgrade from 5.9.9 to latest 5.8.x - where is the db instructions executed when upgrading?
When I upgraded 5.8 to 5.9 my db was updated by WP.
Where are located db upgrade functions?
I want to consult them because I need a downgrade from 5.9 to 5.8
We haven't upgraded any plugin yey, but ...
- 267
0
votes
4
answers
35
views
How to monitor database for uptime? [closed]
Is there a free method to check if your wordpress database is online? basically if the site shows the message: error establishing a database connection then I want it to email me
- 181
0
votes
1
answer
26
views
Naming conventions for database tables
My WP will query some additional, non-core MySQL tables in the same database, populated by third-party app.
Are there any considerations, potential issues or bottlenecks about naming these tables as ...
- 105
-1
votes
1
answer
30
views
SEO impact: WP+Next.js hybrid [closed]
Our corporate website is a hybrid of Next.js and WP:
Next.js app uses data from WP database
WP works in the headless CMS mode
Does this integration affect SEO in any specific ways?
0
votes
0
answers
31
views
How to CRUD remotely hosted WP database without root?
I have a local app, which writes into two tables of a local MySQL. Additionally, I have remotely hosted Wordpress (I have no root on this host), where the database has corresponding wp_ tables.
I ...
- 105
1
vote
1
answer
288
views
SQL errors when querying for something with apostrophes
I have the below PHP function that queries some custom database tables and outputs the result. This generally works great, except for when I put an apostrophe in the query; for example, "Men's&...
- 1,253
0
votes
1
answer
27
views
error establishing database for all wordpress on same instance
i am facing the issue of 3 WordPress websites on the same Amazon s3 instance.
when I open wp-admin in all of them, it shows an error in the database connection.
frontend is all working ok. it's just a ...
0
votes
0
answers
31
views
WordPress User Login not accepted although listed in DB
I got a very strange issue with a WordPress Site:
The users are listed in the WP Users Table, the passwords are correct (changed the passcode several times in the DB directly) but WP Login tells me ...
0
votes
1
answer
35
views
Function wpdb::prepare was called incorrectly. The query argument of wpdb::prepare() must have a placeholder
I am getting the following error: Function wpdb::prepare was called incorrectly. The query argument of wpdb::prepare() must have a placeholder. I have gone through plenty of other similar questions ...
- 129
1
vote
1
answer
50
views
Add independent connections for reading and writing to the database in WordPress
I want to add a read/write separation to my database in WordPress, to optimize queries. I do it as follows (with a MU-Plugin):
class Custom_Read_Write_DB extends wpdb {
public $read_connection;
...
- 1,090
0
votes
0
answers
29
views
Can't save/get Patterns' `post_content` attribute
I am currently successful at getting the WordPress patterns via the following query:
SELECT * FROM {$wpdb->posts} WHERE post_type = 'wp_block'
Problem is, I realized post_content is empty, except ...
- 1
0
votes
1
answer
43
views
Count views without get_post_meta
I was able to get the views through the function using get_post_meta and it works fine.
//Getter
function get_the_views($postID){
$count_key = 'post_views_count';
$count = get_post_meta($...
- 85
0
votes
0
answers
21
views
Optimizing storage of Post Meta Entries
I'm working on a WooCommerce site where each order needs to update financial and order count data for a specific center, which are stored as post meta in another custom post type named "event&...
- 615
0
votes
0
answers
8
views
How to trigger an update_option
I'm trying to update option_name values from my form fields on form submission
// Update value from wp_options 'oxymade_colors' name (--primary-color)
// Used to update the rgb color
$color_mappings ...
0
votes
1
answer
83
views
Database table prefix different between wp-config.php and in database
I'm completely updating this quesion because I've discovered new facts about the problem. My wp-config.php has the line $table_prefix = 'wp75_';. The plugin WP-Optimize also shows the tables with ...
- 177
1
vote
1
answer
26
views
Combining two select posts from mysql - to get least viewed posts
I want to display least viewed posts from all categories except one
1- with this code I can display least viewed posts from all categories :
function NotSoPop (){
global $wpdb;
$return = "<...
- 13
0
votes
1
answer
20
views
Find specific text in the database and display the context of where that text is
I know there is the handy plugin Better Search Replace.
We're looking for something similar which will search the DB for specific text, but also display the context the text is in, e.g. the paragraph ...
- 1
0
votes
1
answer
25
views
$wpdb->update is not working until next page refresh. Is there one more step?
When I update a post and then re-get that post to check if it worked, it does not seem to have worked, but it actually did. Is there a purge_db_cache() kind of thing?
$pid = 55276;
$post = get_post($...
- 578
0
votes
0
answers
20
views
update_post_meta returns ID, but nothing in the database
I am facing a weird issue here and can't wrap my head around it. I am using the woocommerce_checkout_update_order_meta action to add custom data to an order. In the callback function I use ...
- 101
0
votes
1
answer
58
views
Is it safe to totally unregister the default "post" Post Type
I would like to start a fresh WordPress install and unregister the default "post" Post Type (and by unregister it, I mean totally wipe it out (database included)).
Is it a safe purpose ? And ...
- 299
-1
votes
2
answers
78
views
How to improve the performance when using a flat-file dataset and PHP for implementing advanced search function?
I have to add some advanced search function to a WordPress website, I can't use SQLite database because we are not allowed to install any driver on the system. I solved the issue using a CSV file that ...
- 49
0
votes
1
answer
58
views
How to use 2 different databases but share the same user in wordpress
I have 2 wordpress websites on the same server, one is bloo.com and the other is forum.bloo.com. each site has its own database, they have their own wp_content, each has its own file separately, but I ...
- 1
0
votes
1
answer
30
views
Custom Plugin Breaks Other Plugin Functions
I wrote a custom plugin and when activated it breaks my ajax for wpdatatables. I have found that it is my CSS that is breaking this. How would I go about running the CSS code ONLY on that one page?
&...
0
votes
0
answers
23
views
Issue with WordPress Automatically Assigning Terms to Multiple Posts
Hello WordPress community,
I'm encountering an issue where WordPress is automatically assigning newly created terms to multiple posts in my installation. When I create a new term (custom taxonomy: ...
0
votes
1
answer
286
views
Configure Wordpress to use MariaDB over SSL?
I cannot get Wordpress to work with using SSL connection for the database.
My client/server setup is working with a regular DB user over ssl so I can confirm it is setup correctly using MariaDB client....
themegamenuguy99
1
vote
0
answers
47
views
Is there a way to force plugins to use Flyway migrations for database changes?
Can I somehow force Wordpress plugins to output their required database changes as part of updates rather than let them change the database directly?
Coming from Java Spring Boot development, one of ...
0
votes
0
answers
42
views
Woocommerce plugin increasing Database size
My site is hosted on Hostinger, it's ecom site working on Woocommerce plugin. It is causing my Database increasing in every minute. I have run test on database using plugin to sweep old data also. But ...
1
vote
2
answers
136
views
how to run tests using different db connection
I would like to run tests on a db different from the real one. So I cloned the real db into a new one and tried wpdb::select passing as second parameter a mysqli connection to test db.
$mysqli = new ...
- 11
1
vote
0
answers
57
views
Wordpress Admin login problems- PLEASE HELP [closed]
I have just taken over a clients website to carry out future maintenance and updates. I am not sure if the previous developer left on a bad note but the thought has crossed my mind. I simply cannot ...
- 11
1
vote
1
answer
198
views
Deleting WordPress posts and media files based on author via MYSQL database
I would like to delete some of the posts in WordPress between a period based on the author via MYSQL database. I have difficulty identifying the WordPress tables and their relationships to perform the ...
- 11
1
vote
0
answers
16
views
can not serialize and insert data from custom form
I have a custom form . My form have three input fields book_name, chapter_title and chapter_content. chapter_title and chapter_content are dynamic form fields. I want to insert book_name as post_title ...
0
votes
1
answer
185
views
How to generate PDF dynamically based on values from the database in WordPress
How to generate PDF by using the values from database without using plugin in WordPress.
For example, I have a form and will enter the Name. Then it needs to fetch the data from DB based on the ...
0
votes
1
answer
49
views
How to get a list of all posts and their categories?
Basically I just need to have a table like this:
Post title
Categories
Post 1
Category 1, Category 2
Post 2
Category 2, Category 2.1
...
...
From MySQL Query to Retrieve Category from wp_posts I ...
- 332
0
votes
0
answers
46
views
Converting longtext to mediumtext in Wordpress wp_postmeta table
following recommendations to increase performance of my wp_postmeta table, I converted my meta_type field type to varchar 191, hoping this would reduce also the table size (which did not happen). I ...
- 1
0
votes
0
answers
31
views
Editing a WordPress post content from the database does nothing
I had to restore a database from a dump due to technical issues. It works well, however my client edited a long post that wasn't written yet in the dump I used. I managed to retrieve this specific ...
- 101
0
votes
1
answer
31
views
How to maintain development losing any user's data
Need suggestion
I developed a system with WordPress where users can register and publish posts.
There are currently two versions.
One is for production and the other is for development & testing.
...
- 11
0
votes
0
answers
14
views
Merging multiple WP databases into one for a multilanguage site prevents access to language-specific WP administration
My (inherited) WordPress website is setup like this:
example.com is the main version of the site
en.example.com is the English language version of the site. The subdomain's root is pointed to a en ...
- 101
0
votes
1
answer
101
views
Database Errors since site updated to Wordpress 6.4.3
I have stored my site in a cloud backup with localwp. Later I restored this backup into a new site. When I am inside the admin area I can see in the error log that errors are produced when accessing ...
- 66
1
vote
0
answers
31
views
Export and import, only new and updated WordPress data
I'm trying to create a cohesive workflow for the WordPress theme and content that runs our company's site. Recently I setup a staging & Production environment with WPEngine and a local environment ...
0
votes
1
answer
113
views
How to disable publish_future_post auto add wp_options cron
My website >> database >> wp_options >> option_name >> "cron" field total size 31GB (I was so surprised @@)
After checking i see a lot of publish_future_post fields ...
0
votes
0
answers
37
views
I have uploaded thousands of files in the uploads folder via FTP and I want to register them into the database without any plugin
I have uploaded thousands of files in the uploads folder via FTP and I want to register them into the database without any plugin because plugin takes so much time. Is there any way to register them ...
- 1
0
votes
1
answer
44
views
Set limitations of wp_update_post()?
I use Polylang on my site I set this function wp_update_post() to update two-time fields for my all Post Language when I click to update and publish again defualt post. I'm trying to use the following ...
- 3
0
votes
1
answer
66
views
Issue with WordPress Plugin Activation Hook and Table Creation
Description: I am facing an issue with my WordPress plugin where the table creation process upon activation is not working as expected. Here are the details:
What I Tried:
Checked the SQL query: ...
- 1
0
votes
0
answers
15
views
Want to use a single database and single table (wp_posts and wp_postmeta) for two different sites
0
I am currently working on a project where I need to setup a theme and plugin which has same database and table for wordpress tables are: wp_posts wp_postmeta
I can edit these file as well as ...
0
votes
0
answers
33
views
Add tags to blog-posts by php-script
I currently have a different blog software where the blog-post-keywords are in the database record of the blog post. So title, content and keywords are one record, not like in WordPress where each tag ...
- 1
1
vote
0
answers
27
views
Failed PHP 8.0 Upgrade
We are talking about a website which is used not very often. Today I mentioned that we are running an old PHP-Version. So I logged into my provider's control panel and adjusted PHP.
Afterwards I had ...
- 11
0
votes
1
answer
117
views
Wordpress Insert line in DB when clicking a button
when clicking buttonHdp, I wold like to launch the php code in order to insert a line in DB.
Script
<script>
document.addEventListener('DOMContentLoaded', function() {
jQuery(function($){
...
