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

learn more… | top users | synonyms

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 ...
2
votes
0answers
36 views

Backup another database with BackUpWordPress plugin

Is there any possibilities to add another database which is connected to other wordpress plugin? My site is using two database: main wordpress db and additional db for plugin data. The Backup includes ...
2
votes
0answers
354 views

comment_post_ID 0 (cannot remove from dashboard)

Ran across something a bit odd that I haven't seen before. A client has a pretty active blog and uses Akismet (paid) to protect against spam. At least once a day, they're reporting a spam comment that ...
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 ...
1
vote
0answers
98 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 ...
1
vote
0answers
147 views

Separate Database Tables For Different Post Types

one big problem with wordpress is that everything on it is a post(a record in wp-posts table)! images, posts, pages, products(for example in woocommerce), portfolios, Post Revisions... Almost ...
1
vote
0answers
47 views

delete duplicate comments

I found a solution for this a long time ago. Here is the code: <?php require_once('wp-config.php'); global $wpdb, $comment_content, $comments,$comment_ID; # First select all comments $query = ...
1
vote
0answers
20 views

localize elements in database

I want to localize my website with .mo files. Now, while it's pretty easy to scan existing php files and add the relative translation, it's not clear to me how to localize the elements in the db. I ...
1
vote
0answers
25 views

Store partial database to an archive database time to time

As the community knows me that I'm not a PHP Developer by core, but trying to be one. With the company I'm working, I developed many WordPress powered News Portals, where- They publish at least 30 - ...
1
vote
0answers
115 views

Child parent relationship inside WP DB

i am a .net user so i am unfamiliar with not using a foreign key inside of the database. On my WP application, user's are able to create videos on the application, the videos are stored on a ...
1
vote
0answers
23 views

How to migrate the posts from an old custom legacy blog to a new WordPress website?

I have to migrate the posts of a very old custom legacy blog made in ASP (the posts are stored in a MySql table) into a new WordPress blog. So I need your help to find the smartest solution to do it, ...
1
vote
0answers
439 views

WP_Query orderby and tax_query

My goal is to have custom posts type's posts (CPT for simplicity) from a custom taxonomy (CT for simplicity) let say CT Hometown with slug Nebraska to be listed grouped by another CT, let say ...
1
vote
0answers
53 views

Insert menus in the database

I want to create a large menu structure, and the admin pages time out, so I cannot insert them via the admin screens. How can I insert the menu entries directly in the database? Thank you
1
vote
0answers
207 views

Strange Deadlock database error for the query “Delete From wp_options”

I'm experiencing a strange Database error in these days, and it could the the cause of the slowness of my website (tasc.it) in these days. I found this error in the PHP error log, I can see about 4-5 ...
1
vote
0answers
60 views

Is there an atomic way to update_option in Wordpress (to ensure data integrity)?

I want to update an option which is an array by adding a new value, but there's no atomicity or guarantee of data integrity. EXAMPLE //Get the option value (an array) $val = get_option( ...
1
vote
0answers
29 views

Removing Mutlisite lines stop DB connection

I'm trying to revert my mutlisite to a single site and following a guide it recommends removing the following /*define( 'MULTISITE', true );*/ define( 'MULTISITE', false ); define( ...
1
vote
0answers
65 views

Wordpress plugin creating database in localhost but not on real host

So I am busy creating a plugin that creates a custom table to read in some data. The plugin works 100% on localhost but does not create the table in the db on the real host. I have debug enables and ...
1
vote
0answers
54 views

Move out of sync posts from one database to another

I have an issue where the following has occurred: WP install is pointing to database server 1. Database server 1 is backed up. Database from DB server 2 is restored onto DB server 1. I need to get ...
1
vote
0answers
313 views

How to track a users progress through pages by inserting data into Wordpress Database?

My website users can learn British Sign Language through Video Tuts, Quizzes and games etc. I would like to track the users progress through the pages of the course and add that data to a Wordpress ...
1
vote
0answers
364 views

How to populate custom field dropdown box based on prior selection?

I have two dropdown boxes for a search that uses custom fields and I need the second dropbown box to be populated depending on the results of the first box. So far I have: <form role="search" ...
1
vote
0answers
290 views

Wordpress running SQL query to update database from form

Basically I want to take information in from a form and use a separate php page to update the database. so here is the original wordpress php page (add_person.php): <?php /* Template Name: ...
1
vote
0answers
60 views

Importing 10 Years of Media into the WP Database

I've been running the same website for 10 years now, and whenever I would create a news story, I would manually upload and store all my news images in a "news" folder via FTP and then manually write ...
1
vote
0answers
2k views

How to fix database error duplicate entry

At first I thought this was just a damaged table, so I tried repairing via MySQL, but it appears there's more fundamental issues. Which of the duplicates should I remove, and any further advice in ...
1
vote
0answers
79 views

database query with more than a couple meta hangs and doesn't complete

I have a development website with about 70 checkboxes for custom fields. The idea is the user selects one or more checkboxes, it queries the database for all posts that have a meta_key for the ...
1
vote
0answers
117 views

Multisite 404 on pages - rewrite error breaks database

After updating my reading settings on my multisites, I get 404 errors on all my pages. The only way to fix the issue is by reverting the database to previous version, that is the only way it can be ...
1
vote
0answers
91 views

Copy post to separate database with “add_action(…)”

I'm basically trying to have a copy of a post be sent to another database's table when it's published. I've gotten it to add a new row in the new table, with my own static arguments, but I'm not sure ...
1
vote
0answers
388 views

Easiest Way to Authenticate WP Users Using an External DB?

I have been looking for the best/easiest way to share users on a WP blog (in a subfolder) with the MAIN site's user database so that people do not have to register/log in on the WP blog when already ...
0
votes
0answers
5 views

What is the purpose of the option name hack_file in the options table?

I was looking at the options table in a WordPress install and noticed an option name hack_file. At first I thought the site was compromised and then realized it is a default option ...
0
votes
0answers
16 views

Use a Firebase DB as main DB

I was wondering if it was possible to use a Firebase database as a main database? Or do you have another solution to use a unique DB across multiple dev station? Thanks :)
0
votes
0answers
17 views

Multiple domain with one database

I have multiple domain (Multiple domain + subdomain as well) for the different countries and for the different states of it. Now i want to run all the domain from one signle database, all the domain ...
0
votes
0answers
7 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 ...
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
12 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
0answers
13 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
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. ...
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
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 ...
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() ...
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
0answers
35 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 = ...
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 ...
0
votes
0answers
21 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
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
0answers
29 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
37 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
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
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 ...