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

learn more… | top users | synonyms

0
votes
0answers
20 views

Create WP_Query to search for posts by their categories or their parent/child categories

Hello I am really sorry if this has been asked before but I couldn't find the exact solution I need. So here's the problem I want to create a search in my Wordpress page. Whenever a user submits the ...
0
votes
3answers
704 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
1answer
11 views

Is there a way to recover the table wp_term_relationships?

I'm trying to help a Non-Profit Organization with their site (which is built with Wordpress) that suddenly became "buggy"/odd: menus were missing, categories were empty, etc. I'm no expert around ...
0
votes
0answers
52 views

siteurl value getting populated with junk in wp_options table

My website was getting this error on every page : Catchable fatal error: Object of class WP_Error could not be converted to string in /home/juhisheth/public_html/wp-includes/default-constants.php on ...
0
votes
1answer
22 views

Localize strings from db

I'm using this method to translate strings in my template. The question is, what if some strings are dynamically loaded from the db? How can i translate them? I've been googling for days and even ...
6
votes
2answers
879 views

Is there a plugin that will override the “Error establishing a database connection” message? [on hold]

My provider's database server recently had some downtime and my site was displaying the classic "Error establishing a database connection" message for about an hour. I knew what the problem was but ...
6
votes
3answers
251 views

Ignoring initial articles (like 'a', 'an' or 'the') when sorting queries?

I'm currently trying to output a list of music titles and would like to have the sorting ignore (but still display) the initial article of the title. For example if I had a list of bands it will be ...
0
votes
1answer
3k 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, ...
0
votes
1answer
34 views

multiple wordpress installation with shared usertable on an different database

I have multiple wordpress installation, and I would like them to share the same usertable. The wordpress installations are already up and running, and they all have their own database. Is it ...
1
vote
1answer
30 views

Unable to set a default serialized array using dbdelta()

I am trying to set up a table with dbDelta() and one of the columns will have as default a serialized array with predefined values. The issue here is that dbDelta() explodes the query using ...
0
votes
0answers
11 views

Processing a lot of $wpdb isn't insert all the data

In my plugin the user provides some CSV files that are processed and either inserted or updated based on a sku (which acts as a foreign key to my DB and a primary key for where the CSV comes from). I ...
0
votes
0answers
15 views

See site's database's schema

How can I have access to my wordpress site's database schema without SSH an access ? I need to see the tables and fields but couldn't find a way without SSH (my host doesn't provide SSH access).
1
vote
0answers
15 views

How to update the values when the featured image has changed?

I'm trying to implement this function. It saves in the database the dominant color of the image uploaded as featured image in a post. It's working perfectly BUT the problem is that it only works when ...
0
votes
0answers
19 views

Access a WordPress Table from Outside Project

I have a PHP project on example.com and I have a WordPress installation on example.com/blog. I need to get data for my PHP project from one of My WordPress table. Is it possible? If it is possible ...
0
votes
1answer
15 views

Query wp_postmeta into an array based on post_id

I know this might be a simple question but can someone explain to me how to query the WP database and pull in all the "meta_key" and "meta_value" from "post_id" into an array? I have looked at code ...
2
votes
2answers
418 views

Is there a shortcut to change bulk BMP images to JPG images in a site?

Images in WordPress posts, as I understand, are uploaded manually. They are uploaded by default to uploads folder. A client of mine reported that, in one of his site, he uploaded all the images in BMP ...
3
votes
1answer
47 views

How to export WP database for import using WP-CLI on Vagrant Box?

Problem Now that I have a new environment with WP-CLI db import / export I need to import a database from a website that never had WP-CLI installed. Question What's the best Non-WP-CLI export ...
0
votes
0answers
6 views

Do I need to worry about filling meta_value column in wp_postmeta table during migration?

I am migrating article/post data from a Joolma site running 'seblod', which has scattered the data across multiple database tables, so I can't use an off the shelf migration plugin. I am transfering ...
0
votes
1answer
21 views

How Yoast SEO plugin works with variable %%name%%?

I know that Yoast SEO plugin doesn't create any database table then why in wp_postmeta numbering of meta_id are not continuous? Is it because of Yoast Plugin? Also I want to know how its feature of ...
-2
votes
0answers
21 views

Connecting the urgent PostgreSQL WordPress 4.4.1

I need to work with a geographic database. Should I use PostgreSQL on WordPress? I'm using a WordPress plugin in version 1.3 and I get error CONNECTION database.
-1
votes
1answer
19 views

Tool to check the database in Production

I Would like to use a tool to execute SELECT requests on the PRODUCTION database. This tool must be full security because my site is deployed on Internet. Any idea ? Regards
0
votes
2answers
751 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
57 views

Can't update database after wordpress update from 3.8.1 to 4.4.1

I have just updated wordpress 3.8.1 to 4.4.1. Tried to update in various ways: Before updating I have deactivated all the plugins and switched to the default theme provided by wordpress i.e. ...
0
votes
0answers
17 views

Bulk find replace to convert hundreds of old URL calls

We have a new wordpress site generated from an old html site with thousands of pages. An import process was used, but unfortunately as a result the site has hundreds of references within content to ...
0
votes
1answer
18 views

Unkown meta_value in ACF

I'm using ACF, but I wonder the meta_value means? Below is a snippet from my database: meta_id post_id meta_key meta_value 9394 4661 _carousel_0_image field_5683f27fd880e So what ...
0
votes
0answers
7 views

How do I establish a connection between Firebase user database and WordPress?

I'm making a Website and an android app. The android app stores its user details i.e., username and password on Firebase database; I'm also making a website and I want a login in the website which ...
0
votes
0answers
16 views

One WP Database outside localhost and two connections

I would like to ask for help with this problem. I have two places where I have the same WP. 1) Test site - own domain, hosting and DB - here is stored database, so siteurl is here, example: test.com ...
0
votes
0answers
18 views

Import SQL backup

So I accidentally deleted MySQL database of my wordpress, but my site is still running, I can access all the file in the filezilla but I just can't access the admin area of wordpress to make any ...
0
votes
1answer
524 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 ...
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
2answers
391 views

Custom Post Type or Custom Tables

I am in the process of writing a plugin that allows end-users to submit a form that includes customer information. Upon submission, I am notified that a new customer has submitted the request form. ...
0
votes
1answer
492 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' ...
10
votes
5answers
2k views

Is it bad practice to create own table for a plugin?

If I want to save settings for my plugin then it is pretty easy and straight forward. Now I would like to save to the database a bit more. A file name, and 3 other values that only apply to that ...
0
votes
0answers
13 views

#1062 - Duplicate entry '1' for key 'PRIMARY'

I am trying to move my database from my usbwebserver to my online server. But I get this error, can anyone help me with this? #1062 - Duplicate entry '1' for key 'PRIMARY'
0
votes
0answers
10 views

Importing inventory from a csv file in the ftp to the database

I'm looking to upload the content contained in a csv file from FTP directly into a WordPress database every 24 hours. This csv file (containing inventory items) gets generated from one site, and I ...
0
votes
0answers
10 views

MS Access to wordpress sql

I have a client who runs a store and has around 125000 products and he manages his stock from MS Access server. His current site is just for product catalog but he wants to have a new site to sell ...
0
votes
1answer
34 views

WooCommerce - Query for ordered products

I'm trying to obtain all orders for particular day/time and then order products using SQL (MySQL) as seen in the query below: select p.ID as order_id, p.post_date, i.order_item_name, ...
0
votes
1answer
20 views

Does WordPress $wpdb functions wait when table is locked?

Does WordPress' $wpdb functions wait when the table is locked? For example Function A() uses $wpdb->getresults. When $wpdb->getresults wants to read a table and its locked, does it wait for ...
1
vote
1answer
14 views

Setup private content for specific users with daily updates [closed]

So I have only found membership plugins which cater for private area where users can access the material after paying depending on their role. I need to make a dashboard kind of area where users can ...
0
votes
1answer
18 views

Wrong url for the images while using same database for two Wordpress installations

I have revamped the site hosted at https://example.com and trying to run the new version of the site at https://example.com/newsite But i want to use the same database with all the links as ...
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
0answers
12 views

WordPress database error (wp_terms)

I'm having the following issue. Whenever WordPress try to get any term from database (product_tag, portfolio_tag, etc) I see messages like: WordPress database error: [Error writing file ...
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 ...
0
votes
0answers
5 views

“User Role” Not Working

While following recommendations in IThemes Security Plugin, I renamed the database file prefixes which broke our site (multisite installation). I restored the database and everything seemed to work ...
0
votes
0answers
27 views

In WordPress do I create tables for my plugin or do I create custom post types for a Student and Classes Registration system?

I want to use WP 4.x as a framework to build a small Student system. I do not wish to use an existing plugin. My needs are unique, and these do not do what I need. In my design, I have Students ...
1
vote
0answers
22 views

Trouble Migrating all data blog from Wordpress.com to Wordpress.org

I'm transferring a WordPress.com blog to a new WordPress.org website but I'm having trouble transferring everything. I've gone through the usual WordPress tools - export XML file, import using the ...
0
votes
1answer
37 views

wpdb get_results() returns only 2 rows

I am trying to create custom admin widget to present how many users has registered within last days. I have created function as below: function mdbootstrap_add_dashboard_recent_users(){ global ...
2
votes
2answers
788 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 ...
0
votes
0answers
33 views

Wordpress installation: Error establishing a database connection

I've successfully installed Wordpress on my local system and used it to create a demo site. Now I'm struggling to get an empty wordpress installation to work on my webspace. Running the install.php in ...
1
vote
6answers
11k views

After server migration only the homepage works

I have recently changed hosting of my WordPress site to VPS.net. I have moved all of my files and imported the database. Everything appeared to be fine until I clicked a link and noticed that all of ...