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
0answers
10 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( ...
0
votes
2answers
29 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
24 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
12 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
48 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
10 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
11 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
11 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
47 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
44 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
33 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
13 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
12 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
18 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
22 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
25 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
12 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
38 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
17 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
15 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
35 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
34 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
13 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
9 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
15 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
20 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
29 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
28 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
209 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....
0
votes
2answers
37 views

add_action('the_content', 'my_plugin_content') is null

I am creating in personal plugin where I recover data from a personal table. Con add_action('the_content', 'my_plugin_content'); posso far vedere il contenuto in una pagina. I would like to save the ...
1
vote
1answer
67 views

Populate dropdown from database

I am creating a custom plugin for our martial arts school and have come up against a problem that is doing my head in. No doubt I am missing something obvious but have never really dealt with ...
1
vote
2answers
26 views

Form doesnt save to database

It is my first form trying on wordpress.I changed some names such as "name","e-mail" etc. to "name1" , "email1" etc.Because without these changing, submit button refers to 404 page. There is no any ...
1
vote
0answers
15 views

database connection [closed]

I want to create an wordpress website (Question paper genrator) in which there will be a button called genrate paper after clicking it a question paper should be genrated and question should be taken ...
1
vote
2answers
141 views

Notice: wpdb::prepare was called incorrectly. The query argument of wpdb::prepare() must have a placeholder

//Get Services and save to database first. for($i = 0; $i < count($_POST["wc_service_id"]); $i++) { $wc_service_id = $_POST["wc_service_id"][$i]; $wc_service_name = $_POST["...
1
vote
0answers
18 views

Database to page routing API?

Lets say I have in my database a table for Universities - and for each entry in the database, the primary key would be the name of the University, i.e Duke. If I created a template for all the ...
0
votes
1answer
23 views

Store GravityForm data in phpmyadmin (mysql)

I'm currently developing a small portal on Wordpress for a client where users have to submit forms (created with Gravity Forms). I'd like to be able to store the data from these forms, upon submission,...
1
vote
1answer
20 views

Better ads plugin has 500.000 entries in wp_postmeta

My wp_postmeta table is huge, around 1.2 million entries, about half of those are caused by bs entries (_bs_via_rel_2, _bs_review_verdict, _bs_source_url_2, _bs_source_url_3... etc). From what little ...
4
votes
1answer
64 views

Inserting choice in database table

So I have this code: <?php global $wpdb; // This adds the prefix which is set by the user upon installation of WordPress. $table_name = $wpdb->prefix . 'wpex_programma'; // This will get the ...
0
votes
1answer
24 views

How can I find user role in Mysql?

SELECT user_id FROM $wpdb->usermeta WHERE meta_key= .$wpdb->prefix. _capabilities AND meta_value= ROLE in serialized array. How can I set meta_value in serialized array? Many thanks in advance ...
0
votes
0answers
22 views

Insert and retreive data from custom database from Wordpress page

This is the first question I'm asking here, so I'm open to any feedback on how to clarify my problem/question! I have created a small javascript game on a wordpress page with "custom html". I'd like ...
0
votes
0answers
48 views

Custom Plugin Database relations

I will make custom page for my plugin.As a example, in this video, global $wpdb is used to call variables of sing-up form.How can I call my own plugin's variables? I dont know database info yet.Also ...

1
2
3 4 5
46