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

learn more… | top users | synonyms

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
351 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
52 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
91 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
36 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
18 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
19 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
101 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
22 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
373 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
49 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
57 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
101 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 | ...
1
vote
0answers
26 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
50 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
256 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
341 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
275 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
58 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
73 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
115 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
88 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
361 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
15 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
13 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
0answers
24 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
14 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
0answers
16 views

Wordpress Update Get error message

I update latest version of wordpress get error message The file 'wp-config.php' already exists. If you need to reset any of the configuration items in this file, please delete it first. You may try ...
0
votes
0answers
23 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
0answers
13 views

How to show same posts on different WordPress installs?

I have 2 websites using WordPress on the same server and the same database with spesific prefixes. I want to show the posts of the first site in the second site. For example: I have 100 posts in ...
0
votes
0answers
15 views

How to import wp_options rows from Wordpress admin?

Is there any plugin, script or solution to importing rows from wp_options into another Wordpress site via the Wordpress admin? For example import a .sql file that has the rows needed that upon ...
0
votes
0answers
19 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
21 views

dbDelta Not Working

I have some code with dbDelta that I'm trying to use to create a new database table for my plugin: <?php global $mm_importer_version; $mm_importer_version = '1.0'; function mm_install() { ...
0
votes
0answers
21 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
0answers
35 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
0answers
37 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
23 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
0answers
65 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
17 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 ...
0
votes
0answers
17 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
0answers
20 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
98 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
0answers
228 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
0answers
15 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 ...
0
votes
0answers
18 views

Need sort posts by data in custom DB tabel

There is possibility to vote on project (custom_post_type) in theme I created. It has separate db table, where every vote are written (post id, ip, category id, vote time). What would be best way to ...
0
votes
0answers
13 views

Featured image for a third party application

I'm building a Phonegap application that retrieves posts from an existing WordPress database. In which way featured image (i guess it's in wp_postmeta) is related to the post id and how is it ...
0
votes
0answers
68 views

one database, same content, two wordpress sites, different structure? or another solution to have 2 websites with the same content?

I have a WordPress site that shows posts that it gets from rss using a plugin. I want to split the "jobs" in 2 different websites because in this configuration is not working properly (high amount of ...
0
votes
0answers
80 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 ...