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

learn more… | top users | synonyms

0
votes
0answers
5 views

WordPress Database Update Required

This is my first time experiencing the "DataBase update required" and then will not login in to the site. I am currently running version 4.2.2. I have read many blogs and see many people have had ...
1
vote
1answer
16 views

When open add new post or page Wordpress add post with ID=0 continuously

When open add new post or page Wordpress add post with ID=0 continuously. and instead of publish there is submit for review
0
votes
0answers
8 views

multiple wordpress installation with shared usertable on an different database

I have multiple wordpress installation, and I would like them to share the same usertable. The wordpress installations are already up and running, and they all have their own database. Is it ...
0
votes
0answers
11 views

Create new table vs post_meta table database dilemma

I'm working on custom function that will store post data but I dont know which method to use. I have meta box in edit post area that will store diferent videos (embed code) for each post will have ...
0
votes
1answer
30 views

Problem in using wpdb

I used "wpdb" in my code But it was not working and the following error: Fatal error: Call to a member function insert() on a non-object Notice: Trying to get property of non-object" in ...
1
vote
2answers
3k views

How to Query Database for posts with certain Taxonomy Term

I want to write a select query to return data on only posts which have are associated with the taxonomy term food-and-beverage SELECT wp_postmeta . * , wp_posts.post_name FROM wp_posts, wp_postmeta, ...
0
votes
0answers
11 views

Hook upon database insertion?

I have downloaded a plugin that inserts a new row into a table in my database. I want to perform a calculation on this row as soon as it is inserted into the database, in my own plugin. I've seen a ...
0
votes
1answer
26 views

Cannot unserialize Wordpress serialized values in `wp_options` table?

I have nav_menu_options in my Wordpress database as below. 284,'nav_menu_options','a:2:{i:0;b:0;s:8:\"auto_add\";a:0:{}}' I tried to deserialize this value but the result is empty string - I put a ...
0
votes
1answer
430 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
32 views

Build a website with a database connection in Wordpress?

I have built multiple websites using Node.js, PHP, Java and have knowledge on basic web development tools. Except for wordpress. I'm required to build a webpage that does some file manipulation, ...
0
votes
2answers
87 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 ...
1
vote
1answer
14 views

When and why should I use $wpdb different return types?

This one returns an object $mylink = $wpdb->get_row("SELECT * FROM $wpdb->links WHERE link_id = 10"); An associative array $mylink = $wpdb->get_row("SELECT * FROM $wpdb->links WHERE ...
0
votes
1answer
29 views

Get the post permalink within the loop but without additional DB query

I am looking to create a custom 'directory' page which will link to several thousands of posts. Because of the large number I am trying to limit the number of DB queries. I notice that to link to each ...
0
votes
1answer
13 views

Structure of postmeta meta_value for woocommerce product download

So I'm working on a monster script to port all of our existing stuff from Joomla/Virtuemart to Wordpress/WooCommerce. So far I've got just about everything done with moving over our product ...
2
votes
1answer
3k 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 ...
3
votes
5answers
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
1answer
439 views

How do I properly update the Wordpress database password?

A site that I manage was recently compromised and I am going through the steps to harden and re-secure the site. I would like to change the MySql database password and want to make sure I do not take ...
0
votes
3answers
212 views

how to store arrays into a database

I'm trying the store multiple rows into a database. The number of fields will change. Below is the way that I use to store just one row. <?php if(isset($_POST['save'])){ ...
0
votes
2answers
37 views

Disable Database Update Required ? break my website

Im having an issue if i want to login to the dashboard, it needs a "Database Update Required" I'd like to disable it, because once it update the Database, if I go to any post of single-pages, it ...
0
votes
3answers
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 ...
0
votes
3answers
9k views

wpdb->prepare and mysql UPDATE - how is it done?

Trying to set a 'removed' date time in a plugin query but I'm not sure how to use UPDATE SET with $wpdb->prepare. Here's my query: $cur_date = date('Y-m-d G:i:s'); $rows_affected = ...
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
3answers
358 views

Fetch a single row from a custom table for to a given ID

When I want to get a single row from a custom table of my WordPress database by providing a username through function call, it does not work. When I mention the username in where clause of the query, ...
4
votes
0answers
45 views

Relaunch 4.2 utf8mb4 databse upgrade

I updated WP to 4.2 while it was on an old server, that doesn't match the utf8mb4 upgrade requirements. I moved to another server that fit these requirements, but WP won't launch this database ...
0
votes
0answers
10 views

Text with sub bullets not saved correctly

I'm having problems with sub list items. In my backoffice it looks like this (text is blurred): Visual: Text: In the text editor it looks good but when I save the post I get this in my database ...
0
votes
0answers
18 views

WordPress and user security

When we talk about Information Security, many things come into mind and people tend to use CMS to be clear on security as CMS people do the job for you, in terms on hashing passwords, encryption etc. ...
1
vote
1answer
428 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
0answers
17 views

Two same URL domain

I have a problem with my wordpress . I just migrate to a new install only the post and categories . But now entering a link or search the CSS BASE URL for example doubles A href attribute URL : ...
0
votes
1answer
6 views

Changed meta_key value in structures, now dashboard shows zero users

I was trying to edit the email form field so that it accepts int values like of a phone number. I knew very less about how database values work and this is what i did: 1. Figured out that email field ...
0
votes
1answer
1k 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
1answer
13 views

How to enable the user to add value through the admin panel?

please help me! I have custom posts type 'gallery'. In my custom post type i have custom fields. I added them through the file functions.php. How to enable the user to add value through the admin ...
0
votes
1answer
279 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
17 views

Wordpress Failed to Login (DB Error)

is there anyone experience how to fix DB Error on WordPress (switch back to default theme and reset all plugins from FTP) but still cannot login). This is the erro I got: WordPress database error: ...
1
vote
1answer
127 views

Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin

I have a wordpress table like so (phpmyadmin and MySQL) | id | meta_key | meta_value | +----+-----------+------------+ | 1 | import_id | abc | | 2 | import_id | abc | | 3 | ...
0
votes
1answer
35 views

SQL Error wp_commentmeta - incorrect table definition

I'm trying to import a database and wonder how I can stop getting the following error? "#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key " ...
2
votes
1answer
90 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 ...
3
votes
2answers
1k views

remove missing image attachments

Best way to programatically remove attachments that are missing images? I ask because after using a caching plugin, I have images that have been input in the database as attachments that don't ...
-1
votes
1answer
20 views

What is table `wp_woocommerce_termmeta` for? [closed]

I'm using Woocommerce plugin for my Wordpress website. After added, I notice that there is a table called wp_woocommerce_termmeta. What is this table storing? p.s. Is there any relationship ...
0
votes
1answer
24 views

Why user_pass column in wp_users table is varchar(64)

while working on a project, I found that "user_pass" column in "wp_users" table is varchar(64). WordPress always stores user password in md5 which is a 32 char ASCII string. So why not store it in ...
0
votes
2answers
1k 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
1answer
22 views

update_user_meta(): invisible data storage

I try to customize users profile using this code (from this tutorial) : <?php function extra_user_profile_fields( $user ) { ?> <h3>Autres</h3> <table class="form-table"> ...
0
votes
0answers
6 views

Database level import of featured images and link to posts - How?

I have been attempting to import about 50,000 images into 50,000 posts in WP 4.2.2. The _posts table data is all correctly imported already. I know I need to import to _postmeta table and add new ...
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
864 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
24 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
15 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
14 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 ...
-1
votes
0answers
12 views

Why only one of my sites is so slow to backup?

I have made many websites with Wordpress, but only one is really slow to backup, slow like many many many hours. My site : 1630 articles + 36 pages My backup plugin : Wordpress Database Backup (by ...