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

learn more… | top users | synonyms

0
votes
0answers
13 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
0answers
31 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( $wpdb->get_var('...
0
votes
1answer
25 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
26 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
15 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
28 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 $wpdb-&...
1
vote
1answer
43 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
3answers
51 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
0answers
16 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
2answers
59 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
27 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 lost'...
0
votes
0answers
12 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
26 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 ...
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 ...
0
votes
1answer
18 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
25 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 ...
1
vote
2answers
71 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
1answer
28 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
1answer
32 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 ...
1
vote
0answers
33 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 /home/xxxx/public_html/wp-...
0
votes
2answers
51 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
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
1answer
61 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 ...
0
votes
2answers
51 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
30 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
44 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
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
22 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 ...
1
vote
1answer
34 views

How do I find out the full path of a page's template?

If I run the following query on the WordPress database, I get a list of templates: select distinct(meta_value) from wp_postmeta where meta_key='_wp_page_template'; The templates that come back are ...
0
votes
0answers
44 views

How can I push local database changes to production, without impacting recent posts/pages that were published on production server?

I am currently pushing static file changes like this: git > remote repo > deployHQ > production Seems to work great for static files. Finding a similar solution for the database hasn't been as ...
0
votes
0answers
23 views

Associate multiple Database ID's

I am using a form plugin in a multi-seller woocommerce environment where each user (seller) utilizes this form which the values are stored in form's DB tables. My problem/question is: when a seller......
0
votes
1answer
184 views

ERROR: “Table Prefix” must not be empty

I'm having trouble trying to setup WordPress for local development, I tried to install it, but even though I fill up the form to setup config file I still get the same error, I can connect to database,...
0
votes
1answer
41 views

Form and database, plugin development

I'm developing my first plugin. It creates directories and save the path, level (if it is a subdirectory of other created directory) and name in a custom table, created at the activation. The plugin ...
0
votes
0answers
63 views

How to create a coupon in the database?

I added over 1000 coupons (schedule ones) in the database. I had one line in wp_posts and several wp_postmeta tables per coupon. To add, I've saw how a coupon was represented there and I've made ...
0
votes
2answers
31 views

Get all images from this database table

This is my code. Where I'm wrong? <?php $connection = mysql_connect($DB_HOST, $DB_USER, $DB_PASSWORD); mysql_select_db($DB_NAME); $img = mysql_query("SELECT * FROM wp_bwg_image"); ...
0
votes
0answers
42 views

How to configure MySQL-SSL-Access to a MySQL Server 5.5 when a list of CIPHERS seems mandatory?

I have a MySQL 5.5 Server with SSL setup. I can connect with my MySQL user via command line from the webserver to the database server over TCP and verified the connection is encrypted. I figured out ...
4
votes
1answer
80 views

Wordpress Unit Testing - Cannot Create Tables

I'm using PHPUnit to Unit Test my WP plugin on top of the WP testing suite. Everything works fine except that when I try to create a table via the setUp method, the table doesn't get created. Here's ...
0
votes
0answers
17 views

Query a custom post type from a different WordPress install?

I have a client who would like to only create his items on one domain, but have a specific taxonomy of that custom post type display on a different domain (this is not multi-site...they are separate ...
0
votes
0answers
20 views

How can visitors create appointment request to be accessed by all subscribers?

I need some guidance regarding an 'appointment request' implementation. I'm developing an online community as free university platform for patients to find free dental care in university clinics. ...
0
votes
0answers
23 views

Database table not created without error

I have this code to run on activation to create the table $table_name = $wpdb->prefix . "codes" function code_install() { $sql = "CREATE TABLE IF NOT EXISTS " . $table_name . " ( id ...
0
votes
1answer
40 views

I have include wp-config, should I add global $wpdb also?

Usually, In my wordpress website, when I modify template page file, it is done by only add global $wpdb for databse operation without including wp-config file. Now, I create my own php file in ...
0
votes
0answers
21 views

user_id increment?

I wanted an Admin account with user_id 999 in our database, so I changed some settings in the database according to http://www.wpwhitesecurity.com/wordpress-security/change-wordpress-administrator-id/....
1
vote
2answers
72 views

Delete transients in website

We have so many error happen on website (WordPress and Woocommerce) error log and it will show the following error message WordPress database error Deadlock found when trying to get lock; try ...
0
votes
1answer
13 views

Surrogate ID for posts, is there an alternative field in the posts table?

I am copying some content between another CMS and Wordpress. I need to keep track of the original Id because I might have to update the copied content in the future. The old CMS will still be used for ...
0
votes
1answer
44 views

Plugin Development: Storing and Manipulating Data That Fits JSON in Database

I am new to Wordpress plugin development but not web development in general. I have a website whose functionality I am trying to port over to Wordpress for a client that needs it in a custom plugin ...
0
votes
0answers
80 views

WordPress database error Deadlock found

My website become slow due to this issue. WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_options WHERE option_name LIKE '...
6
votes
2answers
439 views

How to tell which database tables belongs to which multisite site

I have a local multisite installation I use for development with a relatively large number of sites set up. Every site has its own numbered database tables (i.e. wp_n_links, wp_n_options, ...
0
votes
0answers
73 views

Unusable menus and “Illegal widget setting ID: nav_menu_item[]” error

This is a bug in my WP install that has crept up unknowingly; I can't say for sure when it began. To describe it: there were menus created in the Appearance -> Menus page early in the site's history, ...