Questions tagged [database]
WordPress stores user generated content, along with other configurable information, in a database (typically MySQL).
2,528
questions
0
votes
1
answer
30
views
Updates applied to staging WordPress site affecting production even with different databases
I am experiencing strange database-related behaviours on my server that hosts a few versions of the same website.
The problem relates to making content and theme updates to one of the subdomain sites ...
- 111
-1
votes
0
answers
12
views
please sejession me [closed]
Problem Occurred When Importing Database!
Please Make Sure The Database is Empty.
- 1
0
votes
1
answer
18
views
Can't change login logo & css - older plugin data blocking?
I'm having problem chancing the login logo & css in the wordpress standard login.
I must previusly had an old plugin or something, because it's using an old image.
Now I have addedd the php code ...
- 29
0
votes
0
answers
21
views
If an Application Password is accidentally revoked, is there any way to restore it?
The concern is that it is too easy for the internal webmaster or admin to
accidentally revoke an application password for an application name for a
specific user.
In this case the application password ...
- 101
0
votes
1
answer
18
views
Wordpress post on home page of my website
Sorry I'm new to wordpress and I'm trying to show my wordpress posts from www.example.com/blog to www.example.com
I installed wordpress in /blog and I'm trying to display all the wordpress posts using ...
0
votes
1
answer
25
views
Understanding Redundant postmeta Tables in WordPress Database
I have noticed that my WordPress database contains three identical postmeta tables. Each of these tables seems to hold the same information.
Is it normal to have multiple postmeta tables in a ...
0
votes
0
answers
12
views
Help required with local wordpress setup
I recently had a problem with Windows on my computer. I removed the hard drive, put it in a usb casing and I am now using it as an external drive on a new computer. I only have access to all the ...
0
votes
0
answers
17
views
Update Cache on Save Instead of Clearing It?
I'm working on getting my wp-admin faster and is thinking about how I can get those slow get_posts() with a lot of meta queries faster.
I have already made som progress with replacing a lof of LEFT ...
- 1,047
0
votes
0
answers
11
views
Product reviews in my sql database
Apparently product reviews section within woocommerce does not have any option to adjust the amount of reviews displayed per page under screen options? Unlike the products section. Is there a way to ...
- 1
0
votes
0
answers
31
views
Images stored from external API not loading
The following is my code I am using to store image that I am getting from an external API using my own plugin. The images, or any media in general, are not loading on the frontend or the Media tab on ...
- 101
0
votes
1
answer
79
views
#1067 - Invalid default value for 'post_date' when trying to create a new column
I am trying to create a new column inside the wp_posts table but I am getting the error #1067 - Invalid default value for 'post_date' when I try and save it. What I am trying to do is, I am getting ...
- 101
0
votes
0
answers
26
views
Change information (phone number) in header of WordPress site using Veda theme
The site is located at www.morrellplumbing.com.au and the header looks like this:
I need to change the phone number, but for the life of me, I cannot find where it is stored in the Wordpress ...
- 101
0
votes
0
answers
10
views
Help with vehicle performance website
Creating a wordpress website for a family member i need to create a dropdown menu after something similar to this
Once the vehicle details are selected when clicking the view tuning options i need it ...
- 1
0
votes
0
answers
20
views
Distributed plugin - add support for Cyrillic
Our plugin creates a custom database table for storing text entered into a textarea.
$sql = "CREATE TABLE $table_name (
id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
...
- 5,048
0
votes
0
answers
20
views
wp_update_post function exclude specific field
I am using a function to update the default post and this function updates the language post publish date and some fields. it's working fine but the problem is that our meta_post field "_mydomain&...
- 1
0
votes
0
answers
19
views
Optimizing AJAX Query with Large Database
I have a WordPress AJAX function that performs a location-based search on a website with a large database of over 100,000 posts... The function is responsible for querying the database to find the ...
0
votes
1
answer
22
views
How is better to store at DB 1-side relationsip from CPT to many Taxonomies Terms ID's?
Wordpress (with plugin for Custom Fields stored at DB Custom table like Pods/MetaBox/JetEngine/etc)
Logic:
Custom Post Type (CPT) witch data will be stored at database Custom Table.
Custom Taxonomy ...
0
votes
0
answers
22
views
Dynamic Gallery: Worpress' equivalents for Wix's collection and repeater
I am recently trying WordPress (the WordPress.com one instead of WordPress.org) to create a webpage that displays a list of events that the website visitors can participate in. I have been using Wix ...
0
votes
0
answers
7
views
Wordpress copying data from one custom post type to another
I import events into The Events Calendar plugin. I also use Directorists plugin. When a venue is imported I need to also add that venue data to Directorists custom post type data.
0
votes
1
answer
18
views
How do I set WordPress to send 2 different emails based on criteria in the database when someone submits a form?
I'm trying to create a small program registration system that allows users to register for a course AFTER carrying out an Advisory session with a lecturer.
The database will contain a table with the ...
0
votes
1
answer
29
views
How to change database entries due to theme change
I am not Wordpress developer but I have a problem and I do not how to deal with it.
My problem is that I am changing theme due to current theme is outdated.Those themes totally different each other ...
0
votes
0
answers
8
views
Limite of data storage
I want to create a very very very big sites on word press. But I don’t know what is the limit of data storage. Can Word press handle millions of users , for e learning courses website, with thousand ...
- 1
1
vote
0
answers
37
views
Automatically synchronizing content between two WordPress installations with different themes and plugins
As the title suggests, I am looking to automatically synchronize content between two WordPress installations.
We are looking to switch themes soon and would like a staging site where we can test new ...
- 11
0
votes
1
answer
25
views
wp-admin login redirecting to home page
Updated my query below in detail. I found the below error in my error.log which causing unable to load my WordPress dashboard. When I try to log in, it is redirecting to the home page.
WordPress ...
0
votes
0
answers
79
views
Elementor form data to ACF
I've developed a webpage incorporating the Elementor Pro form widget to enable users to submit a listing on my website. enter link description here
I have utilized the ACF plugin to create all the ...
0
votes
1
answer
239
views
How to stop wordpress from redirecting from the post's old slug after changing title and slug?
After changing a post's title/slug from mysite.com/name to mysite.com/new-name, the old slug mysite.com/name is now redirecting to the new one mysite.com/new-name, and I don't want that to happen.
I ...
0
votes
1
answer
34
views
Multisite: merging two subsites in the main site
I have a multisite:
example.com = example.com/ar/
example.com/es/
example.com/en/
example.com/ba/
I need to merge 2 and 4 into 1 the main site without losing the post
Ending with only 2 webs: the main ...
- 23
0
votes
0
answers
20
views
a lot of customization of front and back end and after if there are a lot of users, will slow down the server? if so, what do you recommend?
I am currently building a platform on WordPress and am concerned about whether it will slow down when the number of users increases to over 1000 or when I add custom features. However, it might not be ...
0
votes
1
answer
105
views
How to change all the images in post content to full/orginal size - Thumbnails are broken
I use Regenerate Thumbnails plugin and remove all my old thumbnails size.
Now, in my new theme I use new thumbnails for feature images, But all inline images in my post content is broken.
How can I ...
- 29
0
votes
0
answers
29
views
Can not insert data in database table
I did a form and through a plugin i coded in php, i’d like to insert the result of this form into my wordpress database. But i run into a problem cause nothing is inserted in my database despite the ...
0
votes
2
answers
66
views
large number (bigint) for post ID issue in database
the ID of my latest post is 796978707878960002.
I manually created it using the code below:
wp_insert_post(array(
'import_id' => 796978707878960002,
'post_title' => '-test'
));
Now, ...
- 1
0
votes
0
answers
20
views
Can I Load posts from an External database if the post is not found on Main Wordpress Database
I have a WordPress Site on a dedicated server (on a considerably larger Capacity Server - 128GB RAM/64 Processor - 2TB NVme).
THE PROBLEM
We have a considerably large amount of data inside the ...
- 1
0
votes
0
answers
54
views
Can't insert into a database wordpress
i did a form with html and js, and through a plugin in php, i wish i could insert the result of this form into my wordpress database. But i run into multiples problems.
One was that wordpress would ...
0
votes
1
answer
37
views
multiple record insert creating many duplicate records
I want to loop over an array and store the records in the database. This is working but for some reason it is creating 30 odd records instead of just 4. I put this code into a very basic custom plugin ...
- 513
1
vote
0
answers
27
views
How to make a term belong to multiple taxonomies?
As the title says, I’d like to implement a system where I’d like to have a term belonging to multiple taxonomies.
Just in case someone’s wondering “what on earth does he need this for?”, hear me out. ...
0
votes
1
answer
19
views
Sharing plugin tables between 2 sites in the same database
I would like to know how can I make my supportcandy plugin to read the database tables of another supportcandy plugin installed in another site, without activating the wordpress multisite feature.
I ...
- 1
0
votes
0
answers
28
views
Putting form result in my database
i have a problem with my wordpress rn.
I did a form in html and js, and i want to put the actual result in my database where i created a table for it.
So basically i did a plugin in simple php that ...
0
votes
1
answer
176
views
plugin doesn't retrieve data from database
I wrote a code for a plugin which suppose to modify the WordPress dashboard to display a cog icon for each post in a column named "Optimize". I added an action to the icon that triggers the ...
0
votes
0
answers
46
views
Woocommerce permalink URL change in DB
I am changinf URL structure and product URL on the wwebsite.
Problem is this:
When I change permalink structure on the WordPress admin, it creates directly new URL with new structure for each product.
...
0
votes
0
answers
79
views
Bulk data save in custom table
I have a form in admin page that store data in custom table, with multiple checkboxs.
On form submit I need to save the checked box id with the store id it's related in a key pair way (store_id => ...
- 1
0
votes
1
answer
36
views
Can't save formdata in DB
I'm trying to build a form in the backoffice to save some data in a custom table. The form is a list of checkbox, in witch the value is linked to a selected user.
So you have to select a user in a ...
- 1
0
votes
1
answer
29
views
Order of search results based off of a backend custom field and also in alpha order
I'm using WordPress as a searchable database of people, and I want to be able to sort search results by the person's last name. Initially, I figured I could sort the search results in just alpha, but ...
0
votes
1
answer
114
views
Change permalinks in posts via SQL
I have changed our permalink structure for a better SEO Score. Our old was day and name like https://domain.tld/%year%/%month%/%day%/%postname%. On our site are around 2600 posts with links to other ...
- 1
0
votes
0
answers
6
views
How to find fresh (last modified) and sql backup?
I have 3 version of sql databases on my pc, i am again planing to upload it , but confused which was last database, any idea how to find last sql backup ?
- 703
0
votes
1
answer
138
views
Database Queries are crashing the server
Migrated website from old cPanel to Hostinger and now slow queries are killing the server.
I have deleted more than 97% data and rest of the content from one query is:
UPDATE wp_options SET ...
- 1
0
votes
0
answers
29
views
Uploading to Wordpress Database
Hope everyone is doing great. I have a small issue with uploading information to the wordpress database. I created a new table without the prefix. I created code based on what I've learned in ...
0
votes
0
answers
22
views
How to protect my credentials on my clients website
I work with many different clients and I know some will try other freelancers eventually. Right now, my password is stored in my clients database. Is there any way to make this process safe? I would ...
0
votes
0
answers
28
views
Remote database access on another wordpress site's custom post type
Firstsite.com
secondsite.com
both are Wordpress site and firstsite's data I want to fetch on my secondsite's custom post type template.
Secondsite.com has it's own database so I want to use both on ...
- 37
0
votes
0
answers
25
views
Have Wordpress Use a Different Database for users
I have imported my users from Filemaker into a different table in Mysql. Can I have my user login to that database instead of the wp_users table. If so how do I connect it?
Thanks in advance for your ...
0
votes
1
answer
73
views
Restore posts, but only posts that exist in my database backup
This is my situation.
On 1 Jan 2023 I took a backup on my entire Wordpress database. Let's say that backup contains 100 posts.
Fast forward to today, 14 Feb, and I now have say 125 posts in my ...
- 163