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

learn more… | top users | synonyms

0
votes
0answers
40 views

Preventing concurrent update of data

I have to implement the update of some metadata. An algorithm try alter some global variables in order to minimize a global error function. This algorithm is triggered by users who ratings each other. ...
0
votes
0answers
66 views

Get User data from external site

I would like to pull user data into a mobile app. I would create a simple login in the app and send the username and password to my wordpress site. The site would authenticate the user and return user ...
0
votes
0answers
23 views

Using one WordPress installation for two sub domains

I'm helping a friend of mine with his website. He's an artist and he's making music & films. he wants to have 2 separate website using subdomains. like this : music.hiswebsitename.com ...
0
votes
0answers
153 views

Manipulate database of WordPress site with my own scripts

I love WordPress as it provides plenty of great themes, good SEO and overall content management. But I'm not always happy with WordPress's original "Add post" and "Edit post" features as it required ...
0
votes
0answers
79 views

Possible to remove settings from wp_customize?

So, really basic setting here. function Ari_customize_register( $wp_customize ) { $wp_customize->add_setting('header_position', array()); $wp_customize->add_control('header_position', array( ...
0
votes
0answers
33 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
105 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
49 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
39 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
18 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
39 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
46 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
110 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
89 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
21 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
100 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
81 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
498 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
32 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
214 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
41 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
50 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
23 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
68 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
307 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
49 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
30 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
23 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
47 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
263 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
29 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
125 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
81 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
33 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
28 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
101 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
32 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
65 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
21 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
74 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
36 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
189 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

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
307 views

Would manually deleting the dumping data fix a “#1062 - Duplicate entry '1' for key 'PRIMARY'” phpMyAdmin error?

I'm new to PHP! I'm trying to import an SQL database file into myPhpAdmin for a WordPress I'm migrating, but I keep getting this error message: SQL query: `-- -- Dumping data for table ...
0
votes
0answers
434 views

Check if values exists DB

I am getting nutts with this one. I want to check if the email introduced in the form already exists in the database before creating a new record. But for some reason the email is empty at search ...
0
votes
0answers
63 views

How to select from a WP table every 10s in a class (OOP)?

I'm trying to select records every ten 10 seconds from columns message and messagetwo from my WordPress table wp_userlogin, but the code is not being executed. I'm calling wp_schedule_event when my ...
0
votes
0answers
273 views

A plugin is giving me “You do not have sufficient permissions to access this page.” error

I noticed this morning that I was logged off from my site. Whenever I tried to access /wp-admin it gave me a "You do not have sufficient permissions to access this page." error. After an hour of ...
0
votes
0answers
40 views

Mysterious template change after database import/export

When I switch databases from my local environment to the host, some of the pages inexplicably change templates. E.g. there is a custom template "Home" and when I switch the db's it ends up with the ...
0
votes
0answers
111 views

Problem with Featured Image and database

I have an issue with with WordPress install which I just haven't been able to resolve... I have tried disabling all plugins and reverting back to default theme, but the problem remains. The issue is ...
0
votes
0answers
97 views

wp_usermeta key problem

I am trying to add a meta key to wp_usermeta but it does not work at all. The key would get value from a checkbox. I used the code from Wordpress codex tutorial and it's not adding anything. I will ...