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

learn more… | top users | synonyms

2
votes
0answers
35 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
333 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
25 views

Should I be able to run two different “close” code versions of wordpress with the same DB

A concrete example - I am upgrading to 4.1 from 4.0, the upgrade was successful but I discovered that a plugin broke. Can I just revert the code. The real live issue I am facing is having two ...
1
vote
0answers
10 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
54 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
17 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
213 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
40 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
44 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
72 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
24 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
59 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
44 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
168 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
269 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
126 views

MS Access to manage WordPress Database

Now I don't believe this is practical or possible without a large amount of development. My client's old site used MS Access to manage the user's profiles on his old website. His new site uses ...
1
vote
0answers
189 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
53 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
1k 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
68 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
101 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
84 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
309 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
30 views

Handling Massive Amounts of Data in a Wordpress Plugin

I've been working on my own version of a Youtube Post Importer plugin for Wordpress and I've run into a bit of a wall. I'm using the 3rd version of the Youtube Data API seen here ...
0
votes
0answers
11 views

wp_update_post set value to null

Is it possible to set a field to NULL using wp_update_post? I'm trying the following: wp_update_post( array( 'ID' => $future_orphan_id, 'post_parent' ...
0
votes
0answers
25 views

two wordpress sites, two themes, one database, same content

I am doing research about wordpress and there are many interesting stuff to learn, i browse the wordpress forum and i found a post about duplicating site.. or multisite.. I am not sure exactly how it ...
0
votes
0answers
9 views

Will be the posts over writen according to the posts' ID when I import from an old site using XML file?

I have a site now and it has 350 posts. (Let's call is New site) I have another site which has 500 posts (Let's call is Old site) Now I am in a need of importing the all posts (500) from my old site ...
0
votes
0answers
11 views

WP DB Location for “Next Post to Create” Index Value

I have a malformed DB (no mystery here, I deleted some data directly rather than through the WP admin interface). I've deleted all posts and meta for 400+ but when I create a new post, the sequencing ...
0
votes
0answers
13 views

Editable form with database

I want to create a profile page in which user will give title and description for it.this title should be visible in list on same page by clicking on it associated description should get open for ...
0
votes
0answers
12 views

Wordpress + Postgresql

I’ve painted myself into a corner. I hired someone to build a database with all kinds of cool search features and such. The programmer wasn't aware that my site is built on Wordpress. He wrote his ...
0
votes
0answers
14 views

Global Signup/Login in two wordpress site some like similar to stackoverflow?

I have two different wordpress installation at two different server one at mydomain.com and other at subdomain.mydomain.com having different database. My question is how I implement global ...
0
votes
0answers
17 views

Backend - Categories and Menus conflicts

I'm having a big problem with my WP instance which is frustrating. Every time I add a new Category ( a simple default category with no custom posts or taxonomies ) it adds, as expected, that new ...
0
votes
0answers
21 views

Should I store multiple data in a single wp_post field

I hope this is the right place to ask this question. I have chosen to work in a Wordpress environment so this should apply here. I have to design an application that will store hundreds of thousands ...
0
votes
0answers
6 views

Custom table in my plugin print UTF-8 (מוברש) charsets and not hebrew

i have created custom table in wordpress db to use my plugins needs. i have campaigns with hebrew names, this saved to column (varchar(100) utf8_unicode_ci ) in the DB i dont see hebrew but this: ...
0
votes
0answers
28 views

Simple email input store in database

I'm trying to build a really simple form to store email adresses in the wp database for future newsletter purposes. What I have is just a single email input: <form method="POST"> <input ...
0
votes
0answers
11 views

Creating a custom Search Form that links to a custom database?

I'm kinda new in Wordpress and I'm still learning as I go along. Currently, I'm trying to create something like this I have a custom set of database in the server in mysql with a table. The ...
0
votes
0answers
9 views

How to print out database content like declared in DB_CHARSET?

Ok i created some table with Romanian names "CREATE TABLE `wp_drzava` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `Kod` varchar(2) NOT NULL, `Naziv` varchar(100) NOT NULL, `NazivSrb` varchar(100) ...
0
votes
0answers
11 views

Unable to create custom table , register_activation_hook from class

Cannot create the table , what am i missing class em_db { public function em_events_custom_table() { global $wpdb; $table_name = $wpdb->prefix . "em_events_db"; ...
0
votes
0answers
39 views

Get id from database

I need this ID to delete users from table. My plugin crate new table in DB when he is activate. All this code is in main.php, and in second.php i have only form that display my results.. and i include ...
0
votes
0answers
11 views

Comments disappeared but showing in database

This morning I published an article under which several comments were placed. I could read them and everything worked fine. Then all of the sudden, the number of comments were still showing on the ...
0
votes
0answers
9 views

No Database Backup

I'm looking for a way to recover as much as I can from a poorly backed up Wordpress website. The website owner didn't renew their hosting and lost the site. This was the first and last Wordpress ...
0
votes
0answers
19 views

Delete entry from DB

i created plugin and now i want to add delete button, that user can delete one entry from DB table.. Here is my code i form.. function showresult(){ ?> <form method="post" ...
0
votes
0answers
13 views

Force reindexing of plugins in Multisite

I have a Wordpress multisite installation and am developing it on localhost. However if I install a plugin in development, deploy the files and check multisite plugins section in Wordpress admin, it's ...
0
votes
0answers
28 views

How to clean tables after plugins are uninstalled

A number of plugins which I use earlier are not uninstalled and there tables are still there. I don't know the table names created by those plugins. Is there a way to automatically delete (via a ...
0
votes
0answers
40 views

Insert data to DB

I create plugin and that plugin, when is activate, create new table in DB.. Now i need to insert some data like (firstname, lastname..) in that table.. Here is my form : <form name="cool_form" ...
0
votes
0answers
35 views

$wpdb error : call to a member function insert() on a non-object

I'd like to add data to my custom wordpress table of my plugin, here is my code: <?php global $wpdb; $data = $_POST['name']; $wpdb->insert('ct_data' , array( 'name' => $data ), array( "%s" ...
0
votes
0answers
28 views

Get results from wordpress data custom table

Firstly i created a custom table into the wpdb : global $wpdb; $table_name = $wpdb->prefix . 'countdown_table'; $sql = ' `id` int(11) NOT NULL AUTO_INCREMENT, `styleName` varchar(255) ...
0
votes
0answers
17 views

Use existing client information database in wordpress site

Our company's website is being completely redone, this time with wordpress. We have an existing client database where clients can log in and get the information they have permission to view. This ...
0
votes
0answers
17 views

Any way to calculate distance between 2 addresses based on custom fields?

I'm working on a directory database theme, and I wonder if there is any way to calculate distance between 2 addresses or lat/long.... It can be a straight line calculation, and direction (bearing) ...
0
votes
0answers
24 views

Unable to replace text string across site

There is a text string (a little over 1000 characters with spaces) that needs to be replaced across the entire of my website. The text recurs over 300 times on my site, is identical, and was been ...