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

learn more… | top users | synonyms

0
votes
1answer
18 views

Can not manually create a database ( db, user, pass ) for a plugin

So I was working on a plugin and I needed to cache some third party API access, and I needed to manually create a database upon plugin activation or upgrade. The caching stuff needs a database host ( ...
0
votes
1answer
13 views

how to read database fields

Can someone please explain how to read the letters, numbers, and colons in the wordpress database? For example: a:1:{s:13:"administrator";b:1;} in the wp-capabilities table. Thanks!
0
votes
1answer
272 views

Is there any way to recover deleted menu from database sql backup

i accidently deleted my main menu but i have a .sql database backup file and i want to recover my menu from this file. Is it possible? Thanks.
1
vote
1answer
726 views

Wordpress database import: Row size too large

I've done a dump of my Wordpress database using Windows's command prompt: mysqldump -u username -p databasename > filename.sql Then, on a different server, imported it using: mysql -u username ...
0
votes
2answers
30 views

Inserting dynamic content into a page

I see this subject comes up regularly but have not seen an answer to my specific requirement yet. I'm trying to use a WordPress page as a template and insert database-sourced content (about 20 or so ...
0
votes
1answer
16 views

Media library images “missing” after migrating them using SQL

I am migrating a lot of posts from an old site to a new site, and these posts have a lot of Advanced Custom Field "relationship" data attached to them. Because of this, I want to keep all of the ids ...
6
votes
3answers
5k views

DB connection error after copying a WordPress Multisite instance to a second location

Here's my setup. I have a Multisite instance running at http://example.com, and I want to do development and staging. Moving an existing Multisite instance of WP onto localhost is a nightmare, so I'm ...
0
votes
2answers
218 views

Error establishing a database connection - Multi-site with subsite don't exisit [duplicate]

I have a multi site setup to which I have placed define( 'NOBLOGREDIRECT', 'http://www.example.com' ); In the wp-config.php file However when I visit a site which dose not exist (e.g. ...
0
votes
2answers
1k views

Saving Custom Post types and fields to a custom table

I have a project in which I am trying to import a large amount of data into a WordPress installation and from that data, create pages on my site (as a custom post type). Since these pages will be ...
2
votes
1answer
2k views

Insert query inserts 2 entries, should insert 1

I've written a small posts by views plugin, well at least started one. My tables are set up but when they are updated the code adds 2 entries into my table when a post is loaded and views are ...
0
votes
0answers
19 views

Passing string from a form to another page [migrated]

I have tried several plugins to try and pass a text field to another page via PHP and a HTML form. The form works and displays what was entered if there are no text input boxes in the form. The end ...
1
vote
4answers
3k views

Converting WordPress into Android or iPhone app

I've had a request from my client to convert their WordPress website into an App for Android and iPhone. I've looked around at a number of options and it seems doable especially for just the blog ...
-2
votes
0answers
17 views

How to put data from database in mail subject in contact form 7? [closed]

I've made a form using contact form 7. When a user submits the form, the form content is mailed to my mail address. Now, I have to put a field from a database table in the mail subject. Right now, My ...
5
votes
2answers
3k views

Count & Display Database Queries

I'm looking for an solution how I can count and display all queries in a WordPress site. Does anybody know, if there is an good plugin? Otherwise it would be an solution to check the queries on the ...
3
votes
2answers
915 views

Shared Members between two different wordpress installations with different databases

I have two wordpress installations with same host with different folders. Each installation uses its own database. I mean, database are separated. I am not using one database for two wordpress ...
0
votes
1answer
336 views

Displaying BLOB PDF File

I have some pdf files that are stored in the wordpress database as a blob and I need to display these files. The files are not linked to any posts directly. The code I have currently is: <div ...
0
votes
1answer
9 views

Include plugin form in the home page

I created a Wordpress plugin, which allows the admin to add information through a form, and it is saved in the database. I'm trying to link each photo that I upload in the Media library with a form. ...
0
votes
1answer
4k views

Error establishing a database connection when installing multiple sites locally

Initially I was using MAMP and had only 1 wordpress site running locally on my Mac. I've set: document root to: documents/mywebsites/mysite1 In phpMyAdmin I created a DB called: mysite1 wp-config ...
4
votes
3answers
407 views

Why WordPress choose data serialization over json_encode?

In my little age with WordPress, I've seen WordPress itself and its friendly plugins are using PHP serialize() in storing data into db in many cases. But in a recent search I found a serious community ...
1
vote
1answer
42 views

Get data from database using $WPDB

I'm missing something here. I simply want to get data from my database. So I tried this but keeps giving me an error. global $wpdb; $sql = "SELECT * FROM $wpdb->postmeta WHERE group='$group'"; ...
0
votes
1answer
365 views

Safely store code(html/js..) into database

So I'm working on a small plugin, and this plugin allows users to save data to my db. This data is mostly plain text but 3 fields are will have tags inside them. 1 field can be used to save all kind ...
1
vote
1answer
379 views

Wordpress choose wrong database

I have 2 databases. When I include the database connection (with a include('filename.php');) wordpress acts really strange. I can't login, the wordpress username and password is right but it tries to ...
3
votes
4answers
2k views

How to run Two Wordpress blogs with different themes and with single database and same content

How do you run two Wordpress blogs with different themes using one database where the content remains the same in both sites? The issue that I am getting is at the Domain mapping in both blogs.
0
votes
0answers
13 views

WPDB and custom URLS parameters

I need to display some information out of the database for each user. Each user has their own URL for example www.domain.com/music/11612 <?php $music_song_count = $wpdb->get_var("SELECT ...
0
votes
0answers
14 views

Return image urls with specific base string?

I have two wordpress sites on the same server (for ref call them site1 and site2). site2 hotlinks some images from site1. The problem is I recently used a CDN on site1 and told the CDN to disable ...
0
votes
2answers
774 views

Storing textbox values in Database

I am new to WordPress but I am good with PHP programmings, if I wanted to get value from the textbox and store it in the database in WordPress can I do? for ex form1.html <form name="form" ...
0
votes
0answers
12 views

dbDelta Not Working

I have some code with dbDelta that I'm trying to use to create a new database table for my plugin: <?php global $mm_importer_version; $mm_importer_version = '1.0'; function mm_install() { ...
0
votes
0answers
15 views

version control for wordpress? (wordpress folder and database at same time)

I am familiar with version control to some extent. I have been using git and github for school purposes. Now when I use wordpress it makes sense that I can use git when developing on my local ...
0
votes
1answer
20 views

How to relate 3 wordpress components with each other (Create database relationships)

Alright, so I have these 3 website parts: Gallery (that has) Artist Place A gallery can have only one artist and one place An artist can have many galleries A place can have many galleries When I ...
0
votes
1answer
22 views

Selecting NULL value from the database

I have a database with columns that are allowed to be NULL. Whenever I run a query against this database using $wpdb->get_results the columns that are NULL are always returned with an actual ...
-1
votes
0answers
50 views

Form Entries Only Displaying Sometimes

I created a custom lead generation tool for real estate agents using wordpress multisite and a plugin called Formidable. Since there are multiple forms, I had a programmer custom code the entries into ...
0
votes
0answers
20 views

Link wordpress with a SQl + MongoDB + .NET

This may sound a bit crazy, I have a website using different DB, One SQl; one MongoDB, and a .net API I would really really love to be able to move this to a wordpress installation ( or Magento). ...
0
votes
2answers
48 views

Optimising amount of calls to custom fields

I have this code fragment in my codebase: foreach($this->adverisers as $adveriser) { $this->data[$adveriser->name]['image'] = bfi_thumb(get_post_meta($adveriser->ID, ...
0
votes
1answer
470 views

Inserting data into custom tables

I am trying to create custom input tables to send data into custom tables on the wp database. I cannot get my script to do anything. The user will enter a type of liquor, like vodka or whiskey, ...
0
votes
0answers
33 views

What am I doing wrong here? WordPress database error

I'm just trying to insert values into custom table of wordpress and it throws me this error WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to ...
0
votes
0answers
21 views

How to make post title determine category in wordpress

Is there any way to assign a post automatically to a category depending on the title of the post ! Suppose : Post title - This is a test post I want the post to automitically assign to category ...
0
votes
1answer
490 views

Retrieve and display data from custom db table in admin area?

So, i'm having a bit of an issue with a plugin i'm developing, I wonder if anyone can shed any light on the situation, as many, MANY searches have come back with zero help. :-/ Basically, my plugin ...
0
votes
2answers
170 views

Export / import Wordpress database

Is there a proper way of exporting and importing a big WordPress MySQL database to a new database? When I tried to do that in the standard way I run into 2 issues: All widgets disappeared and I had ...
0
votes
1answer
19 views

Widgets with *internal* links do not display after database migration

I am using Grunt to dump my local db, search and replace URLs in it (and account for serialization by using grunt-peach based on Peach), send it to my staging server, then import it into my staging ...
0
votes
1answer
27 views

Use Tags to Query Associated Multiple Posts and Get The Average Of Custom Field Values

I have created a custom post type named “Rating” that I’m using to add customer rating sections to my website. Each rating post has the ability to have a: Title Comment section Featured Photo ...
0
votes
0answers
43 views

API to push post data to WordPress and populate custom fields

I've been looking around for related posts and such in the codex and other Q&A sites for several hours now, but haven't really come up with much so I thought I'd ask all you fine people out there ...
0
votes
0answers
16 views

Adding Database Tables for Reviews functionality that incorporates Tags/Categories

I'm wanting to build onto to the Wordpress database in order to give myself the functionality to create/retrieve customer reviews based upon tags/categories. More specifically, the reviews are not ...
0
votes
1answer
19 views

How to Generate a list of Most Commented post?

I'm trying to call a list of most commented post. But the call to the DB returns always the same post (the first one in the loop) This is my code in functions.php function ...
0
votes
2answers
34 views

How to intercept update_option() before it saves data?

I am working with redux framework and need to save theme option values to a file right before it is saved in DB. Is there a way to intercept update_option() right before it saves data in DB?
0
votes
1answer
31 views

How to connect remote database in wordpress?

I have already wordpress website. i want split my existing database into two parts and store into remote database. So how can i set up remote database connection for existing wordpress ? If its not ...
1
vote
2answers
2k views

“Error establishing a database connection” - Intermittent error on GoDaddy

After transferring a working WordPress site to GoDaddy hosting, we've begun getting "Error establishing a database connection" errors on all pages- first intermittently, and now consistently. It's ...
0
votes
1answer
32 views

Sharing users across multiple sites, each on their own database

I have read many solutions out there for sharing users and checked out the other posts on here, but can't find specifically what I'm after, as they all talk about users on the same database. ...
0
votes
0answers
14 views

get_results is not working properly

I tried to find an answer in many forums for this problem, but it has been impossible. My problem is that when I do $wpdb->get_results in an empty table, mi webpage immediately stops working. ...
0
votes
1answer
25 views

Wordpress site URL changed; how to fix it without database access?

we would like your assist on an error that occurred during some changes on the admin panel. We have this site called Caid.gr , it's for a non-profit company. We changed the Wordpress site URL by ...
1
vote
1answer
2k views

what is the use of /wp-includes/SimplePie?

I have this location on my server. /home/localhost/public_html/wp-includes/SimplePie. I have not installed samplepie plugin. What is it used for since it is not associated with samplepie plugin. The ...