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

learn more… | top users | synonyms

0
votes
0answers
39 views

Searchable database of members using multiple criteria / filters

I'm very new to wp let's say that first! What I need is to create a site which will list a database of members of an organisation. Users will also be able to sign-up and add themselves to the ...
0
votes
0answers
40 views

Add more tables under wp_term_taxonomy

How do I add default fields/columns in the taxonomy terms? I can add custom fields using plugins like ACF but I have no idea on how to query them from the database. I can query the name, slug, and ...
0
votes
0answers
38 views

Why this function not working for install database on plugin activation

I followed codex instructions from wordpress site but for some reason it's not working for me and i can't understand why is there any debug settings or options to activate to explain me where i go ...
0
votes
0answers
49 views

Preloading custom pages in cache using WP Super Cache

I am developing Exposure Inc. Co and am using the RB-Agency plugin for modeling database. The plugin is not very well architected and makes a ton of HTTP queries resulting in high latencies. When a ...
0
votes
0answers
20 views

Incorporating Biology Database with Thousands of Records

I'm a WordPress newbie working on a Mac with MAMP. I have a series of database-driven websites that I'd like to incorporate into WordPress. My biggest website focuses on biology, especially animals. ...
0
votes
0answers
61 views

Import Issue (ACF Repeater+WP Ultimate Importer)

I'm trying to import a bunch of data from my DB and there's plenty of fields, now i'm using advanced custom fields, repeaters to be specific. I had to make my own CSV file and I did this by exporting ...
0
votes
0answers
24 views

Category not displaying in add post, edit post, and categories page.

I have faced one problem after updating WordPress to 3.8.1. When I try to add or edit a post the category list at right side panel is blank, even though I have several categories on the site. Please ...
0
votes
0answers
155 views

Displaying database table in backend of wordpress

So basically I'm working on a job website for a client where they post jobs and users can apply for these jobs with a form that writes to the database with their inputed information.. I have set up a ...
0
votes
0answers
62 views

“Database Connection Error” upon install in Apache VirtualHost document root.. Why did this happen?

I have apache virtualhosts up and confirmed working. I want to install wordpress for one of the vhosts, so I unpacked all the wordpress files in the document root for that vhost. I proceeded to follow ...
0
votes
0answers
31 views

Transposh translation plugin querying wrong database

I've noticed my PHP error log growing very quickly, and it all seems to be a similar error: '[database name].wp_translations' doesn't exist However, the database it's trying to use is for a system ...
0
votes
0answers
94 views

Solution for database version control and deployment?

Currently i use a dump script and commit the database to the git repo. --skip-extended-insert --skip-comments --skip-dump-date means that a diff can give me a fair idea of what has changed, but it ...
0
votes
0answers
188 views

Count Checked Checkboxes in Contact Form 7

I've built a form with Contact Form 7. The form is a petition. It has a list of checkboxes with names and email values attached to them. If a name is selected, that email is added to the list of ...
0
votes
0answers
90 views

Collaborate on wordpress local website, share files via dropbox?

How can one share and sync files of a WordPress website with users that can edit (collaborate on) the website locally on their own instance? Can Dropbox be used to share the WordPress website files ...
0
votes
0answers
57 views

Get fatal error when using wpdb in jQuery.post target URL

Why am I getting a Fatal error whenever I use wpdb in the target URL of my jQuery.post? Here is my code so far. My process.php is this: <?php $to = 'myemail@gmail.com'; $subject = ...
0
votes
0answers
22 views

Every time I update or install a plugin I get “Error Establishing a Database Connection in WordPress”

At first I thought it was a resource issue because I'm only using the lowest AWS ec2 instance, but now I think it might be something else. I Google'd about a bit as it seems to be a common problem ...
0
votes
0answers
40 views

Perform database function in target URL using jQuery.post

I have a popup which gets the users input (name and email) and sends it to a process.php so I can send an email. I pretty much have that done. But I need to add a functionality wherein it will also ...
0
votes
0answers
64 views

Querying the DB to get sum of column from custom meta box (only published posts)

I am trying to get the SUM total of a custom meta box, from all published posts, from a custom post type. By using $wpdb I am able to get the sum from all of the posts (published and otherwise), but ...
0
votes
0answers
31 views

Moving WordPress site to a new server - Admin not loading

I'm trying to move a WordPress Database from one server to another. I've done this a few times with other sites and servers and I use Sublime to do the find and replace and I've had no issues up to ...
0
votes
0answers
36 views

Blog Not Loading, Can't Access Admin Page, No Trace of WordPress on Server

I recently took over as the webmaster for a small company, and I was asked to figure out what's going on with the company's blog, which uses WordPress. Essentially, the blog won't load, and this ...
0
votes
0answers
32 views

How Can I Put Meta_Compare in the Database-Query?

Yes, I know that this can easily be done with built in wp_query but I need this in Wpdb query. I have a custom field and I need to display posts where this field does not exist. By the way can I get ...
0
votes
0answers
47 views

Why does my WordPress front-end categories plugin gives me a database error with my SQL syntax?

A few years back I created a plugin based off of an answer here: How do I create a way for users to assign categories to a post from the frontend? Here's a pastebin of the modified plugin: ...
0
votes
0answers
36 views

Download user generated data from Wordpress

I have created a Wordpress site which I allow users to enter information about themselves such as name, age, sex and address etc. Now that I have this n formation I would like to know the steps I ...
0
votes
0answers
29 views

How do I authenticate/turn off a plugin remotely for plugin SaaS like functionality?

I have a client whom we created a custom plugin for. We are charging monthly for access to this plugin but the only way we have to disable it is manually in the Wordpress admin. How would I go about ...
0
votes
0answers
38 views

Broken Images After DB Name Change

I have a problem I have been unsuccessful in troubleshooting or finding other questions and answers for. My site was displaying fine. I changed the name of my database from "mydomain_beta" to ...
0
votes
0answers
32 views

Customize wordpress search query

Would this method parse_query of the WP_Query class allow a custom search query to a custom table? WP_Query I ask because the Codex says " To customize the query append additional arguments to ...
0
votes
0answers
167 views

help in applying pagination retrieve the data from database

I'm following the tutorial here http://wpengineer.com/2426/ on how to apply pagination in wordpress. Now he said "As pointed out in the comment the array_slice is only necessary because we use sample ...
0
votes
0answers
170 views

insert data from form to custom table

I have a custom form set up on a custom page template. I need the submitted data to be saved in custom table. What am I missing since this isn't send the data? The code I'm using: ...
0
votes
0answers
96 views

Pull Data from DB for Admin Page Display as Relates to Admin Page Class by BA Internet

Why do developers make it so darn hard to use the tools they develop? Don't answer, I already know :) Have had some success using this: https://github.com/bainternet/Admin-Page-Class ...to develop a ...
0
votes
0answers
15 views

Any harm in pointing my dev Wordpress installation to my production database?

I have a dev instance of a public website that I maintain, and while they are very similar, there are differences between the site structure of the development instance and the production website. ...
0
votes
0answers
81 views

Why are my WordPress post queries so slow?

I'm working on a larger WordPress site and trying to troubleshoot why my site is so slow. I've installed W3 Total Cache and have run multiple page speed and plugin tests with no luck. What's strange ...
0
votes
0answers
19 views

Plugins folder broken-No website functionality

After some plugin updates caused me to receive a database error, I was unable to access my dashboard. I changed the name of the plugins folder in FTP and it came back online. I then deleted my ...
0
votes
0answers
28 views

Get posts, terms and custom fields in array

I have a multisite and want all posts from post type products I want to query through the database to get all posts belonging to post type "products" i have accomplished this with the following code ...
0
votes
0answers
21 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
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 ...
0
votes
0answers
109 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 ...
0
votes
0answers
88 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
0answers
35 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
35 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
86 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' ...
0
votes
0answers
112 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
0answers
51 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
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
35 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
0answers
89 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 ...
0
votes
0answers
77 views

Submit password to Ushahidi Platform using gform_after_submission

OK basically I run Wordpress as CMS and Ushahidi for collecting information from different area. All I want is a registration form that send data to 2 different platform. I used Gravity Form ...
0
votes
0answers
37 views

Calling update_user_meta inside of another function doesn't work

I have a function that does updates a db outside of wordpress and then I'd like it to take that information and update the user_meta table in wordpress. The print statement prints all the appropriate ...
0
votes
0answers
51 views

I broke database after reuploading local version - what exactly happened? Database error

The site was already working but since I wanted to change the website more and my Internet is not good right now, I decided to download the whole wp folder to local drive, and export database. I set ...
0
votes
0answers
88 views

Passing user first and last names from external db to WordPress user first and last names using session variables?

This may be a little convoluted, but here it goes. I don't let users register on WordPress to access my member site. I have an outside registration/login system set up and want to continue using ...
0
votes
0answers
53 views

Update members data daily by a function

I use a function to update data (likes, +1, views, point, posts..v.v.) for all members on site Once Daily. So it may be can not run with >2000 members and >5000 posts. Only display a blank page. The ...
0
votes
0answers
126 views

Import Excel (or csv) Table with user-data as subscribers to wordpress

i have a tough problem. From an existing database with user-data I need to transfer those users as subscribers to my wordpress database. My user-profiles have various additional custom fields that I ...