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

learn more… | top users | synonyms

0
votes
0answers
42 views

Is removing orphaned wp_postmeta records safe?

I am using woocommerce as a shopping cart on a wordpress site. Products and Product Variations are each stored as records in the wp_posts table. Each of these Variations have aprox. 15-20 associated ...
0
votes
0answers
17 views

Change Custom Menu Header Manually

I am working on a legacy site and typically don't work with Wordpress, so I'm crashing very hard into the WP world here. Basically, from what I can tell the site has these Custom Menus set up. I want ...
0
votes
0answers
40 views

Convert from .htaccess to web.config?

When I convert to web.config. It shows an error: <rewrite> <!--This directive was not converted because it is not supported by IIS: RewriteBase /.--> <rules> <rule ...
0
votes
0answers
21 views

Why is wordpress trying to re-install itself?

I ran out of space on my MySQL server so I got a bigger disk and moved the files to the new disk, restarted MySQL and things were fine. But I went to my sites and now wordpress is acting like its ...
0
votes
0answers
18 views

What's the point of wp_blog_versions?

The documentation says about wp_blog_versions: The current database version status of each site is maintained in the wp_blogs_versions table and is updated as each site is upgraded. but what's ...
0
votes
0answers
14 views

saving and retrieving data

I been following some tutorials on how to create wordpress plugin, but i did not understand how to save data into a table, from admin e.g asking some questions and then on the front end displaying it ...
0
votes
0answers
23 views

Theme options not being sent to Database

Currently working on a little project for a theme, doing this so i can learn the in's and out's of wordpress. So far i've got to the point of adding sections, and fields within those sections. ...
0
votes
0answers
29 views

Custom Post Types and Posts are mixed

I need help with a problem related with CPT and WP Database. I have a wordpress install with bbPress and a custom post type called Destinos. The problem is that when I´m looking for the forums, or ...
0
votes
0answers
39 views

Restoring .sql backup results in “Error establishing a database connection”

I'm trying to get the database dump (.sql) of a remote site to work with my local setup. Sort of like migrating from remote to local. I've already ftp-ed the site itself, but having problems ...
0
votes
0answers
34 views

Redirect Issue: Wordpress database

I have an issue with my wordpress site that seems to relate to the settings in wordpress. However, it seems to go into a redirect loop. I can confirm upon a fresh installation the issue disappears. I ...
0
votes
0answers
17 views

How does one change the posts database table of a site?

I am currently in the process of developing a mobile site to accompany a site that I have been operating for a while. I came up with the idea to use multisite to create a second site with a ...
0
votes
0answers
53 views

Error establishing database connection on app engine

Error establishing database connection on app engine after deploying wordpress. I got an error Notice: Undefined property: batcache::$query in ...
0
votes
0answers
50 views

trying to update post meta in bulk

I have been trying to arrange my site so that my URL structure is set to domain.com/collection/%collection%/%product-group% Where %collection% is a taxonomy term, collection is the index, and ...
0
votes
0answers
137 views

Unserializeing multiple column values that are stored in one database results variable

Lately i have created a custom template to search for data in a database, and also displaying it, by the use of checkboxes. So, a user can select multiple checkboxes to search data on and the query ...
0
votes
0answers
26 views

GET user's metadata, list it in descending order and GET user's list number

I have a custom user metadata with meta_key reputation. The value is numeric. It is like a points system. The higher value the user has, the higher reputation they have. How do I GET where each user ...
0
votes
0answers
57 views

Getting data from database and use it to complete a form

I have the following files: Main plugin file: <?php /* Plugin Name: FixFormData Description: If you want to autocomplete a form with existing data, this plugin is for you. ...
0
votes
0answers
28 views

Reset postmeta entries every month

I have this currently running on my site, which counts how many times each 'post' has been viewed, adds one view to the count and then saves it in postmeta: function getPostViews($postID){ $count_key ...
0
votes
0answers
34 views

Show WP content on different PHP Sites

we are about to start developing a big dynamic web project (Probably on ZF2) which will have some modules&tabs to act as CMS module (displaying news, galleries, posts etc). Let's assume we have ...
0
votes
0answers
19 views

Best way to define a database with product codes and back-end support?

First let me explain what my wanted situation is: I have a WordPress site where I want the Admin to have access to about 10.000 "product keys". These codes will be inserted in a database of some sort ...
0
votes
0answers
49 views

Create user assessment and use results in sql query

I am building a plugin that displays custom post types based on a user's assessment result. For that I need the user to fill out a form (not a very complicated one). This form submission needs to save ...
0
votes
0answers
112 views

How can I create a data entry form that has Master Detail ability?

I have a patron and books for a library (in this example). One person/patron, many books. I have the two tables. I believe I could use either tablepress or roll my owne output via a custom plugin ...
0
votes
0answers
25 views

How to handle this problem related to the publishing date of imported posts?

I have the following situation that I have to handle: I imported some posts from an old custom blog (not WordPress, a custom blog made using ASP). I exported in CSV format the content of the table ...
0
votes
0answers
12 views

Where is stored the Publish date value for a post?

I have to do a massive change in the database and I need to know in what field of what table is stored the publish date value of a post. Using phpMyAdmin I see that each record into the wp_posts ...
0
votes
0answers
16 views

Custom subscription abandonment

I'm using a subscription service through a small third-party company. I've asked them to consider sending emails to users that drop-off from the subscription but they don't want to implement such a ...
0
votes
0answers
39 views

Exclude posts from certain meta_key

I have query to retrieve all posts, but how can I check the condition for post meta_key ="develop" and meta_value='anything' SELECT DISTINCT date(p.post_date) as post_date FROM $wpdb->posts p ...
0
votes
0answers
19 views

User Tracking for Custom Post Type “Lesson”. Database Queries and Performance

So I wrote this little code snippet to add a post id along with the current users id to the user meta table. I'll use this to show the "lesson" posts that a user has viewed back to them. My only ...
0
votes
0answers
160 views

add_post_meta not saved

EDIT I changed it to if(isset($_POST['Make'])) update_post_meta($pid,"Make", $_POST['Make']); if(isset($_POST['Year'])) update_post_meta($pid,"Year", $_POST['Year']); ...
0
votes
0answers
21 views

How To Structure A Wordpress Database Query?

I have an array containing the IDs of the rows I want to update: $matches = array('abc123', 'def456', 'ghi789'); Rows with those IDs must be updated so that their 'confirmed' value is changed from ...
0
votes
0answers
57 views

How to connect database table to each registered wordpress user.

When registered user visit certain page, I want him to be able to add some 3 column data to a database that can be retrieved for him later. The way I see it implemented is by automatically adding an ...
0
votes
0answers
51 views

High CPU usage after running WP-Optimize for the first time

I installed WP-Optimize and ran it one time. It found and removed over 1500 post revisions and some spam comments. Before this, 4 CPUs were very idle, below 10%. After running the scan, all 4 CPUs ...
0
votes
0answers
24 views

Error with moving my webhost

I've been developping a wordpress webshop for a while now. This week my webhost almost expired, so I've been looking to move to another company because my old one wasn't that good. Today I got my new ...
0
votes
0answers
15 views

why ’ quote double quote in database wordpress

i'm trying backup and restore database using php code. but i don't know why quote double quote show in database wordpress, something like ’, and destroy my wiget_text. So how can i fix that.? help ...
0
votes
0answers
81 views

Pulling Content from Existing Database

I am moving an existing site to wordpress. The existing site already has thousands of rows of data (items for a shop) stored in a different database. I dont want to import this data directly into ...
0
votes
0answers
18 views

Custom Search Page to a different table in the same db

I am new to wordpress and php. I want to create a search page. The inputs are: State, GoverningOrg, ProgramType, Orderby. Then press the submit button. So basically what I did was create a new page ...
0
votes
0answers
56 views

Can't Post to my Wordpress Anymore!

I'm at my rope's end with this whole thing and have tried everything I can to solve it. I have a WordPress site with a SQL database on Azure, but recently all of the users associated with the site ...
0
votes
0answers
19 views

new multisite, old db

I'm trying to get my old posts from a WP install that was in a sub-directory on my site, into a new Multisite install on a new host. The new install is doing what it should. the problem is the posts ...
0
votes
0answers
39 views

Multiple Installs using the same database AND tables

I've been looking for a solution to this problem for actually a few months. Before I get started I would like to inform that I have NO INTEREST in using wordpresses multisite. Here is the issue for ...
0
votes
0answers
28 views

Issues with page load after CSV export of database

I'm having an odd issue. I am using GEO my WP plugin (http://geomywp.com/) to create some custom post types and search forms on the front end. I am trying to import a database with about 600 posts ...
0
votes
0answers
83 views

Writing directly to WP_Posts table

We directly add posts to WP_Posts table using filemaker. Once the post has been published, however, wordpress seems to be disregarding the existence of certain fields. For example, we have data in ...
0
votes
0answers
45 views

Get custom value from external database

a non-coder here but fairly competent to put together blocks of code :) I´m trying to build a prototype using Wordpress and one need I have is to connect to one or more different databases to get a ...
0
votes
0answers
32 views

Can't seem to replicate permalink structure for localhost development site

I'm helping a friend migrate her WordPress powered shop. I'm to the part where I manually re enter all of her products on WooCommerce. On her current live site the link looks like: ...
0
votes
0answers
139 views

call stored procedure without parameters

I asked this question last week, but then I deleted it because it was stated to be off-topic because I use a function within buddypress. However, I am convinced that whatever I am doing wrong is more ...
0
votes
0answers
106 views

Strange Deadlock database error for the query “Delete From wp_options”

I'm experiencing a strange Database error in these days, and it could the the cause of the slowness of my website (tasc.it) in these days. I found this error in the PHP error log, I can see about 4-5 ...
0
votes
0answers
27 views

Does wordpress has Presentation, Data and Logic layer?

I am using wordpress to create websites for a long time but now I have an order that i don't know what technology to use. All the client requirements can be done using wordpress except one - the ...
0
votes
0answers
84 views

Change post category via MySQL

I'm currently building a management program that works separately from Wordpress but interacts directly with the Wordpress MySQL database. I have it working updating, adding and deleting posts and ...
0
votes
0answers
108 views

How to split the Wordpress database?

I have a site that is used to log client and meal information. It is based on Wordpress, but has quite a bit of custom code. We have custom taxonomies set for the client and meal data. Our problem ...
0
votes
0answers
87 views

Error establishing a database connection - WordPress Multistage in Sub-Folder

I have a website running on my production server which I moved to localhost. The folder structure is as follow: localhost/xxx/main - Here are the website files. I have updates the database by ...
0
votes
0answers
58 views

External json physician database to display results in WordPress

We're working on a physician network site in WordPress using the Divi template and we have most work completed. However, we've also been tasked to have a physician search that will bring up results ...
0
votes
0answers
48 views

RSS Feed has no Items (Possible Plugins Conflict)

I am the webmaster of the German WordPress website http://www.kunstplaza.de. Recently, I have noticed that there are no items in the RSS feed, although there should be some as I am posting new ...
0
votes
0answers
64 views

Update entry in WP database through backend form

I'm trying to find a way to UPDATE a entry in my WP DB via a form. My idea is to grab the current entry values, link to another page with another form and display them there inside containers. That ...