Questions tagged [database]

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

Filter by
Sorted by
Tagged with
1 vote
0 answers
19 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 ...
FrontEndGuy's user avatar
1 vote
1 answer
30 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 ...
Lal Prasanth's user avatar
1 vote
0 answers
9 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 ...
Khalid Saiffullah's user avatar
0 votes
1 answer
24 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 ...
Manikandan's user avatar
0 votes
1 answer
23 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 ...
Ooker's user avatar
  • 332
0 votes
0 answers
12 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 ...
perlfan's user avatar
0 votes
0 answers
10 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 ...
Carrm's user avatar
  • 101
0 votes
1 answer
27 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. ...
Sakib's user avatar
  • 11
0 votes
0 answers
13 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 ...
FiddlingAway's user avatar
0 votes
1 answer
50 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 ...
Compjeuter's user avatar
1 vote
0 answers
21 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 ...
Adrian Rodriguez's user avatar
0 votes
1 answer
36 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 ...
Công Tử Huyết's user avatar
0 votes
0 answers
22 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 ...
Sheikh's user avatar
  • 1
0 votes
0 answers
17 views

Should I save user cookie consent in a custom post type or make a custom database table?

What is the better solution for storing large number of user consents: saving them as entries of a custom post type or create custom database tables? The consents will be remembered for half a year. ...
ChrisPlaneta's user avatar
0 votes
1 answer
33 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 ...
SS Apps's user avatar
0 votes
1 answer
41 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: ...
pervez's user avatar
  • 1
0 votes
0 answers
13 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 ...
HIMANSHU SINGH's user avatar
0 votes
0 answers
18 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 ...
Fabian's user avatar
  • 1
1 vote
0 answers
23 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 ...
Karl Exler's user avatar
0 votes
0 answers
35 views

Custom database table entry edit page

I can display every row of a custom DB table in my custom sub page, but I'm not sure how to implement a single row edit page. Is it as easy as verifying some link query parameter and then displaying &...
fuji's user avatar
  • 101
0 votes
1 answer
74 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($){ ...
Jean-François Moulin's user avatar
0 votes
1 answer
33 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 ...
Mike Hermary's user avatar
0 votes
1 answer
21 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 ...
Adam Larsson's user avatar
0 votes
0 answers
26 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 ...
FuzzyWuzzy's user avatar
0 votes
1 answer
23 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 ...
user237290's user avatar
0 votes
1 answer
34 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 ...
Diane Rendel's user avatar
0 votes
0 answers
16 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 ...
Dhashika Ramgolam's user avatar
0 votes
0 answers
30 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 ...
Peter Westerlund's user avatar
0 votes
0 answers
46 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 ...
Jason's user avatar
  • 1
0 votes
0 answers
34 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 ...
I. Antonov's user avatar
0 votes
1 answer
295 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 ...
I. Antonov's user avatar
0 votes
0 answers
47 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 ...
Dale M's user avatar
  • 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 ...
SDot's user avatar
  • 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, ...
shanebp's user avatar
  • 5,063
0 votes
0 answers
22 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&...
SS Apps's user avatar
0 votes
0 answers
23 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 ...
Francisco's user avatar
0 votes
1 answer
23 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 ...
user234970's user avatar
0 votes
0 answers
38 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 ...
mawgumelar's user avatar
0 votes
0 answers
8 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.
Tom Garmon's user avatar
0 votes
1 answer
24 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 ...
Jewel Wildmoon's user avatar
0 votes
1 answer
35 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 ...
donmezburak's user avatar
0 votes
0 answers
10 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 ...
Dan's user avatar
  • 1
1 vote
0 answers
40 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 ...
SynchroPorto's user avatar
0 votes
1 answer
35 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 ...
Chandra Sekhar Rao Bali's user avatar
0 votes
0 answers
148 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 ...
Faris Jamil's user avatar
0 votes
1 answer
508 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 ...
cashrunner's user avatar
0 votes
1 answer
51 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 ...
Irene's user avatar
  • 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 ...
katherine kim's user avatar
0 votes
1 answer
194 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 ...
och's user avatar
  • 39
0 votes
0 answers
72 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 ...
Louis-Emmanuel Metan's user avatar

1
2 3 4 5
51