Questions tagged [database]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
11 views

Creating a Video Content Page (how to use query strings in wordpress)- Help!

I'm very new to Wordpress, so apologies. I have a project that I'm working on and I'm hoping someone could point me in the right direction. To start off I am volunteering to do some work for a small ...
0
votes
0answers
16 views

$wpdb->insert not working inside save_post tag

Will someone help me in this. add_action( 'save_post', 'product_price_box_save' ); function product_price_box_save( $post_id ) { if ( defined( 'DOING_AUTOSAVE' ) && DOING_AUTOSAVE ) ...
1
vote
1answer
19 views

Adding a Table to the wordpress database

I am using the following script to add a table to the wordpress database, but nothing is happening. I am not sure what I am doing wrong. Any advice would be much appreciated. function ...
0
votes
0answers
38 views

WordPress Settings API Overrides My Previous Value

I have created the following custom menu page to save some data, I've included some repeatable fields inside the form. The problem that I have is that every time I click the submit button it overrides ...
0
votes
0answers
17 views

file_get_contents to update_post_meta strange behavior database via shortcode

Here is the context : with a custom plugin, I create a shortcode which must retrieve a list of articles as text files (html inside h2, p, links) from a thematic folder. The html content of the text ...
0
votes
0answers
8 views

wait for DB to finish before reloading page

In my account page I have some PHP logic going on along with update_user_meta. The status of the user meta depends on what the page will display. The problem is that page refreshes before the ...
-1
votes
0answers
8 views

wordpress plug in suggestion - front end editor shell plug in [closed]

I am looking for suggestions on a WP plug in to look for if anyone has ever used one - I have a plug in that only displays its results table in the WP Admin area. I want this to display on another ...
0
votes
0answers
14 views

code that I can run, or a plug in to show what sql tables something pulls information from

Does anyone know if there is some code I can run, or create or a plug in in existence where I can click "run" or see a display showing what sql tables a page is pulling from? For example an ordering ...
0
votes
1answer
18 views

What structure and database storage method should I use for temporary storage that may be written concurrently?

In working with a third-party API, I need to store some state information to help track a process. I'm wondering where and how I should store it. Specifically, I have a multi-page Gravity Form, and ...
0
votes
0answers
12 views

How to perform a heavy and long process in cron jobs?

I have a table in my database that has more than 1000 records and new records can add anytime. I run a process on every record of this table daily. I use an event scheduler to do so in WordPress. But ...
0
votes
1answer
20 views

how to access 2nd Mysqli Database from different server for wordpress

hello I have an old website https://www.manthanpublication.com/manthantest hosted using Codeigniter as it is hard to customize I decide to change to Wordpress now the problem is I have student result ...
0
votes
0answers
9 views

adding user_id and name to a separate table whenever a user register based on role

add_action( 'register_new_user', newfun); function newfun( $user_id ){ $user = new WP_User( $user_id ); if ( ! empty( $user->roles ) && is_array( $user->roles ) && in_array( ...
-1
votes
0answers
18 views

Accessing 2nd Mysql Database from different server in wordpress to display student result

please provide me with a code so i can access 2nd data base in wordpress to run following two pages in wordpress. i want to access 2nd MySQL database in Wordpress from a different server (Wordpress ...
0
votes
2answers
28 views

Multiple Address In WP-Option Value

I've tried to setup my wordpress using 1 domain name and 1 ip address, after this, all the css is missing, but the site still can be accessible using both domain and ip address. Then I tried to ...
0
votes
0answers
23 views

Move Non-WordPress users table to WordPress database

I'm new to Wordpress. I have a users table for my non-WordPress site. Now I want to move my site to WordPress but I have few doubts - Usually, We can transfer tables by exporting as a CSV file and ...
0
votes
0answers
9 views

Update WooCommerce Product's Price From Remote Programatically

Is That Possible to Update Product Price And In-Stock Status In WooCommerce DataBase Programatically? We Need To Read This Info(Price,...) From A Remote DataBase And Insert Into WooCommerce DataBase. ...
1
vote
1answer
32 views

WordPress site uses MyISAM, should I switch to InnoDB necessary?

I've been managing a site for a long time, so the database still uses MyISAM for database engine. So, now that I transferred the site to a new server using mysql 8.0.19 (before it was 5.7), I'm ...
0
votes
0answers
9 views

Is there any defects for using same database prefix in WordPress for multiple sites?

I have now two sites using the same database prefix i.e., not other than wp_ Now, the argument arises that if there are some known issues or defects for them being same. As if I install WordPress from ...
0
votes
0answers
8 views

image size url returns 404

I just recently migrated some old blog posts from one site to another. The images have been imported as well. However, now most of my images are returning 404 errors. Images are linking to /wp-...
0
votes
0answers
4 views

Not showing avatar, email , last-name and one custom field after buddypress sync map of registered users

i have 250 previous members in my site and when install buddypress and sync map with it, avatar appears black ,email are empty , last_name- showing firstname and one customm field also showing first ...
0
votes
0answers
7 views

wordpress sort data in table user

In wordpress how to sort data when I use WP_User_Query. this is code: $query_args = array('role' => 'dc_sub_vendor'); $meta_query = array( 'relation' => 'AND', array( ...
0
votes
0answers
10 views

Filter database based on map selection

I want to add a list of professionals in a country, and I want the user to be able to filter on these professionals Selecting by a category (dropdown) Also by selecting the area on the map (or this ...
0
votes
1answer
45 views

Get Shortcode output to database for static post_content

my simple shortcode retrieves a list of articles as text files from a folder. These articles are in html format (with h2, p ...). I use a plugin which creates the pages I need on the fly in which I ...
0
votes
0answers
11 views

What's the cleanest way to transfer WordPress to a new server

I manage a website with more than 6k posts, and I'm having some server issues, so I'm planning to transfer it to a new server, but I want to do the best not to bring the issues with it. What's the ...
0
votes
1answer
36 views

Very slow page loads

I've inherited a wordpress site using the Avada theme and page loads seems to be exceptionally slow, anywhere from seven seconds to 30 seconds. It looks to me like one or more of the queries are doing ...
0
votes
0answers
26 views

Deleted products from woocommerce are still in the database

I deleted some product variations from my Woocommerce website. almost 75% of all the product variations on my website. I had 20,000 products with 640,000 variations. and now i have only 180,000 ...
0
votes
1answer
19 views

Can we store password in without being hashing?

Actually I'm not against hashing but I'm sending user data from website A to website B for being same username and password. In such scenario when I extract password from website A it is already ...
0
votes
0answers
10 views

Save Custom Password Protected Page Entries to Database

I'm building a custom form to access a password protected page (adding two fields: Company and Email) and I would like to save all the entries into the Database. It's only saving to the database ...
0
votes
1answer
11 views

Fill custom select field with pages/post titles

I'm just getting into the world of SAGE development and at the same time, I'm using the Advanced Custom Fields plugin. Let's say, that we have created two custom post types (Professors, Lessons). ...
0
votes
1answer
14 views

Migrating meta_key and meta_value from old theme to new one

I've just installed a new theme for my wordpress website. ( Jannah Newspaper Theme, to Bimber ) My website is a platform for posting music videos. Jannah Theme have stored all my embed video posted ...
0
votes
0answers
18 views

Umlauts displayed wrong

I'm importing values from a CSV into my wordpress MySQL database. CSV is generated via SSIS and encoded as UTF-8. Encoding of the website is set to UTF-8 in its header. Checked values in the database,...
0
votes
1answer
22 views

Error establishing a database connection - Wordpress setup, everything else is working

Setting up a LAMP stack with Wordpress on a home machine and port forwarding so I can host it on the Internet. Everything seems to have gone ok so far, except when I browse to the IP I see the error ...
0
votes
0answers
18 views

custom post types, custom fields and normalization

I have decided to redesign a plug I developed to use custom post types and custom fields instead of custom tables in the database. I have some questions about abstracting data into new post types. ...
0
votes
1answer
11 views

Custom post type and custom taxonomy key lenght & query performance

I'm creating new custom post types and taxonomies for my client and I wanted to prefix their keys so there is no conflict with any plugin that could be installed that would be providing it's own CPT ...
0
votes
0answers
13 views

Automatically Mirror User Password Changes from Live to Staging Database

If a member resets their password, this will do so on our Live site, which is fine. However, this won't affect their account on the Staging site. If we then push live from Staging (using Siteground's ...
1
vote
0answers
18 views

Trying to change database tables storage engine to innodb gives error “invalid default value for 'post_date'”

I have a live WordPress website. Most of the tables are using MyISAM storage engine with UTF-8 encoding. I need to switch their storage engine to innodb. But when I try to change the engine, I get ...
0
votes
0answers
16 views

Update post_meta table from other database

I need to take values from an old database to a new one. Specifically a plugin's meta value of WooCommerce products. I've got the same products data in both tables but the IDs are not coincident, so ...
0
votes
0answers
14 views

Migrating my site to a new domain does not keep any changes made in customizer

I have been making a wordpress site on my LAMP installation locally, modifying theme and uploading posts and whatnot. So when it was time to finally upload it, I dumped the database, searched and ...
0
votes
0answers
14 views

Separate database for WordPress plugin and custom post type

I'm creating a big database (tens of thousands of entries a month) of gift cards. I want this information to be stored securely on Amazon RDS separate from the regular WordPress database that's apart ...
-1
votes
1answer
29 views

Is it safe to increase/alter the size of the wp_post.guid column from VARCHAR(255) to VARCHAR(2048)?

I am planning to use External Media Without Import plugin which, like any existing media, uses the guid column of the post table to store the URL of the media (ex: jpg etc). My DB has this column ...
0
votes
1answer
22 views

Restore of database doesn't show content

I had to reset and reinstall wordpress bescause of compatibility issues between some plug-ins. So as usual, I took a full back-up of the website, databse, home directory, email, etc.... After a new ...
0
votes
0answers
15 views

The arabic character changed to question marks after upgrade the php version from 5.6 to 7.2

I have a wordpress website when I tried to update the wordpress version to 5.4 it asks me to upgrade the PHP version. I did the upgrade from the server and when I back to the site before updating the ...
0
votes
0answers
12 views

Create categories manually in database

I'm new in wordpress and trying insert some categories directly in Database, it's like: wp_terms - insert register (Ex: ID:1, name: Cat 1 wp_terms - insert register (Ex: ID:2, name: Cat 1_1 ...
0
votes
0answers
13 views

Prevent a post with a specific ID from being created

Is there any way to blacklist a certain post ID, regardless of the post type, so that a post with that ID is never created?
0
votes
0answers
8 views

Need advice for a storage structure

I'm developing blacklist plugin for Woocommerce. Can't decide, which way is better for data storage without a custom database creation. Admin can add some user data to blacklist (for example email, ...
0
votes
1answer
10 views

How to check and get json object in WP database?

I need to check if an option value from database is a json object. This funtion following cannot work : function isJson( string $str, $is_assoc = true ){ json_decode( $str, $is_assoc ); ...
0
votes
2answers
19 views

Why theme settings lost when I installed https

I installed https on a website. I did these steps : locate the certificate SSL Added redirections in .htaccess Changed in database all http://mon-site.fr into https://mon-site.fr I don´t understand ...
2
votes
1answer
26 views

Using same database for main and subdomain

I have a website let's say mysite.com (with it's own database that I created through plesk) and i have created a subdomain with the name sub.mysite.com. After trying to install wordpress on my ...
1
vote
1answer
27 views

How to get the POST TITLE using the POST ID?

I made a page with several POST IDs that I get from the Table of a plugin. Now the page is showing like: 3249 3250 3251 3252 (Post IDS) I wanna show the title of those IDs like 3249 - POST TITLE ...
2
votes
2answers
117 views

Saving Metadata from the Gutenberg Editor Sidebar to the Database

In the saga so far, you can see my First post/question Second post/question This is my third (and hopefully final) question. I've got everything working except for saving the data in the WP database....

1
2 3 4 5
45