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

learn more… | top users | synonyms

0
votes
1answer
98 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
21 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
25 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
105 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
0answers
7 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
1answer
137 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
2answers
150 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
163 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 ...
0
votes
0answers
141 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: ...
2
votes
1answer
223 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 ...
0
votes
2answers
297 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
337 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
115 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 ...
8
votes
2answers
850 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
90 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 ...
2
votes
1answer
86 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 ...
0
votes
2answers
25 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
0answers
50 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
1answer
1k 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
20 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 ...
0
votes
1answer
47 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
2answers
107 views

Brandoo WordPress Unable to Update to WordPress 4.2.2

I have two Brandoo WordPress sites on Azure. Today I recieved a security alert from Microsoft to update to 4.2.2. However, when I try to update WordPress gets stuck in an infinite loop between two ...
0
votes
0answers
27 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. ...
0
votes
1answer
125 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 ...
0
votes
2answers
1k 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 ...
1
vote
1answer
112 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
1answer
110 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
185 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
155 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 ...
0
votes
0answers
162 views

count click on link class on posts and add it to custom field

I have 4 links on each of my posts (facebook, twitter, etc ...), what I'm trying to do, is that everytime someone click on one of this link, i'll have a counter incremented, and store the reslut in a ...
0
votes
1answer
162 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: ...
0
votes
2answers
44 views

Deleting a category from WordPress admin does it remove it completely from the database?

When you delete a category in the admin of WordPress does it completely remove it from the database? I had a few categories with the same naming conventions (different slugs) but now deleting any ...
0
votes
1answer
37 views

Error message on blog posts only on my local environment [closed]

I copied all my WP files from the server to my local WAMP as a dev-environment. Everything works smoothly except when viewing a blog post. I get a good output of all the ...
0
votes
1answer
75 views

Embed a Google Sheet as you view it in a separate tab?

Is it possible to embed a Google Sheet as you view it in a separate tab like in this website? I have tried to use Publish to the web or the plugin Inline Google Spreadsheet Viewer but it just embed ...
0
votes
1answer
42 views

Transforming an wp_options database array into a javascript obect?

In my WP code I grab my options information as such $options = get_option("kaipo_plugin_options"); The array that I print out looks as follows ...
0
votes
1answer
110 views

Sending WordPress database information to cross domain the safe way?

I want to send my options and WP_user database information to my AWS server from my WP site's database. I heard using PHP'cURL is not recommended. I want a safe solution so please aid me in the right ...
2
votes
2answers
152 views

Shared table across network

Im currently creating a plugin that will read an xml file and import the data into 4 tables on a wordpress multisite. the tables are rather large, with ALOT of columns, so the post table is not ...
0
votes
1answer
38 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
44 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
2answers
684 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
347 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 ...
0
votes
1answer
20 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. ...
7
votes
3answers
2k 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 ...
0
votes
0answers
26 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
0answers
53 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
38 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
101 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 ...
0
votes
0answers
219 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
86 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
0answers
43 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 ...