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

learn more… | top users | synonyms

0
votes
2answers
38 views

Let users register weight each day and save it in DB

I need a way that lets my users register they're weight (kg) and maybe % of bodyfat and save that information on each user in the DB. Then i need a way to output that number again on the logged in ...
0
votes
0answers
16 views

I have a problem with my WordPress DB after I tried to install multi-site

I tried to install WordPress Multi-Site. But I ran into some problems with the DB. wp_1_posts: Table 'studioc_editionspanda.wp_1_posts' doesn't exist wp_1_comments: Table ...
0
votes
1answer
636 views

How to add checkbox with multiple values in table?

Right now i changed from options table to my own table so things are getting difficult i have a checkbox its name is selection in table, so here is what i tried <input type="checkbox" ...
-2
votes
1answer
91 views

get_option returning a different value from what's saved

add_action( 'admin_init', 'register_mysettings' ); function register_mysettings() { //register our settings register_setting( 'plugin_options', 'plugin_options', 'plugin_options_validate' ); ...
0
votes
0answers
21 views

How to joint develop a WP locally on two far away machines?

I was hoping someone can confirm to me, someone new to WP, how I can view a WP site created locally on 1 computer on another computer in a far away land. Basically my friend started developing a site ...
1
vote
2answers
132 views

Efficiency on displaying random authors based on large database

I'm trying to display a list of 5 authors randomly. Here are some solutions I had found: http://stackoverflow.com/questions/5502609/get-authors-randomly ...
0
votes
1answer
16 views

WordPress site seems convinced that it's still at its old URL

I had a demo environment set up in /subdirectory/ and then moved it to my root directory to make the site live. Used the wp migrate db plugin to export my database with the new paths, then replaced ...
0
votes
1answer
70 views

import (migration) user database to wp-users

I am having hard time for importing to user-meta and post-meta from my non-wp-tables. I am trying to do db migration from user table and post table to WordPress tables. So it might be user table ...
0
votes
0answers
79 views

Getting Poster Image (Thumb) of Video Embedded through JW Player in Feed

I am trying to add the poster image of YouTube video I embedded through JW Player in the post in the RSS Feed. Till now I found these: 1. This Code is working when used separately, it is getting the ...
2
votes
2answers
109 views

js Conflict in admin panel - I guess it's from the core WP installation

A client's site: causing serious js conflict or js loading disabilities, is under custody. Activating DEBUG, Deactivating all Plugins, and Activating Default theme "T13" found that, still the problem ...
1
vote
1answer
58 views

Posts are deleted everyday at night

So I have a weird issue with WP and that is that all Posts on the site are getting deleted sometime in the night. Before I turn of all plugins and change theme to default.. I would like to know if ...
1
vote
1answer
23 views

How can I get a list of comments by target

I've been looking at the classes WP_Comment_Query and WP_Meta_Query but to be honest, I can't figure out how to use them together. I want to query the database for comments where wp_posts::post_author ...
0
votes
2answers
413 views

Connect to remote database using Localhost install

I will be designing and developing a website for a client but want to allow the client to add content while I am working on the design and development of the site so that it is pretty mich done by the ...
0
votes
1answer
525 views

WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version [closed]

after wordpress update to 3.5+ i get error in this plugin. I do not understand how to fix it. If anyone can help me with these problem or give me an example of how to fix it here is the full code of ...
1
vote
2answers
164 views

Database connection close

Is there any method to close connection similar to mysql_close() for $wpdb in WordPress? Is it not necessary to close connection for global $wpdb?
0
votes
1answer
180 views

after wordpress update to 3.5+ i get many errors in plugin wpdb::prepare()

after wordpress update to 3.5+ i get many errors in this plugin. i found that the reason is: http://make.wordpress.org/core/2012/12/12/php-warning-missing-argument-2-for-wpdb-prepare/ I do not ...
1
vote
1answer
31 views

Database for development

While building plugins one of my biggest annoyances is that my development machine does not match a real world install. What I mean here is that my databases are lacking. I'll code something thinking ...
0
votes
2answers
61 views

Accessing two databases wordpress

I'm trying to access a second database with my wordpress system. To do this, I've attempted to follow the advice found here which seems to have worked for a lot of people. In summary, I'm adding ...
0
votes
1answer
66 views

Comments broken. All comments gone & no new comments can be made. Possible jetpack issue?

So, my client has two self hosted wordpress blogs- one long-existing and one new one that she just launched. She clicked on a jetpack activation link- meant to connect her new blog to it's ...
0
votes
2answers
19 views

Database question while Migrating from one domain to another on same WebHost [Bluehost]

I am about to migrate WordPress Installation from One Domain to another which are under the same host and have common cpanel. Besides the first step of backing up and moving the WP filesystem, can we ...
0
votes
2answers
90 views

Removing Dashboard Menu Items Through The Database

I'm dealing with a previous developer that's being difficult. He's removed the Plugin & Settings menus through the database (I'm assuming) as I can't find it anywhere in the functions.php file and ...
0
votes
1answer
84 views

I'm not able to get access to $wpdb [duplicate]

I'm developing some additional functionality with a jQuery autocomplete form, some custom database tables, and PHP to query the tables. I have it working outside of the WordPress framework using ...
0
votes
1answer
56 views

Database location in Wordpress

I have created my website in WordPress and want to transfert it in my domain created with ipage. I am not able to locate the WordPress database. Can you help me? How is the format or extention of DB ...
0
votes
1answer
121 views

delete duplicate meta_value with same post_id

I've trying to cut down on the time to query a custom post type. After looking at the database and the wp_postmeta table, for some reason, there is some duplicate meta values for the same post_id and ...
0
votes
0answers
70 views

Is it ok to delete empty meta values

I'm using database peek http://wordpress.org/plugins/database-peek/ to show my database structure and have noticed that wp_postmeta has 95073 rows in it. I noticed that a large part of them have ...
0
votes
1answer
205 views

wp_insert_user not creating account correctly when ID is manually set

So, I'm trying to create a new user account with wp_insert_user based on credentials I receive from a Facebook user profile. I want the new user account ID to equal the Facebook account ID (ex: ...
0
votes
1answer
251 views

$wpdb->insert Giving duplicates

I'm getting duplicate entries with this, how can I fix it please? <?php echo "Month". $_POST["Month"]; global $wpdb; $wpdb->show_errors(); $wpdb->print_error(); $wpdb->insert( ...
0
votes
1answer
31 views

How to store category and tags separatly on wordpress?

I am trying to insert data manually on all tables on the back end. I am facing a problem while inserting data to wp_terms. I can successfully insert category into wp_terms and define relationships in ...
0
votes
1answer
713 views

How to access data in wordpress database externally using php

I want to share data in specific wordpress database tables with an iOS app. The client wants data entry via wordpress form plugins which create their own tables in the wp database. The plugins I've ...
0
votes
1answer
194 views

How to permanently delete a taxonomy

I want to delete a taxonomy (both form wordpress and database) created long time ago and now no more used. How to do it? I found this function but I think it will delete all my taxonomies... and I ...
0
votes
1answer
337 views

Wordpress DATABASE Update Manually?

I have a multisite WP and I'm now trying to update my WP to latest version. In the WP Administration Panel, there is a Network Update page at: Updates > Available Updates ...
0
votes
4answers
451 views

Multisite database upgrade SSL error

I have upgraded my Multisite setup WordPress to 3.6.1. And after that, when I do Network Upgrade > Database Upgrade it's showing: Warning! Problem updating http://www.example.com/site1. Your ...
1
vote
1answer
36 views

A field with dashes in the slug [closed]

How do I reach a specific userdata in the database, when that field has a dash (hyphen) - in the slug? I use the plugin WP-Members. I have created a new userdata field with the plugin with the name ...
0
votes
0answers
32 views

How to add additional field in a table row after creating a table?

I used options for my plugins.But now i have changed to use own table.i created and using things good.Now i would like to add one field that gets value from user and add that much value as field.This ...
0
votes
0answers
28 views

Send an email to users reminding them about the event 2 days in advance

In my database, I already have the users list and the events list with their dates and times. How do I send an email to the users list reminding them about the event 2 days in advance? I need it to ...
0
votes
0answers
73 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' ...
2
votes
1answer
100 views

Exporting Data from WordPress into a flat table

I need to be able to export the data within WordPress so that each object is contained in a single row, like a flat table. Imagine each post type as it's own database table, containing columns that ...
0
votes
0answers
108 views

Wordpress plugin tables become corrupt

I have written a plugin that creates and uses 3 database tables. On rare occasion, all 3 database tables become corrupt but no other tables in the database exhibit similar conditions. It is pretty ...
0
votes
2answers
152 views

WPDB SQL query with prepare() returning variable, not db value

I have been trying to get this to work for awhile now and I cannot seem to get any farther on my own. It seems to work fine as a normal SQL query but not within the WP framework using prepare(). ...
0
votes
1answer
44 views

Copy site on same server?

I have a wordpress installation running in my root folder, and I want a copy in /en (including theme, posts and pages). I want a bilingual site and found the plugins too complicated for me - so I ...
0
votes
0answers
47 views

Query Database and Return the result in translated pages

I am having a problem for a while now and I can´t seem to solve it on my own. I have made a website, this website is multilingual and it was made in wordpress. In my "photo album" page when I sort ...
0
votes
1answer
1k views

Simple form that saves to database

I am using a 3rd party service that does a scrub of my database for new entries within a specific table. However I am been unable to find a simple form plugin that submits data to the wordpress ...
0
votes
0answers
23 views

Display Plugin information on specific url

So I created a WP plugin with its own unique DB tables. I chose this approach as opposed to using a custom post type because of relationships I needed between the tables. So I'm not even sure how to ...
0
votes
0answers
34 views

How do I restore my WordPress that has been hacked?

The website was hacked a week and a half ago. I removed files that were added and removed core WP files that I knew I could replace just to move along the process. Now, I am left with the wp-content ...
0
votes
1answer
62 views

wpdb_prepare with multiple or condition

I want to execute a query like this: $wpdb->prepare( "SELECT * ... from ... WHERE ( post_title LIKE '%%%s%%' or post_content LIKE '%%%s%%' )..., $string ); If I do the query with only one ...
0
votes
1answer
37 views

Update field in database for users

I have made a frontend form for the admins where they can check a checkbox for each user and submit the form data by post. For all the users that are checked, a value should be changed in a field in ...
0
votes
0answers
85 views

featured image not showing up with mysql_connect

i noticed a certain problem with the featured image issue, i had everything work nicely until i added a mysql connection to another database to retrieve certain information, the featured image stop ...
7
votes
1answer
815 views

When is the 'post_content_filtered' column in database cleared by WordPress?

Some WordPress plugins (although very few) use the post_content_filtered column in database to save some data related to a post. For example, Markdown on Save stores the markdown version of a post ...
0
votes
2answers
283 views

How to change the database prefix in multisite (WPMU) install

I am starting to implement security features on a client's website and so I would like to change the WP database prefix. However, the website is a multisite installation (WPMU) and so changing the ...
0
votes
2answers
84 views

Installing local to live WP into subdirectory

I am having a bit of trouble moving a local WP site live and into a subdirectory. I want a static homepage for now (index.html in the root folder) while I work on the live site (would be found in ...