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

learn more… | top users | synonyms

2
votes
1answer
45 views

what are terms and taxonomy and how they related to post and how these three are stored in database

I am newbie to wordpress. I want to understand terms and taxonomy in wordpress. My questions: 1. What are the terms and taxonomy in wordpress? 2. how terms and taxonomy relates to post and how post , ...
0
votes
1answer
875 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
0answers
25 views

Problem in adding new site on WP multisite

It's for two or three months that this problem exists in WordPress multisite and I'm still waiting for a solution or an update. When adding new site, I get this error: Warning: preg_match() ...
-1
votes
0answers
16 views

Customization in Wordpress Plugin - Search result page

I am using a WordPress plugin for travel search by Travel Grove. This is the url : http://www.designgridstudios.com/demo3/ . After filling the search form it points to Merchant site and compare the ...
2
votes
1answer
16 views

WordPress and automated MySQL backups to a different host

I'm having the following setup. A development computer in my local network and a production server with a real internet domain. Developing the PHP/CSS files on my dev computer for my theme is handled ...
0
votes
2answers
29 views

Should non-WordPress data get its own DB?

I couldn't find anything on Google or on here about best practice for data that is not really Wordpress related. Say we have a database of clients that we'll be accessing through PHP/SQL. Should I ...
0
votes
0answers
34 views

Loading posts from another wordpress database on the same server

I've searched quite a while and found several solution but apparently I'm doing a lot of stuff wrong. I'm having 4 different Wordpress sites and need to load the latest 2 posts of each site. For ...
0
votes
0answers
9 views

MYSQL ignore categories on Wordpress widget

I have this WP widget that pulls random products from the DB. What I really want is to be able to include just a few products categories (or exclude). Can anyone help me? I appreciate. <?php ...
0
votes
1answer
40 views

Post Views / Hit Counter Problem?

I have decide to use WordPress as a CMS to my 5 moths old website. I have already added all previous posts to my new site ( WordPress ). But now I need to change view counts to previous views counts. ...
0
votes
0answers
36 views

wp_editor content in plugin options page

Hi I'm writing a plugin it involves the site builder / user adding content via wp_editor this content is then saved and submitted via a submit_button. I've wrapped the editor in form action = ...
4
votes
3answers
6k views

where is permalink info stored in database?

I see that I can edit permalink information in wp-admin page > settings > permalinks. However, where is that information actually stored in the database?
0
votes
0answers
17 views

wp_include_post in custom post with coustom field

I'm new in wordpress and my english are not good. I'm using Custom Post Type UI plugin to create a post type "Product" and Advanced Custom Fields plugin to create some custom fields like address. Now ...
1
vote
1answer
127 views

Sharing woocommerce product data

I am needing two installs of WordPress and both are being used as an online shop. The problem i am having is that, I am having to update two sites with the same products and wanting to find a way to ...
1
vote
0answers
45 views

Issue with wp_insert_post and post_content field error Could not update post in the database

I'm having issues creating an import / caching script to be used within a WordPress site. This feed comes from a single text file that is then parsed and returned as an array. When running through ...
0
votes
1answer
35 views

Is it possible to recover Deleted users?

I've accidentally deleted all of my WordPress site users and now I want to recover those deleted users? IS it possible? I've not created database backup so is it still possible?
0
votes
2answers
45 views

Running a song lyrics site on WordPress

I converted an old site, which used to run on a CMS called Smarty, to WordPress and am trying to make the look and feel of the site look like a proper music lyrics site. There don't seem to be themes ...
0
votes
1answer
31 views

what is the best way to store user created data?

The plan is for users to be able to store locations and have notes and other variables for each location. These locations would later be shown on a map, so I would need to be able to quickly access ...
0
votes
1answer
15 views

Expired Post with More Recent Time Stamp?

Im having issues with custom posts not showing in worpdress. I see in my posts table theres two enters for each custom post X - Has a date Jan14th- 2:06pm - post_status: expired Y - Has a date ...
0
votes
1answer
21 views

Weird Behaviour: Not all Wordpress Posts appearing

My wordpress posts have vanished on my dashboard but remain in the database? Meaning I have many 404 errors. All (52) | Published (4) | Drafts (7) | Trash (2) TOTAL =11 items (Note how theres only ...
0
votes
0answers
22 views

Database migration tool for GoDaddy Managed WordPress

I’m about to revoke my Managed WordPress subscription because tools that I have paid for (such as WP Migrate DB Pro) that are an integral part of my development process that sync or migrate my local ...
0
votes
1answer
43 views

option select form always deleting the sql query

I have this form: <tr class="user-statusz-wrap"> <th><label for="statusz"><?php _e('Státusz') ?></label></th> <td> <select type="text" ...
0
votes
0answers
6 views

Users getting registration errors when signing up but still being registered on the backend?

Having a very strange issue on a Wordpress install - we cannot replicate the error ourselves, but multiple customers have complained about it: They fill out the registration form and get an error ...
0
votes
2answers
30 views

How to transfer from localHost to live but use the already existing database on the server?

I have been developing a WordPress website for a client, working from my own machine utilizing WAMP to create a local environment on which to work. Now, the problem is that the website needs to go ...
0
votes
0answers
30 views

Google-App-Engine[PHP]: Error trying to establish database connection

Hi to whom this may interest, I am finding a problem with the cloudsql as database connection is not being established. I have followed the following site step-by-step ...
4
votes
2answers
463 views

What is the advantage of the wp_options design pattern?

As we all know, a design pattern that is used frequently in Wordpress' DB code is the idea of persisting data for a particular object (blog/post/comment), indexed with a particular name or key. We ...
0
votes
1answer
114 views

Is removing orphaned wp_postmeta records safe?

I am using woocommerce as a shopping cart on a wordpress site. Products and Product Variations are each stored as records in the wp_posts table. Each of these Variations have aprox. 15-20 associated ...
0
votes
0answers
38 views

Insert XML data into the existing posts

I have nba videos news website and I want to insert xml data into the existing posts. For ex I have this post Pacers vs Timberwolves Match report and I want to import data from this xml: ...
0
votes
2answers
67 views

Ideas to connect external database table to wordpress posts as custom field source

I have a custom database table within wordpress database.. I filled this database with data and wordpress posts table with matching ids an example would be... wp-posts table has id - title ...
0
votes
0answers
46 views

How to configure the file wp-db.php at /home/…/public_html/wp-includes/wp-db.php on line 1444

I need your support guys ! When I try to connect to my website I got this error: WordPress database error: [Lost connection to MySQL server during query] SELECT cm_posts.* FROM cm_posts INNER JOIN ...
0
votes
1answer
38 views

Fetch data from another site, but the same database

We have two WordPress sites (Site 1 and Site 2) in the same database, with different prefixes ("site_1_" and "site_2_"). Let's say we've got a custom post type named "stuff", which is in Site 1. We'd ...
7
votes
2answers
198 views

Is it mandatory to use $wpdb->prefix in custom tables

Sorry if this question is trivial. I'm just beginning to develop plugins in WordPress. In all the tutorials I found this: while creating the custom tables, $wpdb->prefix is used. Example: ...
0
votes
1answer
36 views

Files on Localhost, Database on Server

With Wordpress, is it possible to work on localhost but have the DB on a server? So that workflow will be: 1) Work on localhost (but connected to remote database) 2) Upload JUST files via ...
0
votes
2answers
18 views

Is it possible to rebuild the website while not accesseing the original database?

Suppose I have forgotten the wordpress admin username and password, is it possible to rebuild the website (create a new database and delete/replace the original wordpress folder) while not accessing ...
0
votes
1answer
119 views

Checking if the data already exsis in the wp database - custom plugin

I'm trying to insert a user input to a custom table in wp and I don't want to have a duplicate entries. So my code to check that is: global $wpdb; $tablename=$wpdb->prefix."students"; ...
0
votes
0answers
27 views

wpdb giving different results then query in SQL Editor

I'm trying to read candidates and the relation with expertises from 2 custom tables in my WP Database. This is my WPDB query : $candidates = $wpdb->get_results(" SELECT * FROM ...
0
votes
0answers
18 views

Return search for custom post type name

It is easy to write code that will only return posts from a certain custom post type. However, I haven't been able to find a way to return posts that search for the actual name of the custom post ...
6
votes
4answers
1k views

Where are wordpress custom types stored?

Where are custom types stored? Because when a custom type is created, in wp_posts, the post type is set to the <new_custom_post_type>. But where are the details of the new custom post type ...
0
votes
1answer
14 views

dbDelta not installing database

I'm not sure why this isn't running. When I output dbDelta it says that it created the table, but it doesn't. I think my SQL is valid. Taking everything out between id and UNIQUE KEY results in the ...
0
votes
0answers
18 views

Deleted empty posts - menu gone

I just discovered that my site had a lot of posts with no title and content. I thought it was empty posts I had created when misclicking on create post instead of create page, so I sent them to trash. ...
1
vote
1answer
971 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
1answer
48 views

Alternative functions for mysql_free_result and mysql_ping in wordpress functions

what are the alternative function for mysql_free_result and mysql_ping in WordPress functions , does WordPress function provides all the functions like php ? is it necessary to Free result memory for ...
1
vote
1answer
38 views

How to share plugin created database tables between two WordPress sites

I have two WordPress installs. One is a subdomain (Blog 2) and the other is the root domain (Blog 1). All tables are installed in same database. I am already sharing the users table, but am also ...
0
votes
2answers
179 views

How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?

I have a custom post type named store and I have a custom taxonomy city, I also have a meta box with a field that is stored with update_post_meta( $post_id, 'store_postal_code', $postal_code ); it ...
0
votes
4answers
21k views

Custom form that store input in database

I have never used WordPress before, but have done a lot of programming. But what is the normal way of making customs forms? I need to create a form where a user fill some input fields and on submit ...
0
votes
1answer
35 views

Function to retrieve IDs of posts, cache results, and improve wp_query

I'm looking to optimize db performance by creating a function that retrieves IDs of posts in a certain category and caches results. So instead of having a query like: SELECT … WHERE 1=1 AND ...
1
vote
1answer
40 views

Can I store my custom comment_type into wp_comments table?

I'm developing a system where a post can have multiple replies/feedbacks. As of now I's storing each of the comments as a serialized postmeta. But just today I figured out that I can use the existing ...
0
votes
1answer
101 views

WordPress and SQL - Update and Insert from another table if column value doesn't exist

Stuck with some mysql for my wordpress site. All within 1 DB. I am attempting to update wp_options table from wp_2_options (Multisite). They both have option_name (unique_key) and option_value ...
2
votes
6answers
3k 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 ...
0
votes
1answer
64 views

live site do not update after importing sql database

My live website is not updating after importing sql database from wamp local server until last time all went perfect but last night I was not able to see the changes live made in local. what I did: ...
1
vote
1answer
396 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 ...