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

learn more… | top users | synonyms

0
votes
0answers
18 views

Duplicate slugs in wp Database [on hold]

While updating a category I keep getting "Item not updated" message, after a little research I found that it is due to duplicate slugs in the database. I know a slug cannot be duplicated, so now I am ...
-6
votes
0answers
25 views

Database Linking From MyPHPadmin [on hold]

I would like to know how am i supposed to build a site which offers multiple login for different users and different data view as per the user for each login. For example a ERP site, when a ...
0
votes
0answers
15 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
44 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
404 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
30 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
19 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
332 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
169 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
17 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
21 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
30 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
14 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 ...
1
vote
1answer
29 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
17 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
31 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
30 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
1k 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
21 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
12 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
21 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 ...
0
votes
1answer
16 views

Split posts between databases

My client requested quite a specific solution for his WP based wordpress (single site, not multisite). Basically what he wants is, let's say after 1000 posts new database should be created (with 5 ...
1
vote
1answer
645 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 ...
5
votes
1answer
102 views

WordPress and multithreading

I'm working on a plugin. I've created an API that reads and writes to a custom table in the DB. This API can be called potentially from N clients simultaneously (and it really happens). I noticed that ...
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
1answer
32 views

2 website 1 database… Local to online

I've two wordpress websites : - One online in FTP folder "www", for this website everything's ok ! - The second website is on localhost for the moment. I would like to put the second website on the ...
0
votes
1answer
323 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
36 views

Save and user submitted data from a form and display them in the wp backend

My question is very simple but the answer I'm not sure if will be that simple. I'm developing a website for a non-profit organization where people can fill out a form containing questions usually ...
-2
votes
0answers
16 views

Which is the get_the_terms effective sql generated by wordpress?

For some heavy process about one project I'm working at, I need to access the database directly with mysql connections and not with WP_Query or wordpress functionalities. So I need to know for ...
0
votes
1answer
15 views

What Wordpress file is saving new users to database

I need to know, what Wordpress php file is saving new users to database. I can't find it, but I need to modify new users usernames before it's added to DB. Thank you!
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 ...
0
votes
1answer
53 views

Why is converting my database to UTF-8 truncating entries?

I'm running WordPress 4.1.1. My site is hosted at NearlyFreeSpeech. I've been using my WordPress blog since the days when it encoded information in the latin1 charset. This week, I realized that ...
0
votes
1answer
22 views

Converting Posts to Pages

So my site backend had issues and my hosting company had fixed it up for me. In doing that, they inadvertently made all my pages, posts. I'm looking at the database that hosts this and there is a ...
0
votes
0answers
18 views

Pages edit as posts

I'm currently dealing with the fallout of the following question (How to change post to page). I got all my pages back though all the pages' URLs were changed so there is no hierarchy and when I try ...
0
votes
0answers
17 views

Set Display Name to first and last name (phpmyadmin SQL Query)

I'm trying to change all the users Display Names to be their first and last name. I have looked into a number of plugins and wrote my own PHP to try and accomplish this however the site has over ...
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
2answers
977 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 ...
0
votes
0answers
23 views

Save data on custom table Wordpress

Here is my current code, <div class="wrap"> <div id="icon-tools" class="icon32"></div> <h2>Quote Manager</h2> <div class="aio-content"> <form method="post" ...
0
votes
2answers
48 views

Shared Custom post type between WP network sites

I'm developing four websites which are separate, besides the Events (custom post type). Three of the websites are WP, and I've got them in a Network. I would like Events to show up in all three Admin ...
1
vote
1answer
371 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 ...
0
votes
1answer
339 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 ...
0
votes
2answers
685 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" ...
-1
votes
1answer
18 views

Website that sells statistics

I'm building a website that will have statistics based on user activity on the website (online votes and views etc). People will have to pay to view those stats. I am utilising wodpress features ...
0
votes
1answer
14 views

Add several fields from different tables to post, fields per post are in same row of table

I like to add 4 or 5 extra fillout boxes to the adminpage of my post... For example, under the actual page box, I would like to add the following fields: Name position publications freetext Here ...
0
votes
1answer
54 views

Creating a search form and displaying results

Im trying to create a plugin for a site where the user can see a table of orders from customers in the Wordpress dashboard, It's a custom db but I'm using the wp-list-table, I've wrecked my brain for ...
0
votes
0answers
91 views

Fatal Error in \wp-admin\includes\misc.php after failed WP update

I was recently approached by a client whose wordpress site had been hacked. The hack caused traffic from search engines to be hijacked to cuteonbags.com. I narrowed down the malware in question and ...
0
votes
1answer
51 views

Image thumbnails not available post migration, but still accessible via direct URL - DB issue

To start with, I'll just clarify that this appears to be a different issue to the numerous migration ones already covered. In short, I've migrated my site to a new domain (both in root, no directory ...
0
votes
0answers
11 views

Migrate database between 2 different wordpress version

I have been trying to import a sql dump from a production site, which is several wp version behind the development site (4.1), is there any compatibility issue? Every time I try to login after the db ...
7
votes
4answers
24k views

How to integrate custom database table in Wordpress and using Wordpress functions

I'm on Wordpress 3.0.4 and I'm having a hard time deciding which way to go. The following is my problem: I have a mysql database table widgets, with about 10 properties like id, size, color etc. ...