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

learn more… | top users | synonyms

-2
votes
0answers
15 views

Make a Wordpress database out of a phone directory Excel sheet? [on hold]

I have a phone directory with last names, first names, phone numbers and addresses. Could I add that spreadsheet somehow to the databases within Wordpress that would then enable the information to be ...
0
votes
1answer
549 views

Save custom meta box data to database

I have a custom post type Events. Under Events, I have a custom meta box which selects the time and data of the event: <?php $meta_boxes[] = array( 'id' => 'event_date_option', 'title' ...
0
votes
0answers
29 views

Storing Unique Data on the Database

I have created a custom table on my database using the code below: function dbcreator_activate() { global $wpdb; $table_name = $wpdb->prefix . "ftbstatistics"; if( ...
0
votes
0answers
8 views

Exporting a multisite DB for a single site production site

So I have a wordpress multisite that houses all of my client test sites(14). This means that its all one database obviously. This client is now ready to go live on a single wordpress instance so I'm ...
0
votes
2answers
54 views

Why my wp_posts data is so huge?

My WordPress has only 23 posts but the wp_posts data is over 70MiB. Is it the average size? The Posts I have were created with WPBakery Visual Composer and has 10 revisions. However, I deleted all the ...
0
votes
1answer
19 views

How to transfer one domain to another domain without losing theme options (customizer)?

I have developed the one wordpress site with custom theme, Here I used the custom customizer options. Then site completed on my local machine I mean localhost (http://127.0.0.1/wordpress). Now the ...
0
votes
1answer
18 views

Finding the login page from database?

long story short I was given the login information for an older gentleman who unfortunately passed away who managed a young lady's Wordpress website. Was asked to manage and update the site for the ...
0
votes
0answers
7 views

Options of accessing wordpress data from mobile app

There is an existing wordpress website and I would like to make native app(probably will do crossplatform native with React Native as I have experience with it) for it. So my question is: is there an ...
0
votes
0answers
16 views

Custom database query with accents returning no results

I have an issue where using accents in my custom database query (wpdb) returns no results. $wpdb->get_results( "SELECT * FROM table WHERE city = 'Montréal'" ); Returns nothing, while ...
2
votes
2answers
3k views

Insert query inserts 2 entries, should insert 1

I've written a small posts by views plugin, well at least started one. My tables are set up but when they are updated the code adds 2 entries into my table when a post is loaded and views are ...
0
votes
3answers
47 views

Create Tables in WordPress

I am very new to WordPress, and today is my 1st day on WordPress. I have a requirement which is very normal for any developer on their platforms, but for me it's challenging In my WordPress site I ...
0
votes
2answers
4k views

Inserting data into custom tables

I am trying to create custom input tables to send data into custom tables on the wp database. I cannot get my script to do anything. The user will enter a type of liquor, like vodka or whiskey, ...
1
vote
1answer
26 views

Plugin Options Not Saving to Database in WP 4.5

WordPress 4.5 broke my plugin and there are no obvious clues why in the change log The plugin controls the visibility of menu items. Users select one or more countries and whether to show or hide the ...
0
votes
1answer
12 views

Missing latest posts and options after DB migration via phpMyAdmin

The latest posts and options are not appearing after importing the database. I'm missing all the latest posts and the latest Advanced Custom Fields. The export is from the remote server and import to ...
0
votes
0answers
14 views

same users different websites other then wordpress

I am creating a network of sites. I have some wordpress installations as well as some other scripts installations. I know that i can use single wordpress users table for different wordpress ...
0
votes
1answer
1k views

How do I properly update the Wordpress database password?

A site that I manage was recently compromised and I am going through the steps to harden and re-secure the site. I would like to change the MySql database password and want to make sure I do not take ...
0
votes
2answers
447 views

Disable Database Update Required ? break my website

Im having an issue if i want to login to the dashboard, it needs a "Database Update Required" I'd like to disable it, because once it update the Database, if I go to any post of single-pages, it ...
2
votes
1answer
86 views

What are terms and taxonomy, how they related to post and how these three are stored in database?

I want to understand terms and taxonomy in WordPress. My questions: What are the terms and taxonomy in wordpress? How terms and taxonomy relates to post and how post, terms, taxonomy are stored in ...
31
votes
6answers
24k views

Why is my database import losing text widget data?

I've created a site in WordPress on our development machine. In the theme we're using there are numerous widget zones to display text in (sidebar and front page). I've used simple Text widgets in all ...
-1
votes
0answers
19 views

WooCommerce: Product attributes, which tables? [on hold]

It seems product attributes and attribute-values are saved in these tables: Attributes: %_woocommerce_attribute_taxonomies Attribute-values: %_terms Attribute <-> Attribute-values: ...
0
votes
0answers
15 views

Scheduling posts in database

I have more than 100 posts to schedule. I have set the date and the status (future) with a SQL query. But when the time comes the post is not published and in desktop I can read message 'Schedule ...
0
votes
0answers
11 views

compare database values before an update

in my wordpress, I want to store my form data to database by using: update_user_meta(); I successfully store the data to database and write it to the page, but the problem in whenever I updated the ...
0
votes
0answers
23 views

Custom post types from custom database

For a plugin I want to use custom post types based on data stored in an external database. This database isn't related to WordPress (the structure of the tables is independent). The datastructure is ...
2
votes
2answers
1k views

Ways of managing staging and production wordpress sites?

Ok I've see a lot similar questions.. but they all either outdated or do not fall in in my problem. So the problem is: We have a website and its clone stage website. On that website apart form me ...
1
vote
2answers
50 views

Installation with sql server express edition

I have developed a web portal in wordpress using xampp server. i have my database in my sql. Now i need to deploy this wordpress portal on other system with sql server express edition. So how can i ...
0
votes
0answers
16 views

Wordpress Switching from Dev to Live URL - Database [duplicate]

So I was working on a WP site with a staging URL. When it was time to go live I thought I could just change the WP_HOME & WP_SITEURL in wp-config.php and live would be good. I quickly realized ...
-1
votes
1answer
10 views

database search feature

I am looking to create a website that creates and searches the created database then displays the results on a custom page. I initially thought this would be a lot easier than it is proving to be. I ...
1
vote
1answer
740 views

Issue with wp_insert_post and post_content field error Could not update post in the database

I'm having issues creating an import / caching script to be used within a WordPress site. This feed comes from a single text file that is then parsed and returned as an array. When running through ...
0
votes
3answers
774 views

Fetch a single row from a custom table for to a given ID

When I want to get a single row from a custom table of my WordPress database by providing a username through function call, it does not work. When I mention the username in where clause of the query, ...
0
votes
0answers
11 views

Database collation and char set issue

I attempted to import my WordPress website from local host to live server online and i get an error #1115: that i have wrong db collation of utf8mb4. So i googled and changed the cllation to ...
0
votes
1answer
2k views

Retrieve and display data from custom db table in admin area?

So, i'm having a bit of an issue with a plugin i'm developing, I wonder if anyone can shed any light on the situation, as many, MANY searches have come back with zero help. :-/ Basically, my plugin ...
1
vote
0answers
28 views

wp_insert_post causing There was an error connecting to the database: Access denied for user 'root'@'localhost' (using password: NO)

I have a multi-step form which I am trying to fix but I am getting the error: Warning: mysql_query(): Access denied for user 'root'@'localhost' (using password: NO) in ...
0
votes
1answer
31 views

Why Worpdress doesn't create table in database?

Primarily this is the only code in my main plugin page. It should create table in the database while I am activating it. But, it is not working at all. Plugin activating successfully. Please, help me ...
0
votes
1answer
19 views

What unexpected data might be stored in terms table and related tables?

In order to remove thousands of old taxonomies and terms used during development, I recommended the following SQL queries to another dev: TRUNCATE wp_terms; TRUNCATE wp_termmeta; TRUNCATE ...
0
votes
3answers
908 views

Reset/Reorder posts ID in the MySQL wp_posts table

I have a Wordpress site that is considerably popular. I am in the process of optimizing the site before adding other plugins such as the WPML plugin which I suspect will be using custom post types. ...
0
votes
2answers
35 views

Where does the actual data stored by add_post_meta

I am pretty new to WordPress API, loving it btw, I have a small project, adding a like button to the end of every post, pressing it makes user like the post, button changes to dislike, pressing again ...
0
votes
2answers
2k views

Storing textbox values in Database

I am new to WordPress but I am good with PHP programmings, if I wanted to get value from the textbox and store it in the database in WordPress can I do? for ex form1.html <form name="form" ...
0
votes
1answer
615 views

How Do I Merge Categories With phpMyAdmin

I tried the following phpMyAdmin query to merge my category 112747 into my category 112748: UPDATE wp_term_relationships SET term_taxonomy_id = 112747 WHERE term_taxonomy_id = 112748; It did not ...
23
votes
4answers
23k views

MySQL Database User: Which Privileges are needed?

The short installation instruction for WordPress ("5 Minutes") state that: Create a database for WordPress on your web server, as well as a MySQL user who has all privileges for accessing and ...
0
votes
0answers
20 views

Add a Filed to WordPress User Table

I am going to give points for users for their activities. I thought to add a field for user table. Is it a bad idea? I use my own function to update that field.
0
votes
0answers
17 views

Why Do I Still Getting Duplicate Rows in SQL?

I'm creating a Custom Freight System which stores the order and the products requested by the user into the WordPress Database. The Problem When I insert the product into the wp_my_custom_products ...
0
votes
0answers
163 views

Google-App-Engine[PHP]: Error trying to establish database connection

Hi to whom this may interest, I am finding a problem with the cloudsql as database connection is not being established. I have followed the following site step-by-step ...
0
votes
1answer
442 views

Merge two databases: OLD SITE -> NEW SITE

I am working to a restyle of a website. I made DB dump from remote server and made local installation, then started to work on my local machine. While i've been working other post have been added to ...
0
votes
1answer
39 views

Restore woocommerce orders

Recently my server team replaced my database and they put our previous Database . So we lost our order details of one day[particular day] . Now the server team give the backup that contain the lost ...
1
vote
2answers
788 views

Most recent post from another database

I am trying to add the most recent post from another Wordpress database (on the same server in all actuality), but am getting the following error: Fatal error: Call to undefined method ...
0
votes
2answers
50 views

User content database

I am trying to set up a login where in each users profile they can add their CV and details. These details and CV will then be shown in a page that can be seen by anyone. The user has the option to ...
0
votes
0answers
36 views

How to delete a stuck post using phpMyAdmin

I was attempting to change some leftover http:// references in the DB using Update/Set SQL statements. I was getting confident and started doing them in bulk and stopped noting exactly what I was ...
0
votes
0answers
23 views

Join Wordpress databases from 2 different installs

I'm just now getting into SQL and the core of Wordpress (PHP). So I'm not an experienced WP developer but not intimidated by the tools. But, if the answers could be dummied down a bit would be very ...
0
votes
0answers
9 views

Save Hist in Author Pages by Date (Year and Month)

I'm trying to save the hits that a page receives in the database so I can display them in the front-end if required. I need the hits that an author pages receives and save them by month. I'm a bit ...
0
votes
0answers
18 views

Website keeps redirecting to Wordpress install page (install.php)

I hope someone here can help me as the problem I have is driving me insane. For the last few months I have been putting together a Wordpress portfolio and had almost finished it. Recently, out of ...