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

learn more… | top users | synonyms

3
votes
1answer
56 views

Issue with foreach on duplicate meta_key's

Im storing using add_user_meta custom values that get sent to the front page of the website. Here is the php code. $user_query = new WP_User_Query( array( 'fields' => 'ID' ) ); ...
3
votes
1answer
143 views

What is the correct way for plugins to create tables with special charset/collation considerations?

I'm using WordPress >=3.8. The default charset/collation values in wp-config.php are define('DB_CHARSET', 'utf8'); define('DB_COLLATE', ''); // Becomes utf8_general_ci I am in a situation where ...
2
votes
1answer
30 views

Change setting name in Customizer and keep the data

I created a theme while back when I was new to Customizer API and for some weird reasons I named theme settings as: $wp_customize->add_setting('thefunk_theme_options[header_color] Instead of just ...
2
votes
1answer
235 views

error establishing a database connection

I know this question is asked like a million times, but I can't find an answer for my problem. This problem is happening in a user of my server (my father's blog actually), and as he told me: "Just ...
2
votes
1answer
97 views

What are terms and taxonomy, how they related to post and how these three are stored in database?

I want to understand terms and taxonomy in WordPress. My questions: What are the terms and taxonomy in wordpress? How terms and taxonomy relates to post and how post, terms, taxonomy are stored in ...
2
votes
1answer
43 views

Should I be able to run two different “close” code versions of wordpress with the same DB

A concrete example - I am upgrading to 4.1 from 4.0, the upgrade was successful but I discovered that a plugin broke. Can I just revert the code. The real live issue I am facing is having two ...
1
vote
1answer
15 views

Wordpress Multisite blogs not working after domain swap

After I swapped over my domains and updated every instance of the old domain in the database and everything else in this guide: https://wpengine.com/support/how-to-change-a-multi-site-primary-domain/ ...
1
vote
1answer
47 views

Wordpress Database lost auto increment

After rolling back a Wordpress database to a backup version it seems that all the tables lost their auto_increment on the primary key columns. I read on another post this could be to do with InnoDB ...
1
vote
1answer
92 views

How to merge local and live databases?

We've been developing for Wordpress for several years and whilst our workflow has been upgraded at several points there's one thing that we've never solved... merging a local Wordpress database with a ...
1
vote
1answer
16 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 ...
1
vote
1answer
32 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
136 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
54 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
59 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
39 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
48 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
58 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
339 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
237 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
23 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
50 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 'studioc_editionspanda....
0
votes
0answers
45 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
127 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
31 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
58 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
131 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
69 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
67 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
106 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
427 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 ...
0
votes
0answers
35 views

Automatic add record after refreshing page

I have on page only this code: get_header(); global $title; global $wpdb; global $current_user; if ( 0 == $current_user->ID ) { } else { } include_once('home-sidebar....
0
votes
0answers
180 views

WordPress 3.6 generating empty database

I wanted to migrate my local WordPress i use for theme development to 3.6, but the generated tables in the database are empty. WordPress creates all tables, but only wp_options is being filled, but ...
0
votes
0answers
28 views

Wordpress database tables crashing frequntly

For my site www.placementmantra.in, I am experiencing twice-daily table crashes, mainly wp_posts. I tried disabling all plugins, but the problem persists. Any suggestions?
0
votes
0answers
83 views

Getting deleted users in database

I am using the database that is being used by a WordPress site. I am trying to get all the users from wp_users table with SQL query. But there is also previously deleted users in wp_users table. I ...
0
votes
0answers
574 views

Wordpress multisite and one database

i need to use one database (i mean the same tables) with all sites under my network. I know about switching blog, but it's not good with wp-admin side (for example for custom post type i can't see the ...
0
votes
0answers
444 views

Displaying database data as pages (or similar)

I have a friend that has a big database of cars (lets say 4000 entries). Now he wants to add this info to his website. Initially I played with the idea of creating a page for each car, but this ends ...
0
votes
0answers
548 views

Get User Login Data (date, time… )

I did my best looking for information about this subject. Your guidance is appreciated. My goal is to perform some actions based on the number of user logins on my website per month and login days ...
0
votes
0answers
243 views

Save Changes function after table is sorted using jquery

I have a simple table, and the jquery works great for sorting. The fields drags an drops perfectly, and updates then and their. Also of course the data in the fields are saved in a array. The data in ...
0
votes
0answers
133 views

Combine Query and Select Database to create directory loop

I have a query loop on my page that I am using which displays all users on the page with certain custom fields filled out. It's working fine however, I need to also query these users for their level ...
0
votes
0answers
26 views

Moving database from WP 2.6 to 3.5 problem

I recently moved my database from a wp 2.6 blog to a wp 3.5 form using this posts advice. (Alex Miller's answer). Everything looked good on the home page; however, when I click on an individual ...
0
votes
0answers
200 views

Using Zoho Creator Database inside Wordpress Frame

Our agency network has an existing Wordpress-based website, and we would like to use Zoho Creator sort of like an intranet which is accessed through the Wordpress site. Basically, something along the ...
0
votes
0answers
1k views

Host does not allow remote connection, so how do I transfer data to my WordPress site?

I spent the last week trying to get my PHP code on my website to connect to my remote "personal" computer to display some data on a webpage. I just found out today from my web host (ipage) "our ...
0
votes
0answers
705 views

Install WordPress with SQL database

I am very new to WordPress. I didn't even know it existed until I had to do it for my work. So I started in with a WAMP server with WordPress. That worked fine until we needed multiple sites with ...
0
votes
0answers
64 views

Create hundreds of users with just ID in phpMyAdmin

I'm trying to do the same as this post. But I have a problem with the insert records into your wp_users table containing all the ID's of the members you want to import Right now, I have 3 ...
0
votes
0answers
182 views

Custom query on Wordpress custom table

I am working with a custom table where some values will be inserted or updated if they already exists, I have checked and rechecked the syntax and it seems to be working fine, if I run the same query ...
0
votes
0answers
62 views

MySQL Engine vs. Charset

I am attempting to have my plugin create a new table. I am fairly new to SQL. I have found two different method for creating tables: Method I $table_name = $wpdb->prefix . 'cool_table'; $sql = "...
0
votes
0answers
401 views

How to add drop down sub menu from database fields in the particular menu slug

I am creating a menu(not in admin panel) in wordpress, and I want to add drop down menu from my database table fields in a particular menu slug? How can I achieve that, using code? I found the ...
-1
votes
0answers
20 views

Error establishing a database connection using Azure

We're using Azure to host our website, last week we accidently hit our maximum number of connections so Azure stopped our website. But today, Azure has re-enabled out website but now it isn't working. ...
-1
votes
0answers
29 views

Wordpress Theme linking to a Sharetribe Database

I am a wordpress newbie and am building a site and am keen to use a Wordpress Theme and then link it to a Sharetribe.com database. I do however want to have a multifunction search bar on the home page ...
-1
votes
0answers
16 views

Dump new user data into codeigniter user's table

Here is the flow: Add new user from WordPress dashboard. Grab the newly registered user's data. dump user's data into codeigniter app database What i have tried: using user_register action hook ...